	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

141 columns | 920 | EDOC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP04: Accounts Payable
1	F04572	A/P Payment Processing - Summary	56	KK	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP40: Inventory/OP Base
2	F4001Z	Batch Receiver File - Order Headings	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
3	F4001ZTX	Recurring Order Header Tax Table	2	RT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
4	F4006Z	Batch Order Receiver - Order Address Information	1	OY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
5	F4011Z	Batch Receiver File - Order Details	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
6	F4011ZTX	Recurring Order Detail Tax Table	2	ZT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
7	F4012Z	Batch Receiver File - Destination Quantity	2	SP	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
8	F4012ZW	WF - Destination Quantity	2	SP	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
9	F4013Z	Kit Components Batch File	1	KS	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP40R: Demand Scheduling
10	F47171	EDI Demand Header	4	EH	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
11	F47172	EDI Demand Detail	4	ED	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
12	F471721	EDI Demand Supplemental Data	4	EU	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
13	F471722	EDI Demand Addresses	4	EA	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
14	F471723	EDI Demand Contact Names	4	EC	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
15	F471724	EDI Demand Contact Numbers	4	EN	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
16	F47173	EDI Demand Scheduling Detail	4	ES	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
17	F471731	EDI Demand Packaging	4	EP	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
18	F47800	EDI Transmission Values	3	FF	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP42: Sales Management
19	F42565	Invoice Print File	72	IW	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
20	F47027T	Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound	14	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
21	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	25	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
22	F47047T	Tag for F47047- EDI Invoice Detail (Sales) - Outbound	14	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
23	F47107T	Tag for F47107- EDI Response to RFQ Detail - Outbound	14	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
24	F47147T	Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound	14	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP42B: Sales Order Entry
25	F4011ZT	Batch Receiver File - Order Details Tag	3	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
26	F47012T	EDI Purchase Order Detail Tag - Inbound	3	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
27	F47092T	EDI Request for Quote Detail Tag - Inbound	3	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
28	F47132T	EDI Purchase Order Change Detail Tag - Inbound	3	UZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP45: Advanced Pricing
29	F4576Z1	Ship and Debit Claims Unedited Transaction Table	102	Z1	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP47: Electronic Commerce
30	F47003	EDI Discrepancy Report Work File	4	SX	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
31	F47006	EDI Order Header - Outbound Tax Table	4	ST	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
32	F47007	EDI Order Detail - Outbound Tax Table	4	DT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
33	F47011	EDI Purchase Order Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
34	F47011TX	EDI Purchase Order Header Tax - Inbound	4	ST	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
35	F47012	EDI Purchase Order Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
36	F47012TX	EDI Purchase Order Detail Tax - Inbound	4	DT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
37	F47013	EDI Purchase Order Detail (SDQ) - Inbound	4	SP	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
38	F47016	EDI Purchase Order Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
39	F470161	EDI Purchase Order Additional Header - Outbound	4	S3	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
40	F47017	EDI Purchase Order Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
41	F470171	EDI Purchase Order Additional Detail - Outbound	4	S4	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
42	F47021	EDI P.O. Acknowledgment Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
43	F47022	EDI P.O. Acknowledgment Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
44	F47026	EDI P.O. Acknowledgment Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
45	F47027	EDI P.O. Acknowledgment Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
46	F47031	EDI Shipping Notice Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
47	F47032	EDI Shipping Notice Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
48	F47032T	EDI Shipping Notice Detail- Inbound Tag	28	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
49	F47036	EDI Shipping Notice Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
50	F47036X	EDI Shipping Notice Header Tax - Outbound	4	ST	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
51	F47037	EDI Shipping Notice Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
52	F470371	EDI Shipping Notice Detail - Outbound	3	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
53	F470371X	EDI Shipping Notice Detail Tax - Outbound	3	DT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
54	F470372	EDI ASN Demand Scheduling Detail	4	AI	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
55	F470373	EDI ASN Shipping	4	AG	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
56	F470374	EDI ASN Demand Addresses	1	AM	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
57	F470375	EDI ASN Packaging Detail	4	AK	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
58	F47041	EDI Invoice Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
59	F47042	EDI Invoice Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
60	F47044	EDI Invoice Summary - Inbound	4	SW	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
61	F47046	EDI Invoice Header (Sales) - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
62	F470461	EDI Invoice Additional Header - Outbound	4	S3	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
63	F470462	EDI Invoice Expanded Header (Sales)	4	S5	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
64	F47047	EDI Invoice Detail (Sales) - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
65	F470471	EDI Invoice Additional Detail - Outbound	4	S4	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
66	F470472	EDI Invoice Expanded Detail (Sales)	4	S6	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
67	F470473	EDI Invoice Detail Charges	4	S7	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
68	F47056	EDI Payment Order Header - Outbound	4	D1	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
69	F470561	EDI Payment Order Bank N & A - Outbound	4	D2	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
70	F470561W	EDI Payment Order Bank N & A - Work	4	D2	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
71	F470562	EDI Payment Order Vendor N & A - Outbound	4	D4	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
72	F470562W	EDI Payment Order Vendor N & A - Work	4	D4	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
73	F470563	EDI Payment Order Payee N & A - Outbound	4	D5	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
74	F470563W	EDI Payment Order Payee N & A - Work	4	D5	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
75	F47056W	EDI Payment Order Header - Work	4	D1	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
76	F47057	EDI Payment Order Remittance Advice - Outbound	4	D3	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
77	F47057W	EDI Payment Order Remittance Advice - Work	4	D3	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
78	F4706	EDI Order Address Information	4	ZA	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
79	F47061	EDI Planning Schedule Header - Inbound	4	MJ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
80	F47062	EDI Planning Schedule Detail - Inbound	4	MY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
81	F47066	EDI Planning Schedule Header - Outbound	4	MJ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
82	F47067	EDI Planning Schedule Detail - Outbound	4	MY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
83	F47071	EDI Receiving Advice Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
84	F47072	EDI Receiving Advice Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
85	F47076	EDI Receiving Advice Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
86	F47077	EDI Receiving Advice Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
87	F47081	EDI Price Sales Catalog Header - Inbound	4	FV	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
88	F47082	EDI Price Sales Catalog Detail - Inbound	4	FY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
89	F47091	EDI Request for Quote Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
90	F47091TX	EDI Request for Quote Header Tax - Inbound	4	ST	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
91	F47092	EDI Request for Quote Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
92	F47093	EDI Request for Quote Detail (SDQ) - Inbound	4	SP	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
93	F47096	EDI Request for Quote Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
94	F47097	EDI Request for Quote Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
95	F47098	EDI RFQ Detail Quantity - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
96	F47101	EDI Response to RFQ Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
97	F47102	EDI Response to RFQ Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
98	F47103	EDI Response to RFQ Detail Quantity - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
99	F47106	EDI Response to RFQ Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
100	F471061	EDI Response to RFQ Additional Header - Outbound	4	S3	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
101	F47107	EDI Response to RFQ Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
102	F471071	EDI Response to RFQ Additional Detail - Outbound	4	S4	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
103	F47111	EDI Lockbox/Payment Header - Transaction	4	Z1	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
104	F47112	EDI Lockbox Header - Transaction	4	Z2	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
105	F47113	EDI Lockbox/Payment Detail - Batch	4	Z3	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
106	F47114	EDI Lockbox/Payment Detail - Payment	4	Z4	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
107	F47121	EDI Product Activity Data Header - Inbound	4	M1	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
108	F47122	EDI Product Activity Data Detail - Inbound	4	MJ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
109	F47123	EDI Product Activity Data (SDQ) - Inbound	4	MK	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
110	F47126	EDI Product Activity Data Header - Outbound	4	M1	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
111	F47127	EDI Product Activity Data Detail - Outbound	4	MJ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
112	F47128	EDI Product Activity Data (SDQ) - Outbound	4	MK	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
113	F47131	EDI Purchase Order Change Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
114	F47131TX	EDI Purchase Order Change Header Tax - Inbound	4	ST	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
115	F47132	EDI Purchase Order Change Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
116	F47132TX	EDI Purchase Order Change Detail Tax - Inbound	4	DT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
117	F47136	EDI Purchase Order Change Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
118	F47137	EDI Purchase Order Change Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
119	F4714	EDI Order Text Lines - Header	4	ZT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
120	F47141	EDI P.O. Change Acknowledgment Header - Inbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
121	F471411	Purchase Order Edit Object Log Table	2	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
122	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
123	F47146	EDI P.O. Change Acknowledgment Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
124	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
125	F4715	EDI Order Text Lines - Detail	4	ZD	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
126	F47156	EDI Shipping Schedule Header - Outbound	4	SY	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
127	F47157	EDI Shipping Schedule Detail - Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
128	F4716	EDI Item Text - Inbound/Outbound	4	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
129	F47181	EDI Consumption Header (FUTURE)	1	EH	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
130	F47182	EDI Consumption Detail (FUTURE)	1	ED	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
131	F47191	EDI Acknowledgement Header	4	AH	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
132	F47192	EDI Acknowledgement Error Detail	4	AE	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
133	F47194	EDI Acknowledgement References	4	AR	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
134	F47196	EDI Acknowledgement Name And Address	4	AA	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
135	F47198	EDI Acknowledgement Notes	4	AN	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
136	F47CTL	EDI Lockbox/Payment Work File	4	Z5	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP49: Transportation Management
137	F47092TX	EDI Request for Quote Detail Tax - Inbound	4	DT	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
138	F47500WF	Inbound Transaction Processor Workfile	2	SZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
139	F49T60	Voucher Cross Reference	1	IV	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
TOP89: Conversion Programs
140	F3294Z	Needed for upgrade from Xe and below	1	AZ	EDOC	EDI - Document Number	Numeric	Generic Edit	9	0
141	F470375T	EDI ASN Packaging Detail Tag Table	1	AK	EDOC	EDI - Document Number	Numeric	Generic Edit	9	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

141 columns | 920 | EDOC