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

129 columns | Print definition?910 | EDTN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0000194Generic Interface Table for B00001943SYEDTNEDI - Transaction NumberStringGeneric Edit220
2F0006Z1Cost Center Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
3F0046Processing Log3PLEDTNEDI - Transaction NumberStringGeneric Edit220
4F0401Z1Supplier Master - Batch Upload3VOEDTNEDI - Transaction NumberStringGeneric Edit220
TOP01: Address Book
5F0101Z2Address Book - Interoperability3SZEDTNEDI - Transaction NumberStringGeneric Edit220
6F01112Z1Batch - Related Person3PBEDTNEDI - Transaction NumberStringGeneric Edit220
7F0111Z1Batch Who's Who Information3BWEDTNEDI - Transaction NumberStringGeneric Edit220
8F01151Z1Batch - Electronic Address3EBEDTNEDI - Transaction NumberStringGeneric Edit220
9F0115Z1Phones - Interoperability3PIEDTNEDI - Transaction NumberStringGeneric Edit220
10F01161Z1Batch - Alternative Address3LBEDTNEDI - Transaction NumberStringGeneric Edit220
TOP03: Accounts Receivable
11F03012Z1Customer Master LOB-Batch Table3VOEDTNEDI - Transaction NumberStringGeneric Edit220
TOP03B: Enhanced Accounts Receivable
12F03B11Z1Batch Invoices4VJEDTNEDI - Transaction NumberStringGeneric Edit220
13F03B11Z2F03B11 Interoperability Table3SYEDTNEDI - Transaction NumberStringGeneric Edit220
14F03B13Z1Electronic Receipts Input3RUEDTNEDI - Transaction NumberStringGeneric Edit220
15F03B13Z2F03B13 Interoperability Table3SYEDTNEDI - Transaction NumberStringGeneric Edit220
16F03B14Z2F03B14 Interoperability Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
17F03B41Z1Inteoperability - Deductions Management3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP04: Accounts Payable
18F0401Z1TSupplier Master - Voucher Match Automation Tag File3VTEDTNEDI - Transaction NumberStringGeneric Edit220
19F0411Z1Voucher Transactions - Batch Upload4VLEDTNEDI - Transaction NumberStringGeneric Edit220
20F0411Z1TVoucher Transactions Batch Upload - Voucher Match Automation3VTEDTNEDI - Transaction NumberStringGeneric Edit220
21F0411Z3F0411 Interoperability Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
22F0413Z1F0413 Interoperability Table3SYEDTNEDI - Transaction NumberStringGeneric Edit220
23F0414Z1F0414 Interoperability Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP05: Time Accounting and HRM Base
24F05100Z1Resource Competencies Unedited Transactions File3CUEDTNEDI - Transaction NumberStringGeneric Edit220
TOP05A: OW HR & PR Foundation
25F060116ZUnedited Quick Hire Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP05T: Time Entry
26F06116Z1Employee Transactions - Batch File4VLEDTNEDI - Transaction NumberStringGeneric Edit220
27F06116Z2ESS Timecard History4VMEDTNEDI - Transaction NumberStringGeneric Edit220
TOP09: General Accounting
28F0902Z1Account Balances - Batch File10GBEDTNEDI - Transaction NumberStringGeneric Edit220
29F0911Z1Journal Entry Transactions - Batch File4VNEDTNEDI - Transaction NumberStringGeneric Edit220
30F0911Z4F0911 Interoperability Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP10: Financial Reporting
31F1001Multi-Site Consolidation Transfer File Header3GPEDTNEDI - Transaction NumberStringGeneric Edit220
32F1001Z1Unedited MSC Interoperability Header Table3IAEDTNEDI - Transaction NumberStringGeneric Edit220
33F1002Multi-Site Consolidation Transfer File3GQEDTNEDI - Transaction NumberStringGeneric Edit220
34F1002Z1Unedited MSC Interoperability Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
35F1003Multi-Site Consolidation Transfer File - Category Codes3GREDTNEDI - Transaction NumberStringGeneric Edit220
36F10UI002Dynamically Created Business Units2BUEDTNEDI - Transaction NumberStringGeneric Edit220
37F10UI003Dynamically Created Accounts2ACEDTNEDI - Transaction NumberStringGeneric Edit220
38F10UI006MSC - F1002 Elimination Work File2GEEDTNEDI - Transaction NumberStringGeneric Edit220
TOP11: Multi Currency
39F0015Z1External Currency Exchange Rates3ZEEDTNEDI - Transaction NumberStringGeneric Edit220
TOP12: Fixed Assets
40F1201Z1Unedited Asset Master Transactions3FAEDTNEDI - Transaction NumberStringGeneric Edit220
41F1217Z1Unedited Equipment Tag Transactions3WREDTNEDI - Transaction NumberStringGeneric Edit220
42F1217Z2Unedited Equipment Tag Transactions3WREDTNEDI - Transaction NumberStringGeneric Edit220
TOP13: Plant/Equipment Management
43F12120Z1Unedited Meter Reading Transactions3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP13C: Condition-Base Maintenance
44F1310Z1Unedited Condition-Based Alerts3CBEDTNEDI - Transaction NumberStringGeneric Edit220
TOP16: Profit Management (EPS)
45F1602Z1External Cost Analyzer Balances - Interoperability Table3CZEDTNEDI - Transaction NumberStringGeneric Edit220
46F1632Z1External Driver Balances-Interoperability Table3CYEDTNEDI - Transaction NumberStringGeneric Edit220
TOP17: Customer Service Management
47F3111Z2Warranty Claim/Supplier Recovery processing3WPEDTNEDI - Transaction NumberStringGeneric Edit220
48F3112Z2Warranty Claim/Supplier Recovery processing3WLEDTNEDI - Transaction NumberStringGeneric Edit220
49F4801TZ2Warranty Claim/Supplier Recovery processing3WQEDTNEDI - Transaction NumberStringGeneric Edit220
50F4801Z2Warranty Claim/Supplier Recovery processing3WSEDTNEDI - Transaction NumberStringGeneric Edit220
TOP30: Product Data Management
51F0007Z1Work Day Calendar Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
52F30006Z1Work Center Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
53F3002Z1Bill of Material Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
54F3003Z1Routing Transactions File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP31: Shop Floor Control
55F30161Z1Inbound Kanban Card Detail3SZEDTNEDI - Transaction NumberStringGeneric Edit220
56F3111Z1Outbound Work Order Parts List3SZEDTNEDI - Transaction NumberStringGeneric Edit220
57F31122Z1Work Order Time Transactions Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
58F3112Z1Outbound Work Order Routings3SZEDTNEDI - Transaction NumberStringGeneric Edit220
59F3112Z1TOutbound Work Order Routings Tag Table - Needed for upgrade3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP31B: Blend Management
60F31B17Z1Operation EUR Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
61F31B18Z1VBT Barrel Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
62F31B19Z1Instructed Attributes Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
63F31B31Z1Operations Composition Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
64F31B34Z1Operations Style Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
65F31B3CZ1Operations Cost Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
66F31B52Z1Operations Equipment Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
67F31B53Z1Operations Consumables Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
68F31B65Z1Operations Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
69F31B93Z1WIM Work Order Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
70F31B97Z1Operations Resource Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
71F31BQAZ1Operations Quality Test Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
72F31BSPZ1Sample Transactions3STEDTNEDI - Transaction NumberStringGeneric Edit220
TOP31P: Engineer To Order
73F4801Z11Outbound Work Order ETO Tag File8SYEDTNEDI - Transaction NumberStringGeneric Edit220
TOP36: Forecasting
74F3460Z1Forecast Unedited Transactions3FTEDTNEDI - Transaction NumberStringGeneric Edit220
TOP37: Quality Management
75F3711Z1Test Results Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP40: Inventory/OP Base
76F4106NCBase Price Extraction3SZEDTNEDI - Transaction NumberStringGeneric Edit220
77F4201Z1Sales Order Header Unedited Transaction File3SYEDTNEDI - Transaction NumberStringGeneric Edit220
78F4211Z1Sales Order Detail Unedited Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
79F49211Z1Sales Order Detail Tag Unedited Transaction File3S1EDTNEDI - Transaction NumberStringGeneric Edit220
TOP41: Inventory Management
80F4101Z1F4101 Item Master Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
81F4101Z1AF4101 Detail Item Master Unedited Transaction3SZEDTNEDI - Transaction NumberStringGeneric Edit220
82F41021Z1Item Location Unedited Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
83F4105Z1Unedited Transaction Table - Item Cost3SZEDTNEDI - Transaction NumberStringGeneric Edit220
84F4141Z1F4141 Cycle Count Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP42: Sales Management
85F4201Z1TSales Order Header Unedited Tax Transaction File3HYEDTNEDI - Transaction NumberStringGeneric Edit220
86F4211Z1TSales Order Detail Unedited Tax Transaction File3DZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP42B: Sales Order Entry
87F4211CZ1Sales Order Detail Unedited Transaction File - CRM3CZEDTNEDI - Transaction NumberStringGeneric Edit220
88F4211URZF4211Z1 CRM User Reserved Tag File3UREDTNEDI - Transaction NumberStringGeneric Edit220
89F42150Z1Header Commission Unedited Transaction File3S2EDTNEDI - Transaction NumberStringGeneric Edit220
90F42160Z1Detail Commission Unedited Transaction File3S3EDTNEDI - Transaction NumberStringGeneric Edit220
TOP43: Procurement
91F4301Z1Purchase Order Header Unedited Transaction Table3SYEDTNEDI - Transaction NumberStringGeneric Edit220
92F43092Z1Receipt Routing Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
93F4311Z1Purchase Order Detail Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
94F43121Z1Receipts Unedited Transaction Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP44H: Homebuilder Management
95F44H101ZHB Community Master Unedited Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
96F44H201ZHB Lot Master Unedited Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
97F44H501ZHB Sales Master Unedited Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
98F44H604ZHB Vendor Assignment Unedited Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
99F44H711ZHB Lot Start Unedited Transaction File3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP45: Advanced Pricing
100F4572Z1Live Promotions Interface - Inbound / Outbound3LPEDTNEDI - Transaction NumberStringGeneric Edit220
101F4572ZPPurge Live Promotions Interface3PGEDTNEDI - Transaction NumberStringGeneric Edit220
102F4576Z1Ship and Debit Claims Unedited Transaction Table3Z1EDTNEDI - Transaction NumberStringGeneric Edit220
TOP46: Warehouse Management
103F4611Z1Unedited Suggestion Table3SZEDTNEDI - Transaction NumberStringGeneric Edit220
104F4942Z1Work File for F49423SYEDTNEDI - Transaction NumberStringGeneric Edit220
TOP48: Work Order Processing
105F4801Z1Outbound Work Order Header3SYEDTNEDI - Transaction NumberStringGeneric Edit220
TOP70: Multi-National Products - obsolete-do not reuse
106F70XMLZ1XML Transaction Interfase3SYEDTNEDI - Transaction NumberStringGeneric Edit220
TOP74: EMEA Localization
107F743011ZSigned Batch Invoice - Tag Table -743TKEDTNEDI - Transaction NumberStringGeneric Edit220
108F74XMLZ1XML Transaction Interface3SYEDTNEDI - Transaction NumberStringGeneric Edit220
109F74XMLZ2XML Transaction Interface iSeries - COMM3SYEDTNEDI - Transaction NumberStringGeneric Edit220
TOP76A: Argentina
110F76A010ZF0101Z2 Argentinean Tag Table - ARG - 01 - 76A3V9EDTNEDI - Transaction NumberStringGeneric Edit220
111F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A4VKEDTNEDI - Transaction NumberStringGeneric Edit220
112F76A30F0411Z1 Tag Table - ARG - 04 - 76A3V8EDTNEDI - Transaction NumberStringGeneric Edit220
113F76A30HEDI Batch Input Localization File - ARG - 04 - 76A3V6EDTNEDI - Transaction NumberStringGeneric Edit220
114F76A30TF76A30 Tag File Z1 - ARG - 04 - 76A3V7EDTNEDI - Transaction NumberStringGeneric Edit220
115F76A60Z1Receipt Header Argentine Tag File Batch Input - ARG - - 76A3TFEDTNEDI - Transaction NumberStringGeneric Edit220
116F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A3BEEDTNEDI - Transaction NumberStringGeneric Edit220
TOP76B: Brazil - Reporting System Only
117F76B12TZNF-e Status Log Z File - BRA - 76B3SZEDTNEDI - Transaction NumberStringGeneric Edit220
TOP76H: Chile
118F76H101ZEDI - A/B Tag File - CHI - 76H - 76H3AHEDTNEDI - Transaction NumberStringGeneric Edit220
119F76H3B1ZF76H3B10 EDI Tag File - CHI - 03B - 76H2ZTEDTNEDI - Transaction NumberStringGeneric Edit220
120F76H3B5ZF76H3B15 EDI Tag File - CHI - 03B - 76H2IREDTNEDI - Transaction NumberStringGeneric Edit220
121F76HUI61Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H4ZTEDTNEDI - Transaction NumberStringGeneric Edit220
TOP76P: Peru
122F76P101ZEDI - A/B Tag File - PER - 76P - 76P3AHEDTNEDI - Transaction NumberStringGeneric Edit220
TOP76V: Venezuela
123F76V101ZEDI A/B Additional Information - VE - 013ZWEDTNEDI - Transaction NumberStringGeneric Edit220
124F76V411ZVoucher Batch Upload Tag File - VEN - 043BIEDTNEDI - Transaction NumberStringGeneric Edit220
125F76V415ZVoucher - Credit/Debit Note Batch Upload - VEN - 043BIEDTNEDI - Transaction NumberStringGeneric Edit220
TOP79A: Greenhouse Gas Accounting
126F79A11Z1GHG Ledger - Batch File4GLEDTNEDI - Transaction NumberStringGeneric Edit220
TOP89: Conversion Programs
127F01111Z1Batch - Contact Information3CBEDTNEDI - Transaction NumberStringGeneric Edit220
128F06116TZNeeded for upgrade from Xe to B93VLEDTNEDI - Transaction NumberStringGeneric Edit220
129F0911Z1TNeeded for upgrade for XE and below3VNEDTNEDI - Transaction NumberStringGeneric Edit220