	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

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

126 columns | 812 | EDOC