JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

80 columns | Print definition?920 | CTAM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03: Accounts Receivable
1F0311Accounts Receivable Ledger40RPCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP03B: Enhanced Accounts Receivable
2F03B11Customer Ledger42RPCTAMAmount - Foreign TaxNumericGeneric Edit152
3F03B112Invoice Revisions44RWCTAMAmount - Foreign TaxNumericGeneric Edit152
4F03B112PInvoice Revisions Purge File44RWCTAMAmount - Foreign TaxNumericGeneric Edit152
5F03B11PCustomer Ledger Purge File42RPCTAMAmount - Foreign TaxNumericGeneric Edit152
6F03B11Z1Batch Invoices59VJCTAMAmount - Foreign TaxNumericGeneric Edit152
7F03B11Z2F03B11 Interoperability Table55SYCTAMAmount - Foreign TaxNumericGeneric Edit152
8F03B21A/R Notification History Detail44ZSCTAMAmount - Foreign TaxNumericGeneric Edit152
9F03B575Auto Debit Invoice Select and Build51RDCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP04: Accounts Payable
10F0411Accounts Payable Ledger42RPCTAMAmount - Foreign TaxNumericGeneric Edit152
11F0411AWF - 'As Of' Accounts Payable Ledger42RPCTAMAmount - Foreign TaxNumericGeneric Edit152
12F0411PPurge - Accounts Payable Ledger42RPCTAMAmount - Foreign TaxNumericGeneric Edit152
13F0411Z1Voucher Transactions - Batch Upload60VLCTAMAmount - Foreign TaxNumericGeneric Edit152
14F0411Z3F0411 Interoperability Table65SZCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP09: General Accounting
15F0911Z1Journal Entry Transactions - Batch File181VNCTAMAmount - Foreign TaxNumericGeneric Edit152
16F0917Bank Statement Detail15GDCTAMAmount - Foreign TaxNumericGeneric Edit152
17F09617Auto Bank Statement Detail18GMCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP15: Real Estate Management
18F15012Tenant E.P. Class Master63NSCTAMAmount - Foreign TaxNumericGeneric Edit152
19F15012BTenant E.P. Class Master66NSCTAMAmount - Foreign TaxNumericGeneric Edit152
20F15016Tenant Escalation Master60NUCTAMAmount - Foreign TaxNumericGeneric Edit152
21F15016BTenant Escalation Master59NUCTAMAmount - Foreign TaxNumericGeneric Edit152
22F1502Recurring Billings Master56NFCTAMAmount - Foreign TaxNumericGeneric Edit152
23F1502BRecurring Billings Master52NFCTAMAmount - Foreign TaxNumericGeneric Edit152
24F1502WBEstimated EP Recurring Billings58N4CTAMAmount - Foreign TaxNumericGeneric Edit152
25F1511Tenant/Lease Billings Detail60NJCTAMAmount - Foreign TaxNumericGeneric Edit152
26F1511BLease Billings Master56NJCTAMAmount - Foreign TaxNumericGeneric Edit152
27F1511HTenant/Lease Billings Detail History60N#CTAMAmount - Foreign TaxNumericGeneric Edit152
28F1511HBLease Billings History56NCCTAMAmount - Foreign TaxNumericGeneric Edit152
29F1538WF - Expence Participation Register74NZCTAMAmount - Foreign TaxNumericGeneric Edit152
30F1538BEP Billing Register72NZCTAMAmount - Foreign TaxNumericGeneric Edit152
31F1540BSales Report Control54NRCTAMAmount - Foreign TaxNumericGeneric Edit152
32F1565Security Deposit Master30JFCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP42: Sales Management
33F42800G1Sales Update G Batch Detail Workfile43DGCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP43: Procurement
34F4311Purchase Order Detail File200PDCTAMAmount - Foreign TaxNumericGeneric Edit152
35F4311Z1Purchase Order Detail Unedited Transaction Table217SZCTAMAmount - Foreign TaxNumericGeneric Edit152
36F43121Purchase Order Receiver File108PRCTAMAmount - Foreign TaxNumericGeneric Edit152
37F43121ZReceiver workfile161PWCTAMAmount - Foreign TaxNumericGeneric Edit152
38F43121Z1Receipts Unedited Transaction Table193SZCTAMAmount - Foreign TaxNumericGeneric Edit152
39F4314ZVoucher Match Selection File56PNCTAMAmount - Foreign TaxNumericGeneric Edit152
40F4316Purchase Order Multiple Account File44P3CTAMAmount - Foreign TaxNumericGeneric Edit152
41F43199P.O. Detail Ledger File - Flexible Version200OLCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP43A: Purchase Order Receipt/Routing
42F43126Purchase Order Receiver Multiple Account45P4CTAMAmount - Foreign TaxNumericGeneric Edit152
TOP47: Electronic Commerce
43F470161EDI Purchase Order Additional Header - Outbound57S3CTAMAmount - Foreign TaxNumericGeneric Edit152
44F47022EDI P.O. Acknowledgment Detail - Inbound211SZCTAMAmount - Foreign TaxNumericGeneric Edit152
45F47032TEDI Shipping Notice Detail- Inbound Tag12SZCTAMAmount - Foreign TaxNumericGeneric Edit152
46F47042EDI Invoice Detail - Inbound77SZCTAMAmount - Foreign TaxNumericGeneric Edit152
47F47044EDI Invoice Summary - Inbound42SWCTAMAmount - Foreign TaxNumericGeneric Edit152
48F470461EDI Invoice Additional Header - Outbound58S3CTAMAmount - Foreign TaxNumericGeneric Edit152
49F47057EDI Payment Order Remittance Advice - Outbound69D3CTAMAmount - Foreign TaxNumericGeneric Edit152
50F47057WEDI Payment Order Remittance Advice - Work69D3CTAMAmount - Foreign TaxNumericGeneric Edit152
51F47072EDI Receiving Advice Detail - Inbound221SZCTAMAmount - Foreign TaxNumericGeneric Edit152
52F47077EDI Receiving Advice Detail - Outbound222SZCTAMAmount - Foreign TaxNumericGeneric Edit152
53F47097EDI Request for Quote Detail - Outbound211SZCTAMAmount - Foreign TaxNumericGeneric Edit152
54F47102EDI Response to RFQ Detail - Inbound211SZCTAMAmount - Foreign TaxNumericGeneric Edit152
55F471061EDI Response to RFQ Additional Header - Outbound58S3CTAMAmount - Foreign TaxNumericGeneric Edit152
56F47142EDI P.O. Change Acknowledgment Detail - Inbound212SZCTAMAmount - Foreign TaxNumericGeneric Edit152
57F47157EDI Shipping Schedule Detail - Outbound201SZCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP48S: Service Billing
58F4822Invoice Summary Work File52W4CTAMAmount - Foreign TaxNumericGeneric Edit152
59F4823Voucher Summary48W0CTAMAmount - Foreign TaxNumericGeneric Edit152
TOP49: Transportation Management
60F4981Freight Audit History90FHCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP52G: Proj & Gov Contract Accounting
61F4822HInvoice Summary History52IHCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP70: Multi-National Products
62F704100Suspended VAT AP - COMM - 7021VACTAMAmount - Foreign TaxNumericGeneric Edit152
TOP74: EMEA Localization
63F74900Foreign Receivables and Payables - EMEA49RPCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP74H: Hungary
64F74H410Foreign Voucher Supplier Amounts - HUN - 74H19SACTAMAmount - Foreign TaxNumericGeneric Edit152
TOP74R: Russia
65F74R410Tax on Hold - RUS - 0412THCTAMAmount - Foreign TaxNumericGeneric Edit152
66F74R420Tax Releases - RUS - 0416TRCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP75T: Taiwan
67F75T004GUI/VAT Transaction Header - 75T29THCTAMAmount - Foreign TaxNumericGeneric Edit152
68F75T0049GUI/VAT Transaction Header History - 75T29THCTAMAmount - Foreign TaxNumericGeneric Edit152
69F75T004PGUI/VAT Transaction Header POS - 75T31THCTAMAmount - Foreign TaxNumericGeneric Edit152
70F75T004ZGUI/VAT Transaction Header - Work - 75T30ZHCTAMAmount - Foreign TaxNumericGeneric Edit152
71F75T005GUI/VAT Transaction Detail - 75T31TDCTAMAmount - Foreign TaxNumericGeneric Edit152
72F75T0059GUI/VAT Transaction Detail History - 75T31TDCTAMAmount - Foreign TaxNumericGeneric Edit152
73F75T005PGUI/VAT Transaction Detail POS - 75T33TDCTAMAmount - Foreign TaxNumericGeneric Edit152
74F75T005TGUI/VAT Transaction Detail Temp - 75T31TDCTAMAmount - Foreign TaxNumericGeneric Edit152
75F75T005ZGUI/VAT Transaction Detail - Work - 75T38ZDCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP76C: Colombia
76F76C031AA/R Customer ledger As Of - F76C031A - COL - 0441RPCTAMAmount - Foreign TaxNumericGeneric Edit152
TOP76M: Mexico
77F76M0314Receipt Detail Tag File - Mexico16MACTAMAmount - Foreign TaxNumericGeneric Edit152
78F76M0414F0414 - Payment Detail Tag File - Mexico18RTCTAMAmount - Foreign TaxNumericGeneric Edit152
79F76M311AR Soft Rounding VAT - Mexico8MBCTAMAmount - Foreign TaxNumericGeneric Edit152
80F76M411Soft Rounding VAT Calculation11RSCTAMAmount - Foreign TaxNumericGeneric Edit152