	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

140 columns | 920 | EDSQ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP03B: Enhanced Accounts Receivable
1	F03B11Z1	Batch Invoices	3	VJ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP04: Accounts Payable
2	F0411Z1	Voucher Transactions - Batch Upload	3	VL	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
3	F0411Z3	F0411 Interoperability Table	15	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
4	F04572	A/P Payment Processing - Summary	54	KK	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP05: Time Accounting and HRM Base
5	F05100Z1	Resource Competencies Unedited Transactions File	24	CU	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP05T: Time Entry
6	F06116Z1	Employee Transactions - Batch File	3	VL	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
7	F06116Z2	ESS Timecard History	3	VM	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP09: General Accounting
8	F0911Z1	Journal Entry Transactions - Batch File	3	VN	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
9	F0911Z4	F0911 Interoperability Table	15	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP11: Multi Currency
10	F0015Z1	External Currency Exchange Rates	15	ZE	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP16: Profit Management (EPS)
11	F1602Z1	External Cost Analyzer Balances - Interoperability Table	15	CZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
12	F1632Z1	External Driver Balances-Interoperability Table	15	CY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP40: Inventory/OP Base
13	F4001Z	Batch Receiver File - Order Headings	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
14	F4011Z	Batch Receiver File - Order Details	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP40R: Demand Scheduling
15	F47171	EDI Demand Header	2	EH	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
16	F47172	EDI Demand Detail	2	ED	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
17	F471721	EDI Demand Supplemental Data	2	EU	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
18	F471722	EDI Demand Addresses	2	EA	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
19	F471723	EDI Demand Contact Names	2	EC	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
20	F471724	EDI Demand Contact Numbers	2	EN	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
21	F47173	EDI Demand Scheduling Detail	2	ES	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
22	F471731	EDI Demand Packaging	2	EP	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP42: Sales Management
23	F47027T	Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound	16	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
24	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	27	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
25	F47047T	Tag for F47047- EDI Invoice Detail (Sales) - Outbound	16	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
26	F47107T	Tag for F47107- EDI Response to RFQ Detail - Outbound	16	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
27	F47147T	Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound	16	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP42B: Sales Order Entry
28	F4011ZT	Batch Receiver File - Order Details Tag	2	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
29	F47012T	EDI Purchase Order Detail Tag - Inbound	2	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
30	F47092T	EDI Request for Quote Detail Tag - Inbound	2	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
31	F47132T	EDI Purchase Order Change Detail Tag - Inbound	2	UZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP45: Advanced Pricing
32	F4572Z1	Live Promotions Interface - Inbound / Outbound	9	LP	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
33	F4572ZP	Purge Live Promotions Interface	9	PG	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP47: Electronic Commerce
34	F47006	EDI Order Header - Outbound Tax Table	2	ST	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
35	F47007	EDI Order Detail - Outbound Tax Table	2	DT	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
36	F47011	EDI Purchase Order Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
37	F47011TX	EDI Purchase Order Header Tax - Inbound	2	ST	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
38	F47012	EDI Purchase Order Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
39	F47012TX	EDI Purchase Order Detail Tax - Inbound	2	DT	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
40	F47013	EDI Purchase Order Detail (SDQ) - Inbound	2	SP	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
41	F47016	EDI Purchase Order Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
42	F470161	EDI Purchase Order Additional Header - Outbound	2	S3	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
43	F47017	EDI Purchase Order Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
44	F470171	EDI Purchase Order Additional Detail - Outbound	2	S4	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
45	F47021	EDI P.O. Acknowledgment Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
46	F47022	EDI P.O. Acknowledgment Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
47	F47026	EDI P.O. Acknowledgment Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
48	F47027	EDI P.O. Acknowledgment Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
49	F47031	EDI Shipping Notice Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
50	F47032	EDI Shipping Notice Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
51	F47036	EDI Shipping Notice Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
52	F47036X	EDI Shipping Notice Header Tax - Outbound	2	ST	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
53	F47037	EDI Shipping Notice Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
54	F470371	EDI Shipping Notice Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
55	F470371X	EDI Shipping Notice Detail Tax - Outbound	2	DT	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
56	F470372	EDI ASN Demand Scheduling Detail	2	AI	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
57	F470373	EDI ASN Shipping	2	AG	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
58	F470374	EDI ASN Demand Addresses	17	AM	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
59	F470375	EDI ASN Packaging Detail	2	AK	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
60	F47041	EDI Invoice Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
61	F47042	EDI Invoice Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
62	F47044	EDI Invoice Summary - Inbound	2	SW	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
63	F47046	EDI Invoice Header (Sales) - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
64	F470461	EDI Invoice Additional Header - Outbound	2	S3	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
65	F470462	EDI Invoice Expanded Header (Sales)	2	S5	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
66	F47047	EDI Invoice Detail (Sales) - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
67	F470471	EDI Invoice Additional Detail - Outbound	2	S4	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
68	F470472	EDI Invoice Expanded Detail (Sales)	2	S6	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
69	F470473	EDI Invoice Detail Charges	2	S7	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
70	F47056	EDI Payment Order Header - Outbound	2	D1	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
71	F470561	EDI Payment Order Bank N & A - Outbound	2	D2	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
72	F470561W	EDI Payment Order Bank N & A - Work	2	D2	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
73	F470562	EDI Payment Order Vendor N & A - Outbound	2	D4	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
74	F470562W	EDI Payment Order Vendor N & A - Work	2	D4	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
75	F470563	EDI Payment Order Payee N & A - Outbound	2	D5	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
76	F470563W	EDI Payment Order Payee N & A - Work	2	D5	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
77	F47056W	EDI Payment Order Header - Work	2	D1	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
78	F47057	EDI Payment Order Remittance Advice - Outbound	2	D3	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
79	F47057W	EDI Payment Order Remittance Advice - Work	2	D3	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
80	F4706	EDI Order Address Information	2	ZA	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
81	F47061	EDI Planning Schedule Header - Inbound	2	MJ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
82	F47062	EDI Planning Schedule Detail - Inbound	2	MY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
83	F47066	EDI Planning Schedule Header - Outbound	2	MJ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
84	F47067	EDI Planning Schedule Detail - Outbound	2	MY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
85	F47071	EDI Receiving Advice Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
86	F47072	EDI Receiving Advice Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
87	F47076	EDI Receiving Advice Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
88	F47077	EDI Receiving Advice Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
89	F47081	EDI Price Sales Catalog Header - Inbound	2	FV	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
90	F47082	EDI Price Sales Catalog Detail - Inbound	2	FY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
91	F47091	EDI Request for Quote Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
92	F47091TX	EDI Request for Quote Header Tax - Inbound	2	ST	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
93	F47092	EDI Request for Quote Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
94	F47093	EDI Request for Quote Detail (SDQ) - Inbound	2	SP	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
95	F47096	EDI Request for Quote Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
96	F47097	EDI Request for Quote Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
97	F47098	EDI RFQ Detail Quantity - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
98	F47101	EDI Response to RFQ Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
99	F47102	EDI Response to RFQ Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
100	F47103	EDI Response to RFQ Detail Quantity - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
101	F47106	EDI Response to RFQ Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
102	F471061	EDI Response to RFQ Additional Header - Outbound	2	S3	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
103	F47107	EDI Response to RFQ Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
104	F471071	EDI Response to RFQ Additional Detail - Outbound	2	S4	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
105	F47111	EDI Lockbox/Payment Header - Transaction	2	Z1	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
106	F47112	EDI Lockbox Header - Transaction	2	Z2	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
107	F47113	EDI Lockbox/Payment Detail - Batch	2	Z3	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
108	F47114	EDI Lockbox/Payment Detail - Payment	2	Z4	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
109	F47121	EDI Product Activity Data Header - Inbound	2	M1	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
110	F47122	EDI Product Activity Data Detail - Inbound	2	MJ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
111	F47123	EDI Product Activity Data (SDQ) - Inbound	2	MK	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
112	F47126	EDI Product Activity Data Header - Outbound	2	M1	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
113	F47127	EDI Product Activity Data Detail - Outbound	2	MJ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
114	F47128	EDI Product Activity Data (SDQ) - Outbound	2	MK	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
115	F47131	EDI Purchase Order Change Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
116	F47131TX	EDI Purchase Order Change Header Tax - Inbound	2	ST	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
117	F47132	EDI Purchase Order Change Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
118	F47132TX	EDI Purchase Order Change Detail Tax - Inbound	2	DT	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
119	F47136	EDI Purchase Order Change Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
120	F47137	EDI Purchase Order Change Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
121	F4714	EDI Order Text Lines - Header	2	ZT	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
122	F47141	EDI P.O. Change Acknowledgment Header - Inbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
123	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
124	F47146	EDI P.O. Change Acknowledgment Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
125	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
126	F4715	EDI Order Text Lines - Detail	2	ZD	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
127	F47156	EDI Shipping Schedule Header - Outbound	2	SY	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
128	F47157	EDI Shipping Schedule Detail - Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
129	F4716	EDI Item Text - Inbound/Outbound	2	SZ	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
130	F47181	EDI Consumption Header (FUTURE)	22	EH	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
131	F47182	EDI Consumption Detail (FUTURE)	31	ED	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
132	F47191	EDI Acknowledgement Header	2	AH	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
133	F47192	EDI Acknowledgement Error Detail	2	AE	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
134	F47194	EDI Acknowledgement References	2	AR	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
135	F47196	EDI Acknowledgement Name And Address	2	AA	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
136	F47198	EDI Acknowledgement Notes	2	AN	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
137	F47CTL	EDI Lockbox/Payment Work File	2	Z5	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP49: Transportation Management
138	F47092TX	EDI Request for Quote Detail Tax - Inbound	2	DT	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP76A: Argentina
139	F76A19Z1	Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A	3	VK	EDSQ	Record Sequence	Numeric	Generic Edit	2	0
TOP79A: Greenhouse Gas Accounting
140	F79A11Z1	GHG Ledger - Batch File	3	GL	EDSQ	Record Sequence	Numeric	Generic Edit	2	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

140 columns | 920 | EDSQ