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

109 columns | Print definition?812 | DGL

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File20TDDGLDate - For G/L (and Voucher)DateGeneric Edit60
2F00189WF - Tax Reconciliation10TGDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP04: Accounts Payable
3F09UI006Tax (F0018) Replica20TDDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP05: Time Accounting and HRM Base
4F0618Employee Transaction History67YTDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP05T: Time Entry
5F06116Employee Transaction Detail File67YTDGLDate - For G/L (and Voucher)DateGeneric Edit60
6F06116Z1Employee Transactions - Batch File81VLDGLDate - For G/L (and Voucher)DateGeneric Edit60
7F06278Retro Timecard Detail File67YTDGLDate - For G/L (and Voucher)DateGeneric Edit60
8F069136Tip Disbursement3JEDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP07: Payroll
9F07UI200Timecard History Work File70THDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP17: Customer Service Management
10F1721Contract Detail62CDDGLDate - For G/L (and Voucher)DateGeneric Edit60
11F4801Z2Warranty Claim/Supplier Recovery processing16WSDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP18: Resource Scheduling
12F186602Labor Rules Tag File77TFDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP31: Shop Floor Control
13F31122Work Order Time Transactions17WTDGLDate - For G/L (and Voucher)DateGeneric Edit60
14F31122SPurge Work Order Time Transactions17WTDGLDate - For G/L (and Voucher)DateGeneric Edit60
15F31122Z1Work Order Time Transactions Unedited Transaction Table30SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
16F4801Z1Outbound Work Order Header16SYDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP31B: Blend Management
17F31B65Operation Header60OHDGLDate - For G/L (and Voucher)DateGeneric Edit60
18F31B66Blend Transactions16BTDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP38: Agreement Management
19F38111Agreements Transaction Ledger55DZDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP39: Advanced Stock Valuation
20F39120Temporary Period Build File for Stock Valuation23TFDGLDate - For G/L (and Voucher)DateGeneric Edit60
21F39121WAdditional Quantity Work File12AQDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP40: Inventory/OP Base
22F4011ZBatch Receiver File - Order Details42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
23F4211Z1Sales Order Detail Unedited Transaction File40SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
24F43800Summary Voucher Match12PRDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP41: Inventory Management
25F4111Item Ledger File27ILDGLDate - For G/L (and Voucher)DateGeneric Edit60
26F41UI001Inventory Transactions Detail File25ITDGLDate - For G/L (and Voucher)DateGeneric Edit60
27F41UI002Inventory Transactions Batch File11TIDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP41B: Bulk Stock Management
28F41511Bulk Product Transaction File10PADGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP42: Sales Management
29F4211Sales Order Detail File27SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
30F42119Sales Order History File27SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
31F42199S.O. Detail Ledger File27SLDGLDate - For G/L (and Voucher)DateGeneric Edit60
32F42800GSales Update G Batch Workfile14SGDGLDate - For G/L (and Voucher)DateGeneric Edit60
33F42UI11SO Detail Cache File (MBF)31ZDDGLDate - For G/L (and Voucher)DateGeneric Edit60
34F42UI800Sales Detail Work File - Sales Update34SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP43: Procurement
35F43080Approvals Fields Constants39PDDGLDate - For G/L (and Voucher)DateGeneric Edit60
36F43092ZReceipt Routing Work File20PVDGLDate - For G/L (and Voucher)DateGeneric Edit60
37F43092Z1Receipt Routing Unedited Transaction Table39SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
38F43099Receipt Routing Ledger File27PODGLDate - For G/L (and Voucher)DateGeneric Edit60
39F4311Purchase Order Detail File31PDDGLDate - For G/L (and Voucher)DateGeneric Edit60
40F4311ZPurchase Order Generator File35PWDGLDate - For G/L (and Voucher)DateGeneric Edit60
41F4311Z1Purchase Order Detail Unedited Transaction Table44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
42F43121Purchase Order Receiver File59PRDGLDate - For G/L (and Voucher)DateGeneric Edit60
43F43121ZReceiver workfile34PWDGLDate - For G/L (and Voucher)DateGeneric Edit60
44F43121Z1Receipts Unedited Transaction Table76SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
45F4314ZVoucher Match Selection File159PNDGLDate - For G/L (and Voucher)DateGeneric Edit60
46F4316Purchase Order Multiple Account File14P3DGLDate - For G/L (and Voucher)DateGeneric Edit60
47F43199P.O. Detail Ledger File - Flexible Version31OLDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP43E: Requisition Self Service
48F43E16Requisition Multiple Account File15P3DGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP44H: Homebuilder Management
49F44H601Bid Header19BHDGLDate - For G/L (and Voucher)DateGeneric Edit60
50F44H611Bid Details25BDDGLDate - For G/L (and Voucher)DateGeneric Edit60
51F44H611WBid Details Work File29BWDGLDate - For G/L (and Voucher)DateGeneric Edit60
52F44H711Lot Start Workfile35SWDGLDate - For G/L (and Voucher)DateGeneric Edit60
53F44H711PAfter Start Purchasing15TPDGLDate - For G/L (and Voucher)DateGeneric Edit60
54F44H711ZHB Lot Start Unedited Transaction File48SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
55F44H71W1Lot Start Generation Workfile35GWDGLDate - For G/L (and Voucher)DateGeneric Edit60
56F44H73W1Lot Start - P.O. / Committment Generation Work File66CGDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP47: Electronic Commerce
57F47012EDI Purchase Order Detail - Inbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
58F47017EDI Purchase Order Detail - Outbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
59F47022EDI P.O. Acknowledgment Detail - Inbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
60F47027EDI P.O. Acknowledgment Detail - Outbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
61F47032EDI Shipping Notice Detail - Inbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
62F47037EDI Shipping Notice Detail - Outbound43SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
63F470371EDI Shipping Notice Detail - Outbound43SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
64F47047EDI Invoice Detail (Sales) - Outbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
65F47072EDI Receiving Advice Detail - Inbound45SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
66F47077EDI Receiving Advice Detail - Outbound45SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
67F47092EDI Request for Quote Detail - Inbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
68F47097EDI Request for Quote Detail - Outbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
69F47102EDI Response to RFQ Detail - Inbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
70F47107EDI Response to RFQ Detail - Outbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
71F47122EDI Product Activity Data Detail - Inbound55MJDGLDate - For G/L (and Voucher)DateGeneric Edit60
72F47127EDI Product Activity Data Detail - Outbound55MJDGLDate - For G/L (and Voucher)DateGeneric Edit60
73F47132EDI Purchase Order Change Detail - Inbound43SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
74F47137EDI Purchase Order Change Detail - Outbound45SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
75F47142EDI P.O. Change Acknowledgment Detail - Inbound46SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
76F47147EDI P.O. Change Acknowledgment Detail - Outbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
77F47157EDI Shipping Schedule Detail - Outbound46SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP48S: Service Billing
78F48011Service Billing Batch Control9WGDGLDate - For G/L (and Voucher)DateGeneric Edit60
79F4812Billing Detail Workfile4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
80F48121Generation Control File - Service Billing2WYDGLDate - For G/L (and Voucher)DateGeneric Edit60
81F4812GRetro Adjustment Workfile2WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
82F4812HBilling Workfile - History4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
83F4812HSBilling Workfile History Purged Save4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
84F4822Invoice Summary Work File24W4DGLDate - For G/L (and Voucher)DateGeneric Edit60
85F48229Delete Invoices Audit Table11W8DGLDate - For G/L (and Voucher)DateGeneric Edit60
86F4823Voucher Summary22W0DGLDate - For G/L (and Voucher)DateGeneric Edit60
87F48520Invoice Summary Access1AEDGLDate - For G/L (and Voucher)DateGeneric Edit60
88F48S0618Payroll Reclassification Workfile67YTDGLDate - For G/L (and Voucher)DateGeneric Edit60
89F48S411CSB Pay When Paid Table2BZDGLDate - For G/L (and Voucher)DateGeneric Edit60
90F48S910Billing Detail Journal File69W2DGLDate - For G/L (and Voucher)DateGeneric Edit60
91F48S912G/L Link File11W6DGLDate - For G/L (and Voucher)DateGeneric Edit60
92F48SUI01Billing Detail Print Workfile4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP49: Transportation Management
93F49631Load In-transit Ledger21TODGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP52: Contract Billing
94F5280Contract Revenue Summary File7GWDGLDate - For G/L (and Voucher)DateGeneric Edit60
95F5280WContract Revenue Summary Work File7GYDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP55: Reserved for Clients
96F55IF421Sales Order per BO32SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
97F55IF425Sales Order per BO - 200532SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
98F55IFRTtabella esportazione7RTDGLDate - For G/L (and Voucher)DateGeneric Edit60
99F55IFSFVEstrazione del venduto per Sales Force Automation17FSDGLDate - For G/L (and Voucher)DateGeneric Edit60
100F55W0100Correction Invoice Print - WF128SDDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP74: EMEA Localization
101F0018TIntrastat Revision14TDDGLDate - For G/L (and Voucher)DateGeneric Edit60
102F74093Workfile for Printing IVA Summary - Italy19HCDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76B: Brazil - Reporting System Only
103F76B400AIN86-Work Table for Storage Control - 4111SCDGLDate - For G/L (and Voucher)DateGeneric Edit60
104F76B50Item Ledger Table - IN68 - 426CEDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76C: Colombia
105F76CT2Sales/Use/V.A.T. Tax File - COL - 76C12CTDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76H: Chile
106F76H611Actual Item Ledger File - CHI - 41 - 76H28ALDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76V: Venezuela
107F76V4582Wittholding Documents Temporal - VEN - 04 - 76V7DRDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP89: Conversion Programs
108F43199ATemp F43199 for ERP 9.0 Upgrade31OLDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOPD3N: dcLINK (data collection) - DSI
109FD3N4116dcLINK Interface - Inventory Reclassification31IRDGLDate - For G/L (and Voucher)DateGeneric Edit60