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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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

145 columns | Print definition?812 | TRDJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File19TDTRDJDate - Order/TransactionDateGeneric Edit60
2F004201Prepayment Transaction Table44PTTRDJDate - Order/TransactionDateGeneric Edit60
TOP04: Accounts Payable
3F09UI006Tax (F0018) Replica19TDTRDJDate - Order/TransactionDateGeneric Edit60
TOP17: Customer Service Management
4F3111Z2Warranty Claim/Supplier Recovery processing51WPTRDJDate - Order/TransactionDateGeneric Edit60
5F3112Z2Warranty Claim/Supplier Recovery processing38WLTRDJDate - Order/TransactionDateGeneric Edit60
6F4801Z2Warranty Claim/Supplier Recovery processing49WSTRDJDate - Order/TransactionDateGeneric Edit60
TOP31: Shop Floor Control
7F3111Work Order Parts List38WMTRDJDate - Order/TransactionDateGeneric Edit60
8F3111SPurge - Shop Floor Parts List38WMTRDJDate - Order/TransactionDateGeneric Edit60
9F3111Z1Outbound Work Order Parts List51SZTRDJDate - Order/TransactionDateGeneric Edit60
10F3112Work Order Routing25WLTRDJDate - Order/TransactionDateGeneric Edit60
11F3112SPurge Shop Floor Control Routing Instructions25WLTRDJDate - Order/TransactionDateGeneric Edit60
12F3112Z1Outbound Work Order Routings38SZTRDJDate - Order/TransactionDateGeneric Edit60
13F3114Rate Schedule Transaction File6IQTRDJDate - Order/TransactionDateGeneric Edit60
14F3118Shortage Maintenance Master File8WNTRDJDate - Order/TransactionDateGeneric Edit60
15F4801SPurge - Work Order Master file30WATRDJDate - Order/TransactionDateGeneric Edit60
16F4801Z1Outbound Work Order Header49SYTRDJDate - Order/TransactionDateGeneric Edit60
TOP38: Agreement Management
17F38111Agreements Transaction Ledger12DZTRDJDate - Order/TransactionDateGeneric Edit60
18F38112Agreements Committed Quantities16DXTRDJDate - Order/TransactionDateGeneric Edit60
TOP39: Advanced Stock Valuation
19F39120Temporary Period Build File for Stock Valuation13TFTRDJDate - Order/TransactionDateGeneric Edit60
20F39120WPeriod Detail Work File6TWTRDJDate - Order/TransactionDateGeneric Edit60
21F39121WAdditional Quantity Work File11AQTRDJDate - Order/TransactionDateGeneric Edit60
TOP40: Inventory/OP Base
22F30UI006Lot Tracking Work File28ILTRDJDate - Order/TransactionDateGeneric Edit60
23F4001ZBatch Receiver File - Order Headings40SYTRDJDate - Order/TransactionDateGeneric Edit60
24F4011ZBatch Receiver File - Order Details36SZTRDJDate - Order/TransactionDateGeneric Edit60
25F4012ZWWF - Destination Quantity17SPTRDJDate - Order/TransactionDateGeneric Edit60
26F4201Z1Sales Order Header Unedited Transaction File30SYTRDJDate - Order/TransactionDateGeneric Edit60
27F4209Held Orders13HOTRDJDate - Order/TransactionDateGeneric Edit60
28F4211DTSales Order Detail Date Tracking File17DTTRDJDate - Order/TransactionDateGeneric Edit60
29F4211Z1Sales Order Detail Unedited Transaction File35SZTRDJDate - Order/TransactionDateGeneric Edit60
TOP41: Inventory Management
30F4111Item Ledger File34ILTRDJDate - Order/TransactionDateGeneric Edit60
31F41181Container Transaction File15CMTRDJDate - Order/TransactionDateGeneric Edit60
32F41UI001Inventory Transactions Detail File24ITTRDJDate - Order/TransactionDateGeneric Edit60
TOP41B: Bulk Stock Management
33F41509Four-Point Analysis Maintenance File36PGTRDJDate - Order/TransactionDateGeneric Edit60
34F41511Bulk Product Transaction File11PATRDJDate - Order/TransactionDateGeneric Edit60
35F41512Gain/Loss Transactions File18PTTRDJDate - Order/TransactionDateGeneric Edit60
TOP42: Sales Management
36F4201Sales Order Header File17SHTRDJDate - Order/TransactionDateGeneric Edit60
37F42019Sales Order Header History File17SHTRDJDate - Order/TransactionDateGeneric Edit60
38F4211Sales Order Detail File22SDTRDJDate - Order/TransactionDateGeneric Edit60
39F42119Sales Order History File22SDTRDJDate - Order/TransactionDateGeneric Edit60
40F42199S.O. Detail Ledger File22SLTRDJDate - Order/TransactionDateGeneric Edit60
41F42UI01SO Header Cache File (MBF)22ZHTRDJDate - Order/TransactionDateGeneric Edit60
42F42UI11SO Detail Cache File (MBF)26ZDTRDJDate - Order/TransactionDateGeneric Edit60
43F42UI520Pick Slips Header File22S8TRDJDate - Order/TransactionDateGeneric Edit60
44F42UI521Pick Slips Detail File20S9TRDJDate - Order/TransactionDateGeneric Edit60
45F42UI800Sales Detail Work File - Sales Update55SDTRDJDate - Order/TransactionDateGeneric Edit60
TOP43: Procurement
46F4301Purchase Order Header15PHTRDJDate - Order/TransactionDateGeneric Edit60
47F4301ZPO Header Work File19PATRDJDate - Order/TransactionDateGeneric Edit60
48F4301Z1Purchase Order Header Unedited Transaction Table28SYTRDJDate - Order/TransactionDateGeneric Edit60
49F43080Approvals Fields Constants31PDTRDJDate - Order/TransactionDateGeneric Edit60
50F43092Z1Receipt Routing Unedited Transaction Table47SZTRDJDate - Order/TransactionDateGeneric Edit60
51F4311Purchase Order Detail File22PDTRDJDate - Order/TransactionDateGeneric Edit60
52F4311ZPurchase Order Generator File26PWTRDJDate - Order/TransactionDateGeneric Edit60
53F4311Z1Purchase Order Detail Unedited Transaction Table35SZTRDJDate - Order/TransactionDateGeneric Edit60
54F43121Purchase Order Receiver File26PRTRDJDate - Order/TransactionDateGeneric Edit60
55F43121Z1Receipts Unedited Transaction Table43SZTRDJDate - Order/TransactionDateGeneric Edit60
56F4314ZVoucher Match Selection File125PNTRDJDate - Order/TransactionDateGeneric Edit60
57F43199P.O. Detail Ledger File - Flexible Version22OLTRDJDate - Order/TransactionDateGeneric Edit60
58F4330Supplier Selection File7P0TRDJDate - Order/TransactionDateGeneric Edit60
59F43E09F43E09 - Approvals Activity Table15AATRDJDate - Order/TransactionDateGeneric Edit60
60F43UI50DPO Print Detail Work File17PWTRDJDate - Order/TransactionDateGeneric Edit60
61F43UI50HPO Print Header Work File25PATRDJDate - Order/TransactionDateGeneric Edit60
TOP43E: Requisition Self Service
62F43E01Requisition Order Header5RHTRDJDate - Order/TransactionDateGeneric Edit60
63F43E11Requisition Detail10RDTRDJDate - Order/TransactionDateGeneric Edit60
TOP44H: Homebuilder Management
64F4455Vendor Assignment (Takeoffs) (World)9JHTRDJDate - Order/TransactionDateGeneric Edit60
65F44H601Bid Header23BHTRDJDate - Order/TransactionDateGeneric Edit60
66F44H604Vendor Assignment13VATRDJDate - Order/TransactionDateGeneric Edit60
67F44H604WVendor Assignment Workfile15VWTRDJDate - Order/TransactionDateGeneric Edit60
68F44H604ZHB Vendor Assignment Unedited Transaction File26SZTRDJDate - Order/TransactionDateGeneric Edit60
69F44H611Bid Details30BDTRDJDate - Order/TransactionDateGeneric Edit60
70F44H611WBid Details Work File34BWTRDJDate - Order/TransactionDateGeneric Edit60
71F44H711Lot Start Workfile37SWTRDJDate - Order/TransactionDateGeneric Edit60
72F44H711ZHB Lot Start Unedited Transaction File50SZTRDJDate - Order/TransactionDateGeneric Edit60
73F44H71W1Lot Start Generation Workfile37GWTRDJDate - Order/TransactionDateGeneric Edit60
74F44H73W1Lot Start - P.O. / Committment Generation Work File68CGTRDJDate - Order/TransactionDateGeneric Edit60
TOP45: Advanced Pricing
75F4576Z1Ship and Debit Claims Unedited Transaction Table135Z1TRDJDate - Order/TransactionDateGeneric Edit60
TOP46: Warehouse Management
76F4600Warehouse Requests67R1TRDJDate - Order/TransactionDateGeneric Edit60
77F4600PUWarehouse Requests - Purged65R1TRDJDate - Order/TransactionDateGeneric Edit60
78F4611Warehouse Suggestions91R2TRDJDate - Order/TransactionDateGeneric Edit60
79F4611PUWarehouse Suggestions - Purged90R2TRDJDate - Order/TransactionDateGeneric Edit60
80F4611Z1Unedited Suggestion Table102SZTRDJDate - Order/TransactionDateGeneric Edit60
TOP46L: License Plating
81F46LUI01Assign/Remove Items To LP Work File39WFTRDJDate - Order/TransactionDateGeneric Edit60
TOP47: Electronic Commerce
82F47011EDI Purchase Order Header - Inbound35SYTRDJDate - Order/TransactionDateGeneric Edit60
83F47012EDI Purchase Order Detail - Inbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
84F47016EDI Purchase Order Header - Outbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
85F47017EDI Purchase Order Detail - Outbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
86F47021EDI P.O. Acknowledgment Header - Inbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
87F47022EDI P.O. Acknowledgment Detail - Inbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
88F47026EDI P.O. Acknowledgment Header - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
89F47027EDI P.O. Acknowledgment Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
90F47031EDI Shipping Notice Header - Inbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
91F47032EDI Shipping Notice Detail - Inbound38SZTRDJDate - Order/TransactionDateGeneric Edit60
92F47037EDI Shipping Notice Detail - Outbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
93F470371EDI Shipping Notice Detail - Outbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
94F47046EDI Invoice Header (Sales) - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
95F47047EDI Invoice Detail (Sales) - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
96F47061EDI Planning Schedule Header - Inbound22MJTRDJDate - Order/TransactionDateGeneric Edit60
97F47066EDI Planning Schedule Header - Outbound22MJTRDJDate - Order/TransactionDateGeneric Edit60
98F47071EDI Receiving Advice Header - Inbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
99F47072EDI Receiving Advice Detail - Inbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
100F47076EDI Receiving Advice Header - Outbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
101F47077EDI Receiving Advice Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
102F47091EDI Request for Quote Header - Inbound35SYTRDJDate - Order/TransactionDateGeneric Edit60
103F47092EDI Request for Quote Detail - Inbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
104F47096EDI Request for Quote Header - Outbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
105F47097EDI Request for Quote Detail - Outbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
106F47101EDI Response to RFQ Header - Inbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
107F47102EDI Response to RFQ Detail - Inbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
108F47106EDI Response to RFQ Header - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
109F47107EDI Response to RFQ Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
110F47122EDI Product Activity Data Detail - Inbound40MJTRDJDate - Order/TransactionDateGeneric Edit60
111F47127EDI Product Activity Data Detail - Outbound40MJTRDJDate - Order/TransactionDateGeneric Edit60
112F47131EDI Purchase Order Change Header - Inbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
113F47132EDI Purchase Order Change Detail - Inbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
114F47136EDI Purchase Order Change Header - Outbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
115F47137EDI Purchase Order Change Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
116F47141EDI P.O. Change Acknowledgment Header - Inbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
117F47142EDI P.O. Change Acknowledgment Detail - Inbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
118F47146EDI P.O. Change Acknowledgment Header - Outbound33SYTRDJDate - Order/TransactionDateGeneric Edit60
119F47147EDI P.O. Change Acknowledgment Detail - Outbound38SZTRDJDate - Order/TransactionDateGeneric Edit60
120F47156EDI Shipping Schedule Header - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
121F47157EDI Shipping Schedule Detail - Outbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
TOP48: Work Order Processing
122F4801Work Order Master File30WATRDJDate - Order/TransactionDateGeneric Edit60
123F48UI001X4801 Master Business Function Workfile32WATRDJDate - Order/TransactionDateGeneric Edit60
TOP49: Transportation Management
124F49631Load In-transit Ledger28TOTRDJDate - Order/TransactionDateGeneric Edit60
TOP55: Reserved for Clients
125F55IF120Period Detail Work File Copy6TWTRDJDate - Order/TransactionDateGeneric Edit60
126F55IF421Sales Order per BO23SDTRDJDate - Order/TransactionDateGeneric Edit60
127F55IF425Sales Order per BO - 200523SDTRDJDate - Order/TransactionDateGeneric Edit60
128F55IFSFVEstrazione del venduto per Sales Force Automation9FSTRDJDate - Order/TransactionDateGeneric Edit60
129F55W0100Correction Invoice Print - WF123SDTRDJDate - Order/TransactionDateGeneric Edit60
TOP74: EMEA Localization
130F74093Workfile for Printing IVA Summary - Italy18HCTRDJDate - Order/TransactionDateGeneric Edit60
131F7420033Sales Document Line (Print Info) - COMM - 4222PITRDJDate - Order/TransactionDateGeneric Edit60
TOP74R: CIS
132F74R4500Paymet Order Supplemental Data - RU - 04 - 74R8POTRDJDate - Order/TransactionDateGeneric Edit60
TOP75T: Taiwan
133F75T004GUI/VAT Transaction Header - 75T9THTRDJDate - Order/TransactionDateGeneric Edit60
134F75T0049GUI/VAT Transaction Header History - 75T9THTRDJDate - Order/TransactionDateGeneric Edit60
135F75T004PGUI/VAT Transaction Header POS - 75T9THTRDJDate - Order/TransactionDateGeneric Edit60
136F75T004ZGUI/VAT Transaction Header - Work - 75T9ZHTRDJDate - Order/TransactionDateGeneric Edit60
TOP76A: Argentina
137F76A30TF76A30 Tag File Z1 - ARG - 04 - 76A15V7TRDJDate - Order/TransactionDateGeneric Edit60
138F76A411QF76A411P Tag File Purge - ARG - 04 - 76A17B1TRDJDate - Order/TransactionDateGeneric Edit60
139F76A411TF760411A A/P Tag File - ARG - 04 - 76A17B1TRDJDate - Order/TransactionDateGeneric Edit60
TOP76C: Colombia
140F76CT2Sales/Use/V.A.T. Tax File - COL - 76C11CTTRDJDate - Order/TransactionDateGeneric Edit60
TOP76H: Chile
141F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H16PITRDJDate - Order/TransactionDateGeneric Edit60
142F76H611Actual Item Ledger File - CHI - 41 - 76H35ALTRDJDate - Order/TransactionDateGeneric Edit60
TOP89: Conversion Programs
143F43199ATemp F43199 for ERP 9.0 Upgrade22OLTRDJDate - Order/TransactionDateGeneric Edit60
TOPD3N: dcLINK (data collection) - DSI
144FD3N4116dcLINK Interface - Inventory Reclassification29IRTRDJDate - Order/TransactionDateGeneric Edit60
TOPH91: Design Tools
145F98TCHDRTable Conversion Header7HDTRDJDate - Order/TransactionDateGeneric Edit60