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

64 columns | Print definition?812 | EXR

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger37GLEXRName - Remark ExplanationStringGeneric Edit300
2F4303Log Master7PKEXRName - Remark ExplanationStringGeneric Edit300
3F4303MLog Models5PMEXRName - Remark ExplanationStringGeneric Edit300
TOP03B: Enhanced Accounts Receivable
4F03B13Receipts Header File37RYEXRName - Remark ExplanationStringGeneric Edit300
5F03B13PReceipts Header Purge File37RYEXRName - Remark ExplanationStringGeneric Edit300
6F03B13Z2F03B13 Interoperability Table50SYEXRName - Remark ExplanationStringGeneric Edit300
7F03B672Draft Remittance Work File - One World Only36RDEXRName - Remark ExplanationStringGeneric Edit300
8F09UI011Receipt Prepost Work File28GLEXRName - Remark ExplanationStringGeneric Edit300
TOP04: Accounts Payable
9F04514WF - 1099 Combined Workfile (Merge of F045141 and F045143)26G1EXRName - Remark ExplanationStringGeneric Edit300
10F045141WF - 1099 G/L Workfile26G1EXRName - Remark ExplanationStringGeneric Edit300
11F045143WF - 1099 A/P WorkFile26G1EXRName - Remark ExplanationStringGeneric Edit300
12F09UI005Tax Offsets User Index40GLEXRName - Remark ExplanationStringGeneric Edit300
TOP05: Time Accounting and HRM Base
13F06106Employee Pay Instructions2YMEXRName - Remark ExplanationStringGeneric Edit300
14F0618Employee Transaction History83YTEXRName - Remark ExplanationStringGeneric Edit300
15F069106Union Benefits Master4Y1EXRName - Remark ExplanationStringGeneric Edit300
TOP05T: Time Entry
16F06116Employee Transaction Detail File83YTEXRName - Remark ExplanationStringGeneric Edit300
17F06116Z1Employee Transactions - Batch File97VLEXRName - 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 - Acct Ledger File for 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
33F70UI001Work File for G/L by Cat. Code Localization8WAEXRName - Remark ExplanationStringGeneric Edit300
34F740911Work File for G/L Report by Category Code Localization11WAEXRName - Remark ExplanationStringGeneric Edit300
TOP12: Fixed Assets
35F1201Asset Master File68FAEXRName - Remark ExplanationStringGeneric Edit300
36F1201PAsset Master Purge Table68FAEXRName - Remark ExplanationStringGeneric Edit300
37F1201Z1Unedited Asset Master Transactions79FAEXRName - Remark ExplanationStringGeneric Edit300
38F12911ERPost G/L to FA Exceptions Work File16GLEXRName - Remark ExplanationStringGeneric Edit300
TOP15: Property Management
39F1503Log Standards Master10NBEXRName - Remark ExplanationStringGeneric Edit300
40F1521Log Detail Master9NBEXRName - Remark ExplanationStringGeneric Edit300
41F1521DLog Detail Master - Alternate Description4NBEXRName - Remark ExplanationStringGeneric Edit300
42F1523Log Standard Master6OGEXRName - Remark ExplanationStringGeneric Edit300
43F1523DLog Standards Master - Alternate Description4OGEXRName - Remark ExplanationStringGeneric Edit300
44F1565Security Deposit Master17JFEXRName - Remark ExplanationStringGeneric Edit300
TOP18: Resource Scheduling
45F186602Labor Rules Tag File92TFEXRName - Remark ExplanationStringGeneric Edit300
TOP31: Shop Floor Control
46F31122Work Order Time Transactions14WTEXRName - Remark ExplanationStringGeneric Edit300
47F31122SPurge Work Order Time Transactions14WTEXRName - Remark ExplanationStringGeneric Edit300
48F31122Z1Work Order Time Transactions Unedited Transaction Table27SZEXRName - Remark ExplanationStringGeneric Edit300
TOP42: Sales Management
49F42800G1Sales Update G Batch Detail Workfile28DGEXRName - Remark ExplanationStringGeneric Edit300
TOP43: Procurement
50F4305Log Master14PLEXRName - Remark ExplanationStringGeneric Edit300
TOP44H: Homebuilder Management
51F44H591Closing Worksheet Entries5CWEXRName - Remark ExplanationStringGeneric Edit300
TOP48S: Service Billing
52F48096Billing Rate / Mark up Table28WQEXRName - Remark ExplanationStringGeneric Edit300
53F4812Billing Detail Workfile51WDEXRName - Remark ExplanationStringGeneric Edit300
54F4812HBilling Workfile - History51WDEXRName - Remark ExplanationStringGeneric Edit300
55F4812HSBilling Workfile History Purged Save51WDEXRName - Remark ExplanationStringGeneric Edit300
56F48S0618Payroll Reclassification Workfile83YTEXRName - Remark ExplanationStringGeneric Edit300
57F48S910Billing Detail Journal File26W2EXRName - Remark ExplanationStringGeneric Edit300
58F48S911Compressed Journal File36W3EXRName - Remark ExplanationStringGeneric Edit300
59F48SUI01Billing Detail Print Workfile51WDEXRName - Remark ExplanationStringGeneric Edit300
TOP57: Reserved for Clients
60F74T550General Ledger Work File - Turkish31DKEXRName - Remark ExplanationStringGeneric Edit300
TOP74: EMEA Localization
61F74S55Expenses and Exchange Rate for Payments - Spain13Q5EXRName - Remark ExplanationStringGeneric Edit300
TOP74R: CIS
62F74R0018Russian Tax File - 74R56TDEXRName - Remark ExplanationStringGeneric Edit300
TOP76B: Brazil - Reporting System Only
63F76B10Account Ledger - IN68 - 0918AREXRName - Remark ExplanationStringGeneric Edit300
64F76B911IN86-Work Table for Journal Entries - 0916BDEXRName - Remark ExplanationStringGeneric Edit300