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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

105 columns | Print definition?920 | EDST | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP40: Inventory/OP Base
1F4001ZBatch Receiver File - Order Headings7SYEDSTEDI - Transaction Set NumberStringUDC60
2F4011ZBatch Receiver File - Order Details7SZEDSTEDI - Transaction Set NumberStringUDC60
TOP40R: Demand Scheduling
3F47171EDI Demand Header7EHEDSTEDI - Transaction Set NumberStringUDC60
4F47172EDI Demand Detail7EDEDSTEDI - Transaction Set NumberStringUDC60
5F471721EDI Demand Supplemental Data7EUEDSTEDI - Transaction Set NumberStringUDC60
6F471722EDI Demand Addresses7EAEDSTEDI - Transaction Set NumberStringUDC60
7F471723EDI Demand Contact Names7ECEDSTEDI - Transaction Set NumberStringUDC60
8F471724EDI Demand Contact Numbers7ENEDSTEDI - Transaction Set NumberStringUDC60
9F47173EDI Demand Scheduling Detail7ESEDSTEDI - Transaction Set NumberStringUDC60
10F471731EDI Demand Packaging7EPEDSTEDI - Transaction Set NumberStringUDC60
11F47800EDI Transmission Values5FFEDSTEDI - Transaction Set NumberStringUDC60
TOP42: Sales Management
12F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound17UZEDSTEDI - Transaction Set NumberStringUDC60
13F470371TTag for F470371- EDI shipping Notice Detail - Outbound28UZEDSTEDI - Transaction Set NumberStringUDC60
14F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound17UZEDSTEDI - Transaction Set NumberStringUDC60
15F47107TTag for F47107- EDI Response to RFQ Detail - Outbound17UZEDSTEDI - Transaction Set NumberStringUDC60
16F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound17UZEDSTEDI - Transaction Set NumberStringUDC60
TOP42B: Sales Order Entry
17F4011ZTBatch Receiver File - Order Details Tag7UZEDSTEDI - Transaction Set NumberStringUDC60
18F47012TEDI Purchase Order Detail Tag - Inbound7UZEDSTEDI - Transaction Set NumberStringUDC60
19F47092TEDI Request for Quote Detail Tag - Inbound7UZEDSTEDI - Transaction Set NumberStringUDC60
20F47132TEDI Purchase Order Change Detail Tag - Inbound7UZEDSTEDI - Transaction Set NumberStringUDC60
TOP45: Advanced Pricing
21F4576Z1Ship and Debit Claims Unedited Transaction Table105Z1EDSTEDI - Transaction Set NumberStringUDC60
TOP47: Electronic Commerce
22F47003EDI Discrepancy Report Work File9SXEDSTEDI - Transaction Set NumberStringUDC60
23F47006EDI Order Header - Outbound Tax Table7STEDSTEDI - Transaction Set NumberStringUDC60
24F47007EDI Order Detail - Outbound Tax Table7DTEDSTEDI - Transaction Set NumberStringUDC60
25F47011EDI Purchase Order Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
26F47011TXEDI Purchase Order Header Tax - Inbound7STEDSTEDI - Transaction Set NumberStringUDC60
27F47012EDI Purchase Order Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
28F47012TXEDI Purchase Order Detail Tax - Inbound7DTEDSTEDI - Transaction Set NumberStringUDC60
29F47016EDI Purchase Order Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
30F470161EDI Purchase Order Additional Header - Outbound72S3EDSTEDI - Transaction Set NumberStringUDC60
31F47017EDI Purchase Order Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
32F470171EDI Purchase Order Additional Detail - Outbound53S4EDSTEDI - Transaction Set NumberStringUDC60
33F47021EDI P.O. Acknowledgment Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
34F47022EDI P.O. Acknowledgment Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
35F47026EDI P.O. Acknowledgment Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
36F47027EDI P.O. Acknowledgment Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
37F47031EDI Shipping Notice Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
38F47032EDI Shipping Notice Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
39F47036EDI Shipping Notice Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
40F47036XEDI Shipping Notice Header Tax - Outbound7STEDSTEDI - Transaction Set NumberStringUDC60
41F47037EDI Shipping Notice Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
42F470371EDI Shipping Notice Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
43F470371XEDI Shipping Notice Detail Tax - Outbound10DTEDSTEDI - Transaction Set NumberStringUDC60
44F470372EDI ASN Demand Scheduling Detail7AIEDSTEDI - Transaction Set NumberStringUDC60
45F470373EDI ASN Shipping6AGEDSTEDI - Transaction Set NumberStringUDC60
46F470374EDI ASN Demand Addresses8AMEDSTEDI - Transaction Set NumberStringUDC60
47F470375EDI ASN Packaging Detail7AKEDSTEDI - Transaction Set NumberStringUDC60
48F47041EDI Invoice Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
49F47042EDI Invoice Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
50F47044EDI Invoice Summary - Inbound7SWEDSTEDI - Transaction Set NumberStringUDC60
51F47046EDI Invoice Header (Sales) - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
52F47047EDI Invoice Detail (Sales) - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
53F47056EDI Payment Order Header - Outbound7D1EDSTEDI - Transaction Set NumberStringUDC60
54F47056WEDI Payment Order Header - Work7D1EDSTEDI - Transaction Set NumberStringUDC60
55F47057EDI Payment Order Remittance Advice - Outbound7D3EDSTEDI - Transaction Set NumberStringUDC60
56F47057WEDI Payment Order Remittance Advice - Work7D3EDSTEDI - Transaction Set NumberStringUDC60
57F47061EDI Planning Schedule Header - Inbound7MJEDSTEDI - Transaction Set NumberStringUDC60
58F47062EDI Planning Schedule Detail - Inbound7MYEDSTEDI - Transaction Set NumberStringUDC60
59F47066EDI Planning Schedule Header - Outbound7MJEDSTEDI - Transaction Set NumberStringUDC60
60F47067EDI Planning Schedule Detail - Outbound7MYEDSTEDI - Transaction Set NumberStringUDC60
61F47071EDI Receiving Advice Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
62F47072EDI Receiving Advice Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
63F47076EDI Receiving Advice Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
64F47077EDI Receiving Advice Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
65F47081EDI Price Sales Catalog Header - Inbound7FVEDSTEDI - Transaction Set NumberStringUDC60
66F47082EDI Price Sales Catalog Detail - Inbound7FYEDSTEDI - Transaction Set NumberStringUDC60
67F47091EDI Request for Quote Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
68F47091TXEDI Request for Quote Header Tax - Inbound7STEDSTEDI - Transaction Set NumberStringUDC60
69F47092EDI Request for Quote Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
70F47096EDI Request for Quote Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
71F47097EDI Request for Quote Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
72F47101EDI Response to RFQ Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
73F47102EDI Response to RFQ Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
74F47106EDI Response to RFQ Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
75F47107EDI Response to RFQ Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
76F47111EDI Lockbox/Payment Header - Transaction7Z1EDSTEDI - Transaction Set NumberStringUDC60
77F47112EDI Lockbox Header - Transaction7Z2EDSTEDI - Transaction Set NumberStringUDC60
78F47121EDI Product Activity Data Header - Inbound7M1EDSTEDI - Transaction Set NumberStringUDC60
79F47122EDI Product Activity Data Detail - Inbound7MJEDSTEDI - Transaction Set NumberStringUDC60
80F47126EDI Product Activity Data Header - Outbound7M1EDSTEDI - Transaction Set NumberStringUDC60
81F47127EDI Product Activity Data Detail - Outbound7MJEDSTEDI - Transaction Set NumberStringUDC60
82F47131EDI Purchase Order Change Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
83F47131TXEDI Purchase Order Change Header Tax - Inbound7STEDSTEDI - Transaction Set NumberStringUDC60
84F47132EDI Purchase Order Change Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
85F47132TXEDI Purchase Order Change Detail Tax - Inbound7DTEDSTEDI - Transaction Set NumberStringUDC60
86F47136EDI Purchase Order Change Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
87F47137EDI Purchase Order Change Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
88F47141EDI P.O. Change Acknowledgment Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
89F47142EDI P.O. Change Acknowledgment Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
90F47146EDI P.O. Change Acknowledgment Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
91F47147EDI P.O. Change Acknowledgment Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
92F47156EDI Shipping Schedule Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
93F47157EDI Shipping Schedule Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
94F4716EDI Item Text - Inbound/Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
95F47181EDI Consumption Header (FUTURE)13EHEDSTEDI - Transaction Set NumberStringUDC60
96F47182EDI Consumption Detail (FUTURE)22EDEDSTEDI - Transaction Set NumberStringUDC60
97F47191EDI Acknowledgement Header7AHEDSTEDI - Transaction Set NumberStringUDC60
98F47192EDI Acknowledgement Error Detail7AEEDSTEDI - Transaction Set NumberStringUDC60
99F47194EDI Acknowledgement References7AREDSTEDI - Transaction Set NumberStringUDC60
100F47196EDI Acknowledgement Name And Address7AAEDSTEDI - Transaction Set NumberStringUDC60
101F47198EDI Acknowledgement Notes7ANEDSTEDI - Transaction Set NumberStringUDC60
102F4722EDI Tolerance Rules1PZEDSTEDI - Transaction Set NumberStringUDC60
103F47CTLEDI Lockbox/Payment Work File11Z5EDSTEDI - Transaction Set NumberStringUDC60
104F47HLHierarchical Configuration1HLEDSTEDI - Transaction Set NumberStringUDC60
TOP49: Transportation Management
105F47092TXEDI Request for Quote Detail Tax - Inbound7DTEDSTEDI - Transaction Set NumberStringUDC60

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

TOPUDC 40 / ST (EDI - Transaction Set Number) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 Default - Trans. Set ID 40/ST N
2    810Invoice
3    820Payment Order
4    823Lockbox
5    824Application Advice Y
6    830Planning Schedule
7    832Price Sales Catalog
8    840Request for Quote
9    843Response to RFQ
10    850Purchase Order
11    852Product Activity Data
12    855Purchase Order Acknowledgment
13    856Shipment Notice
14    860Purchase Order Change
15    861Receiving Advice
16    865Purchase Order Change Ack.
17    867Product Transfer and Resale
18    997Functional Acknowledgment Y
19    APERAKApplication Advice Y
20    CONTRLFunctional Acknowledgment Y
21    DEBADVLockbox
22    DELFORPlanning Schedule
23    DEMANDInbound Demand Y
24    DESADVShipment Notice Y
25    INVOICInvoice
26    ORDERSPurchase Order
27    ORDRSPPurchase Order Acknowledgment
28    PAYEXTPayment Order
29    PRICATPrice Sales Catalog
30    QUOTESResponse to RFQ
31    REQUOTRequest for Quote