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

147 columns | Print definition?920 | DRQJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F5301Change Request Master Table20DIDRQJDate - RequestedDateGeneric Edit60
TOP05A: PeopleSoft HR & PR Foundation
2F05003Verification of Employment Data2EVDRQJDate - RequestedDateGeneric Edit60
TOP05U: E1 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
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
TOP34X: In-Memory Planning Advisor
30F34X200WPlanning Details Supply/Demand Work Table23SDDRQJDate - RequestedDateGeneric Edit60
TOP36: Forecasting
31F3400Forecast Summary File16SGDRQJDate - RequestedDateGeneric Edit60
32F3460Z1Forecast Unedited Transactions18FTDRQJDate - RequestedDateGeneric Edit60
TOP37: Quality Management
33F37900Certificate of Analysis (COA) Extract78TRDRQJDate - RequestedDateGeneric Edit60
TOP40: Inventory/OP Base
34F4001ZBatch Receiver File - Order Headings39SYDRQJDate - RequestedDateGeneric Edit60
35F40051Return Material Authorization35RDDRQJDate - RequestedDateGeneric Edit60
36F4011ZBatch Receiver File - Order Details35SZDRQJDate - RequestedDateGeneric Edit60
37F4012ZWWF - Destination Quantity18SPDRQJDate - RequestedDateGeneric Edit60
38F4013ZKit Components Batch File11KSDRQJDate - RequestedDateGeneric Edit60
39F40300RPreference Resolution History - Master7PMDRQJDate - RequestedDateGeneric Edit60
40F4201Z1Sales Order Header Unedited Transaction File29SYDRQJDate - RequestedDateGeneric Edit60
41F4209Held Orders14HODRQJDate - RequestedDateGeneric Edit60
42F4211DTSales Order Detail Date Tracking File20DTDRQJDate - RequestedDateGeneric Edit60
43F4211Z1Sales Order Detail Unedited Transaction File34SZDRQJDate - RequestedDateGeneric Edit60
44F4215Shipment Header28XHDRQJDate - RequestedDateGeneric Edit60
TOP40S: Supply Chain Self Service
45F4947SWSelf-Service Shipment Tracking Work File7SWDRQJDate - RequestedDateGeneric Edit60
TOP41F: Apparel Management
46FCW20Matrix Work File114WXDRQJDate - RequestedDateGeneric Edit60
47FCW44Proposal Order Details8FPDRQJDate - RequestedDateGeneric Edit60
48FCW64WO Receipts Matrix Entry Work File177WXDRQJDate - RequestedDateGeneric Edit60
49FCW65Work Order Header for Style Items33OFDRQJDate - RequestedDateGeneric Edit60
50FCW67Style Work Order Parts List45WMDRQJDate - RequestedDateGeneric Edit60
51FCW68Style Work Order Routings27WLDRQJDate - RequestedDateGeneric Edit60
52FCW96Material Analysis10WODRQJDate - RequestedDateGeneric Edit60
53FCW97Grouping Messages9GMDRQJDate - RequestedDateGeneric Edit60
TOP42: Sales Management
54F4201Sales Order Header File16SHDRQJDate - RequestedDateGeneric Edit60
55F42019Sales Order Header History File16SHDRQJDate - RequestedDateGeneric Edit60
56F4211Sales Order Detail File21SDDRQJDate - RequestedDateGeneric Edit60
57F42119Sales Order History File21SDDRQJDate - RequestedDateGeneric Edit60
58F42199S.O. Detail Ledger File21SLDRQJDate - RequestedDateGeneric Edit60
59F42565Invoice Print File30IWDRQJDate - RequestedDateGeneric Edit60
60F42UI01SO Header Cache File (MBF)21ZHDRQJDate - RequestedDateGeneric Edit60
61F42UI11SO Detail Cache File (MBF)25ZDDRQJDate - RequestedDateGeneric Edit60
62F42UI11CCustomer Self Service Shopping Cart Workfile11SCDRQJDate - RequestedDateGeneric Edit60
63F42UI520Pick Slips Header File23S8DRQJDate - RequestedDateGeneric Edit60
64F42UI521Pick Slips Detail File19S9DRQJDate - RequestedDateGeneric Edit60
65F42UI800Sales Detail Work File - Sales Update107SDDRQJDate - RequestedDateGeneric Edit60
TOP42B: Sales Order Entry
66F42420Audit Log Transaction25ALDRQJDate - RequestedDateGeneric Edit60
TOP42W: Fulfilment Management
67F427UI01Release Fulfillment Work File27RFDRQJDate - RequestedDateGeneric Edit60
TOP43: Procurement
68F4301Purchase Order Header14PHDRQJDate - RequestedDateGeneric Edit60
69F4301ZPO Header Work File18PADRQJDate - RequestedDateGeneric Edit60
70F4301Z1Purchase Order Header Unedited Transaction Table27SYDRQJDate - RequestedDateGeneric Edit60
71F43080Approvals Fields Constants8PDDRQJDate - RequestedDateGeneric Edit60
72F43092Z1Receipt Routing Unedited Transaction Table48SZDRQJDate - RequestedDateGeneric Edit60
73F4311Purchase Order Detail File21PDDRQJDate - RequestedDateGeneric Edit60
74F4311ZPurchase Order Generator File25PWDRQJDate - RequestedDateGeneric Edit60
75F4311Z1Purchase Order Detail Unedited Transaction Table34SZDRQJDate - RequestedDateGeneric Edit60
76F43121Purchase Order Receiver File28PRDRQJDate - RequestedDateGeneric Edit60
77F43121ZReceiver workfile77PWDRQJDate - RequestedDateGeneric Edit60
78F43121Z1Receipts Unedited Transaction Table45SZDRQJDate - RequestedDateGeneric Edit60
79F4314ZVoucher Match Selection File127PNDRQJDate - RequestedDateGeneric Edit60
80F43199P.O. Detail Ledger File - Flexible Version21OLDRQJDate - RequestedDateGeneric Edit60
81F43632ZOpen Purchase Order by Item Work File18OIDRQJDate - RequestedDateGeneric Edit60
82F43UI50DPO Print Detail Work File20PWDRQJDate - RequestedDateGeneric Edit60
83F43UI50HPO Print Header Work File26PADRQJDate - RequestedDateGeneric Edit60
TOP43E: Requisition Self Service
84F43E11Requisition Detail11RDDRQJDate - RequestedDateGeneric Edit60
TOP43Q: Strategic Sourcing
85F43Q11Event Detail32EDDRQJDate - RequestedDateGeneric Edit60
TOP44H: Homebuilder Management
86F44H601Bid Header22BHDRQJDate - RequestedDateGeneric Edit60
TOP46: Warehouse Management
87F4600Warehouse Requests69R1DRQJDate - RequestedDateGeneric Edit60
88F4600PUWarehouse Requests - Purged67R1DRQJDate - RequestedDateGeneric Edit60
89F4611Warehouse Suggestions92R2DRQJDate - RequestedDateGeneric Edit60
90F4611PUWarehouse Suggestions - Purged91R2DRQJDate - RequestedDateGeneric Edit60
91F4611Z1Unedited Suggestion Table103SZDRQJDate - RequestedDateGeneric Edit60
92F46130Putaway Reservations14R3DRQJDate - RequestedDateGeneric Edit60
93F46130PUPutaway Reservations - Purged14R3DRQJDate - RequestedDateGeneric Edit60
94F4942Z1Work File for F494224SYDRQJDate - RequestedDateGeneric Edit60
TOP46L: License Plating
95F46LUI01Assign/Remove Items To LP Work File38WFDRQJDate - RequestedDateGeneric Edit60
TOP47: Electronic Commerce
96F47011EDI Purchase Order Header - Inbound34SYDRQJDate - RequestedDateGeneric Edit60
97F47012EDI Purchase Order Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
98F47016EDI Purchase Order Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
99F47017EDI Purchase Order Detail - Outbound34SZDRQJDate - RequestedDateGeneric Edit60
100F47021EDI P.O. Acknowledgment Header - Inbound29SYDRQJDate - RequestedDateGeneric Edit60
101F47022EDI P.O. Acknowledgment Detail - Inbound34SZDRQJDate - RequestedDateGeneric Edit60
102F47026EDI P.O. Acknowledgment Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
103F47027EDI P.O. Acknowledgment Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
104F47031EDI Shipping Notice Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
105F47032EDI Shipping Notice Detail - Inbound37SZDRQJDate - RequestedDateGeneric Edit60
106F47037EDI Shipping Notice Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
107F470371EDI Shipping Notice Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
108F47046EDI Invoice Header (Sales) - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
109F47047EDI Invoice Detail (Sales) - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
110F47062EDI Planning Schedule Detail - Inbound26MYDRQJDate - RequestedDateGeneric Edit60
111F47067EDI Planning Schedule Detail - Outbound26MYDRQJDate - RequestedDateGeneric Edit60
112F47071EDI Receiving Advice Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
113F47072EDI Receiving Advice Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
114F47076EDI Receiving Advice Header - Outbound30SYDRQJDate - RequestedDateGeneric Edit60
115F47077EDI Receiving Advice Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
116F47091EDI Request for Quote Header - Inbound34SYDRQJDate - RequestedDateGeneric Edit60
117F47092EDI Request for Quote Detail - Inbound35SZDRQJDate - RequestedDateGeneric Edit60
118F47096EDI Request for Quote Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
119F47097EDI Request for Quote Detail - Outbound34SZDRQJDate - RequestedDateGeneric Edit60
120F47101EDI Response to RFQ Header - Inbound29SYDRQJDate - RequestedDateGeneric Edit60
121F47102EDI Response to RFQ Detail - Inbound34SZDRQJDate - RequestedDateGeneric Edit60
122F47106EDI Response to RFQ Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
123F47107EDI Response to RFQ Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
124F47131EDI Purchase Order Change Header - Inbound31SYDRQJDate - RequestedDateGeneric Edit60
125F47132EDI Purchase Order Change Detail - Inbound36SZDRQJDate - RequestedDateGeneric Edit60
126F47136EDI Purchase Order Change Header - Outbound29SYDRQJDate - RequestedDateGeneric Edit60
127F47137EDI Purchase Order Change Detail - Outbound35SZDRQJDate - RequestedDateGeneric Edit60
128F47141EDI P.O. Change Acknowledgment Header - Inbound30SYDRQJDate - RequestedDateGeneric Edit60
129F47142EDI P.O. Change Acknowledgment Detail - Inbound36SZDRQJDate - RequestedDateGeneric Edit60
130F47146EDI P.O. Change Acknowledgment Header - Outbound32SYDRQJDate - RequestedDateGeneric Edit60
131F47147EDI P.O. Change Acknowledgment Detail - Outbound37SZDRQJDate - RequestedDateGeneric Edit60
132F47156EDI Shipping Schedule Header - Outbound31SYDRQJDate - RequestedDateGeneric Edit60
133F47157EDI Shipping Schedule Detail - Outbound36SZDRQJDate - RequestedDateGeneric Edit60
TOP48: Work Order Processing
134F4801Work Order Master File32WADRQJDate - RequestedDateGeneric Edit60
135F4801SPurge - Work Order Master file32WADRQJDate - RequestedDateGeneric Edit60
136F4801Z1Outbound Work Order Header51SYDRQJDate - RequestedDateGeneric Edit60
137F48710Work Order Mass Update Template Table19WTDRQJDate - RequestedDateGeneric Edit60
138F48UI001X4801 Master Business Function Workfile34WADRQJDate - RequestedDateGeneric Edit60
TOP53: Change Management
139F5301BChange Request Master Table19DIDRQJDate - RequestedDateGeneric Edit60
140F5301BZ1Change Request Master Table Workfile23DIDRQJDate - RequestedDateGeneric Edit60
141F5314Planned Change Order Master Table6D2DRQJDate - RequestedDateGeneric Edit60
142F5315Change Order Master Table6D3DRQJDate - RequestedDateGeneric Edit60
TOP54R: Rental Management
143F54R12Purchase Order Receiver Rentals File15RRDRQJDate - RequestedDateGeneric Edit60
TOP75T: Taiwan
144F75T42WWork file with union of F4211 and F4211910SWDRQJDate - RequestedDateGeneric Edit60
TOP89: Conversion Programs
145F3294Needed for upgrade from Xe and below15KZDRQJDate - RequestedDateGeneric Edit60
146F32943Needed for upgrade from Xe and below16KODRQJDate - RequestedDateGeneric Edit60
147F43199ATemp F43199 for ERP 9.0 Upgrade21OLDRQJDate - RequestedDateGeneric Edit60