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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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

55 columns | Print definition?812 | 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
4F0911TAccount Ledger Tag File6GLJELNJournal Entry Line NumberNumericGeneric Edit70
TOP05T: Time Entry
5F063951Payroll Journal (Compressed) File21GLJELNJournal Entry Line NumberNumericGeneric Edit70
TOP07: Payroll
6F05290WF - Payroll Journal (Detail)21JRJELNJournal Entry Line NumberNumericGeneric Edit70
TOP09: General Accounting
7F0911PPurge - Account Ledger5GLJELNJournal Entry Line NumberNumericGeneric Edit70
8F0911RWF - Acct Ledger File for Reconciliation5GLJELNJournal Entry Line NumberNumericGeneric Edit70
9F0911Z1Journal Entry Transactions - Batch File22VNJELNJournal Entry Line NumberNumericGeneric Edit70
10F0911Z4F0911 Interoperability Table27SZJELNJournal Entry Line NumberNumericGeneric Edit70
11F0912Cost Allocations/Flex Budgeting33RJJELNJournal Entry Line NumberNumericGeneric Edit70
12F0912AIndex Computation Entry File29RIJELNJournal Entry Line NumberNumericGeneric Edit70
13F09UI015Indexed Computations Multi-Tiered Entries5GLJELNJournal Entry Line NumberNumericGeneric Edit70
14F09UI017Cash Forecast Detail6FWJELNJournal Entry Line NumberNumericGeneric Edit70
TOP12: Fixed Assets
15F12911ERPost G/L to FA Exceptions Work File3GLJELNJournal Entry Line NumberNumericGeneric Edit70
TOP15: Property Management
16F1532BExpense Participation Audit File4NTJELNJournal Entry Line NumberNumericGeneric Edit70
TOP38: Agreement Management
17F38111Agreements Transaction Ledger17DZJELNJournal Entry Line NumberNumericGeneric Edit70
TOP39: Advanced Stock Valuation
18F3910G/L Adjustment Table16SCJELNJournal Entry Line NumberNumericGeneric Edit70
TOP40: Inventory/OP Base
19F40UI801Generic Error Table14ZBJELNJournal Entry Line NumberNumericGeneric Edit70
TOP41: Inventory Management
20F4111Item Ledger File25ILJELNJournal Entry Line NumberNumericGeneric Edit70
21F41291ZLanded Cost Cache Table31IGJELNJournal Entry Line NumberNumericGeneric Edit70
TOP41B: Bulk Stock Management
22F41511Bulk Product Transaction File4PAJELNJournal Entry Line NumberNumericGeneric Edit70
23F41512Gain/Loss Transactions File7PTJELNJournal Entry Line NumberNumericGeneric Edit70
TOP42: Sales Management
24F42800G1Sales Update G Batch Detail Workfile3DGJELNJournal Entry Line NumberNumericGeneric Edit70
TOP43: Procurement
25F43121Purchase Order Receiver File60PRJELNJournal Entry Line NumberNumericGeneric Edit70
26F43121ZReceiver workfile12PWJELNJournal Entry Line NumberNumericGeneric Edit70
27F43121Z1Receipts Unedited Transaction Table77SZJELNJournal Entry Line NumberNumericGeneric Edit70
28F4314ZVoucher Match Selection File160PNJELNJournal Entry Line NumberNumericGeneric Edit70
TOP43A: Purchase Order Receipt/Routing
29F43126Purchase Order Receiver Multiple Account26P4JELNJournal Entry Line NumberNumericGeneric Edit70
TOP47: Electronic Commerce
30F47122EDI Product Activity Data Detail - Inbound53MJJELNJournal Entry Line NumberNumericGeneric Edit70
31F47127EDI Product Activity Data Detail - Outbound53MJJELNJournal Entry Line NumberNumericGeneric Edit70
TOP48S: Service Billing
32F4812Billing Detail Workfile5WDJELNJournal Entry Line NumberNumericGeneric Edit70
33F4812HBilling Workfile - History5WDJELNJournal Entry Line NumberNumericGeneric Edit70
34F4812HSBilling Workfile History Purged Save5WDJELNJournal Entry Line NumberNumericGeneric Edit70
35F48S910Billing Detail Journal File15W2JELNJournal Entry Line NumberNumericGeneric Edit70
36F48S911Compressed Journal File13W3JELNJournal Entry Line NumberNumericGeneric Edit70
37F48S912G/L Link File10W6JELNJournal Entry Line NumberNumericGeneric Edit70
38F48SUI01Billing Detail Print Workfile5WDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP49: Transportation Management
39F49631Load In-transit Ledger4TOJELNJournal Entry Line NumberNumericGeneric Edit70
40F4981Freight Audit History45FHJELNJournal Entry Line NumberNumericGeneric Edit70
TOP51: Job Costing
41F51911Draw Reporting Master4GKJELNJournal Entry Line NumberNumericGeneric Edit70
42F51911EXDraw Explanation Table5GKJELNJournal Entry Line NumberNumericGeneric Edit70
TOP74P: Poland
43F74P9100Cash Desk Transaction - POL - 74P8CDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP74R: CIS
44F74R0018Russian Tax File - 74R72TDJELNJournal Entry Line NumberNumericGeneric Edit70
45F74R0100Petty Cash Transactions - RUS - 00 - 74R9PCJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76A: Argentina
46F76A41CERG G/L - Lot Detail - ARG - 09 - - 097LDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76B: Brazil - Reporting System Only
47F76B911IN86-Work Table for Journal Entries - 0915BDJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76C: Colombia
48F76C574DIAN File Type 2 (C) - COL - 042R2JELNJournal Entry Line NumberNumericGeneric Edit70
49F76C575Work File Magnetic Media - COL - 0415Q1JELNJournal Entry Line NumberNumericGeneric Edit70
50F76C576DIAN Flat File - COL - 041PLJELNJournal Entry Line NumberNumericGeneric Edit70
51F76CT1Tributary Information - COL - 76C14TIJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76H: Chile
52F76H611Actual Item Ledger File - CHI - 41 - 76H26ALJELNJournal Entry Line NumberNumericGeneric Edit70
TOP76M: Mexico
53F76M0314Receipt Detail Tag File - Mexico7MAJELNJournal Entry Line NumberNumericGeneric Edit70
54F76M0414F0414 - Payment Detail Tag File - Mexico11RTJELNJournal Entry Line NumberNumericGeneric Edit70
TOPD3N: dcLINK (data collection) - DSI
55FD3N4116dcLINK Interface - Inventory Reclassification6IRJELNJournal Entry Line NumberNumericGeneric Edit70