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
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

180 columns | Print definition?812 | EDDT

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Z1Cost Center Unedited Transaction Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
2F0401Z1Supplier Master - Batch File8VOEDDTEDI - Transmission DateDateGeneric Edit60
TOP01: Address Book
3F0101Z2Address Book - Interoperability8SZEDDTEDI - Transmission DateDateGeneric Edit60
4F01111Z1Batch - Contact Information8CBEDDTEDI - Transmission DateDateGeneric Edit60
5F01112Z1Batch - Related Person8PBEDDTEDI - Transmission DateDateGeneric Edit60
6F0111Z1Batch Who's Who Information8BWEDDTEDI - Transmission DateDateGeneric Edit60
7F01151Z1Batch - Electronic Address8EBEDDTEDI - Transmission DateDateGeneric Edit60
8F0115Z1Phones - Interoperability9PIEDDTEDI - Transmission DateDateGeneric Edit60
9F01161Z1Batch - Alternative Address8LBEDDTEDI - Transmission DateDateGeneric Edit60
TOP03: Accounts Receivable
10F03012Z1Customer Master LOB-Batch File8VOEDDTEDI - Transmission DateDateGeneric Edit60
TOP03B: Enhanced Accounts Receivable
11F03B11Z1Invoice Transactions - Batch File9VJEDDTEDI - Transmission DateDateGeneric Edit60
12F03B11Z2F03B11 Interoperability Table8SYEDDTEDI - Transmission DateDateGeneric Edit60
13F03B13Z2F03B13 Interoperability Table8SYEDDTEDI - Transmission DateDateGeneric Edit60
14F03B14Z2F03B14 Interoperability Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
15F03B41Z1Inteoperability - Deductions Management8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP04: Accounts Payable
16F0411Z1Voucher Transactions - Batch File9VLEDDTEDI - Transmission DateDateGeneric Edit60
17F0411Z3F0411 Interoperability Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
18F0413Z1F0413 Interoperability Table8SYEDDTEDI - Transmission DateDateGeneric Edit60
19F0414Z1F0414 Interoperability Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP05: Time Accounting and HRM Base
20F05100Z1Resource Competencies Unedited Transactions File5CUEDDTEDI - Transmission DateDateGeneric Edit60
TOP05A: OW HR & PR Foundation
21F060116ZUnedited Quick Hire Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP05T: Time Entry
22F06116Z1Employee Transactions - Batch File9VLEDDTEDI - Transmission DateDateGeneric Edit60
TOP09: General Accounting
23F0911Z1Journal Entry Transactions - Batch File9VNEDDTEDI - Transmission DateDateGeneric Edit60
24F0911Z4F0911 Interoperability Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP10: Financial Reporting
25F1001Z1Unedited MSC Interoperability Header Table8IAEDDTEDI - Transmission DateDateGeneric Edit60
26F1002Z1Unedited MSC Interoperability Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP11: Multi Currency
27F0015Z1External Currency Exchange Rates8ZEEDDTEDI - Transmission DateDateGeneric Edit60
TOP12: Fixed Assets
28F1201Z1Unedited Asset Master Transactions8FAEDDTEDI - Transmission DateDateGeneric Edit60
29F1217Z1Unedited Equipment Tag Transactions8WREDDTEDI - Transmission DateDateGeneric Edit60
30F1217Z2Unedited Equipment Tag Transactions8WREDDTEDI - Transmission DateDateGeneric Edit60
TOP13: Plant/Equipment Management
31F12120Z1Unedited Meter Reading Transactions8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP13C: Condition-Base Maintenance
32F1310Z1Unedited Condition-Based Alerts8CBEDDTEDI - Transmission DateDateGeneric Edit60
TOP16: Profit Management (EPS)
33F1602Z1External Cost Analyzer Balances - Interoperability Table8CZEDDTEDI - Transmission DateDateGeneric Edit60
34F1632Z1External Driver Balances-Interoperability Table8CYEDDTEDI - Transmission DateDateGeneric Edit60
TOP17: Customer Service Management
35F3111Z2Warranty Claim/Supplier Recovery processing8WPEDDTEDI - Transmission DateDateGeneric Edit60
36F3112Z2Warranty Claim/Supplier Recovery processing8WLEDDTEDI - Transmission DateDateGeneric Edit60
37F4801TZ2Warranty Claim/Supplier Recovery processing8WQEDDTEDI - Transmission DateDateGeneric Edit60
38F4801Z2Warranty Claim/Supplier Recovery processing8WSEDDTEDI - Transmission DateDateGeneric Edit60
TOP30: Product Data Management
39F0007Z1Work Day Calendar Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
40F30006Z1Work Center Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
41F3002Z1Bill of Material Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
42F3003Z1Routing Transactions File8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP31: Shop Floor Control
43F30161Z1Inbound Kanban Card Detail8SZEDDTEDI - Transmission DateDateGeneric Edit60
44F3111Z1Outbound Work Order Parts List8SZEDDTEDI - Transmission DateDateGeneric Edit60
45F31122Z1Work Order Time Transactions Unedited Transaction Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
46F3112Z1Outbound Work Order Routings8SZEDDTEDI - Transmission DateDateGeneric Edit60
47F4801Z1Outbound Work Order Header8SYEDDTEDI - Transmission DateDateGeneric Edit60
TOP31B: Blend Management
48F31B17Z1Operation EUR Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
49F31B18Z1VBT Barrel Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
50F31B19Z1Instructed Attributes Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
51F31B31Z1Operations Composition Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
52F31B34Z1Operations Style Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
53F31B3CZ1Operations Cost Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
54F31B52Z1Operations Equipment Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
55F31B53Z1Operations Consumables Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
56F31B65Z1Operations Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
57F31B93Z1WIM Work Order Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
58F31B97Z1Operations Resource Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
59F31BQAZ1Operations Quality Test Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP34: Requirements Planning
60F3435Vendor Schedule Commitment File17MCEDDTEDI - Transmission DateDateGeneric Edit60
61F3450Adhoc Vendor Schedule File9MAEDDTEDI - Transmission DateDateGeneric Edit60
TOP36: Forecasting
62F3460Z1Forecast Unedited Transactions8FTEDDTEDI - Transmission DateDateGeneric Edit60
TOP37: Quality Management
63F3711Z1Test Results Unedited Transaction Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP40: Inventory/OP Base
64F4001ZBatch Receiver File - Order Headings9SYEDDTEDI - Transmission DateDateGeneric Edit60
65F4011ZBatch Receiver File - Order Details9SZEDDTEDI - Transmission DateDateGeneric Edit60
66F4106NCBase Price Extraction8SZEDDTEDI - Transmission DateDateGeneric Edit60
67F4201Z1Sales Order Header Unedited Transaction File8SYEDDTEDI - Transmission DateDateGeneric Edit60
68F4211Z1Sales Order Detail Unedited Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
69F49211Z1Sales Order Detail Tag Unedited Transaction File8S1EDDTEDI - Transmission DateDateGeneric Edit60
TOP40R: Demand Scheduling
70F47171EDI Demand Header9EHEDDTEDI - Transmission DateDateGeneric Edit60
71F47172EDI Demand Detail9EDEDDTEDI - Transmission DateDateGeneric Edit60
72F471721EDI Demand Supplemental Data9EUEDDTEDI - Transmission DateDateGeneric Edit60
73F471722EDI Demand Addresses9EAEDDTEDI - Transmission DateDateGeneric Edit60
74F471723EDI Demand Contact Names9ECEDDTEDI - Transmission DateDateGeneric Edit60
75F471724EDI Demand Contact Numbers9ENEDDTEDI - Transmission DateDateGeneric Edit60
76F47173EDI Demand Scheduling Detail9ESEDDTEDI - Transmission DateDateGeneric Edit60
77F471731EDI Demand Packaging9EPEDDTEDI - Transmission DateDateGeneric Edit60
78F47800EDI Transmission Values7FFEDDTEDI - Transmission DateDateGeneric Edit60
TOP41: Inventory Management
79F4101Z1F4101 Item Master Unedited Transaction Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
80F4101Z1AF4101 Detail Item Master Unedited Transaction8SZEDDTEDI - Transmission DateDateGeneric Edit60
81F41021Z1Item Location Unedited Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
82F4105Z1Unedited Transaction Table - Item Cost8SZEDDTEDI - Transmission DateDateGeneric Edit60
83F4141Z1F4141 Cycle Count Unedited Transaction Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP42: Sales Management
84F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound10UZEDDTEDI - Transmission DateDateGeneric Edit60
85F470371TTag for F470371- EDI shipping Notice Detail - Outbound21UZEDDTEDI - Transmission DateDateGeneric Edit60
86F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound10UZEDDTEDI - Transmission DateDateGeneric Edit60
87F47107TTag for F47107- EDI Response to RFQ Detail - Outbound10UZEDDTEDI - Transmission DateDateGeneric Edit60
88F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound10UZEDDTEDI - Transmission DateDateGeneric Edit60
TOP42B: Sales Order Entry
89F4011ZTBatch Receiver File - Order Details Tag9UZEDDTEDI - Transmission DateDateGeneric Edit60
90F4211CZ1Sales Order Detail Unedited Transaction File - CRM7CZEDDTEDI - Transmission DateDateGeneric Edit60
91F4211URZF4211Z1 CRM User Reserved Tag File7UREDDTEDI - Transmission DateDateGeneric Edit60
92F42150Z1Header Commission Unedited Transaction File7S2EDDTEDI - Transmission DateDateGeneric Edit60
93F42160Z1Detail Commission Unedited Transaction File7S3EDDTEDI - Transmission DateDateGeneric Edit60
94F47012TEDI Purchase Order Detail Tag - Inbound9UZEDDTEDI - Transmission DateDateGeneric Edit60
95F47092TEDI Request for Quote Detail Tag - Inbound9UZEDDTEDI - Transmission DateDateGeneric Edit60
96F47132TEDI Purchase Order Change Detail Tag - Inbound9UZEDDTEDI - Transmission DateDateGeneric Edit60
TOP43: Procurement
97F4301Z1Purchase Order Header Unedited Transaction Table8SYEDDTEDI - Transmission DateDateGeneric Edit60
98F43092Z1Receipt Routing Unedited Transaction Table7SZEDDTEDI - Transmission DateDateGeneric Edit60
99F4311Z1Purchase Order Detail Unedited Transaction Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
100F43121Z1Receipts Unedited Transaction Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP44H: Homebuilder Management
101F44H101ZHB Community Master Unedited Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
102F44H201ZHB Lot Master Unedited Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
103F44H501ZHB Sales Master Unedited Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
104F44H604ZHB Vendor Assignment Unedited Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
105F44H711ZHB Lot Start Unedited Transaction File8SZEDDTEDI - Transmission DateDateGeneric Edit60
TOP45: Advanced Pricing
106F4572Z1Live Promotions Interface - Inbound / Outbound13LPEDDTEDI - Transmission DateDateGeneric Edit60
107F4572ZPPurge Live Promotions Interface13PGEDDTEDI - Transmission DateDateGeneric Edit60
108F4576Z1Ship and Debit Claims Unedited Transaction Table8Z1EDDTEDI - Transmission DateDateGeneric Edit60
TOP46: Warehouse Management
109F4611Z1Unedited Suggestion Table8SZEDDTEDI - Transmission DateDateGeneric Edit60
110F4942Z1Work File for F49428SYEDDTEDI - Transmission DateDateGeneric Edit60
TOP47: Electronic Commerce
111F47011EDI Purchase Order Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
112F47012EDI Purchase Order Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
113F47016EDI Purchase Order Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
114F470161EDI Purchase Order Additional Header - Outbound75S3EDDTEDI - Transmission DateDateGeneric Edit60
115F47017EDI Purchase Order Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
116F470171EDI Purchase Order Additional Detail - Outbound56S4EDDTEDI - Transmission DateDateGeneric Edit60
117F47021EDI P.O. Acknowledgment Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
118F47022EDI P.O. Acknowledgment Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
119F47026EDI P.O. Acknowledgment Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
120F47027EDI P.O. Acknowledgment Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
121F47031EDI Shipping Notice Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
122F47032EDI Shipping Notice Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
123F47036EDI Shipping Notice Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
124F47037EDI Shipping Notice Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
125F470371EDI Shipping Notice Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
126F470372EDI ASN Demand Scheduling Detail9AIEDDTEDI - Transmission DateDateGeneric Edit60
127F470373EDI ASN Shipping8AGEDDTEDI - Transmission DateDateGeneric Edit60
128F470374EDI ASN Demand Addresses10AMEDDTEDI - Transmission DateDateGeneric Edit60
129F470375EDI ASN Packaging Detail9AKEDDTEDI - Transmission DateDateGeneric Edit60
130F47041EDI Invoice Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
131F47042EDI Invoice Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
132F47044EDI Invoice Summary - Inbound9SWEDDTEDI - Transmission DateDateGeneric Edit60
133F47046EDI Invoice Header (Sales) - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
134F47047EDI Invoice Detail (Sales) - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
135F47056EDI Payment Order Header - Outbound9D1EDDTEDI - Transmission DateDateGeneric Edit60
136F47056WEDI Payment Order Header - Work9D1EDDTEDI - Transmission DateDateGeneric Edit60
137F47057EDI Payment Order Remittance Advice - Outbound9D3EDDTEDI - Transmission DateDateGeneric Edit60
138F47057WEDI Payment Order Remittance Advice - Work9D3EDDTEDI - Transmission DateDateGeneric Edit60
139F47061EDI Planning Schedule Header - Inbound9MJEDDTEDI - Transmission DateDateGeneric Edit60
140F47062EDI Planning Schedule Detail - Inbound9MYEDDTEDI - Transmission DateDateGeneric Edit60
141F47066EDI Planning Schedule Header - Outbound9MJEDDTEDI - Transmission DateDateGeneric Edit60
142F47067EDI Planning Schedule Detail - Outbound9MYEDDTEDI - Transmission DateDateGeneric Edit60
143F47071EDI Receiving Advice Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
144F47072EDI Receiving Advice Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
145F47076EDI Receiving Advice Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
146F47077EDI Receiving Advice Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
147F47081EDI Price Sales Catalog Header - Inbound9FVEDDTEDI - Transmission DateDateGeneric Edit60
148F47082EDI Price Sales Catalog Detail - Inbound9FYEDDTEDI - Transmission DateDateGeneric Edit60
149F47091EDI Request for Quote Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
150F47092EDI Request for Quote Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
151F47096EDI Request for Quote Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
152F47097EDI Request for Quote Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
153F47101EDI Response to RFQ Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
154F47102EDI Response to RFQ Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
155F47106EDI Response to RFQ Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
156F47107EDI Response to RFQ Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
157F47111EDI Lockbox/Payment Header - Transaction9Z1EDDTEDI - Transmission DateDateGeneric Edit60
158F47112EDI Lockbox Header - Transaction9Z2EDDTEDI - Transmission DateDateGeneric Edit60
159F47121EDI Product Activity Data Header - Inbound9M1EDDTEDI - Transmission DateDateGeneric Edit60
160F47122EDI Product Activity Data Detail - Inbound9MJEDDTEDI - Transmission DateDateGeneric Edit60
161F47126EDI Product Activity Data Header - Outbound9M1EDDTEDI - Transmission DateDateGeneric Edit60
162F47127EDI Product Activity Data Detail - Outbound9MJEDDTEDI - Transmission DateDateGeneric Edit60
163F47131EDI Purchase Order Change Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
164F47132EDI Purchase Order Change Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
165F47136EDI Purchase Order Change Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
166F47137EDI Purchase Order Change Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
167F47141EDI P.O. Change Acknowledgment Header - Inbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
168F47142EDI P.O. Change Acknowledgment Detail - Inbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
169F47146EDI P.O. Change Acknowledgment Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
170F47147EDI P.O. Change Acknowledgment Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
171F47156EDI Shipping Schedule Header - Outbound9SYEDDTEDI - Transmission DateDateGeneric Edit60
172F47157EDI Shipping Schedule Detail - Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
173F4716EDI Item Text - Inbound/Outbound9SZEDDTEDI - Transmission DateDateGeneric Edit60
174F47191EDI Acknowledgement Header9AHEDDTEDI - Transmission DateDateGeneric Edit60
175F47192EDI Acknowledgement Error Detail9AEEDDTEDI - Transmission DateDateGeneric Edit60
176F47194EDI Acknowledgement References9AREDDTEDI - Transmission DateDateGeneric Edit60
177F47196EDI Acknowledgement Name And Address9AAEDDTEDI - Transmission DateDateGeneric Edit60
178F47198EDI Acknowledgement Notes9ANEDDTEDI - Transmission DateDateGeneric Edit60
179F47CTLEDI Lockbox/Payment Work File13Z5EDDTEDI - Transmission DateDateGeneric Edit60
TOP76A: Argentina
180F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B9VKEDDTEDI - Transmission DateDateGeneric Edit60