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

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F03B11Z1Batch Invoices3VJEDSQRecord SequenceNumericGeneric Edit20
TOP04: Accounts Payable
2F0411Z1Voucher Transactions - Batch Upload3VLEDSQRecord SequenceNumericGeneric Edit20
3F0411Z3F0411 Interoperability Table15SZEDSQRecord SequenceNumericGeneric Edit20
4F04572A/P Payment Processing - Summary54KKEDSQRecord SequenceNumericGeneric Edit20
TOP05: Time Accounting and HRM Base
5F05100Z1Resource Competencies Unedited Transactions File24CUEDSQRecord SequenceNumericGeneric Edit20
TOP05T: Time Entry
6F06116Z1Employee Transactions - Batch File3VLEDSQRecord SequenceNumericGeneric Edit20
7F06116Z2ESS Timecard History3VMEDSQRecord SequenceNumericGeneric Edit20
TOP09: General Accounting
8F0911Z1Journal Entry Transactions - Batch File3VNEDSQRecord SequenceNumericGeneric Edit20
9F0911Z4F0911 Interoperability Table15SZEDSQRecord SequenceNumericGeneric Edit20
TOP11: Multi Currency
10F0015Z1External Currency Exchange Rates15ZEEDSQRecord SequenceNumericGeneric Edit20
TOP16: Profit Management (EPS)
11F1602Z1External Cost Analyzer Balances - Interoperability Table15CZEDSQRecord SequenceNumericGeneric Edit20
12F1632Z1External Driver Balances-Interoperability Table15CYEDSQRecord SequenceNumericGeneric Edit20
TOP40: Inventory/OP Base
13F4001ZBatch Receiver File - Order Headings2SYEDSQRecord SequenceNumericGeneric Edit20
14F4011ZBatch Receiver File - Order Details2SZEDSQRecord SequenceNumericGeneric Edit20
TOP40R: Demand Scheduling
15F47171EDI Demand Header2EHEDSQRecord SequenceNumericGeneric Edit20
16F47172EDI Demand Detail2EDEDSQRecord SequenceNumericGeneric Edit20
17F471721EDI Demand Supplemental Data2EUEDSQRecord SequenceNumericGeneric Edit20
18F471722EDI Demand Addresses2EAEDSQRecord SequenceNumericGeneric Edit20
19F471723EDI Demand Contact Names2ECEDSQRecord SequenceNumericGeneric Edit20
20F471724EDI Demand Contact Numbers2ENEDSQRecord SequenceNumericGeneric Edit20
21F47173EDI Demand Scheduling Detail2ESEDSQRecord SequenceNumericGeneric Edit20
22F471731EDI Demand Packaging2EPEDSQRecord SequenceNumericGeneric Edit20
TOP42: Sales Management
23F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound16UZEDSQRecord SequenceNumericGeneric Edit20
24F470371TTag for F470371- EDI shipping Notice Detail - Outbound27UZEDSQRecord SequenceNumericGeneric Edit20
25F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound16UZEDSQRecord SequenceNumericGeneric Edit20
26F47107TTag for F47107- EDI Response to RFQ Detail - Outbound16UZEDSQRecord SequenceNumericGeneric Edit20
27F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound16UZEDSQRecord SequenceNumericGeneric Edit20
TOP42B: Sales Order Entry
28F4011ZTBatch Receiver File - Order Details Tag2UZEDSQRecord SequenceNumericGeneric Edit20
29F47012TEDI Purchase Order Detail Tag - Inbound2UZEDSQRecord SequenceNumericGeneric Edit20
30F47092TEDI Request for Quote Detail Tag - Inbound2UZEDSQRecord SequenceNumericGeneric Edit20
31F47132TEDI Purchase Order Change Detail Tag - Inbound2UZEDSQRecord SequenceNumericGeneric Edit20
TOP45: Advanced Pricing
32F4572Z1Live Promotions Interface - Inbound / Outbound9LPEDSQRecord SequenceNumericGeneric Edit20
33F4572ZPPurge Live Promotions Interface9PGEDSQRecord SequenceNumericGeneric Edit20
TOP47: Electronic Commerce
34F47006EDI Order Header - Outbound Tax Table2STEDSQRecord SequenceNumericGeneric Edit20
35F47007EDI Order Detail - Outbound Tax Table2DTEDSQRecord SequenceNumericGeneric Edit20
36F47011EDI Purchase Order Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
37F47011TXEDI Purchase Order Header Tax - Inbound2STEDSQRecord SequenceNumericGeneric Edit20
38F47012EDI Purchase Order Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
39F47012TXEDI Purchase Order Detail Tax - Inbound2DTEDSQRecord SequenceNumericGeneric Edit20
40F47013EDI Purchase Order Detail (SDQ) - Inbound2SPEDSQRecord SequenceNumericGeneric Edit20
41F47016EDI Purchase Order Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
42F470161EDI Purchase Order Additional Header - Outbound2S3EDSQRecord SequenceNumericGeneric Edit20
43F47017EDI Purchase Order Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
44F470171EDI Purchase Order Additional Detail - Outbound2S4EDSQRecord SequenceNumericGeneric Edit20
45F47021EDI P.O. Acknowledgment Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
46F47022EDI P.O. Acknowledgment Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
47F47026EDI P.O. Acknowledgment Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
48F47027EDI P.O. Acknowledgment Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
49F47031EDI Shipping Notice Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
50F47032EDI Shipping Notice Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
51F47036EDI Shipping Notice Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
52F47036XEDI Shipping Notice Header Tax - Outbound2STEDSQRecord SequenceNumericGeneric Edit20
53F47037EDI Shipping Notice Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
54F470371EDI Shipping Notice Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
55F470371XEDI Shipping Notice Detail Tax - Outbound2DTEDSQRecord SequenceNumericGeneric Edit20
56F470372EDI ASN Demand Scheduling Detail2AIEDSQRecord SequenceNumericGeneric Edit20
57F470373EDI ASN Shipping2AGEDSQRecord SequenceNumericGeneric Edit20
58F470374EDI ASN Demand Addresses17AMEDSQRecord SequenceNumericGeneric Edit20
59F470375EDI ASN Packaging Detail2AKEDSQRecord SequenceNumericGeneric Edit20
60F47041EDI Invoice Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
61F47042EDI Invoice Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
62F47044EDI Invoice Summary - Inbound2SWEDSQRecord SequenceNumericGeneric Edit20
63F47046EDI Invoice Header (Sales) - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
64F470461EDI Invoice Additional Header - Outbound2S3EDSQRecord SequenceNumericGeneric Edit20
65F470462EDI Invoice Expanded Header (Sales)2S5EDSQRecord SequenceNumericGeneric Edit20
66F47047EDI Invoice Detail (Sales) - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
67F470471EDI Invoice Additional Detail - Outbound2S4EDSQRecord SequenceNumericGeneric Edit20
68F470472EDI Invoice Expanded Detail (Sales)2S6EDSQRecord SequenceNumericGeneric Edit20
69F470473EDI Invoice Detail Charges2S7EDSQRecord SequenceNumericGeneric Edit20
70F47056EDI Payment Order Header - Outbound2D1EDSQRecord SequenceNumericGeneric Edit20
71F470561EDI Payment Order Bank N & A - Outbound2D2EDSQRecord SequenceNumericGeneric Edit20
72F470561WEDI Payment Order Bank N & A - Work2D2EDSQRecord SequenceNumericGeneric Edit20
73F470562EDI Payment Order Vendor N & A - Outbound2D4EDSQRecord SequenceNumericGeneric Edit20
74F470562WEDI Payment Order Vendor N & A - Work2D4EDSQRecord SequenceNumericGeneric Edit20
75F470563EDI Payment Order Payee N & A - Outbound2D5EDSQRecord SequenceNumericGeneric Edit20
76F470563WEDI Payment Order Payee N & A - Work2D5EDSQRecord SequenceNumericGeneric Edit20
77F47056WEDI Payment Order Header - Work2D1EDSQRecord SequenceNumericGeneric Edit20
78F47057EDI Payment Order Remittance Advice - Outbound2D3EDSQRecord SequenceNumericGeneric Edit20
79F47057WEDI Payment Order Remittance Advice - Work2D3EDSQRecord SequenceNumericGeneric Edit20
80F4706EDI Order Address Information2ZAEDSQRecord SequenceNumericGeneric Edit20
81F47061EDI Planning Schedule Header - Inbound2MJEDSQRecord SequenceNumericGeneric Edit20
82F47062EDI Planning Schedule Detail - Inbound2MYEDSQRecord SequenceNumericGeneric Edit20
83F47066EDI Planning Schedule Header - Outbound2MJEDSQRecord SequenceNumericGeneric Edit20
84F47067EDI Planning Schedule Detail - Outbound2MYEDSQRecord SequenceNumericGeneric Edit20
85F47071EDI Receiving Advice Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
86F47072EDI Receiving Advice Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
87F47076EDI Receiving Advice Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
88F47077EDI Receiving Advice Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
89F47081EDI Price Sales Catalog Header - Inbound2FVEDSQRecord SequenceNumericGeneric Edit20
90F47082EDI Price Sales Catalog Detail - Inbound2FYEDSQRecord SequenceNumericGeneric Edit20
91F47091EDI Request for Quote Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
92F47091TXEDI Request for Quote Header Tax - Inbound2STEDSQRecord SequenceNumericGeneric Edit20
93F47092EDI Request for Quote Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
94F47093EDI Request for Quote Detail (SDQ) - Inbound2SPEDSQRecord SequenceNumericGeneric Edit20
95F47096EDI Request for Quote Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
96F47097EDI Request for Quote Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
97F47098EDI RFQ Detail Quantity - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
98F47101EDI Response to RFQ Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
99F47102EDI Response to RFQ Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
100F47103EDI Response to RFQ Detail Quantity - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
101F47106EDI Response to RFQ Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
102F471061EDI Response to RFQ Additional Header - Outbound2S3EDSQRecord SequenceNumericGeneric Edit20
103F47107EDI Response to RFQ Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
104F471071EDI Response to RFQ Additional Detail - Outbound2S4EDSQRecord SequenceNumericGeneric Edit20
105F47111EDI Lockbox/Payment Header - Transaction2Z1EDSQRecord SequenceNumericGeneric Edit20
106F47112EDI Lockbox Header - Transaction2Z2EDSQRecord SequenceNumericGeneric Edit20
107F47113EDI Lockbox/Payment Detail - Batch2Z3EDSQRecord SequenceNumericGeneric Edit20
108F47114EDI Lockbox/Payment Detail - Payment2Z4EDSQRecord SequenceNumericGeneric Edit20
109F47121EDI Product Activity Data Header - Inbound2M1EDSQRecord SequenceNumericGeneric Edit20
110F47122EDI Product Activity Data Detail - Inbound2MJEDSQRecord SequenceNumericGeneric Edit20
111F47123EDI Product Activity Data (SDQ) - Inbound2MKEDSQRecord SequenceNumericGeneric Edit20
112F47126EDI Product Activity Data Header - Outbound2M1EDSQRecord SequenceNumericGeneric Edit20
113F47127EDI Product Activity Data Detail - Outbound2MJEDSQRecord SequenceNumericGeneric Edit20
114F47128EDI Product Activity Data (SDQ) - Outbound2MKEDSQRecord SequenceNumericGeneric Edit20
115F47131EDI Purchase Order Change Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
116F47131TXEDI Purchase Order Change Header Tax - Inbound2STEDSQRecord SequenceNumericGeneric Edit20
117F47132EDI Purchase Order Change Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
118F47132TXEDI Purchase Order Change Detail Tax - Inbound2DTEDSQRecord SequenceNumericGeneric Edit20
119F47136EDI Purchase Order Change Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
120F47137EDI Purchase Order Change Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
121F4714EDI Order Text Lines - Header2ZTEDSQRecord SequenceNumericGeneric Edit20
122F47141EDI P.O. Change Acknowledgment Header - Inbound2SYEDSQRecord SequenceNumericGeneric Edit20
123F47142EDI P.O. Change Acknowledgment Detail - Inbound2SZEDSQRecord SequenceNumericGeneric Edit20
124F47146EDI P.O. Change Acknowledgment Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
125F47147EDI P.O. Change Acknowledgment Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
126F4715EDI Order Text Lines - Detail2ZDEDSQRecord SequenceNumericGeneric Edit20
127F47156EDI Shipping Schedule Header - Outbound2SYEDSQRecord SequenceNumericGeneric Edit20
128F47157EDI Shipping Schedule Detail - Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
129F4716EDI Item Text - Inbound/Outbound2SZEDSQRecord SequenceNumericGeneric Edit20
130F47181EDI Consumption Header (FUTURE)22EHEDSQRecord SequenceNumericGeneric Edit20
131F47182EDI Consumption Detail (FUTURE)31EDEDSQRecord SequenceNumericGeneric Edit20
132F47191EDI Acknowledgement Header2AHEDSQRecord SequenceNumericGeneric Edit20
133F47192EDI Acknowledgement Error Detail2AEEDSQRecord SequenceNumericGeneric Edit20
134F47194EDI Acknowledgement References2AREDSQRecord SequenceNumericGeneric Edit20
135F47196EDI Acknowledgement Name And Address2AAEDSQRecord SequenceNumericGeneric Edit20
136F47198EDI Acknowledgement Notes2ANEDSQRecord SequenceNumericGeneric Edit20
137F47CTLEDI Lockbox/Payment Work File2Z5EDSQRecord SequenceNumericGeneric Edit20
TOP49: Transportation Management
138F47092TXEDI Request for Quote Detail Tax - Inbound2DTEDSQRecord SequenceNumericGeneric Edit20
TOP76A: Argentina
139F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A3VKEDSQRecord SequenceNumericGeneric Edit20
TOP79A: Greenhouse Gas Accounting
140F79A11Z1GHG Ledger - Batch File3GLEDSQRecord SequenceNumericGeneric Edit20