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

89 columns | Print definition?920 | 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
15F03B423Sales Order Trigger Configuration14TCFRTHFreight Handling CodeStringUDC30
16F42004Commission Constants File9CMFRTHFreight Handling CodeStringUDC30
17F42005Sales Commission File24SCFRTHFreight Handling CodeStringUDC30
18F4201Sales Order Header File54SHFRTHFreight Handling CodeStringUDC30
19F42019Sales Order Header History File54SHFRTHFreight Handling CodeStringUDC30
20F4211Sales Order Detail File124SDFRTHFreight Handling CodeStringUDC30
21F42119Sales Order History File124SDFRTHFreight Handling CodeStringUDC30
22F42199S.O. Detail Ledger File124SLFRTHFreight Handling CodeStringUDC30
23F4290Delivery Note History13SEFRTHFreight Handling CodeStringUDC30
24F42UI005Sales Commission File24SCFRTHFreight Handling CodeStringUDC30
25F42UI01SO Header Cache File (MBF)59ZHFRTHFreight Handling CodeStringUDC30
26F42UI12Sales Order Detail Cache 2 (MBF)50ZDFRTHFreight Handling CodeStringUDC30
27F42UI520Pick Slips Header File30S8FRTHFreight Handling CodeStringUDC30
28F42UI800Sales Detail Work File - Sales Update62SDFRTHFreight Handling CodeStringUDC30
TOP43: Procurement
29F4301Purchase Order Header41PHFRTHFreight Handling CodeStringUDC30
30F4301ZPO Header Work File45PAFRTHFreight Handling CodeStringUDC30
31F4301Z1Purchase Order Header Unedited Transaction Table54SYFRTHFreight Handling CodeStringUDC30
32F43080Approvals Fields Constants99PDFRTHFreight Handling CodeStringUDC30
33F4311Purchase Order Detail File95PDFRTHFreight Handling CodeStringUDC30
34F4311ZPurchase Order Generator File99PWFRTHFreight Handling CodeStringUDC30
35F4311Z1Purchase Order Detail Unedited Transaction Table108SZFRTHFreight Handling CodeStringUDC30
36F43199P.O. Detail Ledger File - Flexible Version95OLFRTHFreight Handling CodeStringUDC30
37F43UI50HPO Print Header Work File27PAFRTHFreight Handling CodeStringUDC30
TOP43Q: Strategic Sourcing
38F43Q11Event Detail33EDFRTHFreight Handling CodeStringUDC30
39F43Q51Analyze Event Detail29EDFRTHFreight Handling CodeStringUDC30
40F43Q91Bidder Registration17BRFRTHFreight Handling CodeStringUDC30
TOP46: Warehouse Management
41F4942Z1Work File for F494236SYFRTHFreight Handling CodeStringUDC30
TOP47: Electronic Commerce
42F47011EDI Purchase Order Header - Inbound70SYFRTHFreight Handling CodeStringUDC30
43F47012EDI Purchase Order Detail - Inbound146SZFRTHFreight Handling CodeStringUDC30
44F47016EDI Purchase Order Header - Outbound56SYFRTHFreight Handling CodeStringUDC30
45F47017EDI Purchase Order Detail - Outbound109SZFRTHFreight Handling CodeStringUDC30
46F47021EDI P.O. Acknowledgment Header - Inbound56SYFRTHFreight Handling CodeStringUDC30
47F47022EDI P.O. Acknowledgment Detail - Inbound109SZFRTHFreight Handling CodeStringUDC30
48F47026EDI P.O. Acknowledgment Header - Outbound66SYFRTHFreight Handling CodeStringUDC30
49F47027EDI P.O. Acknowledgment Detail - Outbound146SZFRTHFreight Handling CodeStringUDC30
50F47031EDI Shipping Notice Header - Inbound51SYFRTHFreight Handling CodeStringUDC30
51F47032EDI Shipping Notice Detail - Inbound79SZFRTHFreight Handling CodeStringUDC30
52F47037EDI Shipping Notice Detail - Outbound128SZFRTHFreight Handling CodeStringUDC30
53F470371EDI Shipping Notice Detail - Outbound144SZFRTHFreight Handling CodeStringUDC30
54F47046EDI Invoice Header (Sales) - Outbound66SYFRTHFreight Handling CodeStringUDC30
55F47047EDI Invoice Detail (Sales) - Outbound146SZFRTHFreight Handling CodeStringUDC30
56F47071EDI Receiving Advice Header - Inbound57SYFRTHFreight Handling CodeStringUDC30
57F47072EDI Receiving Advice Detail - Inbound110SZFRTHFreight Handling CodeStringUDC30
58F47076EDI Receiving Advice Header - Outbound57SYFRTHFreight Handling CodeStringUDC30
59F47077EDI Receiving Advice Detail - Outbound110SZFRTHFreight Handling CodeStringUDC30
60F47091EDI Request for Quote Header - Inbound70SYFRTHFreight Handling CodeStringUDC30
61F47092EDI Request for Quote Detail - Inbound146SZFRTHFreight Handling CodeStringUDC30
62F47096EDI Request for Quote Header - Outbound56SYFRTHFreight Handling CodeStringUDC30
63F47097EDI Request for Quote Detail - Outbound109SZFRTHFreight Handling CodeStringUDC30
64F47101EDI Response to RFQ Header - Inbound56SYFRTHFreight Handling CodeStringUDC30
65F47102EDI Response to RFQ Detail - Inbound109SZFRTHFreight Handling CodeStringUDC30
66F47106EDI Response to RFQ Header - Outbound66SYFRTHFreight Handling CodeStringUDC30
67F47107EDI Response to RFQ Detail - Outbound146SZFRTHFreight Handling CodeStringUDC30
68F47131EDI Purchase Order Change Header - Inbound67SYFRTHFreight Handling CodeStringUDC30
69F47132EDI Purchase Order Change Detail - Inbound147SZFRTHFreight Handling CodeStringUDC30
70F47136EDI Purchase Order Change Header - Outbound56SYFRTHFreight Handling CodeStringUDC30
71F47137EDI Purchase Order Change Detail - Outbound110SZFRTHFreight Handling CodeStringUDC30
72F47141EDI P.O. Change Acknowledgment Header - Inbound57SYFRTHFreight Handling CodeStringUDC30
73F47142EDI P.O. Change Acknowledgment Detail - Inbound111SZFRTHFreight Handling CodeStringUDC30
74F47146EDI P.O. Change Acknowledgment Header - Outbound67SYFRTHFreight Handling CodeStringUDC30
75F47147EDI P.O. Change Acknowledgment Detail - Outbound148SZFRTHFreight Handling CodeStringUDC30
76F47156EDI Shipping Schedule Header - Outbound59SYFRTHFreight Handling CodeStringUDC30
77F47157EDI Shipping Schedule Detail - Outbound116SZFRTHFreight Handling CodeStringUDC30
TOP49: Transportation Management
78F49110Transportation Bill of Lading Workfile17BWFRTHFreight Handling CodeStringUDC30
79F49130Shipment Document Workfile16BWFRTHFreight Handling CodeStringUDC30
80F4981Freight Audit History59FHFRTHFreight Handling CodeStringUDC30
81F49T10Sales Order Release Staging Table16ORFRTHFreight Handling CodeStringUDC30
TOP54R: Rental Management
82F54R099Rental Contract Header Ledger69HLFRTHFreight Handling CodeStringUDC30
83F54R10Rental Contract Header67CHFRTHFreight Handling CodeStringUDC30
84F54R11Rental Contract Detail101CDFRTHFreight Handling CodeStringUDC30
85F54R199Rental Contract Detail Ledger97DLFRTHFreight Handling CodeStringUDC30
TOP70: Multi-National Products
86F703030Legal Document Header Tag File - COMM - 03B6H1FRTHFreight Handling CodeStringUDC30
TOP76B: Brazil
87F7601BNota Fiscal Header - BRA - 4261FHFRTHFreight Handling CodeStringUDC30
TOP89: Conversion Programs
88F42005ASales Commission File - Temporary24SCFRTHFreight Handling CodeStringUDC30
89F43199ATemp 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  . N
2       AFree Alongside Ship N
3       BRRBypass Routing and Rating9N
4       CFreight Collect1N
5       DDelivered, Duty Paid N
6       FFree On Board - Our Dock N
7       FPFreight Pre-pay and Add N
8       GFree On Board - Their Dock N
9       ICost, Insurance, Freight N
10       PPickup with our Truck N
11       PPFreight Prepaid2N
12       UDelivered, Duty UnPaid N