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

174 columns | Print definition?920 | TRDJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Taxes19TDTRDJDate - 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
TOP34X: In-Memory Planning Advisor
15F34X200WPlanning Details Supply/Demand Work Table25SDTRDJDate - Order/TransactionDateGeneric Edit60
TOP38: Agreement Management
16F38111Agreements Transaction Ledger12DZTRDJDate - Order/TransactionDateGeneric Edit60
17F38112Agreements Committed Quantities16DXTRDJDate - Order/TransactionDateGeneric Edit60
TOP39: Advanced Stock Valuation
18F39120Temporary Period Build File for Stock Valuation13TFTRDJDate - Order/TransactionDateGeneric Edit60
19F39120WPeriod Detail Work File6TWTRDJDate - Order/TransactionDateGeneric Edit60
20F39121WAdditional Quantity Work File11AQTRDJDate - Order/TransactionDateGeneric Edit60
TOP40: Inventory/OP Base
21F30UI006Lot Tracking Work File28ILTRDJDate - Order/TransactionDateGeneric Edit60
22F4001ZBatch Receiver File - Order Headings40SYTRDJDate - Order/TransactionDateGeneric Edit60
23F4011ZBatch Receiver File - Order Details36SZTRDJDate - Order/TransactionDateGeneric Edit60
24F4012ZWWF - Destination Quantity17SPTRDJDate - Order/TransactionDateGeneric Edit60
25F4201Z1Sales Order Header Unedited Transaction File30SYTRDJDate - Order/TransactionDateGeneric Edit60
26F4209Held Orders13HOTRDJDate - Order/TransactionDateGeneric Edit60
27F4211DTSales Order Detail Date Tracking File17DTTRDJDate - Order/TransactionDateGeneric Edit60
28F4211Z1Sales Order Detail Unedited Transaction File35SZTRDJDate - Order/TransactionDateGeneric Edit60
TOP40G: Grower Management
29F40G95Pay On Proceeds Log File21PPTRDJDate - Order/TransactionDateGeneric Edit60
TOP41: Inventory Management
30F4111Item Ledger File34ILTRDJDate - Order/TransactionDateGeneric Edit60
31F41181Container Transaction File15CMTRDJDate - Order/TransactionDateGeneric Edit60
32F4132Usage Header (FUTURE)7UHTRDJDate - Order/TransactionDateGeneric Edit60
33F41UI001Inventory Transactions Detail File24ITTRDJDate - Order/TransactionDateGeneric Edit60
TOP41B: Bulk Stock Management
34F41509Four-Point Analysis Maintenance File36PGTRDJDate - Order/TransactionDateGeneric Edit60
35F41511Bulk Product Transaction File11PATRDJDate - Order/TransactionDateGeneric Edit60
36F41512Gain/Loss Transactions File18PTTRDJDate - Order/TransactionDateGeneric Edit60
TOP41F: Apparel Management
37FCW43Proposal Processing Details22MOTRDJDate - Order/TransactionDateGeneric Edit60
38FCW44Proposal Order Details7FPTRDJDate - Order/TransactionDateGeneric Edit60
39FCW65Work Order Header for Style Items31OFTRDJDate - Order/TransactionDateGeneric Edit60
40FCW67Style Work Order Parts List44WMTRDJDate - Order/TransactionDateGeneric Edit60
41FCW68Style Work Order Routings26WLTRDJDate - Order/TransactionDateGeneric Edit60
TOP42: Sales Management
42F4201Sales Order Header File17SHTRDJDate - Order/TransactionDateGeneric Edit60
43F42019Sales Order Header History File17SHTRDJDate - Order/TransactionDateGeneric Edit60
44F4211Sales Order Detail File22SDTRDJDate - Order/TransactionDateGeneric Edit60
45F42119Sales Order History File22SDTRDJDate - Order/TransactionDateGeneric Edit60
46F42199S.O. Detail Ledger File22SLTRDJDate - Order/TransactionDateGeneric Edit60
47F42UI01SO Header Cache File (MBF)22ZHTRDJDate - Order/TransactionDateGeneric Edit60
48F42UI11SO Detail Cache File (MBF)26ZDTRDJDate - Order/TransactionDateGeneric Edit60
49F42UI520Pick Slips Header File22S8TRDJDate - Order/TransactionDateGeneric Edit60
50F42UI521Pick Slips Detail File20S9TRDJDate - Order/TransactionDateGeneric Edit60
51F42UI800Sales Detail Work File - Sales Update55SDTRDJDate - Order/TransactionDateGeneric Edit60
TOP43: Procurement
52F4301Purchase Order Header15PHTRDJDate - Order/TransactionDateGeneric Edit60
53F4301ZPO Header Work File19PATRDJDate - Order/TransactionDateGeneric Edit60
54F4301Z1Purchase Order Header Unedited Transaction Table28SYTRDJDate - Order/TransactionDateGeneric Edit60
55F43080Approvals Fields Constants31PDTRDJDate - Order/TransactionDateGeneric Edit60
56F43092Z1Receipt Routing Unedited Transaction Table47SZTRDJDate - Order/TransactionDateGeneric Edit60
57F4311Purchase Order Detail File22PDTRDJDate - Order/TransactionDateGeneric Edit60
58F4311ZPurchase Order Generator File26PWTRDJDate - Order/TransactionDateGeneric Edit60
59F4311Z1Purchase Order Detail Unedited Transaction Table35SZTRDJDate - Order/TransactionDateGeneric Edit60
60F43121Purchase Order Receiver File26PRTRDJDate - Order/TransactionDateGeneric Edit60
61F43121Z1Receipts Unedited Transaction Table43SZTRDJDate - Order/TransactionDateGeneric Edit60
62F4314ZVoucher Match Selection File125PNTRDJDate - Order/TransactionDateGeneric Edit60
63F43199P.O. Detail Ledger File - Flexible Version22OLTRDJDate - Order/TransactionDateGeneric Edit60
64F4330Supplier Selection File7P0TRDJDate - Order/TransactionDateGeneric Edit60
65F43UI50DPO Print Detail Work File17PWTRDJDate - Order/TransactionDateGeneric Edit60
66F43UI50HPO Print Header Work File25PATRDJDate - Order/TransactionDateGeneric Edit60
TOP43E: Requisition Self Service
67F43E01Requisition Order Header5RHTRDJDate - Order/TransactionDateGeneric Edit60
68F43E09F43E09 - Approvals Activity Table15AATRDJDate - Order/TransactionDateGeneric Edit60
69F43E11Requisition Detail10RDTRDJDate - Order/TransactionDateGeneric Edit60
TOP44H: Homebuilder Management
70F4455Vendor Assignment (Takeoffs) (World)9JHTRDJDate - Order/TransactionDateGeneric Edit60
71F44H601Bid Header23BHTRDJDate - Order/TransactionDateGeneric Edit60
72F44H604Vendor Assignment13VATRDJDate - Order/TransactionDateGeneric Edit60
73F44H604WVendor Assignment Workfile15VWTRDJDate - Order/TransactionDateGeneric Edit60
74F44H604ZHB Vendor Assignment Unedited Transaction File26SZTRDJDate - Order/TransactionDateGeneric Edit60
75F44H611Bid Details30BDTRDJDate - Order/TransactionDateGeneric Edit60
76F44H611WBid Details Work File34BWTRDJDate - Order/TransactionDateGeneric Edit60
77F44H711Lot Start Workfile37SWTRDJDate - Order/TransactionDateGeneric Edit60
78F44H711ZHB Lot Start Unedited Transaction File50SZTRDJDate - Order/TransactionDateGeneric Edit60
79F44H71W1Lot Start Generation Workfile37GWTRDJDate - Order/TransactionDateGeneric Edit60
80F44H73W1Lot Start - P.O. / Committment Generation Work File68CGTRDJDate - Order/TransactionDateGeneric Edit60
TOP45: Advanced Pricing
81F4576Z1Ship and Debit Claims Unedited Transaction Table135Z1TRDJDate - Order/TransactionDateGeneric Edit60
TOP46: Warehouse Management
82F4600Warehouse Requests67R1TRDJDate - Order/TransactionDateGeneric Edit60
83F4600PUWarehouse Requests - Purged65R1TRDJDate - Order/TransactionDateGeneric Edit60
84F4611Warehouse Suggestions91R2TRDJDate - Order/TransactionDateGeneric Edit60
85F4611PUWarehouse Suggestions - Purged90R2TRDJDate - Order/TransactionDateGeneric Edit60
86F4611Z1Unedited Suggestion Table102SZTRDJDate - Order/TransactionDateGeneric Edit60
TOP46L: License Plating
87F46LUI01Assign/Remove Items To LP Work File39WFTRDJDate - Order/TransactionDateGeneric Edit60
TOP47: Electronic Commerce
88F47011EDI Purchase Order Header - Inbound35SYTRDJDate - Order/TransactionDateGeneric Edit60
89F47012EDI Purchase Order Detail - Inbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
90F47016EDI Purchase Order Header - Outbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
91F47017EDI Purchase Order Detail - Outbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
92F47021EDI P.O. Acknowledgment Header - Inbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
93F47022EDI P.O. Acknowledgment Detail - Inbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
94F47026EDI P.O. Acknowledgment Header - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
95F47027EDI P.O. Acknowledgment Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
96F47031EDI Shipping Notice Header - Inbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
97F47032EDI Shipping Notice Detail - Inbound38SZTRDJDate - Order/TransactionDateGeneric Edit60
98F47037EDI Shipping Notice Detail - Outbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
99F470371EDI Shipping Notice Detail - Outbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
100F47046EDI Invoice Header (Sales) - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
101F47047EDI Invoice Detail (Sales) - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
102F47061EDI Planning Schedule Header - Inbound22MJTRDJDate - Order/TransactionDateGeneric Edit60
103F47066EDI Planning Schedule Header - Outbound22MJTRDJDate - Order/TransactionDateGeneric Edit60
104F47071EDI Receiving Advice Header - Inbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
105F47072EDI Receiving Advice Detail - Inbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
106F47076EDI Receiving Advice Header - Outbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
107F47077EDI Receiving Advice Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
108F47091EDI Request for Quote Header - Inbound35SYTRDJDate - Order/TransactionDateGeneric Edit60
109F47092EDI Request for Quote Detail - Inbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
110F47096EDI Request for Quote Header - Outbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
111F47097EDI Request for Quote Detail - Outbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
112F47101EDI Response to RFQ Header - Inbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
113F47102EDI Response to RFQ Detail - Inbound35SZTRDJDate - Order/TransactionDateGeneric Edit60
114F47106EDI Response to RFQ Header - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
115F47107EDI Response to RFQ Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
116F47122EDI Product Activity Data Detail - Inbound40MJTRDJDate - Order/TransactionDateGeneric Edit60
117F47127EDI Product Activity Data Detail - Outbound40MJTRDJDate - Order/TransactionDateGeneric Edit60
118F47131EDI Purchase Order Change Header - Inbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
119F47132EDI Purchase Order Change Detail - Inbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
120F47136EDI Purchase Order Change Header - Outbound30SYTRDJDate - Order/TransactionDateGeneric Edit60
121F47137EDI Purchase Order Change Detail - Outbound36SZTRDJDate - Order/TransactionDateGeneric Edit60
122F47141EDI P.O. Change Acknowledgment Header - Inbound31SYTRDJDate - Order/TransactionDateGeneric Edit60
123F47142EDI P.O. Change Acknowledgment Detail - Inbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
124F47146EDI P.O. Change Acknowledgment Header - Outbound33SYTRDJDate - Order/TransactionDateGeneric Edit60
125F47147EDI P.O. Change Acknowledgment Detail - Outbound38SZTRDJDate - Order/TransactionDateGeneric Edit60
126F47156EDI Shipping Schedule Header - Outbound32SYTRDJDate - Order/TransactionDateGeneric Edit60
127F47157EDI Shipping Schedule Detail - Outbound37SZTRDJDate - Order/TransactionDateGeneric Edit60
128F47181EDI Consumption Header (FUTURE)6EHTRDJDate - Order/TransactionDateGeneric Edit60
TOP48: Work Order Processing
129F4801Work Order Master File30WATRDJDate - Order/TransactionDateGeneric Edit60
130F4801SPurge - Work Order Master file30WATRDJDate - Order/TransactionDateGeneric Edit60
131F4801Z1Outbound Work Order Header49SYTRDJDate - Order/TransactionDateGeneric Edit60
132F48UI001X4801 Master Business Function Workfile32WATRDJDate - Order/TransactionDateGeneric Edit60
TOP49: Transportation Management
133F49631Load In-transit Ledger28TOTRDJDate - Order/TransactionDateGeneric Edit60
TOP54R: Rental Management
134F54R12Purchase Order Receiver Rentals File13RRTRDJDate - Order/TransactionDateGeneric Edit60
TOP74: EMEA Localization
135F740018DData extraction ESL - 7417DETRDJDate - Order/TransactionDateGeneric Edit60
136F740018WData extraction ESL - Workfile - 7417DETRDJDate - Order/TransactionDateGeneric Edit60
137F74093Worktable for Printing IVA Summary - Italy18HCTRDJDate - Order/TransactionDateGeneric Edit60
138F7420033Sales Document Line (Print Info) - COMM - 4222PITRDJDate - Order/TransactionDateGeneric Edit60
TOP74R: Russia
139F74R4500Paymet Order Supplemental Data - RU - 04 - 74R8POTRDJDate - Order/TransactionDateGeneric Edit60
TOP75I: India
140F75I2213Setoff Temp Table8TTTRDJDate - Order/TransactionDateGeneric Edit60
141F75I312Excise - Consignment/ Adjustment Detail File - ItemWise8Q1TRDJDate - Order/TransactionDateGeneric Edit60
142F75I312YExcise-Consignment/Adjustment Detail -Item wise10Q1TRDJDate - Order/TransactionDateGeneric Edit60
143F75I343Excise - Daywise Closing Balance7QATRDJDate - Order/TransactionDateGeneric Edit60
144F75I357Consignment Header7CHTRDJDate - Order/TransactionDateGeneric Edit60
145F75I3572Consignment - Stock Transfers15CSTRDJDate - Order/TransactionDateGeneric Edit60
146F75I3573Consignment - Order Items3COTRDJDate - Order/TransactionDateGeneric Edit60
147F75I3574Consignment - Issues/Receipts Transactions14CTTRDJDate - Order/TransactionDateGeneric Edit60
148F75I380Excise - RG-1 - Transaction File - IND10RGTRDJDate - Order/TransactionDateGeneric Edit60
149F75I382Amount of Interest Paid per month - IND - 005IPTRDJDate - Order/TransactionDateGeneric Edit60
150F75I3901Work With Consignment - IND -432COTRDJDate - Order/TransactionDateGeneric Edit60
151F75I402Purchase Tax Form Details8PTTRDJDate - Order/TransactionDateGeneric Edit60
152F75I402TPurchase Tax Form Details -Secondary8PTTRDJDate - Order/TransactionDateGeneric Edit60
153F75I403Stock Transfer Details31ABTRDJDate - Order/TransactionDateGeneric Edit60
154F75I403TTemp Data for F75i40333ABTRDJDate - Order/TransactionDateGeneric Edit60
155F75I4213Setoff Report Data -IND -0013SOTRDJDate - Order/TransactionDateGeneric Edit60
156F75I732Service Tax A/R File Additional Info - IND - 03B9STTRDJDate - Order/TransactionDateGeneric Edit60
157F75I742Service Tax A/P File Additional Info - IND - 0410STTRDJDate - Order/TransactionDateGeneric Edit60
TOP75T: Taiwan
158F75T004GUI/VAT Transaction Header - 75T10THTRDJDate - Order/TransactionDateGeneric Edit60
159F75T0049GUI/VAT Transaction Header History - 75T10THTRDJDate - Order/TransactionDateGeneric Edit60
160F75T004PGUI/VAT Transaction Header POS - 75T10THTRDJDate - Order/TransactionDateGeneric Edit60
161F75T004ZGUI/VAT Transaction Header - Work - 75T11ZHTRDJDate - Order/TransactionDateGeneric Edit60
162F75T42WWork file with union of F4211 and F4211911SWTRDJDate - Order/TransactionDateGeneric Edit60
TOP76A: Argentina
163F76A30TF76A30 Tag File Z1 - ARG - 04 - 76A15V7TRDJDate - Order/TransactionDateGeneric Edit60
164F76A411QF76A411P Tag File Purge - ARG - 04 - 76A17B1TRDJDate - Order/TransactionDateGeneric Edit60
165F76A411TF760411A A/P Tag File - ARG - 04 - 76A17B1TRDJDate - Order/TransactionDateGeneric Edit60
TOP76C: Colombia
166F76CT2Sales/Use/V.A.T. Tax File - COL - 76C11CTTRDJDate - Order/TransactionDateGeneric Edit60
TOP76H: Chile
167F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H16PITRDJDate - Order/TransactionDateGeneric Edit60
168F76H611Actual Item Ledger File - CHI - 41 - 76H35ALTRDJDate - Order/TransactionDateGeneric Edit60
TOP79A: Greenhouse Gas Accounting
169F79A11GHG Ledger16GRTRDJDate - Order/TransactionDateGeneric Edit60
170F79A11Z1GHG Ledger - Batch File34GLTRDJDate - Order/TransactionDateGeneric Edit60
171F79A12GHG Ledger Audit17GRTRDJDate - Order/TransactionDateGeneric Edit60
172F79AU11GHG Ledger Work Table19GRTRDJDate - Order/TransactionDateGeneric Edit60
TOP89: Conversion Programs
173F43199ATemp F43199 for ERP 9.0 Upgrade22OLTRDJDate - Order/TransactionDateGeneric Edit60
TOPH91: Design Tools
174F98TCHDRTable Conversion Header7HDTRDJDate - Order/TransactionDateGeneric Edit60