JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

180 columns | Print definition?910 | UUPMJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00142Due Date Rules23L4UUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
2F0045Services Error Recovery21ERUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
3F0049Business Function Call Abstraction Register15CAUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
4F80D306Action Definition14HDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
5F80D307Metric Action Cross Reference11HDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
6F80D309Metric Series Cross Ref12MSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
7F80D310Alert Definition13ALUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
8F80D312Alert Subscription12ASUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
9F80D321UI Metric Group Definition12MGUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
10F80D322UI Metric Group Detail17MDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
11F80D323GroupID Email Address11GEUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP30: Product Data Management
12F300210Lean Multi Level Bill of Material Header26EHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
13F300211Lean Multi Level Bill of Material Detail96EDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
14F300311Lean Multi-Level Routing Detail File59EHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP34A: Advanced Planning & Scheduling
15F34A160Work Center Resource Set13WRUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
16F34A170Work Center Resource and Set XRef14WDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
17F34A180Routing Master Resource Set22RRUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
18F34A190Routing Master Resource and Set XRef21RDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP40G: Grower Management
19F40G002Grower Block Defaults16GCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
20F40G003Harvest Period Patterns16HPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
21F40G01Grower Farm61GFUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
22F40G02Grower Block119GBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
23F40G0200Grower Block Update Profile188BUUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
24F40G021Block Descriptors13SBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
25F40G022Block Styles12BSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
26F40G023Block Coordinates29BCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
27F40G03Grower Harvest127GHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
28F40G0300Grower Harvest Update Profile171HUUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
29F40G031Harvest Estimate Freeze Hdr20FHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
30F40G032Harvest Estimate Freeze Detail35FDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
31F40G033Continous Harvest Estimates14CHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
32F40G034Harvest Item Master16HIUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
33F40G041Item Spray Information35ISUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
34F40G042Spray Master EUR Restriction14SEUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
35F40G043Restricted Spray Style Information - F40G04319SSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
36F40G101Ownership Distribution12ODUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
37F40G102Grower Contacts14GCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
38F40G103EUR - Intended Use Distribution24IUUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
39F40G104Grower Action Dates21ADUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
40F40G150Crush and Purchase Report Details67CPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
41F40G151Quality Result Limits22QLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
42F40G50Maturity Calc Program Name Setup16MCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
43F40G60Scheduled Harvest19HSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
44F40G65Farming Operation Header48FOUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
45F40G70Harvest Operation Withholding Date26WHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
46F40G75Farming Operation Additional Configuration Setup16ACUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
47F40G80Farming Operation Configuration Values Entry16CVUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
48F40G90Grower POP Item Cross Reference15PIUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
49F40G95Pay On Proceeds Log File53PPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP43: Procurement
50F43147Freight Distribution Workfile59FDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
51F4317Purchase Order Detail Non-Billable24PDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
52F4320Purchase Order Clauses13PCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
53F43UI50CPO Print Clauses Table19WCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP43A: Purchase Order Receipt/Routing
54F43127Purchase Order Receiver Non-Billable31PRUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP43C: Contracts
55F43C01Contract Header73CHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
56F43C010Contract Header Profile124HPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
57F43C05Contract Action Dates20CAUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
58F43C10Contract Block77CBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
59F43C100Contract Block Profile140BPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
60F43C11Contract Detail82CDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
61F43C110Contract Harvest Profile129DPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
62F43C20Contract Payee20CPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
63F43C30Assessment Donations24ADUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
64F43C40Contract Assessments Donations15ACUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
65F43C60Contract Clauses15CCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
66F43C600Clauses Mass Update14CPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP43E: Requisition Self Service
67F43E15Shopping Cart Cross Reference19SXUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
68F43E35Direct Connect Communication Document BSSV Properties16CPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP46R: RFID Outbound
69F46R060EPC Partition Definition14EPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
70F46R070EPC Company Length Definition12ECUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP49: Transportation Management
71F49T00Integration Constants15ICUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
72F49T05OTM Record Reservation8ORUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
73F49T10Sales Order Release Staging Table67ORUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
74F49T100Procurement Freight Request staging table67OBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
75F49T11Item Staging Table36ITUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
76F49T20Shipment Staging Table45SSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
77F49T211Sales Order Detail File - Secondary Tag Table40TPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
78F49T219Sales Order Detail File - Secondary Tag History Table40TPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
79F49T30Sales Confirm Staging Table42SOUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
80F49T311Purchase Order Detail - OTM16TPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
81F49T380Seal Numbers15SOUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
82F49T40Shipment Freight Cost Staging Table30TCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
83F49T50Order Release Location Staging34LOUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
84F49T70Corporations Staging Table27CSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
85F49T80Locations Staging Table31LCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOP80D: Plant Manager Dashboard
86F80D104Address Book List11ALUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
87F80D105Business Unit List11BLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
88F80D106Product Group List11PLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
89F80D107Goals Definition14GDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
90F80D107AGoals Definition Tag14GTUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
91F80D108Goals Definition Cross Reference11GKUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
92F80D110PMD Search By Saved Query19SQUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
93F80D130Compliance Alert Master20CMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
94F80D131Compliance Instance Detail47CIUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
95F80D135SOD Alert Master11SMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
96F80D136SOD Alert Detail16SDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
97F80D150Whistle Blower Recipient Lists15RLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
98F80D300Dashboard Constants14DBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
99F80D301Dashboard Code Metric Cross Reference11DMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
100F80D302Metric ID Time Dimension Cross Reference6CRUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
101F80D303Metric Definition22MDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
102F80D304Variant Definition16VDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
103F80D305Hierarchy Definition13HDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
104F80D310AAlert Definition Tag Table13ATUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
105F80D311Alert Instance14AIUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
106F80D311AAlert Instance Tag Table13AJUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
107F80D315Alert Instance Status12ASUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
108F80D320Dashboard Configuration12DCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOPF30L: DFM Line Design
109FF30L002DFM Bill of Material Master77DHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
110FF30L005DFM Task Master24TMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
111FF30L010Scenario Master13SCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
112FF30L011Line Design Control Parameters25LDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
113FF30L012Kanban Control Parameters22KBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
114FF30L013Default User Scenario11DSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
115FF30L014Branch/Plant Master49BPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
116FF30L015Resource Master18REUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
117FF30L016Default User Branch/Plant7DBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
118FF30L017DFM Work Center Master23WMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
119FF30L101Mixed Model Family Master14FMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
120FF30L102Mixed Model Family Items14FDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
121FF30L110Standard Sequence Of Events24SSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
122FF30L115Sequence Of Events30SEUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
123FF30L116Components Consumed22CCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
124FF30L117DFM Event Summary Table20ESUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
125FF30L201Volume Design Master14VMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
126FF30L202Volume By Family19VFUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
127FF30L203Volume By Family By Part24FPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
128FF30L301DFM Customer Master45CMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
129FF30L401DFM Supplier Master13SMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
130FF30L501DFM Item Definition Master110IBUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
131FF30L512DFM Item Units of Measure Conversion Factors12UMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
132FF30L513DFM Units of Measure Standard Conversion7UCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
133FF30L601DFM Employee Master13EMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
134FF30L701DFM Process Master21PMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
135FF30L702Path Master14PHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
136FF30L703Process Path Relationship23PPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
137FF30L705Graphical Product Synch Properties15GPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
138FF30L707Path Links21PLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
139FF30L708Product Synchronization Results17PSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
140FF30L801Sales Order Master36SDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
141FF30L901Process Map Header Table17PHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
142FF30L902Process Map Detail Table30PDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
143FF30L904Process Map Work Content Table24WCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
144FF30L910Mixed Model Line Design Header21LHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
145FF30L911Mixed Model Line Design Detail28LDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
146FF30L912Line Master15LMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
147FF30L920Total Product Cycle Time Header16CHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
148FF30L921Total Product Cycle Time Detail20CLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
149FF30L950DFM Operation Definition Header33ODUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
150FF30L951DFM Operation Definition Detail36OMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
151FF30L990DFM Data Move Configuration Header7MHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
152FF30L991DFM Data Move Configuration Detail12MDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOPF31: Lean Transactions
153FF31010Production Master File49EHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
154FF31011TransactionID Master File43EHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
155FF31011SPurge - TransactionID Master File43ERUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
156FF31111Lean Transaction Parts List71PLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
157FF311114Related Purchase Orders for Lean Pay on Consumption Issues19PCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
158FF31111SPurge - Lean Transaction Parts List71PRUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
159FF31112Routing Transaction Table83EHUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
160FF31112SPurge - Routing Transaction Table83ETUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
161FF31113Lean Transaction Labor Detail50LDUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
162FF31113SPurge - Lean Transaction Labor Detail50LRUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOPF31K: DFM Kanban Management
163FF31K10DFM Kanban Flow Capacity14FCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
164FF31K11DFM Kanban Parent Items20PIUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
165FF31K20DFM Kanban Component21KCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
166FF31K21DFM Kanban Component Pull Chain18CPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
167FF31K22DFM Kanban Component Pull Sequence32PSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
168FF31K25DFM Kanban Master -- TEMP35KMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
169FF31K30DFM Kanban Master34KMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
170FF31K41DFM Kanban Pull Chain23PCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
171FF31K42DFM Kanban Location14LCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
172FF31K50DFM Kanban Constants18DFUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
173FF31K51DFM Kanban Resize Filter14RFUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
174FF31K52DFM Kanban Label Message12LMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOPF34R: DFM Resource Management
175FF34R010Resource Design Master21RMUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
176FF34R011Resource Calendar Master22RCUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
177FF34R012Resource Simulation Master17RSUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
TOPF34S: DFM Production Sequencing
178FF34S001Sequence Detail17SQUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
179FF34S002Daily Plan34DPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
180FF34S003DFM Planning Parameters15PPUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110