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

154 columns | Print definition?910 | DRQJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F5301Change Request Master Table20DIDRQJDate - RequestedDateGeneric Edit60
TOP05A: OW HR & PR Foundation
2F05003Verification of Employment Data2EVDRQJDate - RequestedDateGeneric Edit60
TOP05U: OW HR & PR Foundation US
3F053030IRS Form W-4 Employees Withholding Certificate2EWDRQJDate - RequestedDateGeneric Edit60
TOP17: Customer Service Management
4F3111Z2Warranty Claim/Supplier Recovery processing52WPDRQJDate - RequestedDateGeneric Edit60
5F3112Z2Warranty Claim/Supplier Recovery processing39WLDRQJDate - RequestedDateGeneric Edit60
6F4801Z2Warranty Claim/Supplier Recovery processing51WSDRQJDate - RequestedDateGeneric Edit60
TOP17C: Call Management
7F1755Case Master125ZADRQJDate - RequestedDateGeneric Edit60
TOP30: Product Data Management
8F3019Kanban Replenishment Capacity3KRDRQJDate - RequestedDateGeneric Edit60
TOP31: Shop Floor Control
9F3111Work Order Parts List39WMDRQJDate - RequestedDateGeneric Edit60
10F3111SPurge - Shop Floor Parts List39WMDRQJDate - RequestedDateGeneric Edit60
11F3111Z1Outbound Work Order Parts List52SZDRQJDate - RequestedDateGeneric Edit60
12F3112Work Order Routing26WLDRQJDate - RequestedDateGeneric Edit60
13F3112SPurge Shop Floor Control Routing Instructions26WLDRQJDate - RequestedDateGeneric Edit60
14F3112Z1Outbound Work Order Routings39SZDRQJDate - RequestedDateGeneric Edit60
15F3115Net Change Transaction table8NCDRQJDate - RequestedDateGeneric Edit60
16F3118Shortage Maintenance Master File5WNDRQJDate - RequestedDateGeneric Edit60
17F31UI006Line Scheduling Workbench - Work File32LSDRQJDate - RequestedDateGeneric Edit60
TOP31P: Engineer To Order
18F31P11Project Quote Detail35QPDRQJDate - RequestedDateGeneric Edit60
19F31PUI01Scheduling Error Report3SEDRQJDate - RequestedDateGeneric Edit60
TOP33: Capacity Planning
20F3311Capacity Message File9CNDRQJDate - RequestedDateGeneric Edit60
21F3312Capacity Pegging5CWDRQJDate - RequestedDateGeneric Edit60
22F33UI001Shop Floor Control Routing Instructions10WLDRQJDate - RequestedDateGeneric Edit60
TOP34: Requirements Planning
23F3411MPS/MRP/DRP Message File16MMDRQJDate - RequestedDateGeneric Edit60
24F3412MPS/MRP/DRP Lower Level Requirements File3MWDRQJDate - RequestedDateGeneric Edit60
25F3460Forecast File5MFDRQJDate - RequestedDateGeneric Edit60
26F34A70Last Outbound Work Order Table3OWDRQJDate - RequestedDateGeneric Edit60
27F34UI005MRP Orders/Requirements User Index-Process Item5F5DRQJDate - RequestedDateGeneric Edit60
28F34UI006MRP Co/By Product Net Quantity User Index4W6DRQJDate - RequestedDateGeneric Edit60
29F4321Supplier Schedule Master File18PBDRQJDate - RequestedDateGeneric Edit60
TOP36: Forecasting
30F3400Forecast Summary File16SGDRQJDate - RequestedDateGeneric Edit60
31F3460Z1Forecast Unedited Transactions18FTDRQJDate - RequestedDateGeneric Edit60
TOP37: Quality Management
32F37900Certificate of Analysis (COA) Extract78TRDRQJDate - RequestedDateGeneric Edit60
TOP40: Inventory/OP Base
33F4001ZBatch Receiver File - Order Headings39SYDRQJDate - RequestedDateGeneric Edit60
34F40051Return Material Authorization35RDDRQJDate - RequestedDateGeneric Edit60
35F4011ZBatch Receiver File - Order Details35SZDRQJDate - RequestedDateGeneric Edit60
36F4012ZWWF - Destination Quantity18SPDRQJDate - RequestedDateGeneric Edit60
37F4013ZKit Components Batch File11KSDRQJDate - RequestedDateGeneric Edit60
38F40300RPreference Resolution History - Master7PMDRQJDate - RequestedDateGeneric Edit60
39F4201Z1Sales Order Header Unedited Transaction File29SYDRQJDate - RequestedDateGeneric Edit60
40F4209Held Orders14HODRQJDate - RequestedDateGeneric Edit60
41F4211DTSales Order Detail Date Tracking File20DTDRQJDate - RequestedDateGeneric Edit60
42F4211Z1Sales Order Detail Unedited Transaction File34SZDRQJDate - RequestedDateGeneric Edit60
43F4215Shipment Header28XHDRQJDate - RequestedDateGeneric Edit60
TOP40S: Supply Chain Self Service
44F4947SWSelf-Service Shipment Tracking Work File7SWDRQJDate - RequestedDateGeneric Edit60
TOP41F: Apparel Management
45FCW20Matrix Work File114WXDRQJDate - RequestedDateGeneric Edit60
46FCW44Proposal Order Details8FPDRQJDate - RequestedDateGeneric Edit60
47FCW64WO Receipts Matrix Entry Work File177WXDRQJDate - RequestedDateGeneric Edit60
48FCW65Work Order Header for Style Items33OFDRQJDate - RequestedDateGeneric Edit60
49FCW67Style Work Order Parts List45WMDRQJDate - RequestedDateGeneric Edit60
50FCW68Style Work Order Routings27WLDRQJDate - RequestedDateGeneric Edit60
51FCW96Material Analysis10WODRQJDate - RequestedDateGeneric Edit60
52FCW97Grouping Messages9GMDRQJDate - RequestedDateGeneric Edit60
TOP42: Sales Management
53F4201Sales Order Header File16SHDRQJDate - RequestedDateGeneric Edit60
54F42019Sales Order Header History File16SHDRQJDate - RequestedDateGeneric Edit60
55F4211Sales Order Detail File21SDDRQJDate - RequestedDateGeneric Edit60
56F42119Sales Order History File21SDDRQJDate - RequestedDateGeneric Edit60
57F42199S.O. Detail Ledger File21SLDRQJDate - RequestedDateGeneric Edit60
58F42565Invoice Print File30IWDRQJDate - RequestedDateGeneric Edit60
59F42UI01SO Header Cache File (MBF)21ZHDRQJDate - RequestedDateGeneric Edit60
60F42UI11SO Detail Cache File (MBF)25ZDDRQJDate - RequestedDateGeneric Edit60
61F42UI11CCustomer Self Service Shopping Cart Workfile11SCDRQJDate - RequestedDateGeneric Edit60
62F42UI520Pick Slips Header File23S8DRQJDate - RequestedDateGeneric Edit60
63F42UI521Pick Slips Detail File19S9DRQJDate - RequestedDateGeneric Edit60
64F42UI800Sales Detail Work File - Sales Update107SDDRQJDate - RequestedDateGeneric Edit60
TOP42B: Sales Order Entry
65F42420Audit Log Transaction25ALDRQJDate - RequestedDateGeneric Edit60
TOP42W: Fulfillment Management
66F427UI01Release Fulfillment Work File27RFDRQJDate - RequestedDateGeneric Edit60
TOP43: Procurement
67F4301Purchase Order Header14PHDRQJDate - RequestedDateGeneric Edit60
68F4301ZPO Header Work File18PADRQJDate - RequestedDateGeneric Edit60
69F4301Z1Purchase Order Header Unedited Transaction Table27SYDRQJDate - RequestedDateGeneric Edit60
70F43080Approvals Fields Constants8PDDRQJDate - RequestedDateGeneric Edit60
71F43092Z1Receipt Routing Unedited Transaction Table48SZDRQJDate - RequestedDateGeneric Edit60
72F4311Purchase Order Detail File21PDDRQJDate - RequestedDateGeneric Edit60
73F4311ZPurchase Order Generator File25PWDRQJDate - RequestedDateGeneric Edit60
74F4311Z1Purchase Order Detail Unedited Transaction Table34SZDRQJDate - RequestedDateGeneric Edit60
75F43121Purchase Order Receiver File28PRDRQJDate - RequestedDateGeneric Edit60
76F43121ZReceiver workfile77PWDRQJDate - RequestedDateGeneric Edit60
77F43121Z1Receipts Unedited Transaction Table45SZDRQJDate - RequestedDateGeneric Edit60
78F4314ZVoucher Match Selection File127PNDRQJDate - RequestedDateGeneric Edit60
79F43199P.O. Detail Ledger File - Flexible Version21OLDRQJDate - RequestedDateGeneric Edit60
80F43632ZOpen Purchase Order by Item Work File18OIDRQJDate - RequestedDateGeneric Edit60
81F43UI50DPO Print Detail Work File20PWDRQJDate - RequestedDateGeneric Edit60
82F43UI50HPO Print Header Work File26PADRQJDate - RequestedDateGeneric Edit60
TOP43E: Requisition Self Service
83F43E11Requisition Detail11RDDRQJDate - RequestedDateGeneric Edit60
TOP43Q: Strategic Sourcing
84F43Q11Event Detail32EDDRQJDate - RequestedDateGeneric Edit60
TOP44H: Homebuilder Management
85F44H601Bid Header22BHDRQJDate - RequestedDateGeneric Edit60
TOP46: Warehouse Management
86F4600Warehouse Requests69R1DRQJDate - RequestedDateGeneric Edit60
87F4600PUWarehouse Requests - Purged67R1DRQJDate - RequestedDateGeneric Edit60
88F4611Warehouse Suggestions92R2DRQJDate - RequestedDateGeneric Edit60
89F4611PUWarehouse Suggestions - Purged91R2DRQJDate - RequestedDateGeneric Edit60
90F4611Z1Unedited Suggestion Table103SZDRQJDate - RequestedDateGeneric Edit60
91F46130Putaway Reservations14R3DRQJDate - RequestedDateGeneric Edit60
92F46130PUPutaway Reservations - Purged14R3DRQJDate - RequestedDateGeneric Edit60
93F4942Z1Work File for F494224SYDRQJDate - RequestedDateGeneric Edit60
TOP46L: License Plating
94F46LUI01Assign/Remove Items To LP Work File38WFDRQJDate - RequestedDateGeneric Edit60
TOP47: Electronic Commerce
95F47011EDI Purchase Order Header - Inbound34SYDRQJDate - RequestedDateGeneric Edit60
96F47012EDI Purchase Order Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
97F47016EDI Purchase Order Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
98F47017EDI Purchase Order Detail - Outbound34SZDRQJDate - RequestedDateGeneric Edit60
99F47021EDI P.O. Acknowledgment Header - Inbound29SYDRQJDate - RequestedDateGeneric Edit60
100F47022EDI P.O. Acknowledgment Detail - Inbound34SZDRQJDate - RequestedDateGeneric Edit60
101F47026EDI P.O. Acknowledgment Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
102F47027EDI P.O. Acknowledgment Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
103F47031EDI Shipping Notice Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
104F47032EDI Shipping Notice Detail - Inbound37SZDRQJDate - RequestedDateGeneric Edit60
105F47037EDI Shipping Notice Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
106F470371EDI Shipping Notice Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
107F47046EDI Invoice Header (Sales) - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
108F47047EDI Invoice Detail (Sales) - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
109F47062EDI Planning Schedule Detail - Inbound26MYDRQJDate - RequestedDateGeneric Edit60
110F47067EDI Planning Schedule Detail - Outbound26MYDRQJDate - RequestedDateGeneric Edit60
111F47071EDI Receiving Advice Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
112F47072EDI Receiving Advice Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
113F47076EDI Receiving Advice Header - Outbound30SYDRQJDate - RequestedDateGeneric Edit60
114F47077EDI Receiving Advice Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
115F47091EDI Request for Quote Header - Inbound34SYDRQJDate - RequestedDateGeneric Edit60
116F47092EDI Request for Quote Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
117F47096EDI Request for Quote Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
118F47097EDI Request for Quote Detail - Outbound34SZDRQJDate - RequestedDateGeneric Edit60
119F47101EDI Response to RFQ Header - Inbound29SYDRQJDate - RequestedDateGeneric Edit60
120F47102EDI Response to RFQ Detail - Inbound34SZDRQJDate - RequestedDateGeneric Edit60
121F47106EDI Response to RFQ Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
122F47107EDI Response to RFQ Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
123F47131EDI Purchase Order Change Header - Inbound31SYDRQJDate - RequestedDateGeneric Edit60
124F47132EDI Purchase Order Change Detail - Inbound36SZDRQJDate - RequestedDateGeneric Edit60
125F47136EDI Purchase Order Change Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
126F47137EDI Purchase Order Change Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
127F47141EDI P.O. Change Acknowledgment Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
128F47142EDI P.O. Change Acknowledgment Detail - Inbound36SZDRQJDate - RequestedDateGeneric Edit60
129F47146EDI P.O. Change Acknowledgment Header - Outbound32SYDRQJDate - RequestedDateGeneric Edit60
130F47147EDI P.O. Change Acknowledgment Detail - Outbound37SZDRQJDate - RequestedDateGeneric Edit60
131F47156EDI Shipping Schedule Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
132F47157EDI Shipping Schedule Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
TOP48: Work Order Processing
133F4801Work Order Master File32WADRQJDate - RequestedDateGeneric Edit60
134F4801SPurge - Work Order Master file32WADRQJDate - RequestedDateGeneric Edit60
135F4801Z1Outbound Work Order Header51SYDRQJDate - RequestedDateGeneric Edit60
136F48710Work Order Mass Update Template Table19WTDRQJDate - RequestedDateGeneric Edit60
137F48UI001X4801 Master Business Function Workfile34WADRQJDate - RequestedDateGeneric Edit60
TOP53: Change Management
138F5301BChange Request Master Table19DIDRQJDate - RequestedDateGeneric Edit60
139F5301BZ1Change Request Master Table Workfile23DIDRQJDate - RequestedDateGeneric Edit60
140F5314Planned Change Order Master Table6D2DRQJDate - RequestedDateGeneric Edit60
141F5315Change Order Master Table6D3DRQJDate - RequestedDateGeneric Edit60
TOP55: Reserved for Clients
142F55IF311As Of7RPDRQJDate - RequestedDateGeneric Edit60
143F55IF421Sales Order per BO22SDDRQJDate - RequestedDateGeneric Edit60
144F55IF425Sales Order per BO - 200522SDDRQJDate - RequestedDateGeneric Edit60
145F55IFLOGhistorical log31HLDRQJDate - RequestedDateGeneric Edit60
146F55IFTARCustomer Target and Share Info7TADRQJDate - RequestedDateGeneric Edit60
147F55W0100Correction Invoice Print - WF122SDDRQJDate - RequestedDateGeneric Edit60
TOP75T: Taiwan
148F75T42WWork file with union of F4211 and F4211910SWDRQJDate - RequestedDateGeneric Edit60
TOP80D: Plant Manager Dashboard
149F80D010Sales Order Fact20SFDRQJDate - RequestedDateGeneric Edit60
150F80D230F80D230 On Time Manufacturing Work Order Completions1OTDRQJDate - RequestedDateGeneric Edit60
151F80D231F380D231 Manufacturing Production Costings1PCDRQJDate - RequestedDateGeneric Edit60
TOP89: Conversion Programs
152F3294Needed for upgrade from Xe and below15KZDRQJDate - RequestedDateGeneric Edit60
153F32943Needed for upgrade from Xe and below16KODRQJDate - RequestedDateGeneric Edit60
154F43199ATemp F43199 for ERP 9.0 Upgrade21OLDRQJDate - RequestedDateGeneric Edit60