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

134 columns | Print definition?920 | EDTN

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