	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

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

117 columns | 812 | EDUS