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
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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

123 columns | Print definition?920 | DGL

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Taxes20TDDGLDate - 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
7F06116Z2ESS Timecard History81VMDGLDate - For G/L (and Voucher)DateGeneric Edit60
8F06278Retro Timecard Detail File67YTDGLDate - For G/L (and Voucher)DateGeneric Edit60
9F069136Tip Disbursement3JEDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP07: Payroll
10F07UI200Timecard History Work File70THDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP17: Customer Service Management
11F1721Contract Detail62CDDGLDate - For G/L (and Voucher)DateGeneric Edit60
12F4801Z2Warranty Claim/Supplier Recovery processing16WSDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP18: Timecard Automation
13F186602Labor Rules Tag File77TFDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP31: Shop Floor Control
14F31122Work Order Time Transactions17WTDGLDate - For G/L (and Voucher)DateGeneric Edit60
15F31122SPurge Work Order Time Transactions17WTDGLDate - For G/L (and Voucher)DateGeneric Edit60
16F31122Z1Work Order Time Transactions Unedited Transaction Table30SZDGLDate - 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
45F43147Freight Distribution Workfile33FDDGLDate - For G/L (and Voucher)DateGeneric Edit60
46F4314ZVoucher Match Selection File159PNDGLDate - For G/L (and Voucher)DateGeneric Edit60
47F4316Purchase Order Multiple Account File14P3DGLDate - For G/L (and Voucher)DateGeneric Edit60
48F43199P.O. Detail Ledger File - Flexible Version31OLDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP43E: Requisition Self Service
49F43E16Requisition Multiple Account File15P3DGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP44H: Homebuilder Management
50F44H601Bid Header19BHDGLDate - For G/L (and Voucher)DateGeneric Edit60
51F44H611Bid Details25BDDGLDate - For G/L (and Voucher)DateGeneric Edit60
52F44H611WBid Details Work File29BWDGLDate - For G/L (and Voucher)DateGeneric Edit60
53F44H711Lot Start Workfile35SWDGLDate - For G/L (and Voucher)DateGeneric Edit60
54F44H711PAfter Start Purchasing15TPDGLDate - For G/L (and Voucher)DateGeneric Edit60
55F44H711ZHB Lot Start Unedited Transaction File48SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
56F44H71W1Lot Start Generation Workfile35GWDGLDate - For G/L (and Voucher)DateGeneric Edit60
57F44H73W1Lot Start - P.O. / Committment Generation Work File66CGDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP47: Electronic Commerce
58F47012EDI Purchase Order Detail - Inbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
59F47017EDI Purchase Order Detail - Outbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
60F47022EDI P.O. Acknowledgment Detail - Inbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
61F47027EDI P.O. Acknowledgment Detail - Outbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
62F47032EDI Shipping Notice Detail - Inbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
63F47037EDI Shipping Notice Detail - Outbound43SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
64F470371EDI Shipping Notice Detail - Outbound43SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
65F47047EDI Invoice Detail (Sales) - Outbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
66F47072EDI Receiving Advice Detail - Inbound45SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
67F47077EDI Receiving Advice Detail - Outbound45SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
68F47092EDI Request for Quote Detail - Inbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
69F47097EDI Request for Quote Detail - Outbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
70F47102EDI Response to RFQ Detail - Inbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
71F47107EDI Response to RFQ Detail - Outbound42SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
72F47122EDI Product Activity Data Detail - Inbound55MJDGLDate - For G/L (and Voucher)DateGeneric Edit60
73F47127EDI Product Activity Data Detail - Outbound55MJDGLDate - For G/L (and Voucher)DateGeneric Edit60
74F47132EDI Purchase Order Change Detail - Inbound43SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
75F47137EDI Purchase Order Change Detail - Outbound45SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
76F47142EDI P.O. Change Acknowledgment Detail - Inbound46SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
77F47147EDI P.O. Change Acknowledgment Detail - Outbound44SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
78F47157EDI Shipping Schedule Detail - Outbound46SZDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP48: Work Order Processing
79F4801Z1Outbound Work Order Header16SYDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP48S: Service Billing
80F48011Service Billing Batch Control9WGDGLDate - For G/L (and Voucher)DateGeneric Edit60
81F4812Billing Detail Workfile4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
82F48121Generation Control File - Service Billing2WYDGLDate - For G/L (and Voucher)DateGeneric Edit60
83F4812HBilling Workfile History4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
84F4812HSBilling Workfile History Purged Save4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
85F4822Invoice Summary Work File24W4DGLDate - For G/L (and Voucher)DateGeneric Edit60
86F48229Delete Invoices Audit Table11W8DGLDate - For G/L (and Voucher)DateGeneric Edit60
87F4823Voucher Summary22W0DGLDate - For G/L (and Voucher)DateGeneric Edit60
88F48520Invoice Summary Access1AEDGLDate - For G/L (and Voucher)DateGeneric Edit60
89F48S0618Payroll Reclassification Workfile67YTDGLDate - For G/L (and Voucher)DateGeneric Edit60
90F48S411CSB Pay When Paid Table2BZDGLDate - For G/L (and Voucher)DateGeneric Edit60
91F48S910Billing Detail Journal Workfile69W2DGLDate - For G/L (and Voucher)DateGeneric Edit60
92F48S912G/L Link11W6DGLDate - For G/L (and Voucher)DateGeneric Edit60
93F48SUI01Billing Detail Print Workfile4WDDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP49: Transportation Management
94F49631Load In-transit Ledger21TODGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP52: Contract Billing
95F5280Contract Revenue Summary7GWDGLDate - For G/L (and Voucher)DateGeneric Edit60
96F5280WContract Revenue Summary Work File7GYDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP52G: Proj & Gov Contract Accounting
97F4822HInvoice Summary History24IHDGLDate - For G/L (and Voucher)DateGeneric Edit60
98F52G05HACRN History Table11AHDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP74: EMEA Localization
99F0018TIntrastat Revision14TDDGLDate - For G/L (and Voucher)DateGeneric Edit60
100F740018DData extraction ESL - 7418DEDGLDate - For G/L (and Voucher)DateGeneric Edit60
101F740018WData extraction ESL - Workfile - 7418DEDGLDate - For G/L (and Voucher)DateGeneric Edit60
102F74093Worktable for Printing IVA Summary - Italy19HCDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP74U: United Kingdom Localizations
103F74U0405SPC Certificate Holding Table - UK - 438CHDGLDate - For G/L (and Voucher)DateGeneric Edit60
104F74U0420SPC - Application Master - UK - 4321SEDGLDate - For G/L (and Voucher)DateGeneric Edit60
105F74U0425SPC - Certificate Master - UK - 4322SFDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP75I: India
106F75I309Personal Consumption - CENVAT setoff - IND - 4137CSDGLDate - For G/L (and Voucher)DateGeneric Edit60
107F75I385RG23D Register - Issues - IND - 4234EDDGLDate - For G/L (and Voucher)DateGeneric Edit60
108F75I401Sales Form Information-IND-4234QADGLDate - For G/L (and Voucher)DateGeneric Edit60
109F75I401CSales Form Information- Secondary25QADGLDate - For G/L (and Voucher)DateGeneric Edit60
110F75I402Purchase Tax Form Details9PTDGLDate - For G/L (and Voucher)DateGeneric Edit60
111F75I402TPurchase Tax Form Details -Secondary9PTDGLDate - For G/L (and Voucher)DateGeneric Edit60
112F75I403Stock Transfer Details28ABDGLDate - For G/L (and Voucher)DateGeneric Edit60
113F75I403TTemp Data for F75i40332ABDGLDate - For G/L (and Voucher)DateGeneric Edit60
114F75I4213Setoff Report Data -IND -0010SODGLDate - For G/L (and Voucher)DateGeneric Edit60
115F75I4231Purchase Tax Summary / Details13PTDGLDate - For G/L (and Voucher)DateGeneric Edit60
116F75I601TCS Register Details-IND-4213TRDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP75T: Taiwan
117F75T42WWork file with union of F4211 and F4211913SWDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76B: Brazil
118F76B400AIN86-Work Table for Storage Control - 4111SCDGLDate - For G/L (and Voucher)DateGeneric Edit60
119F76B50Item Ledger Table - IN68 - 426CEDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76C: Colombia
120F76CT2Sales/Use/V.A.T. Tax File - COL - 76C12CTDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76H: Chile
121F76H611Actual Item Ledger File - CHI - 41 - 76H28ALDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP76V: Venezuela
122F76V4582Wittholding Documents Temporal - VEN - 04 - 76V7DRDGLDate - For G/L (and Voucher)DateGeneric Edit60
TOP89: Conversion Programs
123F43199ATemp F43199 for ERP 9.0 Upgrade31OLDGLDate - For G/L (and Voucher)DateGeneric Edit60