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

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