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 | EDUS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0000194Generic Interface Table for B00001941SYEDUSEDI - User IDStringGeneric Edit100
2F0006Z1Cost Center Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
3F0046Processing Log1PLEDUSEDI - User IDStringGeneric Edit100
4F0401Z1Supplier Master - Batch Upload1VOEDUSEDI - User IDStringGeneric Edit100
TOP01: Address Book
5F0101Z2Address Book - Interoperability1SZEDUSEDI - User IDStringGeneric Edit100
6F01112Z1Batch - Related Person1PBEDUSEDI - User IDStringGeneric Edit100
7F0111Z1Batch Who's Who Information1BWEDUSEDI - User IDStringGeneric Edit100
8F01151Z1Batch - Electronic Address1EBEDUSEDI - User IDStringGeneric Edit100
9F0115Z1Phones - Interoperability1PIEDUSEDI - User IDStringGeneric Edit100
10F01161Z1Batch - Alternative Address1LBEDUSEDI - User IDStringGeneric Edit100
TOP03: Accounts Receivable
11F03012Z1Customer Master LOB-Batch Table1VOEDUSEDI - User IDStringGeneric Edit100
TOP03B: Enhanced Accounts Receivable
12F03B11Z1Batch Invoices1VJEDUSEDI - User IDStringGeneric Edit100
13F03B11Z2F03B11 Interoperability Table1SYEDUSEDI - User IDStringGeneric Edit100
14F03B13Z1Electronic Receipts Input1RUEDUSEDI - User IDStringGeneric Edit100
15F03B13Z2F03B13 Interoperability Table1SYEDUSEDI - User IDStringGeneric Edit100
16F03B14Z2F03B14 Interoperability Table1SZEDUSEDI - User IDStringGeneric Edit100
17F03B41Z1Inteoperability - Deductions Management1SZEDUSEDI - User IDStringGeneric Edit100
TOP04: Accounts Payable
18F0401Z1TSupplier Master - Voucher Match Automation Tag File1VTEDUSEDI - User IDStringGeneric Edit100
19F0411Z1Voucher Transactions - Batch Upload1VLEDUSEDI - User IDStringGeneric Edit100
20F0411Z1TVoucher Transactions Batch Upload - Voucher Match Automation1VTEDUSEDI - User IDStringGeneric Edit100
21F0411Z3F0411 Interoperability Table1SZEDUSEDI - User IDStringGeneric Edit100
22F0413Z1F0413 Interoperability Table1SYEDUSEDI - User IDStringGeneric Edit100
23F0414Z1F0414 Interoperability Table1SZEDUSEDI - User IDStringGeneric Edit100
TOP05: Time Accounting and HRM Base
24F05100Z1Resource Competencies Unedited Transactions File1CUEDUSEDI - User IDStringGeneric Edit100
TOP05A: OW HR & PR Foundation
25F060116ZUnedited Quick Hire Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
TOP05T: Time Entry
26F06116Z1Employee Transactions - Batch File1VLEDUSEDI - User IDStringGeneric Edit100
27F06116Z2ESS Timecard History1VMEDUSEDI - User IDStringGeneric Edit100
TOP09: General Accounting
28F0902Z1Account Balances - Batch File8GBEDUSEDI - User IDStringGeneric Edit100
29F0911Z1Journal Entry Transactions - Batch File1VNEDUSEDI - User IDStringGeneric Edit100
30F0911Z4F0911 Interoperability Table1SZEDUSEDI - User IDStringGeneric Edit100
TOP10: Financial Reporting
31F1001Multi-Site Consolidation Transfer File Header2GPEDUSEDI - User IDStringGeneric Edit100
32F1001Z1Unedited MSC Interoperability Header Table1IAEDUSEDI - User IDStringGeneric Edit100
33F1002Multi-Site Consolidation Transfer File2GQEDUSEDI - User IDStringGeneric Edit100
34F1002Z1Unedited MSC Interoperability Table1SZEDUSEDI - User IDStringGeneric Edit100
35F1003Multi-Site Consolidation Transfer File - Category Codes2GREDUSEDI - User IDStringGeneric Edit100
36F10UI002Dynamically Created Business Units1BUEDUSEDI - User IDStringGeneric Edit100
37F10UI003Dynamically Created Accounts1ACEDUSEDI - User IDStringGeneric Edit100
38F10UI006MSC - F1002 Elimination Work File1GEEDUSEDI - User IDStringGeneric Edit100
TOP11: Multi Currency
39F0015Z1External Currency Exchange Rates1ZEEDUSEDI - User IDStringGeneric Edit100
TOP12: Fixed Assets
40F1201Z1Unedited Asset Master Transactions1FAEDUSEDI - User IDStringGeneric Edit100
41F1217Z1Unedited Equipment Tag Transactions1WREDUSEDI - User IDStringGeneric Edit100
42F1217Z2Unedited Equipment Tag Transactions1WREDUSEDI - User IDStringGeneric Edit100
TOP13: Plant/Equipment Management
43F12120Z1Unedited Meter Reading Transactions1SZEDUSEDI - User IDStringGeneric Edit100
TOP13C: Condition-Base Maintenance
44F1310Z1Unedited Condition-Based Alerts1CBEDUSEDI - User IDStringGeneric Edit100
TOP16: Profit Management (EPS)
45F1602Z1External Cost Analyzer Balances - Interoperability Table1CZEDUSEDI - User IDStringGeneric Edit100
46F1632Z1External Driver Balances-Interoperability Table1CYEDUSEDI - User IDStringGeneric Edit100
TOP17: Customer Service Management
47F3111Z2Warranty Claim/Supplier Recovery processing1WPEDUSEDI - User IDStringGeneric Edit100
48F3112Z2Warranty Claim/Supplier Recovery processing1WLEDUSEDI - User IDStringGeneric Edit100
49F4801TZ2Warranty Claim/Supplier Recovery processing1WQEDUSEDI - User IDStringGeneric Edit100
50F4801Z2Warranty Claim/Supplier Recovery processing1WSEDUSEDI - User IDStringGeneric Edit100
TOP30: Product Data Management
51F0007Z1Work Day Calendar Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
52F30006Z1Work Center Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
53F3002Z1Bill of Material Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
54F3003Z1Routing Transactions File1SZEDUSEDI - User IDStringGeneric Edit100
TOP31: Shop Floor Control
55F30161Z1Inbound Kanban Card Detail1SZEDUSEDI - User IDStringGeneric Edit100
56F3111Z1Outbound Work Order Parts List1SZEDUSEDI - User IDStringGeneric Edit100
57F31122Z1Work Order Time Transactions Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
58F3112Z1Outbound Work Order Routings1SZEDUSEDI - User IDStringGeneric Edit100
59F3112Z1TOutbound Work Order Routings Tag Table - Needed for upgrade1SZEDUSEDI - User IDStringGeneric Edit100
TOP31B: Blend Management
60F31B17Z1Operation EUR Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
61F31B18Z1VBT Barrel Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
62F31B19Z1Instructed Attributes Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
63F31B31Z1Operations Composition Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
64F31B34Z1Operations Style Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
65F31B3CZ1Operations Cost Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
66F31B52Z1Operations Equipment Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
67F31B53Z1Operations Consumables Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
68F31B65Z1Operations Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
69F31B93Z1WIM Work Order Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
70F31B97Z1Operations Resource Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
71F31BQAZ1Operations Quality Test Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
72F31BSPZ1Sample Transactions1STEDUSEDI - User IDStringGeneric Edit100
TOP31P: Engineer To Order
73F4801Z11Outbound Work Order ETO Tag File6SYEDUSEDI - User IDStringGeneric Edit100
TOP36: Forecasting
74F3460Z1Forecast Unedited Transactions1FTEDUSEDI - User IDStringGeneric Edit100
TOP37: Quality Management
75F3711Z1Test Results Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
TOP40: Inventory/OP Base
76F4106NCBase Price Extraction1SZEDUSEDI - User IDStringGeneric Edit100
77F4201Z1Sales Order Header Unedited Transaction File1SYEDUSEDI - User IDStringGeneric Edit100
78F4211Z1Sales Order Detail Unedited Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
79F49211Z1Sales Order Detail Tag Unedited Transaction File1S1EDUSEDI - User IDStringGeneric Edit100
TOP41: Inventory Management
80F4101Z1F4101 Item Master Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
81F4101Z1AF4101 Detail Item Master Unedited Transaction1SZEDUSEDI - User IDStringGeneric Edit100
82F41021Z1Item Location Unedited Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
83F4105Z1Unedited Transaction Table - Item Cost1SZEDUSEDI - User IDStringGeneric Edit100
84F4141Z1F4141 Cycle Count Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
TOP42: Sales Management
85F4201Z1TSales Order Header Unedited Tax Transaction File1HYEDUSEDI - User IDStringGeneric Edit100
86F4211Z1TSales Order Detail Unedited Tax Transaction File1DZEDUSEDI - User IDStringGeneric Edit100
TOP42B: Sales Order Entry
87F4211CZ1Sales Order Detail Unedited Transaction File - CRM1CZEDUSEDI - User IDStringGeneric Edit100
88F4211URZF4211Z1 CRM User Reserved Tag File1UREDUSEDI - User IDStringGeneric Edit100
89F42150Z1Header Commission Unedited Transaction File1S2EDUSEDI - User IDStringGeneric Edit100
90F42160Z1Detail Commission Unedited Transaction File1S3EDUSEDI - User IDStringGeneric Edit100
TOP43: Procurement
91F4301Z1Purchase Order Header Unedited Transaction Table1SYEDUSEDI - User IDStringGeneric Edit100
92F43092Z1Receipt Routing Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
93F4311Z1Purchase Order Detail Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
94F43121Z1Receipts Unedited Transaction Table1SZEDUSEDI - User IDStringGeneric Edit100
TOP44H: Homebuilder Management
95F44H101ZHB Community Master Unedited Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
96F44H201ZHB Lot Master Unedited Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
97F44H501ZHB Sales Master Unedited Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
98F44H604ZHB Vendor Assignment Unedited Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
99F44H711ZHB Lot Start Unedited Transaction File1SZEDUSEDI - User IDStringGeneric Edit100
TOP45: Advanced Pricing
100F4572Z1Live Promotions Interface - Inbound / Outbound1LPEDUSEDI - User IDStringGeneric Edit100
101F4572ZPPurge Live Promotions Interface1PGEDUSEDI - User IDStringGeneric Edit100
102F4576Z1Ship and Debit Claims Unedited Transaction Table1Z1EDUSEDI - User IDStringGeneric Edit100
TOP46: Warehouse Management
103F4611Z1Unedited Suggestion Table1SZEDUSEDI - User IDStringGeneric Edit100
104F4942Z1Work File for F49421SYEDUSEDI - User IDStringGeneric Edit100
TOP48: Work Order Processing
105F4801Z1Outbound Work Order Header1SYEDUSEDI - User IDStringGeneric Edit100
TOP70: Multi-National Products - obsolete-do not reuse
106F70XMLZ1XML Transaction Interfase1SYEDUSEDI - User IDStringGeneric Edit100
TOP74: EMEA Localization
107F743011ZSigned Batch Invoice - Tag Table -741TKEDUSEDI - User IDStringGeneric Edit100
108F74XMLZ1XML Transaction Interface1SYEDUSEDI - User IDStringGeneric Edit100
109F74XMLZ2XML Transaction Interface iSeries - COMM1SYEDUSEDI - User IDStringGeneric Edit100
TOP76A: Argentina
110F76A010ZF0101Z2 Argentinean Tag Table - ARG - 01 - 76A1V9EDUSEDI - User IDStringGeneric Edit100
111F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A1VKEDUSEDI - User IDStringGeneric Edit100
112F76A30F0411Z1 Tag Table - ARG - 04 - 76A1V8EDUSEDI - User IDStringGeneric Edit100
113F76A30HEDI Batch Input Localization File - ARG - 04 - 76A1V6EDUSEDI - User IDStringGeneric Edit100
114F76A30TF76A30 Tag File Z1 - ARG - 04 - 76A1V7EDUSEDI - User IDStringGeneric Edit100
115F76A60Z1Receipt Header Argentine Tag File Batch Input - ARG - - 76A1TFEDUSEDI - User IDStringGeneric Edit100
116F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A1BEEDUSEDI - User IDStringGeneric Edit100
TOP76B: Brazil - Reporting System Only
117F76B12TZNF-e Status Log Z File - BRA - 76B1SZEDUSEDI - User IDStringGeneric Edit100
TOP76H: Chile
118F76H101ZEDI - A/B Tag File - CHI - 76H - 76H1AHEDUSEDI - User IDStringGeneric Edit100
119F76H3B1ZF76H3B10 EDI Tag File - CHI - 03B - 76H1ZTEDUSEDI - User IDStringGeneric Edit100
120F76H3B5ZF76H3B15 EDI Tag File - CHI - 03B - 76H1IREDUSEDI - User IDStringGeneric Edit100
121F76HUI61Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H3ZTEDUSEDI - User IDStringGeneric Edit100
TOP76P: Peru
122F76P101ZEDI - A/B Tag File - PER - 76P - 76P1AHEDUSEDI - User IDStringGeneric Edit100
TOP76V: Venezuela
123F76V101ZEDI A/B Additional Information - VE - 011ZWEDUSEDI - User IDStringGeneric Edit100
124F76V411ZVoucher Batch Upload Tag File - VEN - 041BIEDUSEDI - User IDStringGeneric Edit100
125F76V415ZVoucher - Credit/Debit Note Batch Upload - VEN - 041BIEDUSEDI - User IDStringGeneric Edit100
TOP79A: Greenhouse Gas Accounting
126F79A11Z1GHG Ledger - Batch File1GLEDUSEDI - User IDStringGeneric Edit100
TOP89: Conversion Programs
127F01111Z1Batch - Contact Information1CBEDUSEDI - User IDStringGeneric Edit100
128F06116TZNeeded for upgrade from Xe to B91VLEDUSEDI - User IDStringGeneric Edit100
129F0911Z1TNeeded for upgrade for XE and below1VNEDUSEDI - User IDStringGeneric Edit100