	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

134 columns | 920 | EDUS

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0000194	Generic Interface Table for B0000194	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
2	F0006DZ1	Business Unit Alternate Description Z file	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
3	F0006Z1	Cost Center Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
4	F0006Z2	Business Unit Master Z File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
5	F0010Z	Company Constants Z File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
6	F0046	Processing Log	1	PL	EDUS	EDI - User ID	String	Generic Edit	10	0
7	F0401Z1	Supplier Master - Batch Upload	1	VO	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP01: Address Book
8	F0101Z2	Address Book - Interoperability	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
9	F01112Z1	Batch - Related Person	1	PB	EDUS	EDI - User ID	String	Generic Edit	10	0
10	F0111Z1	Batch Who's Who Information	1	BW	EDUS	EDI - User ID	String	Generic Edit	10	0
11	F01151Z1	Batch - Electronic Address	1	EB	EDUS	EDI - User ID	String	Generic Edit	10	0
12	F0115Z1	Phones - Interoperability	1	PI	EDUS	EDI - User ID	String	Generic Edit	10	0
13	F01161Z1	Batch - Alternative Address	1	LB	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP03: Accounts Receivable
14	F03012Z1	Customer Master LOB-Batch Table	1	VO	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP03B: Enhanced Accounts Receivable
15	F03B11Z1	Batch Invoices	1	VJ	EDUS	EDI - User ID	String	Generic Edit	10	0
16	F03B11Z2	F03B11 Interoperability Table	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
17	F03B13Z1	Electronic Receipts Input	1	RU	EDUS	EDI - User ID	String	Generic Edit	10	0
18	F03B13Z2	F03B13 Interoperability Table	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
19	F03B14Z2	F03B14 Interoperability Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
20	F03B41Z1	Inteoperability - Deductions Management	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP04: Accounts Payable
21	F0401Z1T	Supplier Master - Voucher Match Automation Tag File	1	VT	EDUS	EDI - User ID	String	Generic Edit	10	0
22	F0411Z1	Voucher Transactions - Batch Upload	1	VL	EDUS	EDI - User ID	String	Generic Edit	10	0
23	F0411Z1T	Voucher Transactions Batch Upload - Voucher Match Automation	1	VT	EDUS	EDI - User ID	String	Generic Edit	10	0
24	F0411Z3	F0411 Interoperability Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
25	F0413Z1	F0413 Interoperability Table	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
26	F0414Z1	F0414 Interoperability Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP05: Time Accounting and HRM Base
27	F05100Z1	Resource Competencies Unedited Transactions File	1	CU	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP05A: PeopleSoft HR & PR Foundation
28	F060116Z	Unedited Quick Hire Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP05T: Time Entry
29	F06116Z1	Employee Transactions - Batch File	1	VL	EDUS	EDI - User ID	String	Generic Edit	10	0
30	F06116Z2	ESS Timecard History	1	VM	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP09: General Accounting
31	F0902Z1	Account Balances - Batch File	8	GB	EDUS	EDI - User ID	String	Generic Edit	10	0
32	F0911Z1	Journal Entry Transactions - Batch File	1	VN	EDUS	EDI - User ID	String	Generic Edit	10	0
33	F0911Z4	F0911 Interoperability Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP10: Financial Reporting
34	F1001	Multi-Site Consolidation Transfer File Header	2	GP	EDUS	EDI - User ID	String	Generic Edit	10	0
35	F1001Z1	Unedited MSC Interoperability Header Table	1	IA	EDUS	EDI - User ID	String	Generic Edit	10	0
36	F1002	Multi-Site Consolidation Transfer File	2	GQ	EDUS	EDI - User ID	String	Generic Edit	10	0
37	F1002Z1	Unedited MSC Interoperability Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
38	F1003	Multi-Site Consolidation Transfer File - Category Codes	2	GR	EDUS	EDI - User ID	String	Generic Edit	10	0
39	F10UI002	Dynamically Created Business Units	1	BU	EDUS	EDI - User ID	String	Generic Edit	10	0
40	F10UI003	Dynamically Created Accounts	1	AC	EDUS	EDI - User ID	String	Generic Edit	10	0
41	F10UI006	MSC - F1002 Elimination Work File	1	GE	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP11: Multi Currency
42	F0015Z1	External Currency Exchange Rates	1	ZE	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP12: Fixed Assets
43	F1201Z1	Unedited Asset Master Transactions	1	FA	EDUS	EDI - User ID	String	Generic Edit	10	0
44	F1217Z1	Unedited Equipment Tag Transactions	1	WR	EDUS	EDI - User ID	String	Generic Edit	10	0
45	F1217Z2	Unedited Equipment Tag Transactions	1	WR	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP13: Plant/Equipment Management
46	F12120Z1	Unedited Meter Reading Transactions	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP13C: Condition-Base Maintenance
47	F1310Z1	Unedited Condition-Based Alerts	1	CB	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP16: Profit Management (EPS)
48	F1602Z1	External Cost Analyzer Balances - Interoperability Table	1	CZ	EDUS	EDI - User ID	String	Generic Edit	10	0
49	F1632Z1	External Driver Balances-Interoperability Table	1	CY	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP17: Customer Service Management
50	F3111Z2	Warranty Claim/Supplier Recovery processing	1	WP	EDUS	EDI - User ID	String	Generic Edit	10	0
51	F3112Z2	Warranty Claim/Supplier Recovery processing	1	WL	EDUS	EDI - User ID	String	Generic Edit	10	0
52	F4801TZ2	Warranty Claim/Supplier Recovery processing	1	WQ	EDUS	EDI - User ID	String	Generic Edit	10	0
53	F4801Z2	Warranty Claim/Supplier Recovery processing	1	WS	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP30: Product Data Management
54	F0007Z1	Work Day Calendar Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
55	F30006Z1	Work Center Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
56	F3002Z1	Bill of Material Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
57	F3003Z1	Routing Transactions File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP31: Shop Floor Control
58	F30161Z1	Inbound Kanban Card Detail	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
59	F3111Z1	Outbound Work Order Parts List	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
60	F31122Z1	Work Order Time Transactions Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
61	F3112Z1	Outbound Work Order Routings	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
62	F3112Z1T	Outbound Work Order Routings Tag Table - Needed for upgrade	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP31B: Blend Management
63	F31B17Z1	Operation EUR Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
64	F31B18Z1	VBT Barrel Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
65	F31B19Z1	Instructed Attributes Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
66	F31B31Z1	Operations Composition Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
67	F31B34Z1	Operations Style Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
68	F31B3CZ1	Operations Cost Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
69	F31B52Z1	Operations Equipment Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
70	F31B53Z1	Operations Consumables Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
71	F31B65Z1	Operations Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
72	F31B93Z1	WIM Work Order Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
73	F31B97Z1	Operations Resource Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
74	F31BQAZ1	Operations Quality Test Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
75	F31BSPZ1	Sample Transactions	1	ST	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP31P: Engineer To Order
76	F4801Z11	Outbound Work Order ETO Tag File	6	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP36: Forecasting
77	F3460Z1	Forecast Unedited Transactions	1	FT	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP37: Quality Management
78	F3711Z1	Test Results Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP40: Inventory/OP Base
79	F4106NC	Base Price Extraction	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
80	F4201Z1	Sales Order Header Unedited Transaction File	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
81	F4211Z1	Sales Order Detail Unedited Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
82	F49211Z1	Sales Order Detail Tag Unedited Transaction File	1	S1	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP41: Inventory Management
83	F4101Z1	F4101 Item Master Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
84	F4101Z1A	F4101 Detail Item Master Unedited Transaction	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
85	F41021Z1	Item Location Unedited Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
86	F4105Z1	Unedited Transaction Table - Item Cost	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
87	F4141Z1	F4141 Cycle Count Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP42: Sales Management
88	F4201Z1T	Sales Order Header Unedited Tax Transaction File	1	HY	EDUS	EDI - User ID	String	Generic Edit	10	0
89	F4211Z1T	Sales Order Detail Unedited Tax Transaction File	1	DZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP42B: Sales Order Entry
90	F4211CZ1	Sales Order Detail Unedited Transaction File - CRM	1	CZ	EDUS	EDI - User ID	String	Generic Edit	10	0
91	F4211URZ	F4211Z1 CRM User Reserved Tag File	1	UR	EDUS	EDI - User ID	String	Generic Edit	10	0
92	F42150Z1	Header Commission Unedited Transaction File	1	S2	EDUS	EDI - User ID	String	Generic Edit	10	0
93	F42160Z1	Detail Commission Unedited Transaction File	1	S3	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP43: Procurement
94	F4301Z1	Purchase Order Header Unedited Transaction Table	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
95	F43092Z1	Receipt Routing Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
96	F4311Z1	Purchase Order Detail Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
97	F43121Z1	Receipts Unedited Transaction Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP44H: Homebuilder Management
98	F44H101Z	HB Community Master Unedited Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
99	F44H201Z	HB Lot Master Unedited Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
100	F44H501Z	HB Sales Master Unedited Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
101	F44H604Z	HB Vendor Assignment Unedited Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
102	F44H711Z	HB Lot Start Unedited Transaction File	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP45: Advanced Pricing
103	F4572Z1	Live Promotions Interface - Inbound / Outbound	1	LP	EDUS	EDI - User ID	String	Generic Edit	10	0
104	F4572ZP	Purge Live Promotions Interface	1	PG	EDUS	EDI - User ID	String	Generic Edit	10	0
105	F4576Z1	Ship and Debit Claims Unedited Transaction Table	1	Z1	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP46: Warehouse Management
106	F4611Z1	Unedited Suggestion Table	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
107	F4942Z1	Work File for F4942	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP48: Work Order Processing
108	F4801Z1	Outbound Work Order Header	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP70: Multi-National Products
109	F703B1Z1	Sales EDI Invoice Number	1	AZ	EDUS	EDI - User ID	String	Generic Edit	10	0
110	F70XMLZ1	XML Transaction Interfase	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP74: EMEA Localization
111	F743011Z	Signed Batch Invoice - Tag Table -74	1	TK	EDUS	EDI - User ID	String	Generic Edit	10	0
112	F743013Z	Signed Batch Invoice - Tag Table -74	1	TK	EDUS	EDI - User ID	String	Generic Edit	10	0
113	F74XMLZ1	XML Transaction Interface	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
114	F74XMLZ2	XML Transaction Interface iSeries - COMM	1	SY	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP76A: Argentina
115	F76A010Z	F0101Z2 Argentinean Tag Table - ARG - 01 - 76A	1	V9	EDUS	EDI - User ID	String	Generic Edit	10	0
116	F76A19Z1	Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A	1	VK	EDUS	EDI - User ID	String	Generic Edit	10	0
117	F76A30	F0411Z1 Tag Table - ARG - 04 - 76A	1	V8	EDUS	EDI - User ID	String	Generic Edit	10	0
118	F76A30H	EDI Batch Input Localization File - ARG - 04 - 76A	1	V6	EDUS	EDI - User ID	String	Generic Edit	10	0
119	F76A30T	F76A30 Tag File Z1 - ARG - 04 - 76A	1	V7	EDUS	EDI - User ID	String	Generic Edit	10	0
120	F76A60Z1	Receipt Header Argentine Tag File Batch Input - ARG - - 76A	1	TF	EDUS	EDI - User ID	String	Generic Edit	10	0
121	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	1	BE	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP76B: Brazil
122	F76B12TZ	NF-e Status Log Z File - BRA - 76B	1	SZ	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP76H: Chile
123	F76H101Z	EDI - A/B Tag File - CHI - 76H - 76H	1	AH	EDUS	EDI - User ID	String	Generic Edit	10	0
124	F76H3B1Z	F76H3B10 EDI Tag File - CHI - 03B - 76H	1	ZT	EDUS	EDI - User ID	String	Generic Edit	10	0
125	F76H3B5Z	F76H3B15 EDI Tag File - CHI - 03B - 76H	1	IR	EDUS	EDI - User ID	String	Generic Edit	10	0
126	F76HUI61	Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H	3	ZT	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP76P: Peru
127	F76P101Z	EDI - A/B Tag File - PER - 76P - 76P	1	AH	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP76V: Venezuela
128	F76V101Z	EDI A/B Additional Information - VE - 01	1	ZW	EDUS	EDI - User ID	String	Generic Edit	10	0
129	F76V411Z	Voucher Batch Upload Tag File - VEN - 04	1	BI	EDUS	EDI - User ID	String	Generic Edit	10	0
130	F76V415Z	Voucher - Credit/Debit Note Batch Upload - VEN - 04	1	BI	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP79A: Greenhouse Gas Accounting
131	F79A11Z1	GHG Ledger - Batch File	1	GL	EDUS	EDI - User ID	String	Generic Edit	10	0
TOP89: Conversion Programs
132	F01111Z1	Batch - Contact Information	1	CB	EDUS	EDI - User ID	String	Generic Edit	10	0
133	F06116TZ	Needed for upgrade from Xe to B9	1	VL	EDUS	EDI - User ID	String	Generic Edit	10	0
134	F0911Z1T	Needed for upgrade for XE and below	1	VN	EDUS	EDI - User ID	String	Generic Edit	10	0

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

134 columns | 920 | EDUS