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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

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
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

93 columns | Print definition?812 | 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
23F47011EDI Purchase Order Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
24F47012EDI Purchase Order Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
25F47016EDI Purchase Order Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
26F470161EDI Purchase Order Additional Header - Outbound72S3EDSTEDI - Transaction Set NumberStringUDC60
27F47017EDI Purchase Order Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
28F470171EDI Purchase Order Additional Detail - Outbound53S4EDSTEDI - Transaction Set NumberStringUDC60
29F47021EDI P.O. Acknowledgment Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
30F47022EDI P.O. Acknowledgment Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
31F47026EDI P.O. Acknowledgment Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
32F47027EDI P.O. Acknowledgment Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
33F47031EDI Shipping Notice Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
34F47032EDI Shipping Notice Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
35F47036EDI Shipping Notice Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
36F47037EDI Shipping Notice Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
37F470371EDI Shipping Notice Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
38F470372EDI ASN Demand Scheduling Detail7AIEDSTEDI - Transaction Set NumberStringUDC60
39F470373EDI ASN Shipping6AGEDSTEDI - Transaction Set NumberStringUDC60
40F470374EDI ASN Demand Addresses8AMEDSTEDI - Transaction Set NumberStringUDC60
41F470375EDI ASN Packaging Detail7AKEDSTEDI - Transaction Set NumberStringUDC60
42F47041EDI Invoice Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
43F47042EDI Invoice Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
44F47044EDI Invoice Summary - Inbound7SWEDSTEDI - Transaction Set NumberStringUDC60
45F47046EDI Invoice Header (Sales) - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
46F47047EDI Invoice Detail (Sales) - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
47F47056EDI Payment Order Header - Outbound7D1EDSTEDI - Transaction Set NumberStringUDC60
48F47056WEDI Payment Order Header - Work7D1EDSTEDI - Transaction Set NumberStringUDC60
49F47057EDI Payment Order Remittance Advice - Outbound7D3EDSTEDI - Transaction Set NumberStringUDC60
50F47057WEDI Payment Order Remittance Advice - Work7D3EDSTEDI - Transaction Set NumberStringUDC60
51F47061EDI Planning Schedule Header - Inbound7MJEDSTEDI - Transaction Set NumberStringUDC60
52F47062EDI Planning Schedule Detail - Inbound7MYEDSTEDI - Transaction Set NumberStringUDC60
53F47066EDI Planning Schedule Header - Outbound7MJEDSTEDI - Transaction Set NumberStringUDC60
54F47067EDI Planning Schedule Detail - Outbound7MYEDSTEDI - Transaction Set NumberStringUDC60
55F47071EDI Receiving Advice Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
56F47072EDI Receiving Advice Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
57F47076EDI Receiving Advice Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
58F47077EDI Receiving Advice Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
59F47081EDI Price Sales Catalog Header - Inbound7FVEDSTEDI - Transaction Set NumberStringUDC60
60F47082EDI Price Sales Catalog Detail - Inbound7FYEDSTEDI - Transaction Set NumberStringUDC60
61F47091EDI Request for Quote Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
62F47092EDI Request for Quote Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
63F47096EDI Request for Quote Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
64F47097EDI Request for Quote Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
65F47101EDI Response to RFQ Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
66F47102EDI Response to RFQ Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
67F47106EDI Response to RFQ Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
68F47107EDI Response to RFQ Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
69F47111EDI Lockbox/Payment Header - Transaction7Z1EDSTEDI - Transaction Set NumberStringUDC60
70F47112EDI Lockbox Header - Transaction7Z2EDSTEDI - Transaction Set NumberStringUDC60
71F47121EDI Product Activity Data Header - Inbound7M1EDSTEDI - Transaction Set NumberStringUDC60
72F47122EDI Product Activity Data Detail - Inbound7MJEDSTEDI - Transaction Set NumberStringUDC60
73F47126EDI Product Activity Data Header - Outbound7M1EDSTEDI - Transaction Set NumberStringUDC60
74F47127EDI Product Activity Data Detail - Outbound7MJEDSTEDI - Transaction Set NumberStringUDC60
75F47131EDI Purchase Order Change Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
76F47132EDI Purchase Order Change Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
77F47136EDI Purchase Order Change Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
78F47137EDI Purchase Order Change Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
79F47141EDI P.O. Change Acknowledgment Header - Inbound7SYEDSTEDI - Transaction Set NumberStringUDC60
80F47142EDI P.O. Change Acknowledgment Detail - Inbound7SZEDSTEDI - Transaction Set NumberStringUDC60
81F47146EDI P.O. Change Acknowledgment Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
82F47147EDI P.O. Change Acknowledgment Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
83F47156EDI Shipping Schedule Header - Outbound7SYEDSTEDI - Transaction Set NumberStringUDC60
84F47157EDI Shipping Schedule Detail - Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
85F4716EDI Item Text - Inbound/Outbound7SZEDSTEDI - Transaction Set NumberStringUDC60
86F47191EDI Acknowledgement Header7AHEDSTEDI - Transaction Set NumberStringUDC60
87F47192EDI Acknowledgement Error Detail7AEEDSTEDI - Transaction Set NumberStringUDC60
88F47194EDI Acknowledgement References7AREDSTEDI - Transaction Set NumberStringUDC60
89F47196EDI Acknowledgement Name And Address7AAEDSTEDI - Transaction Set NumberStringUDC60
90F47198EDI Acknowledgement Notes7ANEDSTEDI - Transaction Set NumberStringUDC60
91F4722EDI Tolerance Rules1PZEDSTEDI - Transaction Set NumberStringUDC60
92F47CTLEDI Lockbox/Payment Work File11Z5EDSTEDI - Transaction Set NumberStringUDC60
93F47HLHierarchical Configuration1HLEDSTEDI - 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
2    810   Invoice
3    820   Payment Order
4    823   Lockbox
5    824   Application AdviceY
6    830   Planning Schedule
7    832   Price Sales Catalog
8    840   Request for Quote
9    843   Response to RFQ
10    844   Claim NotificationN
11    845   Claim AcknowledgementN
12    849   Claim Status NotificationN
13    850   Purchase Order
14    852   Product Activity Data
15    855   Purchase Order Acknowledgment
16    856   Shipment Notice
17    860   Purchase Order Change
18    861   Receiving Advice
19    865   Purchase Order Change Ack.
20    867   Product Transfer and Resale
21    997   Functional AcknowledgmentY
22    APERAKApplication AdviceY
23    CONTRLFunctional AcknowledgmentY
24    DEBADVLockbox
25    DELFORPlanning Schedule
26    DEMANDInbound DemandY
27    DESADVShipment NoticeY
28    INVOICInvoice
29    ORDERSPurchase Order
30    ORDRSPPurchase Order Acknowledgment
31    PAYEXTPayment Order
32    PRICATPrice Sales Catalog
33    QUOTESResponse to RFQ
34    REQUOTRequest for Quote