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

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