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
3F0911GLAccount Ledger
4F4101IMItem Master
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

44 columns | Print definition?812 | EXA

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger36GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP03B: Enhanced Accounts Receivable
2F09UI011Receipt Prepost Work File27GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP04: Accounts Payable
3F09UI005Tax Offsets User Index25GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP05: Time Accounting and HRM Base
4F069027Table Code Unit-of-Measure Window2Y2EXAName - Alpha ExplanationStringGeneric Edit300
5F069116Payroll Transaction Constants2YCEXAName - Alpha ExplanationStringGeneric Edit300
6F06931Wage Attachment File2J3EXAName - Alpha ExplanationStringGeneric Edit300
TOP05T: Time Entry
7F063951Payroll Journal (Compressed) File17GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP07: Payroll
8F05290WF - Payroll Journal (Detail)17JREXAName - Alpha ExplanationStringGeneric Edit300
9F069026Payroll Generic Tables12Y2EXAName - Alpha ExplanationStringGeneric Edit300
10F0729Employee DBA Override Instructions8Y9EXAName - Alpha ExplanationStringGeneric Edit300
11F07390Year-End Rollover Workfile9ROEXAName - Alpha ExplanationStringGeneric Edit300
TOP08AD: ADP Integration
12F051375ADP Payroll DBA Transaction Constants4ADEXAName - Alpha ExplanationStringGeneric Edit300
TOP08B: Benefits Administration
13F08320Benefits Plan Master2BAEXAName - Alpha ExplanationStringGeneric Edit300
14F08380WFBatch Enrollment Work File6BEEXAName - Alpha ExplanationStringGeneric Edit300
TOP09: General Accounting
15F0911PPurge - Account Ledger36GLEXAName - Alpha ExplanationStringGeneric Edit300
16F0911RWF - Acct Ledger File for Reconciliation33GLEXAName - Alpha ExplanationStringGeneric Edit300
17F0911Z1Journal Entry Transactions - Batch File53VNEXAName - Alpha ExplanationStringGeneric Edit300
18F0911Z4F0911 Interoperability Table58SZEXAName - Alpha ExplanationStringGeneric Edit300
19F0912Cost Allocations/Flex Budgeting29RJEXAName - Alpha ExplanationStringGeneric Edit300
20F0912AIndex Computation Entry File25RIEXAName - Alpha ExplanationStringGeneric Edit300
21F0912BVariable Allocation File9R#EXAName - Alpha ExplanationStringGeneric Edit300
22F0917Bank Statement Detail48GDEXAName - Alpha ExplanationStringGeneric Edit300
23F09505WF - Bank File of Cleared Checks.3GNEXAName - Alpha ExplanationStringGeneric Edit300
24F09UI015Indexed Computations Multi-Tiered Entries36GLEXAName - Alpha ExplanationStringGeneric Edit300
25F70UI001Work File for G/L by Cat. Code Localization7WAEXAName - Alpha ExplanationStringGeneric Edit300
26F740911Work File for G/L Report by Category Code Localization10WAEXAName - Alpha ExplanationStringGeneric Edit300
TOP11: Multi Currency
27F1114Company Conversions Parameter File16C2EXAName - Alpha ExplanationStringGeneric Edit300
TOP12: Fixed Assets
28F12911ERPost G/L to FA Exceptions Work File6GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP42: Sales Management
29F42800GSales Update G Batch Workfile21SGEXAName - Alpha ExplanationStringGeneric Edit300
30F42800G1Sales Update G Batch Detail Workfile116DGEXAName - Alpha ExplanationStringGeneric Edit300
TOP48S: Service Billing
31F4812Billing Detail Workfile50WDEXAName - Alpha ExplanationStringGeneric Edit300
32F4812HBilling Workfile - History50WDEXAName - Alpha ExplanationStringGeneric Edit300
33F4812HSBilling Workfile History Purged Save50WDEXAName - Alpha ExplanationStringGeneric Edit300
34F48S910Billing Detail Journal File25W2EXAName - Alpha ExplanationStringGeneric Edit300
35F48S911Compressed Journal File35W3EXAName - Alpha ExplanationStringGeneric Edit300
36F48SUI01Billing Detail Print Workfile50WDEXAName - Alpha ExplanationStringGeneric Edit300
TOP51: Job Costing
37F51911EXDraw Explanation Table6GKEXAName - Alpha ExplanationStringGeneric Edit300
TOP55: Reserved for Clients
38F55IFP04Pozycje Budżetowe WF13WFEXAName - Alpha ExplanationStringGeneric Edit300
39F59BO001Cash Journal Master File15CJEXAName - Alpha ExplanationStringGeneric Edit300
40F59PO001Cash Journal Master File15CJEXAName - Alpha ExplanationStringGeneric Edit300
41F74T550General Ledger Work File - Turkish30DKEXAName - Alpha ExplanationStringGeneric Edit300
TOP76A: Argentina
42F76A42CERG G/L - Work File - ARG - 09 - 0911TFEXAName - Alpha ExplanationStringGeneric Edit300
TOP76B: Brazil - Reporting System Only
43F76B10Account Ledger - IN68 - 0917AREXAName - Alpha ExplanationStringGeneric Edit300
44F76B911IN86-Work Table for Journal Entries - 0917BDEXAName - Alpha ExplanationStringGeneric Edit300