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

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