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

73 columns | Print definition?920 | JELN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00189WF - Tax Reconciliation8TGJELNJournal Entry Line NumberNumericGeneric Edit70
2F0018RTax Reconciliation Repository5EDJELNJournal Entry Line NumberNumericGeneric Edit70
3F0911Account Ledger5GLJELNJournal Entry Line NumberNumericGeneric Edit70
TOP03B: Enhanced Accounts Receivable
4F03B117Revenue Recognition GL Info5RLJELNJournal Entry Line NumberNumericGeneric Edit70
5F03B119Revenue Recognition GL Info Audit5RNJELNJournal Entry Line NumberNumericGeneric Edit70
TOP05T: Time Entry
6F063951Payroll Journal (Compressed) File21GLJELNJournal Entry Line NumberNumericGeneric Edit70
TOP07: Payroll
7F05290WF - Payroll Journal (Detail)21JRJELNJournal Entry Line NumberNumericGeneric Edit70
TOP09: General Accounting
8F0911PPurge - Account Ledger5GLJELNJournal Entry Line NumberNumericGeneric Edit70
9F0911RWF - Account Ledger Reconciliation5GLJELNJournal Entry Line NumberNumericGeneric Edit70
10F0911Z1Journal Entry Transactions - Batch File22VNJELNJournal Entry Line NumberNumericGeneric Edit70
11F0911Z4F0911 Interoperability Table27SZJELNJournal Entry Line NumberNumericGeneric Edit70
12F0912Cost Allocations/Flex Budgeting33RJJELNJournal Entry Line NumberNumericGeneric Edit70
13F0912AIndex Computation Entry File29RIJELNJournal Entry Line NumberNumericGeneric Edit70
14F097021WAccount Ledger to Account Master Work Table7TAJELNJournal Entry Line NumberNumericGeneric Edit70
15F09UI015Indexed Computations Multi-Tiered Entries5GLJELNJournal Entry Line NumberNumericGeneric Edit70
16F09UI017Cash Forecast Detail6FWJELNJournal Entry Line NumberNumericGeneric Edit70
17F52G11Burdening Detail Ledger5BDJELNJournal Entry Line NumberNumericGeneric Edit70
18F52G11WFTemporary Burdened Detail Ledger Workfile5BWJELNJournal Entry Line NumberNumericGeneric Edit70
TOP12: Fixed Assets
19F12911ERPost G/L to FA Exceptions Work File3GLJELNJournal Entry Line NumberNumericGeneric Edit70
TOP15: Real Estate Management
20F1532BExpense Participation Audit File4NTJELNJournal Entry Line NumberNumericGeneric Edit70
TOP38: Agreement Management
21F38111Agreements Transaction Ledger17DZJELNJournal Entry Line NumberNumericGeneric Edit70
TOP39: Advanced Stock Valuation
22F3910G/L Adjustment Table16SCJELNJournal Entry Line NumberNumericGeneric Edit70
TOP40: Inventory/OP Base
23F40UI801Generic Error Table14ZBJELNJournal Entry Line NumberNumericGeneric Edit70
TOP41: Inventory Management
24F4111Item Ledger File25ILJELNJournal Entry Line NumberNumericGeneric Edit70
25F41291ZLanded Cost Cache Table31IGJELNJournal Entry Line NumberNumericGeneric Edit70
TOP41B: Bulk Stock Management
26F41511Bulk Product Transaction File4PAJELNJournal Entry Line NumberNumericGeneric Edit70
27F41512Gain/Loss Transactions File7PTJELNJournal Entry Line NumberNumericGeneric Edit70
TOP42: Sales Management
28F42800G1Sales Update G Batch Detail Workfile3DGJELNJournal Entry Line NumberNumericGeneric Edit70
TOP43: Procurement
29F43121Purchase Order Receiver File60PRJELNJournal Entry Line NumberNumericGeneric Edit70
30F43121ZReceiver workfile12PWJELNJournal Entry Line NumberNumericGeneric Edit70
31F43121Z1Receipts Unedited Transaction Table77SZJELNJournal Entry Line NumberNumericGeneric Edit70
32F4314ZVoucher Match Selection File160PNJELNJournal Entry Line NumberNumericGeneric Edit70
TOP43A: Purchase Order Receipt/Routing
33F43126Purchase Order Receiver Multiple Account26P4JELNJournal Entry Line NumberNumericGeneric Edit70
34F43127Purchase Order Receiver Non-Billable18PRJELNJournal Entry Line NumberNumericGeneric Edit70
TOP47: Electronic Commerce
35F47122EDI Product Activity Data Detail - Inbound53MJJELNJournal Entry Line NumberNumericGeneric Edit70
36F47127EDI Product Activity Data Detail - Outbound53MJJELNJournal Entry Line NumberNumericGeneric Edit70
TOP48S: Service Billing
37F4812Billing Detail Workfile5WDJELNJournal Entry Line NumberNumericGeneric Edit70
38F4812HBilling Workfile History5WDJELNJournal Entry Line NumberNumericGeneric Edit70
39F4812HSBilling Workfile History Purged Save5WDJELNJournal Entry Line NumberNumericGeneric Edit70
40F48S910Billing Detail Journal Workfile15W2JELNJournal Entry Line NumberNumericGeneric Edit70
41F48S911Summarized Journal Workfile13W3JELNJournal Entry Line NumberNumericGeneric Edit70
42F48S912G/L Link10W6JELNJournal Entry Line NumberNumericGeneric Edit70
43F48SUI01Billing Detail Print Workfile5WDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP49: Transportation Management
44F49631Load In-transit Ledger4TOJELNJournal Entry Line NumberNumericGeneric Edit70
45F4981Freight Audit History45FHJELNJournal Entry Line NumberNumericGeneric Edit70
TOP51: Job Costing
46F51911Draw Reporting Master4GKJELNJournal Entry Line NumberNumericGeneric Edit70
47F51911EXDraw Explanation Table5GKJELNJournal Entry Line NumberNumericGeneric Edit70
TOP70: Multi-National Products
48F700911GL Invoice Number5GAJELNJournal Entry Line NumberNumericGeneric Edit70
49F704200Final VAT AP - COMM - 7016FVJELNJournal Entry Line NumberNumericGeneric Edit70
TOP74P: Poland
50F74P9100Cash Desk Transaction - POL - 74P8CDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP74R: Russia
51F74R0018Russian Tax File - 74R72TDJELNJournal Entry Line NumberNumericGeneric Edit70
52F74R0100Petty Cash Transactions - RUS - 00 - 74R9PCJELNJournal Entry Line NumberNumericGeneric Edit70
TOP75C: China
53F75C015Cash Flow Data - China5CFJELNJournal Entry Line NumberNumericGeneric Edit70
54F75C202Asset Disposal Amounts - CHINA8DAJELNJournal Entry Line NumberNumericGeneric Edit70
55F75C911AAccount Ledger Processing Info- China - 096ALJELNJournal Entry Line NumberNumericGeneric Edit70
56F75C912Transaction-wise Subsidiary Info - China - 096TSJELNJournal Entry Line NumberNumericGeneric Edit70
TOP75I: India
57F75I310WVoucher Entry Record6REJELNJournal Entry Line NumberNumericGeneric Edit70
TOP75T: Taiwan
58F75T005GUI/VAT Transaction Detail - 75T39TDJELNJournal Entry Line NumberNumericGeneric Edit70
59F75T0059GUI/VAT Transaction Detail History - 75T39TDJELNJournal Entry Line NumberNumericGeneric Edit70
60F75T005TGUI/VAT Transaction Detail Temp - 75T39TDJELNJournal Entry Line NumberNumericGeneric Edit70
61F75T005ZGUI/VAT Transaction Detail - Work - 75T46ZDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76A: Argentina
62F76A41CERG G/L - Lot Detail - ARG - 09 - 76A7LDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76B: Brazil
63F76B911IN86-Work Table for Journal Entries - 0915BDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76C: Colombia
64F76C574DIAN File Type 2 (C) - COL - 042R2JELNJournal Entry Line NumberNumericGeneric Edit70
65F76C575Work File Magnetic Media - COL - 0415Q1JELNJournal Entry Line NumberNumericGeneric Edit70
66F76C576DIAN Flat File - COL - 041PLJELNJournal Entry Line NumberNumericGeneric Edit70
67F76C9F02DIAN Formats by AccountID - COL - 096DFJELNJournal Entry Line NumberNumericGeneric Edit70
68F76CT1Tributary Information - COL - 76C14TIJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76H: Chile
69F76H611Actual Item Ledger File - CHI - 41 - 76H26ALJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76M: Mexico
70F76M0314Receipt Detail Tag File - Mexico7MAJELNJournal Entry Line NumberNumericGeneric Edit70
71F76M0414F0414 - Payment Detail Tag File - Mexico11RTJELNJournal Entry Line NumberNumericGeneric Edit70
72F76M990GL VAT on Gain/loss MEX - 76M4GLJELNJournal Entry Line NumberNumericGeneric Edit70
TOP89: Conversion Programs
73F0911TNeeded for upgrade for XE and below6GLJELNJournal Entry Line NumberNumericGeneric Edit70