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

178 columns | Print definition?812 | EDFT

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Z1Cost Center Unedited Transaction Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
2F0401Z1Supplier Master - Batch File7VOEDFTEDI - Translation FormatStringGeneric Edit100
TOP01: Address Book
3F0101Z2Address Book - Interoperability7SZEDFTEDI - Translation FormatStringGeneric Edit100
4F01111Z1Batch - Contact Information7CBEDFTEDI - Translation FormatStringGeneric Edit100
5F01112Z1Batch - Related Person7PBEDFTEDI - Translation FormatStringGeneric Edit100
6F0111Z1Batch Who's Who Information7BWEDFTEDI - Translation FormatStringGeneric Edit100
7F01151Z1Batch - Electronic Address7EBEDFTEDI - Translation FormatStringGeneric Edit100
8F0115Z1Phones - Interoperability8PIEDFTEDI - Translation FormatStringGeneric Edit100
9F01161Z1Batch - Alternative Address7LBEDFTEDI - Translation FormatStringGeneric Edit100
TOP03: Accounts Receivable
10F03012Z1Customer Master LOB-Batch File7VOEDFTEDI - Translation FormatStringGeneric Edit100
TOP03B: Enhanced Accounts Receivable
11F03B11Z1Invoice Transactions - Batch File8VJEDFTEDI - Translation FormatStringGeneric Edit100
12F03B11Z2F03B11 Interoperability Table7SYEDFTEDI - Translation FormatStringGeneric Edit100
13F03B13Z2F03B13 Interoperability Table7SYEDFTEDI - Translation FormatStringGeneric Edit100
14F03B14Z2F03B14 Interoperability Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
15F03B41Z1Inteoperability - Deductions Management7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP04: Accounts Payable
16F0411Z1Voucher Transactions - Batch File8VLEDFTEDI - Translation FormatStringGeneric Edit100
17F0411Z3F0411 Interoperability Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
18F0413Z1F0413 Interoperability Table7SYEDFTEDI - Translation FormatStringGeneric Edit100
19F0414Z1F0414 Interoperability Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP05: Time Accounting and HRM Base
20F05100Z1Resource Competencies Unedited Transactions File23CUEDFTEDI - Translation FormatStringGeneric Edit100
TOP05A: OW HR & PR Foundation
21F060116ZUnedited Quick Hire Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP05T: Time Entry
22F06116Z1Employee Transactions - Batch File8VLEDFTEDI - Translation FormatStringGeneric Edit100
TOP09: General Accounting
23F0911Z1Journal Entry Transactions - Batch File8VNEDFTEDI - Translation FormatStringGeneric Edit100
24F0911Z4F0911 Interoperability Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP10: Financial Reporting
25F1001Z1Unedited MSC Interoperability Header Table7IAEDFTEDI - Translation FormatStringGeneric Edit100
26F1002Z1Unedited MSC Interoperability Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP11: Multi Currency
27F0015Z1External Currency Exchange Rates7ZEEDFTEDI - Translation FormatStringGeneric Edit100
TOP12: Fixed Assets
28F1201Z1Unedited Asset Master Transactions7FAEDFTEDI - Translation FormatStringGeneric Edit100
29F1217Z1Unedited Equipment Tag Transactions7WREDFTEDI - Translation FormatStringGeneric Edit100
30F1217Z2Unedited Equipment Tag Transactions7WREDFTEDI - Translation FormatStringGeneric Edit100
TOP13: Plant/Equipment Management
31F12120Z1Unedited Meter Reading Transactions7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP13C: Condition-Base Maintenance
32F1310Z1Unedited Condition-Based Alerts7CBEDFTEDI - Translation FormatStringGeneric Edit100
TOP16: Profit Management (EPS)
33F1602Z1External Cost Analyzer Balances - Interoperability Table7CZEDFTEDI - Translation FormatStringGeneric Edit100
34F1632Z1External Driver Balances-Interoperability Table7CYEDFTEDI - Translation FormatStringGeneric Edit100
TOP17: Customer Service Management
35F3111Z2Warranty Claim/Supplier Recovery processing7WPEDFTEDI - Translation FormatStringGeneric Edit100
36F3112Z2Warranty Claim/Supplier Recovery processing7WLEDFTEDI - Translation FormatStringGeneric Edit100
37F4801TZ2Warranty Claim/Supplier Recovery processing7WQEDFTEDI - Translation FormatStringGeneric Edit100
38F4801Z2Warranty Claim/Supplier Recovery processing7WSEDFTEDI - Translation FormatStringGeneric Edit100
TOP30: Product Data Management
39F0007Z1Work Day Calendar Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
40F30006Z1Work Center Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
41F3002Z1Bill of Material Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
42F3003Z1Routing Transactions File7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP31: Shop Floor Control
43F30161Z1Inbound Kanban Card Detail7SZEDFTEDI - Translation FormatStringGeneric Edit100
44F3111Z1Outbound Work Order Parts List7SZEDFTEDI - Translation FormatStringGeneric Edit100
45F31122Z1Work Order Time Transactions Unedited Transaction Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
46F3112Z1Outbound Work Order Routings7SZEDFTEDI - Translation FormatStringGeneric Edit100
47F4801Z1Outbound Work Order Header7SYEDFTEDI - Translation FormatStringGeneric Edit100
TOP31B: Blend Management
48F31B17Z1Operation EUR Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
49F31B18Z1VBT Barrel Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
50F31B19Z1Instructed Attributes Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
51F31B31Z1Operations Composition Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
52F31B34Z1Operations Style Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
53F31B3CZ1Operations Cost Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
54F31B52Z1Operations Equipment Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
55F31B53Z1Operations Consumables Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
56F31B65Z1Operations Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
57F31B93Z1WIM Work Order Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
58F31B97Z1Operations Resource Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
59F31BQAZ1Operations Quality Test Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP36: Forecasting
60F3460Z1Forecast Unedited Transactions7FTEDFTEDI - Translation FormatStringGeneric Edit100
TOP37: Quality Management
61F3711Z1Test Results Unedited Transaction Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP40: Inventory/OP Base
62F4001ZBatch Receiver File - Order Headings8SYEDFTEDI - Translation FormatStringGeneric Edit100
63F4011ZBatch Receiver File - Order Details8SZEDFTEDI - Translation FormatStringGeneric Edit100
64F4106NCBase Price Extraction7SZEDFTEDI - Translation FormatStringGeneric Edit100
65F4201Z1Sales Order Header Unedited Transaction File7SYEDFTEDI - Translation FormatStringGeneric Edit100
66F4211Z1Sales Order Detail Unedited Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
67F49211Z1Sales Order Detail Tag Unedited Transaction File7S1EDFTEDI - Translation FormatStringGeneric Edit100
TOP40R: Demand Scheduling
68F47171EDI Demand Header8EHEDFTEDI - Translation FormatStringGeneric Edit100
69F47172EDI Demand Detail8EDEDFTEDI - Translation FormatStringGeneric Edit100
70F471721EDI Demand Supplemental Data8EUEDFTEDI - Translation FormatStringGeneric Edit100
71F471722EDI Demand Addresses8EAEDFTEDI - Translation FormatStringGeneric Edit100
72F471723EDI Demand Contact Names8ECEDFTEDI - Translation FormatStringGeneric Edit100
73F471724EDI Demand Contact Numbers8ENEDFTEDI - Translation FormatStringGeneric Edit100
74F47173EDI Demand Scheduling Detail8ESEDFTEDI - Translation FormatStringGeneric Edit100
75F471731EDI Demand Packaging8EPEDFTEDI - Translation FormatStringGeneric Edit100
76F47800EDI Transmission Values6FFEDFTEDI - Translation FormatStringGeneric Edit100
TOP41: Inventory Management
77F4101Z1F4101 Item Master Unedited Transaction Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
78F4101Z1AF4101 Detail Item Master Unedited Transaction7SZEDFTEDI - Translation FormatStringGeneric Edit100
79F41021Z1Item Location Unedited Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
80F4105Z1Unedited Transaction Table - Item Cost7SZEDFTEDI - Translation FormatStringGeneric Edit100
81F4141Z1F4141 Cycle Count Unedited Transaction Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP42: Sales Management
82F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound12UZEDFTEDI - Translation FormatStringGeneric Edit100
83F470371TTag for F470371- EDI shipping Notice Detail - Outbound23UZEDFTEDI - Translation FormatStringGeneric Edit100
84F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound12UZEDFTEDI - Translation FormatStringGeneric Edit100
85F47107TTag for F47107- EDI Response to RFQ Detail - Outbound12UZEDFTEDI - Translation FormatStringGeneric Edit100
86F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound12UZEDFTEDI - Translation FormatStringGeneric Edit100
TOP42B: Sales Order Entry
87F4011ZTBatch Receiver File - Order Details Tag8UZEDFTEDI - Translation FormatStringGeneric Edit100
88F4211CZ1Sales Order Detail Unedited Transaction File - CRM6CZEDFTEDI - Translation FormatStringGeneric Edit100
89F4211URZF4211Z1 CRM User Reserved Tag File6UREDFTEDI - Translation FormatStringGeneric Edit100
90F42150Z1Header Commission Unedited Transaction File6S2EDFTEDI - Translation FormatStringGeneric Edit100
91F42160Z1Detail Commission Unedited Transaction File6S3EDFTEDI - Translation FormatStringGeneric Edit100
92F47012TEDI Purchase Order Detail Tag - Inbound8UZEDFTEDI - Translation FormatStringGeneric Edit100
93F47092TEDI Request for Quote Detail Tag - Inbound8UZEDFTEDI - Translation FormatStringGeneric Edit100
94F47132TEDI Purchase Order Change Detail Tag - Inbound8UZEDFTEDI - Translation FormatStringGeneric Edit100
TOP43: Procurement
95F4301Z1Purchase Order Header Unedited Transaction Table7SYEDFTEDI - Translation FormatStringGeneric Edit100
96F43092Z1Receipt Routing Unedited Transaction Table6SZEDFTEDI - Translation FormatStringGeneric Edit100
97F4311Z1Purchase Order Detail Unedited Transaction Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
98F43121Z1Receipts Unedited Transaction Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP44H: Homebuilder Management
99F44H101ZHB Community Master Unedited Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
100F44H201ZHB Lot Master Unedited Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
101F44H501ZHB Sales Master Unedited Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
102F44H604ZHB Vendor Assignment Unedited Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
103F44H711ZHB Lot Start Unedited Transaction File7SZEDFTEDI - Translation FormatStringGeneric Edit100
TOP45: Advanced Pricing
104F4572Z1Live Promotions Interface - Inbound / Outbound12LPEDFTEDI - Translation FormatStringGeneric Edit100
105F4572ZPPurge Live Promotions Interface12PGEDFTEDI - Translation FormatStringGeneric Edit100
106F4576Z1Ship and Debit Claims Unedited Transaction Table7Z1EDFTEDI - Translation FormatStringGeneric Edit100
TOP46: Warehouse Management
107F4611Z1Unedited Suggestion Table7SZEDFTEDI - Translation FormatStringGeneric Edit100
108F4942Z1Work File for F49427SYEDFTEDI - Translation FormatStringGeneric Edit100
TOP47: Electronic Commerce
109F47011EDI Purchase Order Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
110F47012EDI Purchase Order Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
111F47016EDI Purchase Order Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
112F470161EDI Purchase Order Additional Header - Outbound73S3EDFTEDI - Translation FormatStringGeneric Edit100
113F47017EDI Purchase Order Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
114F470171EDI Purchase Order Additional Detail - Outbound54S4EDFTEDI - Translation FormatStringGeneric Edit100
115F47021EDI P.O. Acknowledgment Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
116F47022EDI P.O. Acknowledgment Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
117F47026EDI P.O. Acknowledgment Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
118F47027EDI P.O. Acknowledgment Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
119F47031EDI Shipping Notice Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
120F47032EDI Shipping Notice Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
121F47036EDI Shipping Notice Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
122F47037EDI Shipping Notice Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
123F470371EDI Shipping Notice Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
124F470372EDI ASN Demand Scheduling Detail8AIEDFTEDI - Translation FormatStringGeneric Edit100
125F470373EDI ASN Shipping7AGEDFTEDI - Translation FormatStringGeneric Edit100
126F470374EDI ASN Demand Addresses9AMEDFTEDI - Translation FormatStringGeneric Edit100
127F470375EDI ASN Packaging Detail8AKEDFTEDI - Translation FormatStringGeneric Edit100
128F47041EDI Invoice Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
129F47042EDI Invoice Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
130F47044EDI Invoice Summary - Inbound8SWEDFTEDI - Translation FormatStringGeneric Edit100
131F47046EDI Invoice Header (Sales) - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
132F47047EDI Invoice Detail (Sales) - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
133F47056EDI Payment Order Header - Outbound8D1EDFTEDI - Translation FormatStringGeneric Edit100
134F47056WEDI Payment Order Header - Work8D1EDFTEDI - Translation FormatStringGeneric Edit100
135F47057EDI Payment Order Remittance Advice - Outbound8D3EDFTEDI - Translation FormatStringGeneric Edit100
136F47057WEDI Payment Order Remittance Advice - Work8D3EDFTEDI - Translation FormatStringGeneric Edit100
137F47061EDI Planning Schedule Header - Inbound8MJEDFTEDI - Translation FormatStringGeneric Edit100
138F47062EDI Planning Schedule Detail - Inbound8MYEDFTEDI - Translation FormatStringGeneric Edit100
139F47066EDI Planning Schedule Header - Outbound8MJEDFTEDI - Translation FormatStringGeneric Edit100
140F47067EDI Planning Schedule Detail - Outbound8MYEDFTEDI - Translation FormatStringGeneric Edit100
141F47071EDI Receiving Advice Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
142F47072EDI Receiving Advice Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
143F47076EDI Receiving Advice Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
144F47077EDI Receiving Advice Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
145F47081EDI Price Sales Catalog Header - Inbound8FVEDFTEDI - Translation FormatStringGeneric Edit100
146F47082EDI Price Sales Catalog Detail - Inbound8FYEDFTEDI - Translation FormatStringGeneric Edit100
147F47091EDI Request for Quote Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
148F47092EDI Request for Quote Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
149F47096EDI Request for Quote Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
150F47097EDI Request for Quote Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
151F47101EDI Response to RFQ Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
152F47102EDI Response to RFQ Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
153F47106EDI Response to RFQ Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
154F47107EDI Response to RFQ Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
155F47111EDI Lockbox/Payment Header - Transaction8Z1EDFTEDI - Translation FormatStringGeneric Edit100
156F47112EDI Lockbox Header - Transaction8Z2EDFTEDI - Translation FormatStringGeneric Edit100
157F47121EDI Product Activity Data Header - Inbound8M1EDFTEDI - Translation FormatStringGeneric Edit100
158F47122EDI Product Activity Data Detail - Inbound8MJEDFTEDI - Translation FormatStringGeneric Edit100
159F47126EDI Product Activity Data Header - Outbound8M1EDFTEDI - Translation FormatStringGeneric Edit100
160F47127EDI Product Activity Data Detail - Outbound8MJEDFTEDI - Translation FormatStringGeneric Edit100
161F47131EDI Purchase Order Change Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
162F47132EDI Purchase Order Change Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
163F47136EDI Purchase Order Change Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
164F47137EDI Purchase Order Change Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
165F47141EDI P.O. Change Acknowledgment Header - Inbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
166F47142EDI P.O. Change Acknowledgment Detail - Inbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
167F47146EDI P.O. Change Acknowledgment Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
168F47147EDI P.O. Change Acknowledgment Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
169F47156EDI Shipping Schedule Header - Outbound8SYEDFTEDI - Translation FormatStringGeneric Edit100
170F47157EDI Shipping Schedule Detail - Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
171F4716EDI Item Text - Inbound/Outbound8SZEDFTEDI - Translation FormatStringGeneric Edit100
172F47191EDI Acknowledgement Header8AHEDFTEDI - Translation FormatStringGeneric Edit100
173F47192EDI Acknowledgement Error Detail8AEEDFTEDI - Translation FormatStringGeneric Edit100
174F47194EDI Acknowledgement References8AREDFTEDI - Translation FormatStringGeneric Edit100
175F47196EDI Acknowledgement Name And Address8AAEDFTEDI - Translation FormatStringGeneric Edit100
176F47198EDI Acknowledgement Notes8ANEDFTEDI - Translation FormatStringGeneric Edit100
177F47CTLEDI Lockbox/Payment Work File12Z5EDFTEDI - Translation FormatStringGeneric Edit100
TOP76A: Argentina
178F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B7VKEDFTEDI - Translation FormatStringGeneric Edit100