JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
3F0911GLAccount Ledger
4F4101IMItem Master
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

90 columns | Print definition?910 | FRTH | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0401Z1Supplier Master - Batch Upload60VOFRTHFreight Handling CodeStringUDC30
TOP01: Address Book
2F0401Supplier Master46A6FRTHFreight Handling CodeStringUDC30
TOP03: Accounts Receivable
3F03012Customer Master by Line of Business93AIFRTHFreight Handling CodeStringUDC30
4F03012Z1Customer Master LOB-Batch Table106VOFRTHFreight Handling CodeStringUDC30
TOP40: Inventory/OP Base
5F4001ZBatch Receiver File - Order Headings78SYFRTHFreight Handling CodeStringUDC30
6F4011ZBatch Receiver File - Order Details145SZFRTHFreight Handling CodeStringUDC30
7F40332Preference Profile - Customer Freight18CFFRTHFreight Handling CodeStringUDC30
8F40333Preference Profile - Carrier21CAFRTHFreight Handling CodeStringUDC30
9F40334Preference Profile - Mode of Transport20MTFRTHFreight Handling CodeStringUDC30
10F4201Z1Sales Order Header Unedited Transaction File67SYFRTHFreight Handling CodeStringUDC30
11F4211Z1Sales Order Detail Unedited Transaction File137SZFRTHFreight Handling CodeStringUDC30
12F4215Shipment Header47XHFRTHFreight Handling CodeStringUDC30
TOP40S: Supply Chain Self Service
13F4947SWSelf-Service Shipment Tracking Work File15SWFRTHFreight Handling CodeStringUDC30
TOP41: Inventory Management
14F4132Usage Header (FUTURE)15UHFRTHFreight Handling CodeStringUDC30
TOP42: Sales Management
15F42004Commission Constants File9CMFRTHFreight Handling CodeStringUDC30
16F42005Sales Commission File24SCFRTHFreight Handling CodeStringUDC30
17F4201Sales Order Header File54SHFRTHFreight Handling CodeStringUDC30
18F42019Sales Order Header History File54SHFRTHFreight Handling CodeStringUDC30
19F4211Sales Order Detail File124SDFRTHFreight Handling CodeStringUDC30
20F42119Sales Order History File124SDFRTHFreight Handling CodeStringUDC30
21F42199S.O. Detail Ledger File124SLFRTHFreight Handling CodeStringUDC30
22F4290Delivery Note History13SEFRTHFreight Handling CodeStringUDC30
23F42UI005Sales Commission File24SCFRTHFreight Handling CodeStringUDC30
24F42UI01SO Header Cache File (MBF)59ZHFRTHFreight Handling CodeStringUDC30
25F42UI12Sales Order Detail Cache 2 (MBF)50ZDFRTHFreight Handling CodeStringUDC30
26F42UI520Pick Slips Header File30S8FRTHFreight Handling CodeStringUDC30
27F42UI800Sales Detail Work File - Sales Update62SDFRTHFreight Handling CodeStringUDC30
TOP43: Procurement
28F4301Purchase Order Header41PHFRTHFreight Handling CodeStringUDC30
29F4301ZPO Header Work File45PAFRTHFreight Handling CodeStringUDC30
30F4301Z1Purchase Order Header Unedited Transaction Table54SYFRTHFreight Handling CodeStringUDC30
31F43080Approvals Fields Constants99PDFRTHFreight Handling CodeStringUDC30
32F4311Purchase Order Detail File95PDFRTHFreight Handling CodeStringUDC30
33F4311ZPurchase Order Generator File99PWFRTHFreight Handling CodeStringUDC30
34F4311Z1Purchase Order Detail Unedited Transaction Table108SZFRTHFreight Handling CodeStringUDC30
35F43199P.O. Detail Ledger File - Flexible Version95OLFRTHFreight Handling CodeStringUDC30
36F43UI50HPO Print Header Work File27PAFRTHFreight Handling CodeStringUDC30
TOP43Q: Strategic Sourcing
37F43Q11Event Detail33EDFRTHFreight Handling CodeStringUDC30
38F43Q51Analyze Event Detail29EDFRTHFreight Handling CodeStringUDC30
39F43Q91Bidder Registration17BRFRTHFreight Handling CodeStringUDC30
TOP46: Warehouse Management
40F4942Z1Work File for F494236SYFRTHFreight Handling CodeStringUDC30
TOP47: Electronic Commerce
41F47011EDI Purchase Order Header - Inbound70SYFRTHFreight Handling CodeStringUDC30
42F47012EDI Purchase Order Detail - Inbound146SZFRTHFreight Handling CodeStringUDC30
43F47016EDI Purchase Order Header - Outbound56SYFRTHFreight Handling CodeStringUDC30
44F47017EDI Purchase Order Detail - Outbound109SZFRTHFreight Handling CodeStringUDC30
45F47021EDI P.O. Acknowledgment Header - Inbound56SYFRTHFreight Handling CodeStringUDC30
46F47022EDI P.O. Acknowledgment Detail - Inbound109SZFRTHFreight Handling CodeStringUDC30
47F47026EDI P.O. Acknowledgment Header - Outbound66SYFRTHFreight Handling CodeStringUDC30
48F47027EDI P.O. Acknowledgment Detail - Outbound146SZFRTHFreight Handling CodeStringUDC30
49F47031EDI Shipping Notice Header - Inbound51SYFRTHFreight Handling CodeStringUDC30
50F47032EDI Shipping Notice Detail - Inbound79SZFRTHFreight Handling CodeStringUDC30
51F47037EDI Shipping Notice Detail - Outbound128SZFRTHFreight Handling CodeStringUDC30
52F470371EDI Shipping Notice Detail - Outbound144SZFRTHFreight Handling CodeStringUDC30
53F47046EDI Invoice Header (Sales) - Outbound66SYFRTHFreight Handling CodeStringUDC30
54F47047EDI Invoice Detail (Sales) - Outbound146SZFRTHFreight Handling CodeStringUDC30
55F47071EDI Receiving Advice Header - Inbound57SYFRTHFreight Handling CodeStringUDC30
56F47072EDI Receiving Advice Detail - Inbound110SZFRTHFreight Handling CodeStringUDC30
57F47076EDI Receiving Advice Header - Outbound57SYFRTHFreight Handling CodeStringUDC30
58F47077EDI Receiving Advice Detail - Outbound110SZFRTHFreight Handling CodeStringUDC30
59F47091EDI Request for Quote Header - Inbound70SYFRTHFreight Handling CodeStringUDC30
60F47092EDI Request for Quote Detail - Inbound146SZFRTHFreight Handling CodeStringUDC30
61F47096EDI Request for Quote Header - Outbound56SYFRTHFreight Handling CodeStringUDC30
62F47097EDI Request for Quote Detail - Outbound109SZFRTHFreight Handling CodeStringUDC30
63F47101EDI Response to RFQ Header - Inbound56SYFRTHFreight Handling CodeStringUDC30
64F47102EDI Response to RFQ Detail - Inbound109SZFRTHFreight Handling CodeStringUDC30
65F47106EDI Response to RFQ Header - Outbound66SYFRTHFreight Handling CodeStringUDC30
66F47107EDI Response to RFQ Detail - Outbound146SZFRTHFreight Handling CodeStringUDC30
67F47131EDI Purchase Order Change Header - Inbound67SYFRTHFreight Handling CodeStringUDC30
68F47132EDI Purchase Order Change Detail - Inbound147SZFRTHFreight Handling CodeStringUDC30
69F47136EDI Purchase Order Change Header - Outbound56SYFRTHFreight Handling CodeStringUDC30
70F47137EDI Purchase Order Change Detail - Outbound110SZFRTHFreight Handling CodeStringUDC30
71F47141EDI P.O. Change Acknowledgment Header - Inbound57SYFRTHFreight Handling CodeStringUDC30
72F47142EDI P.O. Change Acknowledgment Detail - Inbound111SZFRTHFreight Handling CodeStringUDC30
73F47146EDI P.O. Change Acknowledgment Header - Outbound67SYFRTHFreight Handling CodeStringUDC30
74F47147EDI P.O. Change Acknowledgment Detail - Outbound148SZFRTHFreight Handling CodeStringUDC30
75F47156EDI Shipping Schedule Header - Outbound59SYFRTHFreight Handling CodeStringUDC30
76F47157EDI Shipping Schedule Detail - Outbound116SZFRTHFreight Handling CodeStringUDC30
TOP49: Transportation Management
77F49110Transportation Bill of Lading Workfile17BWFRTHFreight Handling CodeStringUDC30
78F49130Shipment Document Workfile16BWFRTHFreight Handling CodeStringUDC30
79F4981Freight Audit History59FHFRTHFreight Handling CodeStringUDC30
80F49T10Sales Order Release Staging Table16ORFRTHFreight Handling CodeStringUDC30
TOP55: Reserved for Clients
81F55FR001Storno Bolle13SBFRTHFreight Handling CodeStringUDC30
82F55IF421Sales Order per BO138SDFRTHFreight Handling CodeStringUDC30
83F55IF425Sales Order per BO - 2005138SDFRTHFreight Handling CodeStringUDC30
84F55IF565Invoice Work file Extension19EXFRTHFreight Handling CodeStringUDC30
85F55W0100Correction Invoice Print - WF1125SDFRTHFreight Handling CodeStringUDC30
86F74H1050Invoicing Workfile Header - New20IHFRTHFreight Handling CodeStringUDC30
TOP70: Multi-National Products - obsolete-do not reuse
87F703030Legal Document Header Tag File - COMM - 03B6H1FRTHFreight Handling CodeStringUDC30
TOP76B: Brazil - Reporting System Only
88F7601BNota Fiscal Header - BRA - 4261FHFRTHFreight Handling CodeStringUDC30
TOP89: Conversion Programs
89F42005ASales Commission File - Temporary24SCFRTHFreight Handling CodeStringUDC30
90F43199ATemp F43199 for ERP 9.0 Upgrade95OLFRTHFreight Handling CodeStringUDC30

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

TOPUDC 42 / FR (Freight Handling Code) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1