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

148 columns | Print definition?910 | 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
24F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound18UZEDTYType RecordCharacterUDC10
25F470371TTag for F470371- EDI shipping Notice Detail - Outbound29UZEDTYType RecordCharacterUDC10
26F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound18UZEDTYType RecordCharacterUDC10
27F47107TTag for F47107- EDI Response to RFQ Detail - Outbound18UZEDTYType RecordCharacterUDC10
28F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound18UZEDTYType RecordCharacterUDC10
TOP42B: Sales Order Entry
29F4011ZTBatch Receiver File - Order Details Tag1UZEDTYType RecordCharacterUDC10
30F47012TEDI Purchase Order Detail Tag - Inbound1UZEDTYType RecordCharacterUDC10
31F47092TEDI Request for Quote Detail Tag - Inbound1UZEDTYType RecordCharacterUDC10
32F47132TEDI Purchase Order Change Detail Tag - Inbound1UZEDTYType RecordCharacterUDC10
TOP45: Advanced Pricing
33F4572Z1Live Promotions Interface - Inbound / Outbound8LPEDTYType RecordCharacterUDC10
34F4572ZPPurge Live Promotions Interface8PGEDTYType RecordCharacterUDC10
TOP47: Electronic Commerce
35F47002Flat File Cross-Reference Table3SVEDTYType RecordCharacterUDC10
36F47003EDI Discrepancy Report Work File18SXEDTYType RecordCharacterUDC10
37F47006EDI Order Header - Outbound Tax Table1STEDTYType RecordCharacterUDC10
38F47007EDI Order Detail - Outbound Tax Table1DTEDTYType RecordCharacterUDC10
39F47011EDI Purchase Order Header - Inbound1SYEDTYType RecordCharacterUDC10
40F47011TXEDI Purchase Order Header Tax - Inbound1STEDTYType RecordCharacterUDC10
41F47012EDI Purchase Order Detail - Inbound1SZEDTYType RecordCharacterUDC10
42F47012TXEDI Purchase Order Detail Tax - Inbound1DTEDTYType RecordCharacterUDC10
43F47013EDI Purchase Order Detail (SDQ) - Inbound1SPEDTYType RecordCharacterUDC10
44F47016EDI Purchase Order Header - Outbound1SYEDTYType RecordCharacterUDC10
45F470161EDI Purchase Order Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
46F47017EDI Purchase Order Detail - Outbound1SZEDTYType RecordCharacterUDC10
47F470171EDI Purchase Order Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
48F47021EDI P.O. Acknowledgment Header - Inbound1SYEDTYType RecordCharacterUDC10
49F47022EDI P.O. Acknowledgment Detail - Inbound1SZEDTYType RecordCharacterUDC10
50F47026EDI P.O. Acknowledgment Header - Outbound1SYEDTYType RecordCharacterUDC10
51F47027EDI P.O. Acknowledgment Detail - Outbound1SZEDTYType RecordCharacterUDC10
52F47031EDI Shipping Notice Header - Inbound1SYEDTYType RecordCharacterUDC10
53F47032EDI Shipping Notice Detail - Inbound1SZEDTYType RecordCharacterUDC10
54F47036EDI Shipping Notice Header - Outbound1SYEDTYType RecordCharacterUDC10
55F47036XEDI Shipping Notice Header Tax - Outbound1STEDTYType RecordCharacterUDC10
56F47037EDI Shipping Notice Detail - Outbound1SZEDTYType RecordCharacterUDC10
57F470371EDI Shipping Notice Detail - Outbound1SZEDTYType RecordCharacterUDC10
58F470371XEDI Shipping Notice Detail Tax - Outbound1DTEDTYType RecordCharacterUDC10
59F470372EDI ASN Demand Scheduling Detail1AIEDTYType RecordCharacterUDC10
60F470373EDI ASN Shipping1AGEDTYType RecordCharacterUDC10
61F470374EDI ASN Demand Addresses16AMEDTYType RecordCharacterUDC10
62F470375EDI ASN Packaging Detail1AKEDTYType RecordCharacterUDC10
63F47041EDI Invoice Header - Inbound1SYEDTYType RecordCharacterUDC10
64F47042EDI Invoice Detail - Inbound1SZEDTYType RecordCharacterUDC10
65F47044EDI Invoice Summary - Inbound1SWEDTYType RecordCharacterUDC10
66F47046EDI Invoice Header (Sales) - Outbound1SYEDTYType RecordCharacterUDC10
67F470461EDI Invoice Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
68F470462EDI Invoice Expanded Header (Sales)1S5EDTYType RecordCharacterUDC10
69F47047EDI Invoice Detail (Sales) - Outbound1SZEDTYType RecordCharacterUDC10
70F470471EDI Invoice Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
71F470472EDI Invoice Expanded Detail (Sales)1S6EDTYType RecordCharacterUDC10
72F470473EDI Invoice Detail Charges1S7EDTYType RecordCharacterUDC10
73F47056EDI Payment Order Header - Outbound1D1EDTYType RecordCharacterUDC10
74F470561EDI Payment Order Bank N & A - Outbound1D2EDTYType RecordCharacterUDC10
75F470561WEDI Payment Order Bank N & A - Work1D2EDTYType RecordCharacterUDC10
76F470562EDI Payment Order Vendor N & A - Outbound1D4EDTYType RecordCharacterUDC10
77F470562WEDI Payment Order Vendor N & A - Work1D4EDTYType RecordCharacterUDC10
78F470563EDI Payment Order Payee N & A - Outbound1D5EDTYType RecordCharacterUDC10
79F470563WEDI Payment Order Payee N & A - Work1D5EDTYType RecordCharacterUDC10
80F47056WEDI Payment Order Header - Work1D1EDTYType RecordCharacterUDC10
81F47057EDI Payment Order Remittance Advice - Outbound1D3EDTYType RecordCharacterUDC10
82F47057WEDI Payment Order Remittance Advice - Work1D3EDTYType RecordCharacterUDC10
83F4706EDI Order Address Information1ZAEDTYType RecordCharacterUDC10
84F47061EDI Planning Schedule Header - Inbound1MJEDTYType RecordCharacterUDC10
85F47062EDI Planning Schedule Detail - Inbound1MYEDTYType RecordCharacterUDC10
86F47066EDI Planning Schedule Header - Outbound1MJEDTYType RecordCharacterUDC10
87F47067EDI Planning Schedule Detail - Outbound1MYEDTYType RecordCharacterUDC10
88F47071EDI Receiving Advice Header - Inbound1SYEDTYType RecordCharacterUDC10
89F47072EDI Receiving Advice Detail - Inbound1SZEDTYType RecordCharacterUDC10
90F47076EDI Receiving Advice Header - Outbound1SYEDTYType RecordCharacterUDC10
91F47077EDI Receiving Advice Detail - Outbound1SZEDTYType RecordCharacterUDC10
92F47081EDI Price Sales Catalog Header - Inbound1FVEDTYType RecordCharacterUDC10
93F47082EDI Price Sales Catalog Detail - Inbound1FYEDTYType RecordCharacterUDC10
94F47091EDI Request for Quote Header - Inbound1SYEDTYType RecordCharacterUDC10
95F47091TXEDI Request for Quote Header Tax - Inbound1STEDTYType RecordCharacterUDC10
96F47092EDI Request for Quote Detail - Inbound1SZEDTYType RecordCharacterUDC10
97F47093EDI Request for Quote Detail (SDQ) - Inbound1SPEDTYType RecordCharacterUDC10
98F47096EDI Request for Quote Header - Outbound1SYEDTYType RecordCharacterUDC10
99F47097EDI Request for Quote Detail - Outbound1SZEDTYType RecordCharacterUDC10
100F47098EDI RFQ Detail Quantity - Outbound1SZEDTYType RecordCharacterUDC10
101F47101EDI Response to RFQ Header - Inbound1SYEDTYType RecordCharacterUDC10
102F47102EDI Response to RFQ Detail - Inbound1SZEDTYType RecordCharacterUDC10
103F47103EDI Response to RFQ Detail Quantity - Inbound1SZEDTYType RecordCharacterUDC10
104F47106EDI Response to RFQ Header - Outbound1SYEDTYType RecordCharacterUDC10
105F471061EDI Response to RFQ Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
106F47107EDI Response to RFQ Detail - Outbound1SZEDTYType RecordCharacterUDC10
107F471071EDI Response to RFQ Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
108F47111EDI Lockbox/Payment Header - Transaction1Z1EDTYType RecordCharacterUDC10
109F47112EDI Lockbox Header - Transaction1Z2EDTYType RecordCharacterUDC10
110F47113EDI Lockbox/Payment Detail - Batch1Z3EDTYType RecordCharacterUDC10
111F47114EDI Lockbox/Payment Detail - Payment1Z4EDTYType RecordCharacterUDC10
112F47121EDI Product Activity Data Header - Inbound1M1EDTYType RecordCharacterUDC10
113F47122EDI Product Activity Data Detail - Inbound1MJEDTYType RecordCharacterUDC10
114F47123EDI Product Activity Data (SDQ) - Inbound1MKEDTYType RecordCharacterUDC10
115F47126EDI Product Activity Data Header - Outbound1M1EDTYType RecordCharacterUDC10
116F47127EDI Product Activity Data Detail - Outbound1MJEDTYType RecordCharacterUDC10
117F47128EDI Product Activity Data (SDQ) - Outbound1MKEDTYType RecordCharacterUDC10
118F47131EDI Purchase Order Change Header - Inbound1SYEDTYType RecordCharacterUDC10
119F47131TXEDI Purchase Order Change Header Tax - Inbound1STEDTYType RecordCharacterUDC10
120F47132EDI Purchase Order Change Detail - Inbound1SZEDTYType RecordCharacterUDC10
121F47132TXEDI Purchase Order Change Detail Tax - Inbound1DTEDTYType RecordCharacterUDC10
122F47136EDI Purchase Order Change Header - Outbound1SYEDTYType RecordCharacterUDC10
123F47137EDI Purchase Order Change Detail - Outbound1SZEDTYType RecordCharacterUDC10
124F4714EDI Order Text Lines - Header1ZTEDTYType RecordCharacterUDC10
125F47141EDI P.O. Change Acknowledgment Header - Inbound1SYEDTYType RecordCharacterUDC10
126F47142EDI P.O. Change Acknowledgment Detail - Inbound1SZEDTYType RecordCharacterUDC10
127F47146EDI P.O. Change Acknowledgment Header - Outbound1SYEDTYType RecordCharacterUDC10
128F47147EDI P.O. Change Acknowledgment Detail - Outbound1SZEDTYType RecordCharacterUDC10
129F4715EDI Order Text Lines - Detail1ZDEDTYType RecordCharacterUDC10
130F47156EDI Shipping Schedule Header - Outbound1SYEDTYType RecordCharacterUDC10
131F47157EDI Shipping Schedule Detail - Outbound1SZEDTYType RecordCharacterUDC10
132F4716EDI Item Text - Inbound/Outbound1SZEDTYType RecordCharacterUDC10
133F47181EDI Consumption Header (FUTURE)21EHEDTYType RecordCharacterUDC10
134F47182EDI Consumption Detail (FUTURE)30EDEDTYType RecordCharacterUDC10
135F47191EDI Acknowledgement Header1AHEDTYType RecordCharacterUDC10
136F47192EDI Acknowledgement Error Detail1AEEDTYType RecordCharacterUDC10
137F47194EDI Acknowledgement References1AREDTYType RecordCharacterUDC10
138F47196EDI Acknowledgement Name And Address1AAEDTYType RecordCharacterUDC10
139F47198EDI Acknowledgement Notes1ANEDTYType RecordCharacterUDC10
140F47CTLEDI Lockbox/Payment Work File1Z5EDTYType RecordCharacterUDC10
TOP49: Transportation Management
141F47092TXEDI Request for Quote Detail Tax - Inbound1DTEDTYType RecordCharacterUDC10
TOP76A: Argentina
142F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A2VKEDTYType RecordCharacterUDC10
TOP76B: Brazil - Reporting System Only
143F76B472Dynamic Formater Layout Transaction & Line Types - 03B3DDEDTYType RecordCharacterUDC10
144F76B473Dynamic Formater Layouts Specification - 03B3DSEDTYType RecordCharacterUDC10
145F76B474Dynamic Formater Bank Attributes - 03B7BAEDTYType RecordCharacterUDC10
146F76B474IFile Upload For Bank Transaction Inbound Process - 03B5BIEDTYType RecordCharacterUDC10
TOP79A: Greenhouse Gas Accounting
147F79A11Z1GHG Ledger - Batch File2GLEDTYType RecordCharacterUDC10
TOP89: Conversion Programs
148F470375TEDI 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         1HeaderY
2         2DetailY
3         3Additional HeaderY
4         4Additional DetailY
5         5SDQY
6         6AddressY
7         7Header TextY
8         8Detail TextY
9         9PackagingY
10         AExpanded HeaderY
11         BExpanded DetailY
12         CDetail ChargesY
13         DPackaging TagY
14         NContact NamesY
15         PContact NumbersY
16         SSupplementalY