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

51 columns | Print definition?920 | EXA

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger36GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP03B: Enhanced Accounts Receivable
2F03B117Revenue Recognition GL Info66RLEXAName - Alpha ExplanationStringGeneric Edit300
3F03B119Revenue Recognition GL Info Audit67RNEXAName - Alpha ExplanationStringGeneric Edit300
4F09UI011Receipt Prepost Work File27GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP04: Accounts Payable
5F09UI005Tax Offsets User Index25GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP05: Time Accounting and HRM Base
6F069027Table Code Unit-of-Measure Window2Y2EXAName - Alpha ExplanationStringGeneric Edit300
7F069116Payroll Transaction Constants2YCEXAName - Alpha ExplanationStringGeneric Edit300
8F069130Group Limits2YDEXAName - Alpha ExplanationStringGeneric Edit300
9F06931Wage Attachment File2J3EXAName - Alpha ExplanationStringGeneric Edit300
TOP05T: Time Entry
10F059022Pay Calculation Table11PCEXAName - Alpha ExplanationStringGeneric Edit300
11F063951Payroll Journal (Compressed) File17GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP07: Payroll
12F05290WF - Payroll Journal (Detail)17JREXAName - Alpha ExplanationStringGeneric Edit300
13F069026Payroll Generic Tables12Y2EXAName - Alpha ExplanationStringGeneric Edit300
14F0729Employee DBA Override Instructions8Y9EXAName - Alpha ExplanationStringGeneric Edit300
15F07390Year-End Rollover Workfile9ROEXAName - Alpha ExplanationStringGeneric Edit300
TOP08AD: ADP Integration
16F051375ADP Payroll DBA Transaction Constants4ADEXAName - Alpha ExplanationStringGeneric Edit300
TOP08B: Benefits Administration
17F08320Benefits Plan Master2BAEXAName - Alpha ExplanationStringGeneric Edit300
18F08380WFBatch Enrollment Work File6BEEXAName - Alpha ExplanationStringGeneric Edit300
TOP09: General Accounting
19F0911PPurge - Account Ledger36GLEXAName - Alpha ExplanationStringGeneric Edit300
20F0911RWF - Account Ledger Reconciliation33GLEXAName - Alpha ExplanationStringGeneric Edit300
21F0911Z1Journal Entry Transactions - Batch File53VNEXAName - Alpha ExplanationStringGeneric Edit300
22F0911Z4F0911 Interoperability Table58SZEXAName - Alpha ExplanationStringGeneric Edit300
23F0912Cost Allocations/Flex Budgeting29RJEXAName - Alpha ExplanationStringGeneric Edit300
24F09123Advanced Variable Numerator6VNEXAName - Alpha ExplanationStringGeneric Edit300
25F0912AIndex Computation Entry File25RIEXAName - Alpha ExplanationStringGeneric Edit300
26F0912BVariable Allocation File9R#EXAName - Alpha ExplanationStringGeneric Edit300
27F0917Bank Statement Detail48GDEXAName - Alpha ExplanationStringGeneric Edit300
28F09505WF - Bank File of Cleared Checks.3GNEXAName - Alpha ExplanationStringGeneric Edit300
29F097021WAccount Ledger to Account Master Work Table13TAEXAName - Alpha ExplanationStringGeneric Edit300
30F09UI015Indexed Computations Multi-Tiered Entries36GLEXAName - Alpha ExplanationStringGeneric Edit300
31F52G11Burdening Detail Ledger26BDEXAName - Alpha ExplanationStringGeneric Edit300
32F52G11WFTemporary Burdened Detail Ledger Workfile26BWEXAName - Alpha ExplanationStringGeneric Edit300
33F70UI001Work File for G/L by Cat. Code Localization7WAEXAName - Alpha ExplanationStringGeneric Edit300
34F740911Work File for G/L Report by Category Code Localization10WAEXAName - Alpha ExplanationStringGeneric Edit300
TOP11: Multi Currency
35F1114Company Conversions Parameter File16C2EXAName - Alpha ExplanationStringGeneric Edit300
TOP12: Fixed Assets
36F12911ERPost G/L to FA Exceptions Work File6GLEXAName - Alpha ExplanationStringGeneric Edit300
TOP42: Sales Management
37F42800GSales Update G Batch Workfile21SGEXAName - Alpha ExplanationStringGeneric Edit300
38F42800G1Sales Update G Batch Detail Workfile116DGEXAName - Alpha ExplanationStringGeneric Edit300
TOP48S: Service Billing
39F4812Billing Detail Workfile50WDEXAName - Alpha ExplanationStringGeneric Edit300
40F4812HBilling Workfile History50WDEXAName - Alpha ExplanationStringGeneric Edit300
41F4812HSBilling Workfile History Purged Save50WDEXAName - Alpha ExplanationStringGeneric Edit300
42F48S910Billing Detail Journal Workfile25W2EXAName - Alpha ExplanationStringGeneric Edit300
43F48S911Summarized Journal Workfile35W3EXAName - Alpha ExplanationStringGeneric Edit300
44F48SUI01Billing Detail Print Workfile50WDEXAName - Alpha ExplanationStringGeneric Edit300
TOP51: Job Costing
45F51911EXDraw Explanation Table6GKEXAName - Alpha ExplanationStringGeneric Edit300
TOP52G: Proj & Gov Contract Accounting
46F52G90Invoice Printing Work Table46WTEXAName - Alpha ExplanationStringGeneric Edit300
TOP74Z: Czech Republic
47F74Z0010Cash Desk Document Printed - CZE - 74Z13ZOEXAName - Alpha ExplanationStringGeneric Edit300
TOP76A: Argentina
48F76A42CERG G/L - Work File - ARG - 09 - 76A11TFEXAName - Alpha ExplanationStringGeneric Edit300
TOP76B: Brazil
49F76B10Account Ledger - IN68 - 0917AREXAName - Alpha ExplanationStringGeneric Edit300
50F76B911IN86-Work Table for Journal Entries - 0917BDEXAName - Alpha ExplanationStringGeneric Edit300
TOP76C: Colombia
51F76C9F02DIAN Formats by AccountID - COL - 0917DFEXAName - Alpha ExplanationStringGeneric Edit300