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

140 columns | Print definition?812 | 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 - Employee's 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
7F1755Customer Call 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
18F4801SPurge - Work Order Master file32WADRQJDate - RequestedDateGeneric Edit60
19F4801Z1Outbound Work Order Header51SYDRQJDate - RequestedDateGeneric Edit60
TOP31P: Engineer To Order
20F31P11Project Quote Detail35QPDRQJDate - RequestedDateGeneric Edit60
21F31PUI01Scheduling Error Report3SEDRQJDate - RequestedDateGeneric Edit60
TOP32: Configuration Management
22F3294Configured String History File15KZDRQJDate - RequestedDateGeneric Edit60
23F32943Configured String History - OneWorld16KODRQJDate - RequestedDateGeneric Edit60
TOP33: Capacity Planning
24F3311Capacity Message File9CNDRQJDate - RequestedDateGeneric Edit60
25F3312Capacity Pegging5CWDRQJDate - RequestedDateGeneric Edit60
26F33UI001Shop Floor Control Routing Instructions10WLDRQJDate - RequestedDateGeneric Edit60
TOP34: Requirements Planning
27F3411MPS/MRP/DRP Message File16MMDRQJDate - RequestedDateGeneric Edit60
28F3412MPS/MRP/DRP Lower Level Requirements File3MWDRQJDate - RequestedDateGeneric Edit60
29F3460Forecast File5MFDRQJDate - RequestedDateGeneric Edit60
30F34A70Last Outbound Work Order Table3OWDRQJDate - RequestedDateGeneric Edit60
31F34UI005MRP Orders/Requirements User Index-Process Item5F5DRQJDate - RequestedDateGeneric Edit60
32F34UI006MRP Co/By Product Net Quantity User Index4W6DRQJDate - RequestedDateGeneric Edit60
33F4321Supplier Schedule Master File18PBDRQJDate - RequestedDateGeneric Edit60
TOP36: Forecasting
34F3400Forecast Summary File16SGDRQJDate - RequestedDateGeneric Edit60
35F3460Z1Forecast Unedited Transactions18FTDRQJDate - RequestedDateGeneric Edit60
TOP37: Quality Management
36F37900Certificate of Analysis (COA) Extract78TRDRQJDate - RequestedDateGeneric Edit60
TOP40: Inventory/OP Base
37F4001ZBatch Receiver File - Order Headings39SYDRQJDate - RequestedDateGeneric Edit60
38F40051Return Material Authorization35RDDRQJDate - RequestedDateGeneric Edit60
39F4011ZBatch Receiver File - Order Details35SZDRQJDate - RequestedDateGeneric Edit60
40F4012ZWWF - Destination Quantity18SPDRQJDate - RequestedDateGeneric Edit60
41F4013ZKit Components Batch File11KSDRQJDate - RequestedDateGeneric Edit60
42F40300RPreference Resolution History - Master7PMDRQJDate - RequestedDateGeneric Edit60
43F4201Z1Sales Order Header Unedited Transaction File29SYDRQJDate - RequestedDateGeneric Edit60
44F4209Held Orders14HODRQJDate - RequestedDateGeneric Edit60
45F4211DTSales Order Detail Date Tracking File20DTDRQJDate - RequestedDateGeneric Edit60
46F4211Z1Sales Order Detail Unedited Transaction File34SZDRQJDate - RequestedDateGeneric Edit60
47F4215Shipment Header28XHDRQJDate - RequestedDateGeneric Edit60
TOP40S: Supply Chain Self Service
48F4947SWSelf-Service Shipment Tracking Work File7SWDRQJDate - RequestedDateGeneric Edit60
TOP42: Sales Management
49F4201Sales Order Header File16SHDRQJDate - RequestedDateGeneric Edit60
50F42019Sales Order Header History File16SHDRQJDate - RequestedDateGeneric Edit60
51F4211Sales Order Detail File21SDDRQJDate - RequestedDateGeneric Edit60
52F42119Sales Order History File21SDDRQJDate - RequestedDateGeneric Edit60
53F42199S.O. Detail Ledger File21SLDRQJDate - RequestedDateGeneric Edit60
54F42565Invoice Print File30IWDRQJDate - RequestedDateGeneric Edit60
55F42UI01SO Header Cache File (MBF)21ZHDRQJDate - RequestedDateGeneric Edit60
56F42UI11SO Detail Cache File (MBF)25ZDDRQJDate - RequestedDateGeneric Edit60
57F42UI11CCustomer Self Service Shopping Cart Workfile11SCDRQJDate - RequestedDateGeneric Edit60
58F42UI520Pick Slips Header File23S8DRQJDate - RequestedDateGeneric Edit60
59F42UI521Pick Slips Detail File19S9DRQJDate - RequestedDateGeneric Edit60
60F42UI800Sales Detail Work File - Sales Update107SDDRQJDate - RequestedDateGeneric Edit60
TOP42B: Sales Order Entry
61F42420Audit Log Transaction25ALDRQJDate - RequestedDateGeneric Edit60
TOP43: Procurement
62F4301Purchase Order Header14PHDRQJDate - RequestedDateGeneric Edit60
63F4301ZPO Header Work File18PADRQJDate - RequestedDateGeneric Edit60
64F4301Z1Purchase Order Header Unedited Transaction Table27SYDRQJDate - RequestedDateGeneric Edit60
65F43080Approvals Fields Constants8PDDRQJDate - RequestedDateGeneric Edit60
66F43092Z1Receipt Routing Unedited Transaction Table48SZDRQJDate - RequestedDateGeneric Edit60
67F4311Purchase Order Detail File21PDDRQJDate - RequestedDateGeneric Edit60
68F4311ZPurchase Order Generator File25PWDRQJDate - RequestedDateGeneric Edit60
69F4311Z1Purchase Order Detail Unedited Transaction Table34SZDRQJDate - RequestedDateGeneric Edit60
70F43121Purchase Order Receiver File28PRDRQJDate - RequestedDateGeneric Edit60
71F43121ZReceiver workfile77PWDRQJDate - RequestedDateGeneric Edit60
72F43121Z1Receipts Unedited Transaction Table45SZDRQJDate - RequestedDateGeneric Edit60
73F4314ZVoucher Match Selection File127PNDRQJDate - RequestedDateGeneric Edit60
74F43199P.O. Detail Ledger File - Flexible Version21OLDRQJDate - RequestedDateGeneric Edit60
75F43632ZOpen Purchase Order by Item Work File18OIDRQJDate - RequestedDateGeneric Edit60
76F43UI50DPO Print Detail Work File20PWDRQJDate - RequestedDateGeneric Edit60
77F43UI50HPO Print Header Work File26PADRQJDate - RequestedDateGeneric Edit60
TOP43E: Requisition Self Service
78F43E11Requisition Detail11RDDRQJDate - RequestedDateGeneric Edit60
TOP43Q: Strategic Sourcing
79F43Q11Event Detail32EDDRQJDate - RequestedDateGeneric Edit60
TOP44H: Homebuilder Management
80F44H601Bid Header22BHDRQJDate - RequestedDateGeneric Edit60
TOP46: Warehouse Management
81F4600Warehouse Requests69R1DRQJDate - RequestedDateGeneric Edit60
82F4600PUWarehouse Requests - Purged67R1DRQJDate - RequestedDateGeneric Edit60
83F4611Warehouse Suggestions92R2DRQJDate - RequestedDateGeneric Edit60
84F4611PUWarehouse Suggestions - Purged91R2DRQJDate - RequestedDateGeneric Edit60
85F4611Z1Unedited Suggestion Table103SZDRQJDate - RequestedDateGeneric Edit60
86F46130Putaway Reservations14R3DRQJDate - RequestedDateGeneric Edit60
87F46130PUPutaway Reservations - Purged14R3DRQJDate - RequestedDateGeneric Edit60
88F4942Z1Work File for F494224SYDRQJDate - RequestedDateGeneric Edit60
TOP46L: License Plating
89F46LUI01Assign/Remove Items To LP Work File38WFDRQJDate - RequestedDateGeneric Edit60
TOP47: Electronic Commerce
90F47011EDI Purchase Order Header - Inbound34SYDRQJDate - RequestedDateGeneric Edit60
91F47012EDI Purchase Order Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
92F47016EDI Purchase Order Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
93F47017EDI Purchase Order Detail - Outbound34SZDRQJDate - RequestedDateGeneric Edit60
94F47021EDI P.O. Acknowledgment Header - Inbound29SYDRQJDate - RequestedDateGeneric Edit60
95F47022EDI P.O. Acknowledgment Detail - Inbound34SZDRQJDate - RequestedDateGeneric Edit60
96F47026EDI P.O. Acknowledgment Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
97F47027EDI P.O. Acknowledgment Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
98F47031EDI Shipping Notice Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
99F47032EDI Shipping Notice Detail - Inbound37SZDRQJDate - RequestedDateGeneric Edit60
100F47037EDI Shipping Notice Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
101F470371EDI Shipping Notice Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
102F47046EDI Invoice Header (Sales) - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
103F47047EDI Invoice Detail (Sales) - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
104F47062EDI Planning Schedule Detail - Inbound26MYDRQJDate - RequestedDateGeneric Edit60
105F47067EDI Planning Schedule Detail - Outbound26MYDRQJDate - RequestedDateGeneric Edit60
106F47071EDI Receiving Advice Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
107F47072EDI Receiving Advice Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
108F47076EDI Receiving Advice Header - Outbound30SYDRQJDate - RequestedDateGeneric Edit60
109F47077EDI Receiving Advice Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
110F47091EDI Request for Quote Header - Inbound34SYDRQJDate - RequestedDateGeneric Edit60
111F47092EDI Request for Quote Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
112F47096EDI Request for Quote Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
113F47097EDI Request for Quote Detail - Outbound34SZDRQJDate - RequestedDateGeneric Edit60
114F47101EDI Response to RFQ Header - Inbound29SYDRQJDate - RequestedDateGeneric Edit60
115F47102EDI Response to RFQ Detail - Inbound34SZDRQJDate - RequestedDateGeneric Edit60
116F47106EDI Response to RFQ Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
117F47107EDI Response to RFQ Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
118F47131EDI Purchase Order Change Header - Inbound31SYDRQJDate - RequestedDateGeneric Edit60
119F47132EDI Purchase Order Change Detail - Inbound36SZDRQJDate - RequestedDateGeneric Edit60
120F47136EDI Purchase Order Change Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
121F47137EDI Purchase Order Change Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
122F47141EDI P.O. Change Acknowledgment Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
123F47142EDI P.O. Change Acknowledgment Detail - Inbound36SZDRQJDate - RequestedDateGeneric Edit60
124F47146EDI P.O. Change Acknowledgment Header - Outbound32SYDRQJDate - RequestedDateGeneric Edit60
125F47147EDI P.O. Change Acknowledgment Detail - Outbound37SZDRQJDate - RequestedDateGeneric Edit60
126F47156EDI Shipping Schedule Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
127F47157EDI Shipping Schedule Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
TOP48: Work Order Processing
128F4801Work Order Master File32WADRQJDate - RequestedDateGeneric Edit60
129F48UI001X4801 Master Business Function Workfile34WADRQJDate - RequestedDateGeneric Edit60
TOP53: Change Management
130F5301BChange Request Master Table19DIDRQJDate - RequestedDateGeneric Edit60
131F5301BZ1Change Request Master Table Workfile23DIDRQJDate - RequestedDateGeneric Edit60
132F5314Planned Change Order Master Table6D2DRQJDate - RequestedDateGeneric Edit60
133F5315Change Order Master Table6D3DRQJDate - RequestedDateGeneric Edit60
TOP55: Reserved for Clients
134F55IF311As Of7RPDRQJDate - RequestedDateGeneric Edit60
135F55IF421Sales Order per BO22SDDRQJDate - RequestedDateGeneric Edit60
136F55IF425Sales Order per BO - 200522SDDRQJDate - RequestedDateGeneric Edit60
137F55IFLOGhistorical log31HLDRQJDate - RequestedDateGeneric Edit60
138F55IFTARCustomer Target and Share Info7TADRQJDate - RequestedDateGeneric Edit60
139F55W0100Correction Invoice Print - WF122SDDRQJDate - RequestedDateGeneric Edit60
TOP89: Conversion Programs
140F43199ATemp F43199 for ERP 9.0 Upgrade21OLDRQJDate - RequestedDateGeneric Edit60