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

117 columns | 812 | EDTN