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

126 columns | Print definition?812 | EDSQ

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