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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

68 columns | Print definition?910 | EXR

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