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

101 columns | Print definition?812 | MOT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP40: Inventory/OP Base
1F4001ZBatch Receiver File - Order Headings72SYMOTMode of TransportStringUDC30
2F4011ZBatch Receiver File - Order Details139SZMOTMode of TransportStringUDC30
3F40300RPreference Resolution History - Master12PMMOTMode of TransportStringUDC30
4F40305Preference Profile - Print Messages26RMMOTMode of TransportStringUDC30
5F40306Preference Profile - Inventory Sourcing14SRMOTMode of TransportStringUDC30
6F40309Preference Profile - Delivery Date15DYMOTMode of TransportStringUDC30
7F40309RPreference Resolution Ledger - Delivery Date17DYMOTMode of TransportStringUDC30
8F40320Preference Profile - Multi Shipping/Receiving Locations17LPMOTMode of TransportStringUDC30
9F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations18LPMOTMode of TransportStringUDC30
10F40329Preference Profile - Document Distribution14DDMOTMode of TransportStringUDC30
11F40330Preference Profile - Document Set14DGMOTMode of TransportStringUDC30
12F40331Preference Profile - Options and Equipment13OEMOTMode of TransportStringUDC30
13F40333Preference Profile - Carrier15CAMOTMode of TransportStringUDC30
14F40334Preference Profile - Mode of Transport22MTMOTMode of TransportStringUDC30
15F4201Z1Sales Order Header Unedited Transaction File61SYMOTMode of TransportStringUDC30
16F4211Z1Sales Order Detail Unedited Transaction File132SZMOTMode of TransportStringUDC30
17F4215Shipment Header13XHMOTMode of TransportStringUDC30
TOP40S: Supply Chain Self Service
18F4947SWSelf-Service Shipment Tracking Work File14SWMOTMode of TransportStringUDC30
TOP41B: Bulk Stock Management
19F41509Four-Point Analysis Maintenance File12PGMOTMode of TransportStringUDC30
TOP42: Sales Management
20F4201Sales Order Header File48SHMOTMode of TransportStringUDC30
21F42019Sales Order Header History File48SHMOTMode of TransportStringUDC30
22F4211Sales Order Detail File119SDMOTMode of TransportStringUDC30
23F42119Sales Order History File119SDMOTMode of TransportStringUDC30
24F42199S.O. Detail Ledger File119SLMOTMode of TransportStringUDC30
25F42UI01SO Header Cache File (MBF)53ZHMOTMode of TransportStringUDC30
26F42UI12Sales Order Detail Cache 2 (MBF)45ZDMOTMode of TransportStringUDC30
27F42UI130Commitment Work File43ZCMOTMode of TransportStringUDC30
TOP42B: Sales Order Entry
28F42420Audit Log Transaction50ALMOTMode of TransportStringUDC30
TOP43: Procurement
29F4301Purchase Order Header45PHMOTMode of TransportStringUDC30
30F4301ZPO Header Work File49PAMOTMode of TransportStringUDC30
31F4301Z1Purchase Order Header Unedited Transaction Table58SYMOTMode of TransportStringUDC30
32F43080Approvals Fields Constants106PDMOTMode of TransportStringUDC30
33F4311Purchase Order Detail File102PDMOTMode of TransportStringUDC30
34F4311ZPurchase Order Generator File106PWMOTMode of TransportStringUDC30
35F4311Z1Purchase Order Detail Unedited Transaction Table115SZMOTMode of TransportStringUDC30
36F43121Z1Receipts Unedited Transaction Table145SZMOTMode of TransportStringUDC30
37F43199P.O. Detail Ledger File - Flexible Version102OLMOTMode of TransportStringUDC30
38F43UI50DPO Print Detail Work File15PWMOTMode of TransportStringUDC30
TOP43Q: Strategic Sourcing
39F43Q11Event Detail34EDMOTMode of TransportStringUDC30
40F43Q51Analyze Event Detail30EDMOTMode of TransportStringUDC30
TOP46: Warehouse Management
41F4942Z1Work File for F494238SYMOTMode of TransportStringUDC30
TOP47: Electronic Commerce
42F47011EDI Purchase Order Header - Inbound64SYMOTMode of TransportStringUDC30
43F47012EDI Purchase Order Detail - Inbound140SZMOTMode of TransportStringUDC30
44F47016EDI Purchase Order Header - Outbound60SYMOTMode of TransportStringUDC30
45F47017EDI Purchase Order Detail - Outbound116SZMOTMode of TransportStringUDC30
46F47021EDI P.O. Acknowledgment Header - Inbound60SYMOTMode of TransportStringUDC30
47F47022EDI P.O. Acknowledgment Detail - Inbound116SZMOTMode of TransportStringUDC30
48F47026EDI P.O. Acknowledgment Header - Outbound60SYMOTMode of TransportStringUDC30
49F47027EDI P.O. Acknowledgment Detail - Outbound140SZMOTMode of TransportStringUDC30
50F47031EDI Shipping Notice Header - Inbound55SYMOTMode of TransportStringUDC30
51F47032EDI Shipping Notice Detail - Inbound86SZMOTMode of TransportStringUDC30
52F47037EDI Shipping Notice Detail - Outbound122SZMOTMode of TransportStringUDC30
53F470371EDI Shipping Notice Detail - Outbound138SZMOTMode of TransportStringUDC30
54F47046EDI Invoice Header (Sales) - Outbound60SYMOTMode of TransportStringUDC30
55F47047EDI Invoice Detail (Sales) - Outbound140SZMOTMode of TransportStringUDC30
56F47071EDI Receiving Advice Header - Inbound61SYMOTMode of TransportStringUDC30
57F47072EDI Receiving Advice Detail - Inbound117SZMOTMode of TransportStringUDC30
58F47076EDI Receiving Advice Header - Outbound61SYMOTMode of TransportStringUDC30
59F47077EDI Receiving Advice Detail - Outbound117SZMOTMode of TransportStringUDC30
60F47091EDI Request for Quote Header - Inbound64SYMOTMode of TransportStringUDC30
61F47092EDI Request for Quote Detail - Inbound140SZMOTMode of TransportStringUDC30
62F47096EDI Request for Quote Header - Outbound60SYMOTMode of TransportStringUDC30
63F47097EDI Request for Quote Detail - Outbound116SZMOTMode of TransportStringUDC30
64F47101EDI Response to RFQ Header - Inbound60SYMOTMode of TransportStringUDC30
65F47102EDI Response to RFQ Detail - Inbound116SZMOTMode of TransportStringUDC30
66F47106EDI Response to RFQ Header - Outbound60SYMOTMode of TransportStringUDC30
67F47107EDI Response to RFQ Detail - Outbound140SZMOTMode of TransportStringUDC30
68F47131EDI Purchase Order Change Header - Inbound61SYMOTMode of TransportStringUDC30
69F47132EDI Purchase Order Change Detail - Inbound141SZMOTMode of TransportStringUDC30
70F47136EDI Purchase Order Change Header - Outbound60SYMOTMode of TransportStringUDC30
71F47137EDI Purchase Order Change Detail - Outbound117SZMOTMode of TransportStringUDC30
72F47141EDI P.O. Change Acknowledgment Header - Inbound61SYMOTMode of TransportStringUDC30
73F47142EDI P.O. Change Acknowledgment Detail - Inbound118SZMOTMode of TransportStringUDC30
74F47146EDI P.O. Change Acknowledgment Header - Outbound61SYMOTMode of TransportStringUDC30
75F47147EDI P.O. Change Acknowledgment Detail - Outbound142SZMOTMode of TransportStringUDC30
76F47156EDI Shipping Schedule Header - Outbound63SYMOTMode of TransportStringUDC30
77F47157EDI Shipping Schedule Detail - Outbound123SZMOTMode of TransportStringUDC30
TOP49: Transportation Management
78F49004Mode of Transport Constants2CTMOTMode of TransportStringUDC30
79F49005Generate Tracking Number2TGMOTMode of TransportStringUDC30
80F490051Generate Tracking Number Segment2XGMOTMode of TransportStringUDC30
81F490053Generate Tracking Number Separator2ZGMOTMode of TransportStringUDC30
82F49010Vehicle Master (Conversion from World File)15VMMOTMode of TransportStringUDC30
83F49110Transportation Bill of Lading Workfile15BWMOTMode of TransportStringUDC30
84F49130Shipment Document Workfile15BWMOTMode of TransportStringUDC30
85F4931Vehicle Type4VGMOTMode of TransportStringUDC30
86F4935Connected Vehicle Header7VHMOTMode of TransportStringUDC30
87F4941Shipment Routing Steps3RSMOTMode of TransportStringUDC30
88F4950Routing Entries7RTMOTMode of TransportStringUDC30
89F49501Intermodal Detail Routing Entries6RDMOTMode of TransportStringUDC30
90F4952Routing Restrictions2REMOTMode of TransportStringUDC30
91F4956Option and Equipment Inclusions/Exclusions1IXMOTMode of TransportStringUDC30
92F4957Transportation Confirmed Batch Shipment15BCMOTMode of TransportStringUDC30
93F4960Load Header24TMMOTMode of TransportStringUDC30
94F4963Load In-transit11TIMOTMode of TransportStringUDC30
95F49631Load In-transit Ledger20TOMOTMode of TransportStringUDC30
96F4981Freight Audit History17FHMOTMode of TransportStringUDC30
TOP55: Reserved for Clients
97F55IF421Sales Order per BO132SDMOTMode of TransportStringUDC30
98F55IF425Sales Order per BO - 2005132SDMOTMode of TransportStringUDC30
99F55W0100Correction Invoice Print - WF1120SDMOTMode of TransportStringUDC30
TOP74: EMEA Localization
100F0018TIntrastat Revision21TDMOTMode of TransportStringUDC30
TOP89: Conversion Programs
101F43199ATemp F43199 for ERP 9.0 Upgrade102OLMOTMode of TransportStringUDC30

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / TM (Mode of Transport) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .N
2       ALLDefault ModeN
3       GRDGround ServiceN
4       LTLLess than TruckloadN
5       NDANext Day AirN
6       SDASecond Day AirN
7       TL TruckloadN
8       WPXWestern Parcel InternationalN