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

75 columns | Print definition?812 | DSVJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File21TDDSVJDate - Service/TaxDateGeneric Edit60
2F0911Account Ledger96GLDSVJDate - Service/TaxDateGeneric Edit60
TOP03: Accounts Receivable
3F0311Accounts Receivable Ledger43RPDSVJDate - Service/TaxDateGeneric Edit60
TOP03B: Enhanced Accounts Receivable
4F03B11Customer Ledger45RPDSVJDate - Service/TaxDateGeneric Edit60
5F03B112Invoice Revisions48RWDSVJDate - Service/TaxDateGeneric Edit60
6F03B112PInvoice Revisions Purge File48RWDSVJDate - Service/TaxDateGeneric Edit60
7F03B11PCustomer Ledger Purge File45RPDSVJDate - Service/TaxDateGeneric Edit60
8F03B11Z1Invoice Transactions - Batch File62VJDSVJDate - Service/TaxDateGeneric Edit60
9F03B11Z2F03B11 Interoperability Table58SYDSVJDate - Service/TaxDateGeneric Edit60
10F03B465A/R Netting Workfile17RODSVJDate - Service/TaxDateGeneric Edit60
11F03B575Auto Debit Invoice Select and Build54RDDSVJDate - Service/TaxDateGeneric Edit60
12F09UI011Receipt Prepost Work File36GLDSVJDate - Service/TaxDateGeneric Edit60
TOP04: Accounts Payable
13F0411Accounts Payable Ledger11RPDSVJDate - Service/TaxDateGeneric Edit60
14F0411AWF - As Of - Accounts Payable Ledger11RPDSVJDate - Service/TaxDateGeneric Edit60
15F0411PPurge - Accounts Payable Ledger11RPDSVJDate - Service/TaxDateGeneric Edit60
16F0411Z1Voucher Transactions - Batch File29VLDSVJDate - Service/TaxDateGeneric Edit60
17F0411Z3F0411 Interoperability Table33SZDSVJDate - Service/TaxDateGeneric Edit60
18F09UI005Tax Offsets User Index2GLDSVJDate - Service/TaxDateGeneric Edit60
19F09UI006Tax (F0018) Replica21TDDSVJDate - Service/TaxDateGeneric Edit60
TOP09: General Accounting
20F0911PPurge - Account Ledger96GLDSVJDate - Service/TaxDateGeneric Edit60
21F0911RWF - Acct Ledger File for Reconciliation54GLDSVJDate - Service/TaxDateGeneric Edit60
22F0911Z1Journal Entry Transactions - Batch File113VNDSVJDate - Service/TaxDateGeneric Edit60
23F0911Z4F0911 Interoperability Table118SZDSVJDate - Service/TaxDateGeneric Edit60
24F0912Cost Allocations/Flex Budgeting28RJDSVJDate - Service/TaxDateGeneric Edit60
25F0912AIndex Computation Entry File24RIDSVJDate - Service/TaxDateGeneric Edit60
26F09UI015Indexed Computations Multi-Tiered Entries96GLDSVJDate - Service/TaxDateGeneric Edit60
TOP12: Fixed Assets
27F1205Equipment Messages14FTDSVJDate - Service/TaxDateGeneric Edit60
28F1205PEquipment Messages Purge Table14FTDSVJDate - Service/TaxDateGeneric Edit60
TOP15: Property Management
29F151991G/L Transaction A/R Application Work File14NBDSVJDate - Service/TaxDateGeneric Edit60
TOP42: Sales Management
30F42800G1Sales Update G Batch Detail Workfile24DGDSVJDate - Service/TaxDateGeneric Edit60
TOP43: Procurement
31F43080Approvals Fields Constants38PDDSVJDate - Service/TaxDateGeneric Edit60
32F4311Purchase Order Detail File30PDDSVJDate - Service/TaxDateGeneric Edit60
33F4311ZPurchase Order Generator File34PWDSVJDate - Service/TaxDateGeneric Edit60
34F4311Z1Purchase Order Detail Unedited Transaction Table43SZDSVJDate - Service/TaxDateGeneric Edit60
35F43199P.O. Detail Ledger File - Flexible Version30OLDSVJDate - Service/TaxDateGeneric Edit60
TOP47: Electronic Commerce
36F470161EDI Purchase Order Additional Header - Outbound58S3DSVJDate - Service/TaxDateGeneric Edit60
37F47017EDI Purchase Order Detail - Outbound43SZDSVJDate - Service/TaxDateGeneric Edit60
38F470171EDI Purchase Order Additional Detail - Outbound40S4DSVJDate - Service/TaxDateGeneric Edit60
39F47022EDI P.O. Acknowledgment Detail - Inbound43SZDSVJDate - Service/TaxDateGeneric Edit60
40F47032EDI Shipping Notice Detail - Inbound43SZDSVJDate - Service/TaxDateGeneric Edit60
41F470461EDI Invoice Additional Header - Outbound59S3DSVJDate - Service/TaxDateGeneric Edit60
42F470471EDI Invoice Additional Detail - Outbound43S4DSVJDate - Service/TaxDateGeneric Edit60
43F47057EDI Payment Order Remittance Advice - Outbound42D3DSVJDate - Service/TaxDateGeneric Edit60
44F47057WEDI Payment Order Remittance Advice - Work42D3DSVJDate - Service/TaxDateGeneric Edit60
45F47072EDI Receiving Advice Detail - Inbound44SZDSVJDate - Service/TaxDateGeneric Edit60
46F47077EDI Receiving Advice Detail - Outbound44SZDSVJDate - Service/TaxDateGeneric Edit60
47F47097EDI Request for Quote Detail - Outbound43SZDSVJDate - Service/TaxDateGeneric Edit60
48F47102EDI Response to RFQ Detail - Inbound43SZDSVJDate - Service/TaxDateGeneric Edit60
49F471061EDI Response to RFQ Additional Header - Outbound59S3DSVJDate - Service/TaxDateGeneric Edit60
50F471071EDI Response to RFQ Additional Detail - Outbound43S4DSVJDate - Service/TaxDateGeneric Edit60
51F47137EDI Purchase Order Change Detail - Outbound44SZDSVJDate - Service/TaxDateGeneric Edit60
52F47142EDI P.O. Change Acknowledgment Detail - Inbound45SZDSVJDate - Service/TaxDateGeneric Edit60
53F47157EDI Shipping Schedule Detail - Outbound45SZDSVJDate - Service/TaxDateGeneric Edit60
TOP48S: Service Billing
54F4812Billing Detail Workfile47WDDSVJDate - Service/TaxDateGeneric Edit60
55F4812HBilling Workfile - History47WDDSVJDate - Service/TaxDateGeneric Edit60
56F4812HSBilling Workfile History Purged Save47WDDSVJDate - Service/TaxDateGeneric Edit60
57F4822Invoice Summary Work File26W4DSVJDate - Service/TaxDateGeneric Edit60
58F4823Voucher Summary24W0DSVJDate - Service/TaxDateGeneric Edit60
59F48S910Billing Detail Journal File78W2DSVJDate - Service/TaxDateGeneric Edit60
60F48S911Compressed Journal File42W3DSVJDate - Service/TaxDateGeneric Edit60
61F48SUI01Billing Detail Print Workfile47WDDSVJDate - Service/TaxDateGeneric Edit60
TOP55: Reserved for Clients
62F55IF311As Of125RPDSVJDate - Service/TaxDateGeneric Edit60
63F74H1050Invoicing Workfile Header - New11IHDSVJDate - Service/TaxDateGeneric Edit60
TOP74: EMEA Localization
64F74093Workfile for Printing IVA Summary - Italy20HCDSVJDate - Service/TaxDateGeneric Edit60
65F74900Foreign Receivables and Payables - EMEA52RPDSVJDate - Service/TaxDateGeneric Edit60
TOP74R: CIS
66F74R0018Russian Tax File - 74R13TDDSVJDate - Service/TaxDateGeneric Edit60
67F74R4500Paymet Order Supplemental Data - RU - 04 - 74R15PODSVJDate - Service/TaxDateGeneric Edit60
TOP76A: Argentina
68F76A09Invoice Total - ARG - 00 - 0030TTDSVJDate - Service/TaxDateGeneric Edit60
69F76A09PInvoice Total Purge - ARG - 03B - 76A30TTDSVJDate - Service/TaxDateGeneric Edit60
70F76A8001Generation SICORE's Files - Last Step -RG 738/99 - 0411V2DSVJDate - Service/TaxDateGeneric Edit60
TOP76C: Colombia
71F76C031AA/R Customer ledger As Of - F76C031A - COL - 0444RPDSVJDate - Service/TaxDateGeneric Edit60
72F76C575Work File Magnetic Media - COL - 0414Q1DSVJDate - Service/TaxDateGeneric Edit60
73F76CT1Tributary Information - COL - 76C13TIDSVJDate - Service/TaxDateGeneric Edit60
74F76CT2Sales/Use/V.A.T. Tax File - COL - 76C13CTDSVJDate - Service/TaxDateGeneric Edit60
TOP89: Conversion Programs
75F43199ATemp F43199 for ERP 9.0 Upgrade30OLDSVJDate - Service/TaxDateGeneric Edit60