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
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

149 columns | Print definition?920 | EDTY | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F03B11Z1Batch Invoices2VJEDTYType RecordCharacterUDC10
TOP04: Accounts Payable
2F0411Z1Voucher Transactions - Batch Upload2VLEDTYType RecordCharacterUDC10
3F0411Z3F0411 Interoperability Table14SZEDTYType RecordCharacterUDC10
4F04572A/P Payment Processing - Summary53KKEDTYType RecordCharacterUDC10
TOP05: Time Accounting and HRM Base
5F05100Z1Resource Competencies Unedited Transactions File28CUEDTYType RecordCharacterUDC10
TOP05T: Time Entry
6F06116Z1Employee Transactions - Batch File2VLEDTYType RecordCharacterUDC10
7F06116Z2ESS Timecard History2VMEDTYType RecordCharacterUDC10
TOP09: General Accounting
8F0911Z1Journal Entry Transactions - Batch File2VNEDTYType RecordCharacterUDC10
9F0911Z4F0911 Interoperability Table14SZEDTYType RecordCharacterUDC10
TOP11: Multi Currency
10F0015Z1External Currency Exchange Rates14ZEEDTYType RecordCharacterUDC10
TOP16: Profit Management (EPS)
11F1602Z1External Cost Analyzer Balances - Interoperability Table14CZEDTYType RecordCharacterUDC10
12F1632Z1External Driver Balances-Interoperability Table14CYEDTYType RecordCharacterUDC10
TOP40: Inventory/OP Base
13F4001ZBatch Receiver File - Order Headings1SYEDTYType RecordCharacterUDC10
14F4011ZBatch Receiver File - Order Details1SZEDTYType RecordCharacterUDC10
TOP40R: Demand Scheduling
15F47171EDI Demand Header1EHEDTYType RecordCharacterUDC10
16F47172EDI Demand Detail1EDEDTYType RecordCharacterUDC10
17F471721EDI Demand Supplemental Data1EUEDTYType RecordCharacterUDC10
18F471722EDI Demand Addresses1EAEDTYType RecordCharacterUDC10
19F471723EDI Demand Contact Names1ECEDTYType RecordCharacterUDC10
20F471724EDI Demand Contact Numbers1ENEDTYType RecordCharacterUDC10
21F47173EDI Demand Scheduling Detail1ESEDTYType RecordCharacterUDC10
22F471731EDI Demand Packaging1EPEDTYType RecordCharacterUDC10
23F47800EDI Transmission Values1FFEDTYType RecordCharacterUDC10
TOP42: Sales Management
24F42UI130Commitment Work File11ZCEDTYType RecordCharacterUDC10
25F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound18UZEDTYType RecordCharacterUDC10
26F470371TTag for F470371- EDI shipping Notice Detail - Outbound29UZEDTYType RecordCharacterUDC10
27F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound18UZEDTYType RecordCharacterUDC10
28F47107TTag for F47107- EDI Response to RFQ Detail - Outbound18UZEDTYType RecordCharacterUDC10
29F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound18UZEDTYType RecordCharacterUDC10
TOP42B: Sales Order Entry
30F4011ZTBatch Receiver File - Order Details Tag1UZEDTYType RecordCharacterUDC10
31F47012TEDI Purchase Order Detail Tag - Inbound1UZEDTYType RecordCharacterUDC10
32F47092TEDI Request for Quote Detail Tag - Inbound1UZEDTYType RecordCharacterUDC10
33F47132TEDI Purchase Order Change Detail Tag - Inbound1UZEDTYType RecordCharacterUDC10
TOP45: Advanced Pricing
34F4572Z1Live Promotions Interface - Inbound / Outbound8LPEDTYType RecordCharacterUDC10
35F4572ZPPurge Live Promotions Interface8PGEDTYType RecordCharacterUDC10
TOP47: Electronic Commerce
36F47002Flat File Cross-Reference Table3SVEDTYType RecordCharacterUDC10
37F47003EDI Discrepancy Report Work File18SXEDTYType RecordCharacterUDC10
38F47006EDI Order Header - Outbound Tax Table1STEDTYType RecordCharacterUDC10
39F47007EDI Order Detail - Outbound Tax Table1DTEDTYType RecordCharacterUDC10
40F47011EDI Purchase Order Header - Inbound1SYEDTYType RecordCharacterUDC10
41F47011TXEDI Purchase Order Header Tax - Inbound1STEDTYType RecordCharacterUDC10
42F47012EDI Purchase Order Detail - Inbound1SZEDTYType RecordCharacterUDC10
43F47012TXEDI Purchase Order Detail Tax - Inbound1DTEDTYType RecordCharacterUDC10
44F47013EDI Purchase Order Detail (SDQ) - Inbound1SPEDTYType RecordCharacterUDC10
45F47016EDI Purchase Order Header - Outbound1SYEDTYType RecordCharacterUDC10
46F470161EDI Purchase Order Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
47F47017EDI Purchase Order Detail - Outbound1SZEDTYType RecordCharacterUDC10
48F470171EDI Purchase Order Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
49F47021EDI P.O. Acknowledgment Header - Inbound1SYEDTYType RecordCharacterUDC10
50F47022EDI P.O. Acknowledgment Detail - Inbound1SZEDTYType RecordCharacterUDC10
51F47026EDI P.O. Acknowledgment Header - Outbound1SYEDTYType RecordCharacterUDC10
52F47027EDI P.O. Acknowledgment Detail - Outbound1SZEDTYType RecordCharacterUDC10
53F47031EDI Shipping Notice Header - Inbound1SYEDTYType RecordCharacterUDC10
54F47032EDI Shipping Notice Detail - Inbound1SZEDTYType RecordCharacterUDC10
55F47036EDI Shipping Notice Header - Outbound1SYEDTYType RecordCharacterUDC10
56F47036XEDI Shipping Notice Header Tax - Outbound1STEDTYType RecordCharacterUDC10
57F47037EDI Shipping Notice Detail - Outbound1SZEDTYType RecordCharacterUDC10
58F470371EDI Shipping Notice Detail - Outbound1SZEDTYType RecordCharacterUDC10
59F470371XEDI Shipping Notice Detail Tax - Outbound1DTEDTYType RecordCharacterUDC10
60F470372EDI ASN Demand Scheduling Detail1AIEDTYType RecordCharacterUDC10
61F470373EDI ASN Shipping1AGEDTYType RecordCharacterUDC10
62F470374EDI ASN Demand Addresses16AMEDTYType RecordCharacterUDC10
63F470375EDI ASN Packaging Detail1AKEDTYType RecordCharacterUDC10
64F47041EDI Invoice Header - Inbound1SYEDTYType RecordCharacterUDC10
65F47042EDI Invoice Detail - Inbound1SZEDTYType RecordCharacterUDC10
66F47044EDI Invoice Summary - Inbound1SWEDTYType RecordCharacterUDC10
67F47046EDI Invoice Header (Sales) - Outbound1SYEDTYType RecordCharacterUDC10
68F470461EDI Invoice Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
69F470462EDI Invoice Expanded Header (Sales)1S5EDTYType RecordCharacterUDC10
70F47047EDI Invoice Detail (Sales) - Outbound1SZEDTYType RecordCharacterUDC10
71F470471EDI Invoice Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
72F470472EDI Invoice Expanded Detail (Sales)1S6EDTYType RecordCharacterUDC10
73F470473EDI Invoice Detail Charges1S7EDTYType RecordCharacterUDC10
74F47056EDI Payment Order Header - Outbound1D1EDTYType RecordCharacterUDC10
75F470561EDI Payment Order Bank N & A - Outbound1D2EDTYType RecordCharacterUDC10
76F470561WEDI Payment Order Bank N & A - Work1D2EDTYType RecordCharacterUDC10
77F470562EDI Payment Order Vendor N & A - Outbound1D4EDTYType RecordCharacterUDC10
78F470562WEDI Payment Order Vendor N & A - Work1D4EDTYType RecordCharacterUDC10
79F470563EDI Payment Order Payee N & A - Outbound1D5EDTYType RecordCharacterUDC10
80F470563WEDI Payment Order Payee N & A - Work1D5EDTYType RecordCharacterUDC10
81F47056WEDI Payment Order Header - Work1D1EDTYType RecordCharacterUDC10
82F47057EDI Payment Order Remittance Advice - Outbound1D3EDTYType RecordCharacterUDC10
83F47057WEDI Payment Order Remittance Advice - Work1D3EDTYType RecordCharacterUDC10
84F4706EDI Order Address Information1ZAEDTYType RecordCharacterUDC10
85F47061EDI Planning Schedule Header - Inbound1MJEDTYType RecordCharacterUDC10
86F47062EDI Planning Schedule Detail - Inbound1MYEDTYType RecordCharacterUDC10
87F47066EDI Planning Schedule Header - Outbound1MJEDTYType RecordCharacterUDC10
88F47067EDI Planning Schedule Detail - Outbound1MYEDTYType RecordCharacterUDC10
89F47071EDI Receiving Advice Header - Inbound1SYEDTYType RecordCharacterUDC10
90F47072EDI Receiving Advice Detail - Inbound1SZEDTYType RecordCharacterUDC10
91F47076EDI Receiving Advice Header - Outbound1SYEDTYType RecordCharacterUDC10
92F47077EDI Receiving Advice Detail - Outbound1SZEDTYType RecordCharacterUDC10
93F47081EDI Price Sales Catalog Header - Inbound1FVEDTYType RecordCharacterUDC10
94F47082EDI Price Sales Catalog Detail - Inbound1FYEDTYType RecordCharacterUDC10
95F47091EDI Request for Quote Header - Inbound1SYEDTYType RecordCharacterUDC10
96F47091TXEDI Request for Quote Header Tax - Inbound1STEDTYType RecordCharacterUDC10
97F47092EDI Request for Quote Detail - Inbound1SZEDTYType RecordCharacterUDC10
98F47093EDI Request for Quote Detail (SDQ) - Inbound1SPEDTYType RecordCharacterUDC10
99F47096EDI Request for Quote Header - Outbound1SYEDTYType RecordCharacterUDC10
100F47097EDI Request for Quote Detail - Outbound1SZEDTYType RecordCharacterUDC10
101F47098EDI RFQ Detail Quantity - Outbound1SZEDTYType RecordCharacterUDC10
102F47101EDI Response to RFQ Header - Inbound1SYEDTYType RecordCharacterUDC10
103F47102EDI Response to RFQ Detail - Inbound1SZEDTYType RecordCharacterUDC10
104F47103EDI Response to RFQ Detail Quantity - Inbound1SZEDTYType RecordCharacterUDC10
105F47106EDI Response to RFQ Header - Outbound1SYEDTYType RecordCharacterUDC10
106F471061EDI Response to RFQ Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
107F47107EDI Response to RFQ Detail - Outbound1SZEDTYType RecordCharacterUDC10
108F471071EDI Response to RFQ Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
109F47111EDI Lockbox/Payment Header - Transaction1Z1EDTYType RecordCharacterUDC10
110F47112EDI Lockbox Header - Transaction1Z2EDTYType RecordCharacterUDC10
111F47113EDI Lockbox/Payment Detail - Batch1Z3EDTYType RecordCharacterUDC10
112F47114EDI Lockbox/Payment Detail - Payment1Z4EDTYType RecordCharacterUDC10
113F47121EDI Product Activity Data Header - Inbound1M1EDTYType RecordCharacterUDC10
114F47122EDI Product Activity Data Detail - Inbound1MJEDTYType RecordCharacterUDC10
115F47123EDI Product Activity Data (SDQ) - Inbound1MKEDTYType RecordCharacterUDC10
116F47126EDI Product Activity Data Header - Outbound1M1EDTYType RecordCharacterUDC10
117F47127EDI Product Activity Data Detail - Outbound1MJEDTYType RecordCharacterUDC10
118F47128EDI Product Activity Data (SDQ) - Outbound1MKEDTYType RecordCharacterUDC10
119F47131EDI Purchase Order Change Header - Inbound1SYEDTYType RecordCharacterUDC10
120F47131TXEDI Purchase Order Change Header Tax - Inbound1STEDTYType RecordCharacterUDC10
121F47132EDI Purchase Order Change Detail - Inbound1SZEDTYType RecordCharacterUDC10
122F47132TXEDI Purchase Order Change Detail Tax - Inbound1DTEDTYType RecordCharacterUDC10
123F47136EDI Purchase Order Change Header - Outbound1SYEDTYType RecordCharacterUDC10
124F47137EDI Purchase Order Change Detail - Outbound1SZEDTYType RecordCharacterUDC10
125F4714EDI Order Text Lines - Header1ZTEDTYType RecordCharacterUDC10
126F47141EDI P.O. Change Acknowledgment Header - Inbound1SYEDTYType RecordCharacterUDC10
127F47142EDI P.O. Change Acknowledgment Detail - Inbound1SZEDTYType RecordCharacterUDC10
128F47146EDI P.O. Change Acknowledgment Header - Outbound1SYEDTYType RecordCharacterUDC10
129F47147EDI P.O. Change Acknowledgment Detail - Outbound1SZEDTYType RecordCharacterUDC10
130F4715EDI Order Text Lines - Detail1ZDEDTYType RecordCharacterUDC10
131F47156EDI Shipping Schedule Header - Outbound1SYEDTYType RecordCharacterUDC10
132F47157EDI Shipping Schedule Detail - Outbound1SZEDTYType RecordCharacterUDC10
133F4716EDI Item Text - Inbound/Outbound1SZEDTYType RecordCharacterUDC10
134F47181EDI Consumption Header (FUTURE)21EHEDTYType RecordCharacterUDC10
135F47182EDI Consumption Detail (FUTURE)30EDEDTYType RecordCharacterUDC10
136F47191EDI Acknowledgement Header1AHEDTYType RecordCharacterUDC10
137F47192EDI Acknowledgement Error Detail1AEEDTYType RecordCharacterUDC10
138F47194EDI Acknowledgement References1AREDTYType RecordCharacterUDC10
139F47196EDI Acknowledgement Name And Address1AAEDTYType RecordCharacterUDC10
140F47198EDI Acknowledgement Notes1ANEDTYType RecordCharacterUDC10
141F47CTLEDI Lockbox/Payment Work File1Z5EDTYType RecordCharacterUDC10
TOP49: Transportation Management
142F47092TXEDI Request for Quote Detail Tax - Inbound1DTEDTYType RecordCharacterUDC10
TOP76A: Argentina
143F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A2VKEDTYType RecordCharacterUDC10
TOP76B: Brazil
144F76B472Dynamic Formater Layout Transaction & Line Types - 03B3DDEDTYType RecordCharacterUDC10
145F76B473Dynamic Formater Layouts Specification - 03B3DSEDTYType RecordCharacterUDC10
146F76B474Dynamic Formater Bank Attributes - 03B7BAEDTYType RecordCharacterUDC10
147F76B474IFile Upload For Bank Transaction Inbound Process - 03B5BIEDTYType RecordCharacterUDC10
TOP79A: Greenhouse Gas Accounting
148F79A11Z1GHG Ledger - Batch File2GLEDTYType RecordCharacterUDC10
TOP89: Conversion Programs
149F470375TEDI ASN Packaging Detail Tag Table10AKEDTYType RecordCharacterUDC10

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

TOPUDC 00 / RD (Record Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1         1Header Y
2         2Detail Y
3         3Additional Header Y
4         4Additional Detail Y
5         5SDQ Y
6         6Address Y
7         7Header Text Y
8         8Detail Text Y
9         9Packaging Y
10         AExpanded Header Y
11         BExpanded Detail Y
12         CDetail Charges Y
13         DPackaging Tag Y
14         HHeader Tag Y
15         NContact Names Y
16         PContact Numbers Y
17         SSupplemental Y