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

135 columns | Print definition?812 | EDTY | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F03B11Z1Invoice Transactions - Batch File2VJEDTYType RecordCharacterUDC10
TOP04: Accounts Payable
2F0411Z1Voucher Transactions - Batch File2VLEDTYType RecordCharacterUDC10
3F0411Z3F0411 Interoperability Table14SZEDTYType RecordCharacterUDC10
4F04572A/P Payment Processing - Summary File53KKEDTYType RecordCharacterUDC10
TOP05: Time Accounting and HRM Base
5F05100Z1Resource Competencies Unedited Transactions File28CUEDTYType RecordCharacterUDC10
TOP05T: Time Entry
6F06116Z1Employee Transactions - Batch File2VLEDTYType RecordCharacterUDC10
TOP09: General Accounting
7F0911Z1Journal Entry Transactions - Batch File2VNEDTYType RecordCharacterUDC10
8F0911Z4F0911 Interoperability Table14SZEDTYType RecordCharacterUDC10
TOP11: Multi Currency
9F0015Z1External Currency Exchange Rates14ZEEDTYType RecordCharacterUDC10
TOP16: Profit Management (EPS)
10F1602Z1External Cost Analyzer Balances - Interoperability Table14CZEDTYType RecordCharacterUDC10
11F1632Z1External Driver Balances-Interoperability Table14CYEDTYType RecordCharacterUDC10
TOP40: Inventory/OP Base
12F4001ZBatch Receiver File - Order Headings1SYEDTYType RecordCharacterUDC10
13F4011ZBatch Receiver File - Order Details1SZEDTYType RecordCharacterUDC10
TOP40R: Demand Scheduling
14F47171EDI Demand Header1EHEDTYType RecordCharacterUDC10
15F47172EDI Demand Detail1EDEDTYType RecordCharacterUDC10
16F471721EDI Demand Supplemental Data1EUEDTYType RecordCharacterUDC10
17F471722EDI Demand Addresses1EAEDTYType RecordCharacterUDC10
18F471723EDI Demand Contact Names1ECEDTYType RecordCharacterUDC10
19F471724EDI Demand Contact Numbers1ENEDTYType RecordCharacterUDC10
20F47173EDI Demand Scheduling Detail1ESEDTYType RecordCharacterUDC10
21F471731EDI Demand Packaging1EPEDTYType RecordCharacterUDC10
22F47800EDI Transmission Values1FFEDTYType RecordCharacterUDC10
TOP42: Sales Management
23F42UI130Commitment Work File11ZCEDTYType RecordCharacterUDC10
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
37F47011EDI Purchase Order Header - Inbound1SYEDTYType RecordCharacterUDC10
38F47012EDI Purchase Order Detail - Inbound1SZEDTYType RecordCharacterUDC10
39F47013EDI Purchase Order Detail (SDQ) - Inbound1SPEDTYType RecordCharacterUDC10
40F47016EDI Purchase Order Header - Outbound1SYEDTYType RecordCharacterUDC10
41F470161EDI Purchase Order Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
42F47017EDI Purchase Order Detail - Outbound1SZEDTYType RecordCharacterUDC10
43F470171EDI Purchase Order Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
44F47021EDI P.O. Acknowledgment Header - Inbound1SYEDTYType RecordCharacterUDC10
45F47022EDI P.O. Acknowledgment Detail - Inbound1SZEDTYType RecordCharacterUDC10
46F47026EDI P.O. Acknowledgment Header - Outbound1SYEDTYType RecordCharacterUDC10
47F47027EDI P.O. Acknowledgment Detail - Outbound1SZEDTYType RecordCharacterUDC10
48F47031EDI Shipping Notice Header - Inbound1SYEDTYType RecordCharacterUDC10
49F47032EDI Shipping Notice Detail - Inbound1SZEDTYType RecordCharacterUDC10
50F47036EDI Shipping Notice Header - Outbound1SYEDTYType RecordCharacterUDC10
51F47037EDI Shipping Notice Detail - Outbound1SZEDTYType RecordCharacterUDC10
52F470371EDI Shipping Notice Detail - Outbound1SZEDTYType RecordCharacterUDC10
53F470372EDI ASN Demand Scheduling Detail1AIEDTYType RecordCharacterUDC10
54F470373EDI ASN Shipping1AGEDTYType RecordCharacterUDC10
55F470374EDI ASN Demand Addresses16AMEDTYType RecordCharacterUDC10
56F470375EDI ASN Packaging Detail1AKEDTYType RecordCharacterUDC10
57F47041EDI Invoice Header - Inbound1SYEDTYType RecordCharacterUDC10
58F47042EDI Invoice Detail - Inbound1SZEDTYType RecordCharacterUDC10
59F47044EDI Invoice Summary - Inbound1SWEDTYType RecordCharacterUDC10
60F47046EDI Invoice Header (Sales) - Outbound1SYEDTYType RecordCharacterUDC10
61F470461EDI Invoice Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
62F470462EDI Invoice Expanded Header (Sales)1S5EDTYType RecordCharacterUDC10
63F47047EDI Invoice Detail (Sales) - Outbound1SZEDTYType RecordCharacterUDC10
64F470471EDI Invoice Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
65F470472EDI Invoice Expanded Detail (Sales)1S6EDTYType RecordCharacterUDC10
66F470473EDI Invoice Detail Charges1S7EDTYType RecordCharacterUDC10
67F47056EDI Payment Order Header - Outbound1D1EDTYType RecordCharacterUDC10
68F470561EDI Payment Order Bank N and A - Outbound1D2EDTYType RecordCharacterUDC10
69F470561WEDI Payment Order Bank N and A - Work1D2EDTYType RecordCharacterUDC10
70F470562EDI Payment Order Vendor N and A - Outbound1D4EDTYType RecordCharacterUDC10
71F470562WEDI Payment Order Vendor N and A - Work1D4EDTYType RecordCharacterUDC10
72F470563EDI Payment Order Payee N and A - Outbound1D5EDTYType RecordCharacterUDC10
73F470563WEDI Payment Order Payee N and A - Work1D5EDTYType RecordCharacterUDC10
74F47056WEDI Payment Order Header - Work1D1EDTYType RecordCharacterUDC10
75F47057EDI Payment Order Remittance Advice - Outbound1D3EDTYType RecordCharacterUDC10
76F47057WEDI Payment Order Remittance Advice - Work1D3EDTYType RecordCharacterUDC10
77F4706EDI Order Address Information1ZAEDTYType RecordCharacterUDC10
78F47061EDI Planning Schedule Header - Inbound1MJEDTYType RecordCharacterUDC10
79F47062EDI Planning Schedule Detail - Inbound1MYEDTYType RecordCharacterUDC10
80F47066EDI Planning Schedule Header - Outbound1MJEDTYType RecordCharacterUDC10
81F47067EDI Planning Schedule Detail - Outbound1MYEDTYType RecordCharacterUDC10
82F47071EDI Receiving Advice Header - Inbound1SYEDTYType RecordCharacterUDC10
83F47072EDI Receiving Advice Detail - Inbound1SZEDTYType RecordCharacterUDC10
84F47076EDI Receiving Advice Header - Outbound1SYEDTYType RecordCharacterUDC10
85F47077EDI Receiving Advice Detail - Outbound1SZEDTYType RecordCharacterUDC10
86F47081EDI Price Sales Catalog Header - Inbound1FVEDTYType RecordCharacterUDC10
87F47082EDI Price Sales Catalog Detail - Inbound1FYEDTYType RecordCharacterUDC10
88F47091EDI Request for Quote Header - Inbound1SYEDTYType RecordCharacterUDC10
89F47092EDI Request for Quote Detail - Inbound1SZEDTYType RecordCharacterUDC10
90F47093EDI Request for Quote Detail (SDQ) - Inbound1SPEDTYType RecordCharacterUDC10
91F47096EDI Request for Quote Header - Outbound1SYEDTYType RecordCharacterUDC10
92F47097EDI Request for Quote Detail - Outbound1SZEDTYType RecordCharacterUDC10
93F47098EDI RFQ Detail Quantity - Outbound1SZEDTYType RecordCharacterUDC10
94F47101EDI Response to RFQ Header - Inbound1SYEDTYType RecordCharacterUDC10
95F47102EDI Response to RFQ Detail - Inbound1SZEDTYType RecordCharacterUDC10
96F47103EDI Response to RFQ Detail Quantity - Inbound1SZEDTYType RecordCharacterUDC10
97F47106EDI Response to RFQ Header - Outbound1SYEDTYType RecordCharacterUDC10
98F471061EDI Response to RFQ Additional Header - Outbound1S3EDTYType RecordCharacterUDC10
99F47107EDI Response to RFQ Detail - Outbound1SZEDTYType RecordCharacterUDC10
100F471071EDI Response to RFQ Additional Detail - Outbound1S4EDTYType RecordCharacterUDC10
101F47111EDI Lockbox/Payment Header - Transaction1Z1EDTYType RecordCharacterUDC10
102F47112EDI Lockbox Header - Transaction1Z2EDTYType RecordCharacterUDC10
103F47113EDI Lockbox/Payment Detail - Batch1Z3EDTYType RecordCharacterUDC10
104F47114EDI Lockbox/Payment Detail - Payment1Z4EDTYType RecordCharacterUDC10
105F47121EDI Product Activity Data Header - Inbound1M1EDTYType RecordCharacterUDC10
106F47122EDI Product Activity Data Detail - Inbound1MJEDTYType RecordCharacterUDC10
107F47123EDI Product Activity Data (SDQ) - Inbound1MKEDTYType RecordCharacterUDC10
108F47126EDI Product Activity Data Header - Outbound1M1EDTYType RecordCharacterUDC10
109F47127EDI Product Activity Data Detail - Outbound1MJEDTYType RecordCharacterUDC10
110F47128EDI Product Activity Data (SDQ) - Outbound1MKEDTYType RecordCharacterUDC10
111F47131EDI Purchase Order Change Header - Inbound1SYEDTYType RecordCharacterUDC10
112F47132EDI Purchase Order Change Detail - Inbound1SZEDTYType RecordCharacterUDC10
113F47136EDI Purchase Order Change Header - Outbound1SYEDTYType RecordCharacterUDC10
114F47137EDI Purchase Order Change Detail - Outbound1SZEDTYType RecordCharacterUDC10
115F4714EDI Order Text Lines - Header1ZTEDTYType RecordCharacterUDC10
116F47141EDI P.O. Change Acknowledgment Header - Inbound1SYEDTYType RecordCharacterUDC10
117F47142EDI P.O. Change Acknowledgment Detail - Inbound1SZEDTYType RecordCharacterUDC10
118F47146EDI P.O. Change Acknowledgment Header - Outbound1SYEDTYType RecordCharacterUDC10
119F47147EDI P.O. Change Acknowledgment Detail - Outbound1SZEDTYType RecordCharacterUDC10
120F4715EDI Order Text Lines - Detail1ZDEDTYType RecordCharacterUDC10
121F47156EDI Shipping Schedule Header - Outbound1SYEDTYType RecordCharacterUDC10
122F47157EDI Shipping Schedule Detail - Outbound1SZEDTYType RecordCharacterUDC10
123F4716EDI Item Text - Inbound/Outbound1SZEDTYType RecordCharacterUDC10
124F47191EDI Acknowledgement Header1AHEDTYType RecordCharacterUDC10
125F47192EDI Acknowledgement Error Detail1AEEDTYType RecordCharacterUDC10
126F47194EDI Acknowledgement References1AREDTYType RecordCharacterUDC10
127F47196EDI Acknowledgement Name And Address1AAEDTYType RecordCharacterUDC10
128F47198EDI Acknowledgement Notes1ANEDTYType RecordCharacterUDC10
129F47CTLEDI Lockbox/Payment Work File1Z5EDTYType RecordCharacterUDC10
TOP76A: Argentina
130F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B2VKEDTYType RecordCharacterUDC10
TOP76B: Brazil - Reporting System Only
131F76B472Dynamic Formater Layout Transaction and Line Types - 03B3DDEDTYType RecordCharacterUDC10
132F76B473Dynamic Formater Layouts Specification - 03B3DSEDTYType RecordCharacterUDC10
133F76B474Dynamic Formater Bank Attributes - 03B7BAEDTYType RecordCharacterUDC10
134F76B474IFile Upload For Bank Transaction Inbound Process - 03B5BIEDTYType RecordCharacterUDC10
TOP89: Conversion Programs
135F470375TEDI 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