JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

63 columns | Print definition?920 | RLLN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F3111Z2Warranty Claim/Supplier Recovery processing30WPRLLNRelated PO/SO Line NumberNumericGeneric Edit73
2F3112Z2Warranty Claim/Supplier Recovery processing79WLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP31: Shop Floor Control
3F3111Work Order Parts List17WMRLLNRelated PO/SO Line NumberNumericGeneric Edit73
4F3111SPurge - Shop Floor Parts List17WMRLLNRelated PO/SO Line NumberNumericGeneric Edit73
5F3111Z1Outbound Work Order Parts List30SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
6F3112Work Order Routing67WLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
7F3112SPurge Shop Floor Control Routing Instructions67WLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
8F3112Z1Outbound Work Order Routings79SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
9F3118Shortage Maintenance Master File13WNRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP31P: Engineer To Order
10F31P11Project Quote Detail33QPRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP34: Requirements Planning
11F3412MPS/MRP/DRP Lower Level Requirements File13MWRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP34X: In-Memory Planning Advisor
12F34X200WPlanning Details Supply/Demand Work Table49SDRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP37: Quality Management
13F3711Test Results8TRRLLNRelated PO/SO Line NumberNumericGeneric Edit73
14F3711Z1Test Results Unedited Transaction Table21SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
15F37900Certificate of Analysis (COA) Extract8TRRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP40: Inventory/OP Base
16F40051Return Material Authorization4RDRLLNRelated PO/SO Line NumberNumericGeneric Edit73
17F4011ZBatch Receiver File - Order Details28SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
18F4211Z1Sales Order Detail Unedited Transaction File28SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP41: Inventory Management
19F4118Container Deposit File11CNRLLNRelated PO/SO Line NumberNumericGeneric Edit73
20F41181Container Transaction File22CMRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP41F: Apparel Management
21FCW67Style Work Order Parts List23WMRLLNRelated PO/SO Line NumberNumericGeneric Edit73
22FCW68Style Work Order Routings71WLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP42: Sales Management
23F4211Sales Order Detail File15SDRLLNRelated PO/SO Line NumberNumericGeneric Edit73
24F42119Sales Order History File15SDRLLNRelated PO/SO Line NumberNumericGeneric Edit73
25F42199S.O. Detail Ledger File15SLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
26F42UI11SO Detail Cache File (MBF)19ZDRLLNRelated PO/SO Line NumberNumericGeneric Edit73
27F42UI521Pick Slips Detail File15S9RLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP43: Procurement
28F43080Approvals Fields Constants25PDRLLNRelated PO/SO Line NumberNumericGeneric Edit73
29F4311Purchase Order Detail File15PDRLLNRelated PO/SO Line NumberNumericGeneric Edit73
30F4311ZPurchase Order Generator File19PWRLLNRelated PO/SO Line NumberNumericGeneric Edit73
31F4311Z1Purchase Order Detail Unedited Transaction Table28SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
32F43199P.O. Detail Ledger File - Flexible Version15OLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
33F43UI50DPO Print Detail Work File47PWRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP43E: Requisition Self Service
34F43E121eRequisition Receiver file12ERRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP45: Advanced Pricing
35F4079Rebate Transaction Detail23SVRLLNRelated PO/SO Line NumberNumericGeneric Edit73
36F4576Z1Ship and Debit Claims Unedited Transaction Table132Z1RLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP47: Electronic Commerce
37F47012EDI Purchase Order Detail - Inbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
38F47017EDI Purchase Order Detail - Outbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
39F47022EDI P.O. Acknowledgment Detail - Inbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
40F47027EDI P.O. Acknowledgment Detail - Outbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
41F47032EDI Shipping Notice Detail - Inbound32SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
42F47037EDI Shipping Notice Detail - Outbound32SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
43F470371EDI Shipping Notice Detail - Outbound32SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
44F47047EDI Invoice Detail (Sales) - Outbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
45F47072EDI Receiving Advice Detail - Inbound30SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
46F47077EDI Receiving Advice Detail - Outbound30SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
47F47092EDI Request for Quote Detail - Inbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
48F47097EDI Request for Quote Detail - Outbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
49F47102EDI Response to RFQ Detail - Inbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
50F47107EDI Response to RFQ Detail - Outbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
51F47132EDI Purchase Order Change Detail - Inbound30SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
52F47137EDI Purchase Order Change Detail - Outbound30SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
53F47142EDI P.O. Change Acknowledgment Detail - Inbound31SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
54F47147EDI P.O. Change Acknowledgment Detail - Outbound31SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
55F47157EDI Shipping Schedule Detail - Outbound29SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP49: Transportation Management
56F49T10Sales Order Release Staging Table35ORRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP75I: India
57F75I3576Stock Transfer - Work Orders9SWRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP89: Conversion Programs
58F43199ATemp F43199 for ERP 9.0 Upgrade15OLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOP90CG: CRM Case Management
59F90CG503Case Association Table9CARLLNRelated PO/SO Line NumberNumericGeneric Edit73
TOPF31: Lean Transactions
60FF31111Lean Transaction Parts List20PLRLLNRelated PO/SO Line NumberNumericGeneric Edit73
61FF31111SPurge - Lean Transaction Parts List20PRRLLNRelated PO/SO Line NumberNumericGeneric Edit73
62FF31112Routing Transaction Table64EHRLLNRelated PO/SO Line NumberNumericGeneric Edit73
63FF31112SPurge - Routing Transaction Table64ETRLLNRelated PO/SO Line NumberNumericGeneric Edit73