JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

70 columns | Print definition?920 | EXR

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger37GLEXRName - Remark ExplanationStringGeneric Edit300
2F4303MLog Models5PMEXRName - Remark ExplanationStringGeneric Edit300
TOP03B: Enhanced Accounts Receivable
3F03B117Revenue Recognition GL Info79RLEXRName - Remark ExplanationStringGeneric Edit300
4F03B119Revenue Recognition GL Info Audit83RNEXRName - Remark ExplanationStringGeneric Edit300
5F03B13Receipts Header37RYEXRName - Remark ExplanationStringGeneric Edit300
6F03B13PReceipts Header Purge File37RYEXRName - Remark ExplanationStringGeneric Edit300
7F03B13Z2F03B13 Interoperability Table50SYEXRName - Remark ExplanationStringGeneric Edit300
8F03B672Draft Remittance36RDEXRName - Remark ExplanationStringGeneric Edit300
9F09UI011Receipt Prepost Work File28GLEXRName - Remark ExplanationStringGeneric Edit300
TOP04: Accounts Payable
10F045141099 Merged Worktables (F045141:F045143)26G1EXRName - Remark ExplanationStringGeneric Edit300
11F0451411099 G/L Worktable26G1EXRName - Remark ExplanationStringGeneric Edit300
12F0451431099 A/P Worktable26G1EXRName - Remark ExplanationStringGeneric Edit300
13F09UI005Tax Offsets User Index40GLEXRName - Remark ExplanationStringGeneric Edit300
TOP05: Time Accounting and HRM Base
14F06106Employee Pay Instructions2YMEXRName - Remark ExplanationStringGeneric Edit300
15F0618Employee Transaction History83YTEXRName - Remark ExplanationStringGeneric Edit300
16F069106Union Benefits Master4Y1EXRName - Remark ExplanationStringGeneric Edit300
TOP05T: Time Entry
17F06116Employee Transaction Detail File83YTEXRName - Remark ExplanationStringGeneric Edit300
18F06116Z1Employee Transactions - Batch File97VLEXRName - Remark ExplanationStringGeneric Edit300
19F06116Z2ESS Timecard History97VMEXRName - Remark ExplanationStringGeneric Edit300
20F06278Retro Timecard Detail File83YTEXRName - Remark ExplanationStringGeneric Edit300
21F06290Payroll Accounting Journal Work File20YREXRName - Remark ExplanationStringGeneric Edit300
22F063951Payroll Journal (Compressed) File18GLEXRName - Remark ExplanationStringGeneric Edit300
23F069136Tip Disbursement9JEEXRName - Remark ExplanationStringGeneric Edit300
TOP07: Payroll
24F05290WF - Payroll Journal (Detail)18JREXRName - Remark ExplanationStringGeneric Edit300
25F07UI200Timecard History Work File86THEXRName - Remark ExplanationStringGeneric Edit300
TOP08AD: ADP Integration
26F051371ADP Employee DBA Instructions7ADEXRName - Remark ExplanationStringGeneric Edit300
TOP08R: Recruitment Management - (Appl. Track. & Req.)
27F06012Personnel Resume5YDEXRName - Remark ExplanationStringGeneric Edit300
TOP09: General Accounting
28F0911PPurge - Account Ledger37GLEXRName - Remark ExplanationStringGeneric Edit300
29F0911RWF - Account Ledger Reconciliation34GLEXRName - Remark ExplanationStringGeneric Edit300
30F0911Z1Journal Entry Transactions - Batch File54VNEXRName - Remark ExplanationStringGeneric Edit300
31F0911Z4F0911 Interoperability Table59SZEXRName - Remark ExplanationStringGeneric Edit300
32F0912Cost Allocations/Flex Budgeting30RJEXRName - Remark ExplanationStringGeneric Edit300
33F0912AIndex Computation Entry File26RIEXRName - Remark ExplanationStringGeneric Edit300
34F097021WAccount Ledger to Account Master Work Table14TAEXRName - Remark ExplanationStringGeneric Edit300
35F09UI015Indexed Computations Multi-Tiered Entries37GLEXRName - Remark ExplanationStringGeneric Edit300
36F52G11Burdening Detail Ledger27BDEXRName - Remark ExplanationStringGeneric Edit300
37F52G11WFTemporary Burdened Detail Ledger Workfile27BWEXRName - Remark ExplanationStringGeneric Edit300
38F70UI001Work File for G/L by Cat. Code Localization8WAEXRName - Remark ExplanationStringGeneric Edit300
39F740911Work File for G/L Report by Category Code Localization11WAEXRName - Remark ExplanationStringGeneric Edit300
TOP12: Fixed Assets
40F1201Asset Master File68FAEXRName - Remark ExplanationStringGeneric Edit300
41F1201PAsset Master Purge Table68FAEXRName - Remark ExplanationStringGeneric Edit300
42F1201Z1Unedited Asset Master Transactions79FAEXRName - Remark ExplanationStringGeneric Edit300
43F12911ERPost G/L to FA Exceptions Work File16GLEXRName - Remark ExplanationStringGeneric Edit300
TOP15: Real Estate Management
44F1503Log Standards Master10NBEXRName - Remark ExplanationStringGeneric Edit300
45F1521Log Detail Master9NBEXRName - Remark ExplanationStringGeneric Edit300
46F1521DLog Detail Master - Alternate Description4NBEXRName - Remark ExplanationStringGeneric Edit300
47F1523Log Standard Master6OGEXRName - Remark ExplanationStringGeneric Edit300
48F1523DLog Standards Master - Alternate Description4OGEXRName - Remark ExplanationStringGeneric Edit300
49F1565Security Deposit Master17JFEXRName - Remark ExplanationStringGeneric Edit300
TOP18: Timecard Automation
50F186602Labor Rules Tag File92TFEXRName - Remark ExplanationStringGeneric Edit300
TOP31: Shop Floor Control
51F31122Work Order Time Transactions14WTEXRName - Remark ExplanationStringGeneric Edit300
52F31122SPurge Work Order Time Transactions14WTEXRName - Remark ExplanationStringGeneric Edit300
53F31122Z1Work Order Time Transactions Unedited Transaction Table27SZEXRName - Remark ExplanationStringGeneric Edit300
TOP42: Sales Management
54F42800G1Sales Update G Batch Detail Workfile28DGEXRName - Remark ExplanationStringGeneric Edit300
TOP43: Procurement
55F4303Log Master7PKEXRName - Remark ExplanationStringGeneric Edit300
56F4305Log Master14PLEXRName - Remark ExplanationStringGeneric Edit300
TOP44H: Homebuilder Management
57F44H591Closing Worksheet Entries5CWEXRName - Remark ExplanationStringGeneric Edit300
TOP48S: Service Billing
58F48096Billing Rate / Mark up Table28WQEXRName - Remark ExplanationStringGeneric Edit300
59F4812Billing Detail Workfile51WDEXRName - Remark ExplanationStringGeneric Edit300
60F4812HBilling Workfile History51WDEXRName - Remark ExplanationStringGeneric Edit300
61F4812HSBilling Workfile History Purged Save51WDEXRName - Remark ExplanationStringGeneric Edit300
62F48S0618Payroll Reclassification Workfile83YTEXRName - Remark ExplanationStringGeneric Edit300
63F48S910Billing Detail Journal Workfile26W2EXRName - Remark ExplanationStringGeneric Edit300
64F48S911Summarized Journal Workfile36W3EXRName - Remark ExplanationStringGeneric Edit300
65F48SUI01Billing Detail Print Workfile51WDEXRName - Remark ExplanationStringGeneric Edit300
TOP52G: Proj & Gov Contract Accounting
66F52G90Invoice Printing Work Table45WTEXRName - Remark ExplanationStringGeneric Edit300
TOP74R: Russia
67F74R0018Russian Tax File - 74R56TDEXRName - Remark ExplanationStringGeneric Edit300
TOP74S: Spain
68F74S55Expenses and Exchange Rate for Payments - Spain - 0413Q5EXRName - Remark ExplanationStringGeneric Edit300
TOP76B: Brazil
69F76B10Account Ledger - IN68 - 0918AREXRName - Remark ExplanationStringGeneric Edit300
70F76B911IN86-Work Table for Journal Entries - 0916BDEXRName - Remark ExplanationStringGeneric Edit300