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

140 columns | Print definition?910 | EKCO

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP04: Accounts Payable
1F04572A/P Payment Processing - Summary55KKEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
TOP40: Inventory/OP Base
2F4001ZBatch Receiver File - Order Headings3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
3F4001ZTXRecurring Order Header Tax Table1RTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
4F4006ZBatch Order Receiver - Order Address Information3OYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
5F4011ZBatch Receiver File - Order Details3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
6F4011ZTXRecurring Order Detail Tax Table1ZTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
7F4012ZBatch Receiver File - Destination Quantity1SPEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
8F4012ZWWF - Destination Quantity1SPEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
9F4013ZKit Components Batch File3KSEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
TOP40R: Demand Scheduling
10F47171EDI Demand Header3EHEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
11F47172EDI Demand Detail3EDEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
12F471721EDI Demand Supplemental Data3EUEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
13F471722EDI Demand Addresses3EAEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
14F471723EDI Demand Contact Names3ECEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
15F471724EDI Demand Contact Numbers3ENEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
16F47173EDI Demand Scheduling Detail3ESEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
17F471731EDI Demand Packaging3EPEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
18F47800EDI Transmission Values2FFEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
TOP42: Sales Management
19F42565Invoice Print File74IWEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
20F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound19UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
21F470371TTag for F470371- EDI shipping Notice Detail - Outbound30UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
22F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound19UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
23F47107TTag for F47107- EDI Response to RFQ Detail - Outbound19UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
24F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound19UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
TOP42B: Sales Order Entry
25F4011ZTBatch Receiver File - Order Details Tag5UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
26F47012TEDI Purchase Order Detail Tag - Inbound5UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
27F47092TEDI Request for Quote Detail Tag - Inbound5UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
28F47132TEDI Purchase Order Change Detail Tag - Inbound5UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
TOP47: Electronic Commerce
29F47003EDI Discrepancy Report Work File6SXEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
30F47006EDI Order Header - Outbound Tax Table3STEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
31F47007EDI Order Detail - Outbound Tax Table3DTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
32F47011EDI Purchase Order Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
33F47011TXEDI Purchase Order Header Tax - Inbound3STEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
34F47012EDI Purchase Order Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
35F47012TXEDI Purchase Order Detail Tax - Inbound3DTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
36F47013EDI Purchase Order Detail (SDQ) - Inbound3SPEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
37F47016EDI Purchase Order Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
38F470161EDI Purchase Order Additional Header - Outbound3S3EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
39F47017EDI Purchase Order Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
40F470171EDI Purchase Order Additional Detail - Outbound3S4EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
41F47021EDI P.O. Acknowledgment Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
42F47022EDI P.O. Acknowledgment Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
43F47026EDI P.O. Acknowledgment Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
44F47027EDI P.O. Acknowledgment Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
45F47031EDI Shipping Notice Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
46F47032EDI Shipping Notice Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
47F47032TEDI Shipping Notice Detail- Inbound Tag30SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
48F47036EDI Shipping Notice Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
49F47036XEDI Shipping Notice Header Tax - Outbound3STEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
50F47037EDI Shipping Notice Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
51F470371EDI Shipping Notice Detail - Outbound4SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
52F470371XEDI Shipping Notice Detail Tax - Outbound4DTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
53F470372EDI ASN Demand Scheduling Detail3AIEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
54F470373EDI ASN Shipping3AGEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
55F470374EDI ASN Demand Addresses3AMEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
56F470375EDI ASN Packaging Detail3AKEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
57F47041EDI Invoice Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
58F47042EDI Invoice Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
59F47044EDI Invoice Summary - Inbound3SWEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
60F47046EDI Invoice Header (Sales) - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
61F470461EDI Invoice Additional Header - Outbound3S3EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
62F470462EDI Invoice Expanded Header (Sales)3S5EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
63F47047EDI Invoice Detail (Sales) - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
64F470471EDI Invoice Additional Detail - Outbound3S4EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
65F470472EDI Invoice Expanded Detail (Sales)3S6EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
66F470473EDI Invoice Detail Charges3S7EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
67F47056EDI Payment Order Header - Outbound3D1EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
68F470561EDI Payment Order Bank N & A - Outbound3D2EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
69F470561WEDI Payment Order Bank N & A - Work3D2EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
70F470562EDI Payment Order Vendor N & A - Outbound3D4EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
71F470562WEDI Payment Order Vendor N & A - Work3D4EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
72F470563EDI Payment Order Payee N & A - Outbound3D5EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
73F470563WEDI Payment Order Payee N & A - Work3D5EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
74F47056WEDI Payment Order Header - Work3D1EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
75F47057EDI Payment Order Remittance Advice - Outbound3D3EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
76F47057WEDI Payment Order Remittance Advice - Work3D3EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
77F4706EDI Order Address Information3ZAEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
78F47061EDI Planning Schedule Header - Inbound3MJEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
79F47062EDI Planning Schedule Detail - Inbound3MYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
80F47066EDI Planning Schedule Header - Outbound3MJEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
81F47067EDI Planning Schedule Detail - Outbound3MYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
82F47071EDI Receiving Advice Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
83F47072EDI Receiving Advice Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
84F47076EDI Receiving Advice Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
85F47077EDI Receiving Advice Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
86F47081EDI Price Sales Catalog Header - Inbound3FVEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
87F47082EDI Price Sales Catalog Detail - Inbound3FYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
88F47091EDI Request for Quote Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
89F47091TXEDI Request for Quote Header Tax - Inbound3STEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
90F47092EDI Request for Quote Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
91F47093EDI Request for Quote Detail (SDQ) - Inbound3SPEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
92F47096EDI Request for Quote Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
93F47097EDI Request for Quote Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
94F47098EDI RFQ Detail Quantity - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
95F47101EDI Response to RFQ Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
96F47102EDI Response to RFQ Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
97F47103EDI Response to RFQ Detail Quantity - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
98F47106EDI Response to RFQ Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
99F471061EDI Response to RFQ Additional Header - Outbound3S3EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
100F47107EDI Response to RFQ Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
101F471071EDI Response to RFQ Additional Detail - Outbound3S4EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
102F47111EDI Lockbox/Payment Header - Transaction3Z1EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
103F47112EDI Lockbox Header - Transaction3Z2EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
104F47113EDI Lockbox/Payment Detail - Batch3Z3EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
105F47114EDI Lockbox/Payment Detail - Payment3Z4EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
106F47121EDI Product Activity Data Header - Inbound3M1EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
107F47122EDI Product Activity Data Detail - Inbound3MJEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
108F47123EDI Product Activity Data (SDQ) - Inbound3MKEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
109F47126EDI Product Activity Data Header - Outbound3M1EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
110F47127EDI Product Activity Data Detail - Outbound3MJEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
111F47128EDI Product Activity Data (SDQ) - Outbound3MKEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
112F47131EDI Purchase Order Change Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
113F47131TXEDI Purchase Order Change Header Tax - Inbound3STEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
114F47132EDI Purchase Order Change Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
115F47132TXEDI Purchase Order Change Detail Tax - Inbound3DTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
116F47136EDI Purchase Order Change Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
117F47137EDI Purchase Order Change Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
118F4714EDI Order Text Lines - Header3ZTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
119F47141EDI P.O. Change Acknowledgment Header - Inbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
120F471411Purchase Order Edit Object Log Table1SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
121F47142EDI P.O. Change Acknowledgment Detail - Inbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
122F47146EDI P.O. Change Acknowledgment Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
123F47147EDI P.O. Change Acknowledgment Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
124F4715EDI Order Text Lines - Detail3ZDEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
125F47156EDI Shipping Schedule Header - Outbound3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
126F47157EDI Shipping Schedule Detail - Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
127F4716EDI Item Text - Inbound/Outbound3SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
128F47181EDI Consumption Header (FUTURE)3EHEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
129F47182EDI Consumption Detail (FUTURE)3EDEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
130F47191EDI Acknowledgement Header3AHEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
131F47192EDI Acknowledgement Error Detail3AEEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
132F47194EDI Acknowledgement References3AREKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
133F47196EDI Acknowledgement Name And Address3AAEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
134F47198EDI Acknowledgement Notes3ANEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
135F47CTLEDI Lockbox/Payment Work File3Z5EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
TOP49: Transportation Management
136F47092TXEDI Request for Quote Detail Tax - Inbound3DTEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
137F47500WFInbound Transaction Processor Workfile1SZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
138F49T60Voucher Cross Reference3IVEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
TOP89: Conversion Programs
139F3294ZNeeded for upgrade from Xe and below3AZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50
140F470375TEDI ASN Packaging Detail Tag Table3AKEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50