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

125 columns | Print definition?812 | EKCO

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