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

112 columns | Print definition?920 | 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
TOP41: Inventory Management
19F4132Usage Header (FUTURE)19UHMOTMode of TransportStringUDC30
TOP41B: Bulk Stock Management
20F41509Four-Point Analysis Maintenance File12PGMOTMode of TransportStringUDC30
TOP42: Sales Management
21F03B423Sales Order Trigger Configuration16TCMOTMode of TransportStringUDC30
22F4201Sales Order Header File48SHMOTMode of TransportStringUDC30
23F42019Sales Order Header History File48SHMOTMode of TransportStringUDC30
24F4211Sales Order Detail File119SDMOTMode of TransportStringUDC30
25F42119Sales Order History File119SDMOTMode of TransportStringUDC30
26F42199S.O. Detail Ledger File119SLMOTMode of TransportStringUDC30
27F42UI01SO Header Cache File (MBF)53ZHMOTMode of TransportStringUDC30
28F42UI12Sales Order Detail Cache 2 (MBF)45ZDMOTMode of TransportStringUDC30
29F42UI130Commitment Work File43ZCMOTMode of TransportStringUDC30
TOP42B: Sales Order Entry
30F42420Audit Log Transaction50ALMOTMode of TransportStringUDC30
TOP43: Procurement
31F4301Purchase Order Header45PHMOTMode of TransportStringUDC30
32F4301ZPO Header Work File49PAMOTMode of TransportStringUDC30
33F4301Z1Purchase Order Header Unedited Transaction Table58SYMOTMode of TransportStringUDC30
34F43080Approvals Fields Constants106PDMOTMode of TransportStringUDC30
35F4311Purchase Order Detail File102PDMOTMode of TransportStringUDC30
36F4311ZPurchase Order Generator File106PWMOTMode of TransportStringUDC30
37F4311Z1Purchase Order Detail Unedited Transaction Table115SZMOTMode of TransportStringUDC30
38F43121Z1Receipts Unedited Transaction Table145SZMOTMode of TransportStringUDC30
39F43199P.O. Detail Ledger File - Flexible Version102OLMOTMode of TransportStringUDC30
40F43UI50DPO Print Detail Work File15PWMOTMode of TransportStringUDC30
TOP43Q: Strategic Sourcing
41F43Q11Event Detail34EDMOTMode of TransportStringUDC30
42F43Q51Analyze Event Detail30EDMOTMode of TransportStringUDC30
TOP46: Warehouse Management
43F4942Z1Work File for F494238SYMOTMode of TransportStringUDC30
TOP47: Electronic Commerce
44F47011EDI Purchase Order Header - Inbound64SYMOTMode of TransportStringUDC30
45F47012EDI Purchase Order Detail - Inbound140SZMOTMode of TransportStringUDC30
46F47016EDI Purchase Order Header - Outbound60SYMOTMode of TransportStringUDC30
47F47017EDI Purchase Order Detail - Outbound116SZMOTMode of TransportStringUDC30
48F47021EDI P.O. Acknowledgment Header - Inbound60SYMOTMode of TransportStringUDC30
49F47022EDI P.O. Acknowledgment Detail - Inbound116SZMOTMode of TransportStringUDC30
50F47026EDI P.O. Acknowledgment Header - Outbound60SYMOTMode of TransportStringUDC30
51F47027EDI P.O. Acknowledgment Detail - Outbound140SZMOTMode of TransportStringUDC30
52F47031EDI Shipping Notice Header - Inbound55SYMOTMode of TransportStringUDC30
53F47032EDI Shipping Notice Detail - Inbound86SZMOTMode of TransportStringUDC30
54F47037EDI Shipping Notice Detail - Outbound122SZMOTMode of TransportStringUDC30
55F470371EDI Shipping Notice Detail - Outbound138SZMOTMode of TransportStringUDC30
56F47046EDI Invoice Header (Sales) - Outbound60SYMOTMode of TransportStringUDC30
57F47047EDI Invoice Detail (Sales) - Outbound140SZMOTMode of TransportStringUDC30
58F47071EDI Receiving Advice Header - Inbound61SYMOTMode of TransportStringUDC30
59F47072EDI Receiving Advice Detail - Inbound117SZMOTMode of TransportStringUDC30
60F47076EDI Receiving Advice Header - Outbound61SYMOTMode of TransportStringUDC30
61F47077EDI Receiving Advice Detail - Outbound117SZMOTMode of TransportStringUDC30
62F47091EDI Request for Quote Header - Inbound64SYMOTMode of TransportStringUDC30
63F47092EDI Request for Quote Detail - Inbound140SZMOTMode of TransportStringUDC30
64F47096EDI Request for Quote Header - Outbound60SYMOTMode of TransportStringUDC30
65F47097EDI Request for Quote Detail - Outbound116SZMOTMode of TransportStringUDC30
66F47101EDI Response to RFQ Header - Inbound60SYMOTMode of TransportStringUDC30
67F47102EDI Response to RFQ Detail - Inbound116SZMOTMode of TransportStringUDC30
68F47106EDI Response to RFQ Header - Outbound60SYMOTMode of TransportStringUDC30
69F47107EDI Response to RFQ Detail - Outbound140SZMOTMode of TransportStringUDC30
70F47131EDI Purchase Order Change Header - Inbound61SYMOTMode of TransportStringUDC30
71F47132EDI Purchase Order Change Detail - Inbound141SZMOTMode of TransportStringUDC30
72F47136EDI Purchase Order Change Header - Outbound60SYMOTMode of TransportStringUDC30
73F47137EDI Purchase Order Change Detail - Outbound117SZMOTMode of TransportStringUDC30
74F47141EDI P.O. Change Acknowledgment Header - Inbound61SYMOTMode of TransportStringUDC30
75F47142EDI P.O. Change Acknowledgment Detail - Inbound118SZMOTMode of TransportStringUDC30
76F47146EDI P.O. Change Acknowledgment Header - Outbound61SYMOTMode of TransportStringUDC30
77F47147EDI P.O. Change Acknowledgment Detail - Outbound142SZMOTMode of TransportStringUDC30
78F47156EDI Shipping Schedule Header - Outbound63SYMOTMode of TransportStringUDC30
79F47157EDI Shipping Schedule Detail - Outbound123SZMOTMode of TransportStringUDC30
TOP49: Transportation Management
80F49004Mode of Transport Constants2CTMOTMode of TransportStringUDC30
81F49005Generate Tracking Number2TGMOTMode of TransportStringUDC30
82F490051Generate Tracking Number Segment2XGMOTMode of TransportStringUDC30
83F490053Generate Tracking Number Separator2ZGMOTMode of TransportStringUDC30
84F49010Vehicle Master (Conversion from World File)15VMMOTMode of TransportStringUDC30
85F49110Transportation Bill of Lading Workfile15BWMOTMode of TransportStringUDC30
86F49130Shipment Document Workfile15BWMOTMode of TransportStringUDC30
87F4931Vehicle Type4VGMOTMode of TransportStringUDC30
88F4935Connected Vehicle Header7VHMOTMode of TransportStringUDC30
89F4941Shipment Routing Steps3RSMOTMode of TransportStringUDC30
90F4950Routing Entries7RTMOTMode of TransportStringUDC30
91F49501Intermodal Detail Routing Entries6RDMOTMode of TransportStringUDC30
92F4952Routing Restrictions2REMOTMode of TransportStringUDC30
93F4956Option and Equipment Inclusions/Exclusions1IXMOTMode of TransportStringUDC30
94F4957Transportation Confirmed Batch Shipment15BCMOTMode of TransportStringUDC30
95F4960Load Header24TMMOTMode of TransportStringUDC30
96F4963Load In-transit11TIMOTMode of TransportStringUDC30
97F49631Load In-transit Ledger20TOMOTMode of TransportStringUDC30
98F4981Freight Audit History17FHMOTMode of TransportStringUDC30
99F49T10Sales Order Release Staging Table15ORMOTMode of TransportStringUDC30
100F49T20Shipment Staging Table23SSMOTMode of TransportStringUDC30
TOP54R: Rental Management
101F54R099Rental Contract Header Ledger63HLMOTMode of TransportStringUDC30
102F54R10Rental Contract Header61CHMOTMode of TransportStringUDC30
103F54R11Rental Contract Detail95CDMOTMode of TransportStringUDC30
104F54R199Rental Contract Detail Ledger91DLMOTMode of TransportStringUDC30
TOP74: EMEA Localization
105F0018TIntrastat Revision21TDMOTMode of TransportStringUDC30
TOP75I: India
106F75I0002Additional Information Master for SO5Q1MOTMode of TransportStringUDC30
107F75I320YExcise - Payment Details30QBMOTMode of TransportStringUDC30
108F75I345Excise - ARE3 Form Header Details-IND-0024QRMOTMode of TransportStringUDC30
109F75I345XExcise - ARE-3 Form Header for Yarn21QRMOTMode of TransportStringUDC30
110F75I354Excise ARE3 Tag file for Form Header IND 4214QWMOTMode of TransportStringUDC30
111F75I701Bill of Entry - Header18QHMOTMode of TransportStringUDC30
TOP89: Conversion Programs
112F43199ATemp 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       1Transport by sea N
3       2Transport by rail N
4       3Transport by road N
5       4Transport by air N
6       5Consignments by post N
7       6Fixed transport installations N
8       7Transport by inland waterway N
9       8Own propulsion N
10       ALLDefault Mode N
11       GRDGround Service N
12       LTLLess than Truckload N
13       NDANext Day Air N
14       SDASecond Day Air N
15       TLTruckload N
16       WPXWestern Parcel International N