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

80 columns | Print definition?920 | ZON | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0401Z1Supplier Master - Batch Upload54VOZONZone NumberStringUDC30
TOP01: Address Book
2F0401Supplier Master40A6ZONZone NumberStringUDC30
TOP03: Accounts Receivable
3F03012Customer Master by Line of Business88AIZONZone NumberStringUDC30
4F03012Z1Customer Master LOB-Batch Table101VOZONZone NumberStringUDC30
TOP40: Inventory/OP Base
5F4001ZBatch Receiver File - Order Headings76SYZONZone NumberStringUDC30
6F4011ZBatch Receiver File - Order Details143SZZONZone NumberStringUDC30
7F40333Preference Profile - Carrier18CAZONZone NumberStringUDC30
8F40334Preference Profile - Mode of Transport17MTZONZone NumberStringUDC30
9F4201Z1Sales Order Header Unedited Transaction File65SYZONZone NumberStringUDC30
10F4211Z1Sales Order Detail Unedited Transaction File135SZZONZone NumberStringUDC30
11F4215Shipment Header39XHZONZone NumberStringUDC30
TOP41: Inventory Management
12F4132Usage Header (FUTURE)18UHZONZone NumberStringUDC30
TOP42: Sales Management
13F4020Freight/Additional Charges Rate Information1ARZONZone NumberStringUDC30
14F4201Sales Order Header File52SHZONZone NumberStringUDC30
15F42019Sales Order Header History File52SHZONZone NumberStringUDC30
16F4211Sales Order Detail File122SDZONZone NumberStringUDC30
17F42119Sales Order History File122SDZONZone NumberStringUDC30
18F42199S.O. Detail Ledger File122SLZONZone NumberStringUDC30
19F42UI01SO Header Cache File (MBF)57ZHZONZone NumberStringUDC30
20F42UI12Sales Order Detail Cache 2 (MBF)48ZDZONZone NumberStringUDC30
TOP42B: Sales Order Entry
21F42420Audit Log Transaction79ALZONZone NumberStringUDC30
TOP43: Procurement
22F4301Purchase Order Header42PHZONZone NumberStringUDC30
23F4301ZPO Header Work File46PAZONZone NumberStringUDC30
24F4301Z1Purchase Order Header Unedited Transaction Table55SYZONZone NumberStringUDC30
25F43080Approvals Fields Constants101PDZONZone NumberStringUDC30
26F4311Purchase Order Detail File97PDZONZone NumberStringUDC30
27F4311ZPurchase Order Generator File101PWZONZone NumberStringUDC30
28F4311Z1Purchase Order Detail Unedited Transaction Table110SZZONZone NumberStringUDC30
29F43199P.O. Detail Ledger File - Flexible Version97OLZONZone NumberStringUDC30
TOP46: Warehouse Management
30F4600Warehouse Requests51R1ZONZone NumberStringUDC30
31F4600PUWarehouse Requests - Purged49R1ZONZone NumberStringUDC30
32F4611Warehouse Suggestions124R2ZONZone NumberStringUDC30
33F4611PUWarehouse Suggestions - Purged123R2ZONZone NumberStringUDC30
34F4611Z1Unedited Suggestion Table135SZZONZone NumberStringUDC30
TOP47: Electronic Commerce
35F47011EDI Purchase Order Header - Inbound68SYZONZone NumberStringUDC30
36F47012EDI Purchase Order Detail - Inbound144SZZONZone NumberStringUDC30
37F47016EDI Purchase Order Header - Outbound57SYZONZone NumberStringUDC30
38F47017EDI Purchase Order Detail - Outbound111SZZONZone NumberStringUDC30
39F47021EDI P.O. Acknowledgment Header - Inbound57SYZONZone NumberStringUDC30
40F47022EDI P.O. Acknowledgment Detail - Inbound111SZZONZone NumberStringUDC30
41F47026EDI P.O. Acknowledgment Header - Outbound64SYZONZone NumberStringUDC30
42F47027EDI P.O. Acknowledgment Detail - Outbound144SZZONZone NumberStringUDC30
43F47031EDI Shipping Notice Header - Inbound52SYZONZone NumberStringUDC30
44F47032EDI Shipping Notice Detail - Inbound81SZZONZone NumberStringUDC30
45F47037EDI Shipping Notice Detail - Outbound126SZZONZone NumberStringUDC30
46F470371EDI Shipping Notice Detail - Outbound142SZZONZone NumberStringUDC30
47F47046EDI Invoice Header (Sales) - Outbound64SYZONZone NumberStringUDC30
48F47047EDI Invoice Detail (Sales) - Outbound144SZZONZone NumberStringUDC30
49F47071EDI Receiving Advice Header - Inbound58SYZONZone NumberStringUDC30
50F47072EDI Receiving Advice Detail - Inbound112SZZONZone NumberStringUDC30
51F47076EDI Receiving Advice Header - Outbound58SYZONZone NumberStringUDC30
52F47077EDI Receiving Advice Detail - Outbound112SZZONZone NumberStringUDC30
53F47091EDI Request for Quote Header - Inbound68SYZONZone NumberStringUDC30
54F47092EDI Request for Quote Detail - Inbound144SZZONZone NumberStringUDC30
55F47096EDI Request for Quote Header - Outbound57SYZONZone NumberStringUDC30
56F47097EDI Request for Quote Detail - Outbound111SZZONZone NumberStringUDC30
57F47101EDI Response to RFQ Header - Inbound57SYZONZone NumberStringUDC30
58F47102EDI Response to RFQ Detail - Inbound111SZZONZone NumberStringUDC30
59F47106EDI Response to RFQ Header - Outbound64SYZONZone NumberStringUDC30
60F47107EDI Response to RFQ Detail - Outbound144SZZONZone NumberStringUDC30
61F47131EDI Purchase Order Change Header - Inbound65SYZONZone NumberStringUDC30
62F47132EDI Purchase Order Change Detail - Inbound145SZZONZone NumberStringUDC30
63F47136EDI Purchase Order Change Header - Outbound57SYZONZone NumberStringUDC30
64F47137EDI Purchase Order Change Detail - Outbound112SZZONZone NumberStringUDC30
65F47141EDI P.O. Change Acknowledgment Header - Inbound58SYZONZone NumberStringUDC30
66F47142EDI P.O. Change Acknowledgment Detail - Inbound113SZZONZone NumberStringUDC30
67F47146EDI P.O. Change Acknowledgment Header - Outbound65SYZONZone NumberStringUDC30
68F47147EDI P.O. Change Acknowledgment Detail - Outbound146SZZONZone NumberStringUDC30
69F47156EDI Shipping Schedule Header - Outbound60SYZONZone NumberStringUDC30
70F47157EDI Shipping Schedule Detail - Outbound118SZZONZone NumberStringUDC30
TOP49: Transportation Management
71F4950Routing Entries12RTZONZone NumberStringUDC30
72F4960Load Header13TMZONZone NumberStringUDC30
73F4981Freight Audit History57FHZONZone NumberStringUDC30
74F49T50Order Release Location Staging23LOZONZone NumberStringUDC30
TOP54R: Rental Management
75F54R099Rental Contract Header Ledger67HLZONZone NumberStringUDC30
76F54R10Rental Contract Header65CHZONZone NumberStringUDC30
77F54R11Rental Contract Detail99CDZONZone NumberStringUDC30
78F54R199Rental Contract Detail Ledger95DLZONZone NumberStringUDC30
TOP75I: India
79F75I4223Sales Tax Summary/Detail17SDZONZone NumberStringUDC30
TOP89: Conversion Programs
80F43199ATemp F43199 for ERP 9.0 Upgrade97OLZONZone NumberStringUDC30

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

TOPUDC 40 / ZN (Shipping Zone) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 Blank - Shipping Zone 40/ZN N
2       001Metro Delivery
3       002Same Day Delivery
4       10Zone 1 N
5       20Zone 2 N
6       30Zone 3 N
7       999Out of City