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

77 columns | Print definition?812 | ZON | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0401Z1Supplier Master - Batch File54VOZONZone NumberStringUDC30
TOP01: Address Book
2F0401Supplier Master40A6ZONZone NumberStringUDC30
TOP03: Accounts Receivable
3F03012Customer Master by Line of Business88AIZONZone NumberStringUDC30
4F03012Z1Customer Master LOB-Batch File101VOZONZone 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
TOP42: Sales Management
12F4020Freight/Additional Charges Rate Information1ARZONZone NumberStringUDC30
13F4201Sales Order Header File52SHZONZone NumberStringUDC30
14F42019Sales Order Header History File52SHZONZone NumberStringUDC30
15F4211Sales Order Detail File122SDZONZone NumberStringUDC30
16F42119Sales Order History File122SDZONZone NumberStringUDC30
17F42199S.O. Detail Ledger File122SLZONZone NumberStringUDC30
18F42UI01SO Header Cache File (MBF)57ZHZONZone NumberStringUDC30
19F42UI12Sales Order Detail Cache 2 (MBF)48ZDZONZone NumberStringUDC30
TOP42B: Sales Order Entry
20F42420Audit Log Transaction79ALZONZone NumberStringUDC30
TOP43: Procurement
21F4301Purchase Order Header42PHZONZone NumberStringUDC30
22F4301ZPO Header Work File46PAZONZone NumberStringUDC30
23F4301Z1Purchase Order Header Unedited Transaction Table55SYZONZone NumberStringUDC30
24F43080Approvals Fields Constants101PDZONZone NumberStringUDC30
25F4311Purchase Order Detail File97PDZONZone NumberStringUDC30
26F4311ZPurchase Order Generator File101PWZONZone NumberStringUDC30
27F4311Z1Purchase Order Detail Unedited Transaction Table110SZZONZone NumberStringUDC30
28F43199P.O. Detail Ledger File - Flexible Version97OLZONZone NumberStringUDC30
TOP46: Warehouse Management
29F4600Warehouse Requests51R1ZONZone NumberStringUDC30
30F4600PUWarehouse Requests - Purged49R1ZONZone NumberStringUDC30
31F4611Warehouse Suggestions124R2ZONZone NumberStringUDC30
32F4611PUWarehouse Suggestions - Purged123R2ZONZone NumberStringUDC30
33F4611Z1Unedited Suggestion Table135SZZONZone NumberStringUDC30
TOP47: Electronic Commerce
34F47011EDI Purchase Order Header - Inbound68SYZONZone NumberStringUDC30
35F47012EDI Purchase Order Detail - Inbound144SZZONZone NumberStringUDC30
36F47016EDI Purchase Order Header - Outbound57SYZONZone NumberStringUDC30
37F47017EDI Purchase Order Detail - Outbound111SZZONZone NumberStringUDC30
38F47021EDI P.O. Acknowledgment Header - Inbound57SYZONZone NumberStringUDC30
39F47022EDI P.O. Acknowledgment Detail - Inbound111SZZONZone NumberStringUDC30
40F47026EDI P.O. Acknowledgment Header - Outbound64SYZONZone NumberStringUDC30
41F47027EDI P.O. Acknowledgment Detail - Outbound144SZZONZone NumberStringUDC30
42F47031EDI Shipping Notice Header - Inbound52SYZONZone NumberStringUDC30
43F47032EDI Shipping Notice Detail - Inbound81SZZONZone NumberStringUDC30
44F47037EDI Shipping Notice Detail - Outbound126SZZONZone NumberStringUDC30
45F470371EDI Shipping Notice Detail - Outbound142SZZONZone NumberStringUDC30
46F47046EDI Invoice Header (Sales) - Outbound64SYZONZone NumberStringUDC30
47F47047EDI Invoice Detail (Sales) - Outbound144SZZONZone NumberStringUDC30
48F47071EDI Receiving Advice Header - Inbound58SYZONZone NumberStringUDC30
49F47072EDI Receiving Advice Detail - Inbound112SZZONZone NumberStringUDC30
50F47076EDI Receiving Advice Header - Outbound58SYZONZone NumberStringUDC30
51F47077EDI Receiving Advice Detail - Outbound112SZZONZone NumberStringUDC30
52F47091EDI Request for Quote Header - Inbound68SYZONZone NumberStringUDC30
53F47092EDI Request for Quote Detail - Inbound144SZZONZone NumberStringUDC30
54F47096EDI Request for Quote Header - Outbound57SYZONZone NumberStringUDC30
55F47097EDI Request for Quote Detail - Outbound111SZZONZone NumberStringUDC30
56F47101EDI Response to RFQ Header - Inbound57SYZONZone NumberStringUDC30
57F47102EDI Response to RFQ Detail - Inbound111SZZONZone NumberStringUDC30
58F47106EDI Response to RFQ Header - Outbound64SYZONZone NumberStringUDC30
59F47107EDI Response to RFQ Detail - Outbound144SZZONZone NumberStringUDC30
60F47131EDI Purchase Order Change Header - Inbound65SYZONZone NumberStringUDC30
61F47132EDI Purchase Order Change Detail - Inbound145SZZONZone NumberStringUDC30
62F47136EDI Purchase Order Change Header - Outbound57SYZONZone NumberStringUDC30
63F47137EDI Purchase Order Change Detail - Outbound112SZZONZone NumberStringUDC30
64F47141EDI P.O. Change Acknowledgment Header - Inbound58SYZONZone NumberStringUDC30
65F47142EDI P.O. Change Acknowledgment Detail - Inbound113SZZONZone NumberStringUDC30
66F47146EDI P.O. Change Acknowledgment Header - Outbound65SYZONZone NumberStringUDC30
67F47147EDI P.O. Change Acknowledgment Detail - Outbound146SZZONZone NumberStringUDC30
68F47156EDI Shipping Schedule Header - Outbound60SYZONZone NumberStringUDC30
69F47157EDI Shipping Schedule Detail - Outbound118SZZONZone NumberStringUDC30
TOP49: Transportation Management
70F4950Routing Entries12RTZONZone NumberStringUDC30
71F4960Load Header13TMZONZone NumberStringUDC30
72F4981Freight Audit History57FHZONZone NumberStringUDC30
TOP55: Reserved for Clients
73F55IF421Sales Order per BO136SDZONZone NumberStringUDC30
74F55IF425Sales Order per BO - 2005136SDZONZone NumberStringUDC30
75F55IF565Invoice Work file Extension22EXZONZone NumberStringUDC30
76F55W0100Correction Invoice Print - WF1123SDZONZone NumberStringUDC30
TOP89: Conversion Programs
77F43199ATemp 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