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

54 columns | Print definition?910 | 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
7F059022Pay Calculation Table11PCEXAName - Alpha ExplanationStringGeneric Edit300
8F063951Payroll Journal (Compressed) File17GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP07: Payroll
9F05290WF - Payroll Journal (Detail)17JREXAName - Alpha ExplanationStringGeneric Edit300
10F069026Payroll Generic Tables12Y2EXAName - Alpha ExplanationStringGeneric Edit300
11F0729Employee DBA Override Instructions8Y9EXAName - Alpha ExplanationStringGeneric Edit300
12F07390Year-End Rollover Workfile9ROEXAName - Alpha ExplanationStringGeneric Edit300
TOP08AD: ADP Integration
13F051375ADP Payroll DBA Transaction Constants4ADEXAName - Alpha ExplanationStringGeneric Edit300
TOP08B: Benefits Administration
14F08320Benefits Plan Master2BAEXAName - Alpha ExplanationStringGeneric Edit300
15F08380WFBatch Enrollment Work File6BEEXAName - Alpha ExplanationStringGeneric Edit300
TOP09: General Accounting
16F0911PPurge - Account Ledger36GLEXAName - Alpha ExplanationStringGeneric Edit300
17F0911RWF - Account Ledger Reconciliation33GLEXAName - Alpha ExplanationStringGeneric Edit300
18F0911Z1Journal Entry Transactions - Batch File53VNEXAName - Alpha ExplanationStringGeneric Edit300
19F0911Z4F0911 Interoperability Table58SZEXAName - Alpha ExplanationStringGeneric Edit300
20F0912Cost Allocations/Flex Budgeting29RJEXAName - Alpha ExplanationStringGeneric Edit300
21F09123Advanced Variable Numerator6VNEXAName - Alpha ExplanationStringGeneric Edit300
22F0912AIndex Computation Entry File25RIEXAName - Alpha ExplanationStringGeneric Edit300
23F0912BVariable Allocation File9R#EXAName - Alpha ExplanationStringGeneric Edit300
24F0917Bank Statement Detail48GDEXAName - Alpha ExplanationStringGeneric Edit300
25F09505WF - Bank File of Cleared Checks.3GNEXAName - Alpha ExplanationStringGeneric Edit300
26F09UI015Indexed Computations Multi-Tiered Entries36GLEXAName - Alpha ExplanationStringGeneric Edit300
27F52G11Burdening Detail Ledger26BDEXAName - Alpha ExplanationStringGeneric Edit300
28F52G11WFTemporary Burdened Detail Ledger Workfile26BWEXAName - Alpha ExplanationStringGeneric Edit300
29F70UI001Work File for G/L by Cat. Code Localization7WAEXAName - Alpha ExplanationStringGeneric Edit300
30F740911Work File for G/L Report by Category Code Localization10WAEXAName - Alpha ExplanationStringGeneric Edit300
TOP11: Multi Currency
31F1114Company Conversions Parameter File16C2EXAName - Alpha ExplanationStringGeneric Edit300
TOP12: Fixed Assets
32F12911ERPost G/L to FA Exceptions Work File6GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP42: Sales Management
33F42800GSales Update G Batch Workfile21SGEXAName - Alpha ExplanationStringGeneric Edit300
34F42800G1Sales Update G Batch Detail Workfile116DGEXAName - Alpha ExplanationStringGeneric Edit300
TOP48S: Service Billing
35F4812Billing Detail Workfile50WDEXAName - Alpha ExplanationStringGeneric Edit300
36F4812HBilling Workfile History50WDEXAName - Alpha ExplanationStringGeneric Edit300
37F4812HSBilling Workfile History Purged Save50WDEXAName - Alpha ExplanationStringGeneric Edit300
38F48S910Billing Detail Journal Workfile25W2EXAName - Alpha ExplanationStringGeneric Edit300
39F48S911Summarized Journal Workfile35W3EXAName - Alpha ExplanationStringGeneric Edit300
40F48SUI01Billing Detail Print Workfile50WDEXAName - Alpha ExplanationStringGeneric Edit300
TOP51: Job Costing
41F51911EXDraw Explanation Table6GKEXAName - Alpha ExplanationStringGeneric Edit300
TOP52G: Government Contracting
42F52G90Invoice Printing Work Table46WTEXAName - Alpha ExplanationStringGeneric Edit300
TOP55: Reserved for Clients
43F55IF05Pozycje Budżetowe WF15WFEXAName - Alpha ExplanationStringGeneric Edit300
44F55IFN5Pozycje Budżetowe WF17WFEXAName - Alpha ExplanationStringGeneric Edit300
45F55IFP04Pozycje Budżetowe WF13WFEXAName - Alpha ExplanationStringGeneric Edit300
46F55IFPN4Pozycje Budżetowe WF15WFEXAName - Alpha ExplanationStringGeneric Edit300
47F59BO001Cash Journal Master File15CJEXAName - Alpha ExplanationStringGeneric Edit300
48F59PO001Cash Journal Master File15CJEXAName - Alpha ExplanationStringGeneric Edit300
49F74T550General Ledger Work File - Turkish30DKEXAName - Alpha ExplanationStringGeneric Edit300
TOP74Z: Czech Republic
50F74Z0010Cash Desk Document Printed - CZE - 74Z13ZOEXAName - Alpha ExplanationStringGeneric Edit300
TOP76A: Argentina
51F76A42CERG G/L - Work File - ARG - 09 - 76A11TFEXAName - Alpha ExplanationStringGeneric Edit300
TOP76B: Brazil - Reporting System Only
52F76B10Account Ledger - IN68 - 0917AREXAName - Alpha ExplanationStringGeneric Edit300
53F76B911IN86-Work Table for Journal Entries - 0917BDEXAName - Alpha ExplanationStringGeneric Edit300
TOP76C: Colombia
54F76C9F02DIAN Formats by AccountID - COL - 0917DFEXAName - Alpha ExplanationStringGeneric Edit300