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

63 columns | Print definition?910 | RC5

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger139GLRC5File Line Identifier 5.0NumericGeneric Edit50
TOP03B: Enhanced Accounts Receivable
2F03B14Receipts Detail2RZRC5File Line Identifier 5.0NumericGeneric Edit50
3F03B14PReceipts Detail Purge File2RZRC5File Line Identifier 5.0NumericGeneric Edit50
4F03B14Z2F03B14 Interoperability Table15SZRC5File Line Identifier 5.0NumericGeneric Edit50
5F03B21A/R Notification History Detail2ZSRC5File Line Identifier 5.0NumericGeneric Edit50
6F03B23A/R Fee Journal History Detail2RTRC5File Line Identifier 5.0NumericGeneric Edit50
7F03B40A/R Deduction Management23RBRC5File Line Identifier 5.0NumericGeneric Edit50
8F09UI011Receipt Prepost Work File43GLRC5File Line Identifier 5.0NumericGeneric Edit50
9F74W300A/R Fee Journal History Detail Tag File2RURC5File Line Identifier 5.0NumericGeneric Edit50
TOP04: Accounts Payable
10F0414Accounts Payable Matching Document Detail2RNRC5File Line Identifier 5.0NumericGeneric Edit50
11F0414AWF - As Of Accounts Payable Payment Detail2RNRC5File Line Identifier 5.0NumericGeneric Edit50
12F0414PPurge - Accounts Payable Matching Document Detail2RNRC5File Line Identifier 5.0NumericGeneric Edit50
13F0414Z1F0414 Interoperability Table15SZRC5File Line Identifier 5.0NumericGeneric Edit50
14F09UI005Tax Offsets User Index49GLRC5File Line Identifier 5.0NumericGeneric Edit50
TOP09: General Accounting
15F0911PPurge - Account Ledger139GLRC5File Line Identifier 5.0NumericGeneric Edit50
16F0911RWF - Account Ledger Reconciliation77GLRC5File Line Identifier 5.0NumericGeneric Edit50
17F0911Z1Journal Entry Transactions - Batch File191VNRC5File Line Identifier 5.0NumericGeneric Edit50
18F0911Z4F0911 Interoperability Table166SZRC5File Line Identifier 5.0NumericGeneric Edit50
TOP10: Financial Reporting
19F1002Multi-Site Consolidation Transfer File4GQRC5File Line Identifier 5.0NumericGeneric Edit50
20F1002Z1Unedited MSC Interoperability Table4SZRC5File Line Identifier 5.0NumericGeneric Edit50
21F1003Multi-Site Consolidation Transfer File - Category Codes4GRRC5File Line Identifier 5.0NumericGeneric Edit50
22F10UI006MSC - F1002 Elimination Work File5GERC5File Line Identifier 5.0NumericGeneric Edit50
TOP47: Electronic Commerce
23F47057EDI Payment Order Remittance Advice - Outbound106D3RC5File Line Identifier 5.0NumericGeneric Edit50
24F47057WEDI Payment Order Remittance Advice - Work106D3RC5File Line Identifier 5.0NumericGeneric Edit50
TOP55: Reserved for Clients
25F55IFVALOutput File di R55IFVALOR14FARC5File Line Identifier 5.0NumericGeneric Edit50
TOP74: EMEA Localization
26F7400006Processed Documents in Legal Applications - COMM - 006PDRC5File Line Identifier 5.0NumericGeneric Edit50
27F7400C2AFrench VAT on A/R2FCRC5File Line Identifier 5.0NumericGeneric Edit50
28F7400C3French VAT on A/P2TGRC5File Line Identifier 5.0NumericGeneric Edit50
TOP74P: Poland
29F74P03BWA/R Trial Balance - POL - 03B - 74P17P3RC5File Line Identifier 5.0NumericGeneric Edit50
30F74P04WA/P Trial Balance Work Table - POL - 04 - 74P18P2RC5File Line Identifier 5.0NumericGeneric Edit50
31F74P3B23A/R Fee Journal History Detail for Poland - POL - 03B2HDRC5File Line Identifier 5.0NumericGeneric Edit50
TOP74R: CIS
32F74R0018Russian Tax File - 74R66TDRC5File Line Identifier 5.0NumericGeneric Edit50
33F74R311Prepayment Detail Tax File - RUS - 03B7DERC5File Line Identifier 5.0NumericGeneric Edit50
34F74R3B14F03B14 Tag File - RUS - 03B - 74R2TFRC5File Line Identifier 5.0NumericGeneric Edit50
35F74R4014F0414 Tag File - RUS - 04 - 74R2TFRC5File Line Identifier 5.0NumericGeneric Edit50
TOP74U: United Kingdom Localizations
36F74U0445SPC Accounts Payable Match Doc Detail Tag File - UK - 432RNRC5File Line Identifier 5.0NumericGeneric Edit50
TOP74Y: Italy - Reporting System Only
37F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B3TIRC5File Line Identifier 5.0NumericGeneric Edit50
TOP75A: Australia - Reporting System Only
38F75A200GST - Tax Invoice / Adjustment Note Tag file2TFRC5File Line Identifier 5.0NumericGeneric Edit50
TOP75I: India
39F75I611TCS Prepayment Transaction File - IND-03B6TTRC5File Line Identifier 5.0NumericGeneric Edit50
40F75I732Service Tax A/R File Additional Info - IND - 03B7STRC5File Line Identifier 5.0NumericGeneric Edit50
41F75I734Service Tax Received File - IND - 03B2PFRC5File Line Identifier 5.0NumericGeneric Edit50
42F75I742Service Tax A/P File Additional Info - IND - 048STRC5File Line Identifier 5.0NumericGeneric Edit50
43F75I744Service Tax Payment File - IND - 042PFRC5File Line Identifier 5.0NumericGeneric Edit50
44F75I754Advance Service Tax Payment File - IND -042APRC5File Line Identifier 5.0NumericGeneric Edit50
45F75IUI7Service Tax Credit Register - Work File - IND2WFRC5File Line Identifier 5.0NumericGeneric Edit50
TOP76A: Argentina
46F760414AA/P Payment Detail Tag Table - ARG - 04 - 76A2V1RC5File Line Identifier 5.0NumericGeneric Edit50
47F76A414PPurge - A/P Payment Detail - ARG - 04 - 76A2V1RC5File Line Identifier 5.0NumericGeneric Edit50
48F76A8500Tag File F03B14 - ARG - 03B - 76A2TFRC5File Line Identifier 5.0NumericGeneric Edit50
49F76AUI81Draft - Invoices Work File - ARG - 03B - 76A33WFRC5File Line Identifier 5.0NumericGeneric Edit50
50F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A8WFRC5File Line Identifier 5.0NumericGeneric Edit50
TOP76B: Brazil - Reporting System Only
51F76B12TENF-e Status Log - BRA - 76B5SLRC5File Line Identifier 5.0NumericGeneric Edit50
52F76B8602IN86-Work Table for Suppliers and Customers - 0421PRRC5File Line Identifier 5.0NumericGeneric Edit50
TOP76C: Colombia
53F76C034AA/R Check Detail file As Of - COL - 03B3RZRC5File Line Identifier 5.0NumericGeneric Edit50
54F76C4F01DIAN Formats File by Payment - COL - 043FPRC5File Line Identifier 5.0NumericGeneric Edit50
TOP76H: Chile
55F76H402Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H2LPRC5File Line Identifier 5.0NumericGeneric Edit50
TOP76M: Mexico
56F76M0314Receipt Detail Tag File - Mexico2MARC5File Line Identifier 5.0NumericGeneric Edit50
57F76M0414F0414 - Payment Detail Tag File - Mexico2RTRC5File Line Identifier 5.0NumericGeneric Edit50
58F76M414A/P Matching Detail Withholding Information - MEX - 042MWRC5File Line Identifier 5.0NumericGeneric Edit50
59F76M930AR VAT on Gain/loss MEX - 76M2APRC5File Line Identifier 5.0NumericGeneric Edit50
60F76M940AP VAT on Gain/loss - MEX - 76M2APRC5File Line Identifier 5.0NumericGeneric Edit50
61F76M990GL VAT on Gain/loss MEX - 76M19GLRC5File Line Identifier 5.0NumericGeneric Edit50
TOP76P: Peru
62F76P414TF0414 Tag File - PER - 04 - 76P2P4RC5File Line Identifier 5.0NumericGeneric Edit50
TOP89: Conversion Programs
63F0086Conversion Audit File for Euro Conversion5AURC5File Line Identifier 5.0NumericGeneric Edit50