	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

305 columns | 910 | SFXO

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018	Taxes	7	TD	SFXO	Order Suffix	String	Generic Edit	3	0
2	F00189	WF - Tax Reconciliation	7	TG	SFXO	Order Suffix	String	Generic Edit	3	0
3	F004201	Prepayment Transaction Table	4	PT	SFXO	Order Suffix	String	Generic Edit	3	0
TOP02: Electronic Mail
4	F0113	Message Log Ledger File	22	ZZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP03: Accounts Receivable
5	F0311	Accounts Receivable Ledger	84	RP	SFXO	Order Suffix	String	Generic Edit	3	0
TOP03B: Enhanced Accounts Receivable
6	F03B11	Customer Ledger	83	RP	SFXO	Order Suffix	String	Generic Edit	3	0
7	F03B11P	Customer Ledger Purge File	83	RP	SFXO	Order Suffix	String	Generic Edit	3	0
8	F03B11Z1	Batch Invoices	99	VJ	SFXO	Order Suffix	String	Generic Edit	3	0
9	F03B11Z2	F03B11 Interoperability Table	96	SY	SFXO	Order Suffix	String	Generic Edit	3	0
10	F03B14	Receipts Detail	125	RZ	SFXO	Order Suffix	String	Generic Edit	3	0
11	F03B14P	Receipts Detail Purge File	129	RZ	SFXO	Order Suffix	String	Generic Edit	3	0
12	F03B14Z2	F03B14 Interoperability Table	137	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
13	F03B21	A/R Notification History Detail	55	ZS	SFXO	Order Suffix	String	Generic Edit	3	0
14	F03B575	Auto Debit Invoice Select and Build	92	RD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP04: Accounts Payable
15	F0411	Accounts Payable Ledger	66	RP	SFXO	Order Suffix	String	Generic Edit	3	0
16	F0411A	WF - As Of Accounts Payable Ledger	66	RP	SFXO	Order Suffix	String	Generic Edit	3	0
17	F0411P	Purge - Accounts Payable Ledger	66	RP	SFXO	Order Suffix	String	Generic Edit	3	0
18	F0411Z1	Voucher Transactions - Batch Upload	84	VL	SFXO	Order Suffix	String	Generic Edit	3	0
19	F0411Z1T	Voucher Transactions Batch Upload - Voucher Match Automation	8	VT	SFXO	Order Suffix	String	Generic Edit	3	0
20	F0411Z3	F0411 Interoperability Table	89	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
21	F09UI006	Tax (F0018) Replica	7	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP12: Fixed Assets
22	F1217	Equipment Master Extension	23	WR	SFXO	Order Suffix	String	Generic Edit	3	0
23	F1217P	Equipment Master Extension Purge Table	23	WR	SFXO	Order Suffix	String	Generic Edit	3	0
24	F1217Z1	Unedited Equipment Tag Transactions	36	WR	SFXO	Order Suffix	String	Generic Edit	3	0
25	F1217Z2	Unedited Equipment Tag Transactions	36	WR	SFXO	Order Suffix	String	Generic Edit	3	0
TOP17: Customer Service Management
26	F3111Z2	Warranty Claim/Supplier Recovery processing	16	WP	SFXO	Order Suffix	String	Generic Edit	3	0
27	F3112Z2	Warranty Claim/Supplier Recovery processing	16	WL	SFXO	Order Suffix	String	Generic Edit	3	0
28	F4801Z2	Warranty Claim/Supplier Recovery processing	22	WS	SFXO	Order Suffix	String	Generic Edit	3	0
TOP31: Shop Floor Control
29	F3111	Work Order Parts List	3	WM	SFXO	Order Suffix	String	Generic Edit	3	0
30	F3111S	Purge - Shop Floor Parts List	3	WM	SFXO	Order Suffix	String	Generic Edit	3	0
31	F3111Z1	Outbound Work Order Parts List	16	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
32	F3112	Work Order Routing	3	WL	SFXO	Order Suffix	String	Generic Edit	3	0
33	F3112S	Purge Shop Floor Control Routing Instructions	3	WL	SFXO	Order Suffix	String	Generic Edit	3	0
34	F3112Z1	Outbound Work Order Routings	16	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
35	F4802S	Purge Work Order Instructions	3	WB	SFXO	Order Suffix	String	Generic Edit	3	0
TOP31B: Blend Management
36	F31B85	Weigh Tag Master	31	WT	SFXO	Order Suffix	String	Generic Edit	3	0
TOP32: Configuration Management
37	F3201	Configurator Master Table	5	CM	SFXO	Order Suffix	String	Generic Edit	3	0
38	F32019	Configurator Master History Table	5	CH	SFXO	Order Suffix	String	Generic Edit	3	0
TOP34: Requirements Planning
39	F3411	MPS/MRP/DRP Message File	12	MM	SFXO	Order Suffix	String	Generic Edit	3	0
40	F3430	Vendor Schedule Quantity File	6	MV	SFXO	Order Suffix	String	Generic Edit	3	0
41	F3435	Vendor Schedule Commitment File	6	MC	SFXO	Order Suffix	String	Generic Edit	3	0
42	F3440	Vendor Schedule History File	6	MH	SFXO	Order Suffix	String	Generic Edit	3	0
43	F3450	Adhoc Vendor Schedule File	17	MA	SFXO	Order Suffix	String	Generic Edit	3	0
44	F4321	Supplier Schedule Master File	4	PB	SFXO	Order Suffix	String	Generic Edit	3	0
45	F4321T	Supplier Schedule Master Tag File - Used for Upgrade from Xe	4	PB	SFXO	Order Suffix	String	Generic Edit	3	0
TOP34A: Advanced Planning & Scheduling
46	F34A60	Last Outbound Purchase Order/Transfer Order	14	OB	SFXO	Order Suffix	String	Generic Edit	3	0
TOP40: Inventory/OP Base
47	F4001Z	Batch Receiver File - Order Headings	27	SY	SFXO	Order Suffix	String	Generic Edit	3	0
48	F40051	Return Material Authorization	28	RD	SFXO	Order Suffix	String	Generic Edit	3	0
49	F4011Z	Batch Receiver File - Order Details	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
50	F4011Z60	Batch Receiver File - Order Details Commissions	4	DC	SFXO	Order Suffix	String	Generic Edit	3	0
51	F40741	Preference Adjustment History	5	PH	SFXO	Order Suffix	String	Generic Edit	3	0
52	F4080	Related Order Cross Reference Table	9	RO	SFXO	Order Suffix	String	Generic Edit	3	0
53	F40UI00T	Tax Work File	5	PN	SFXO	Order Suffix	String	Generic Edit	3	0
54	F40UI74	Price Adjustment History Work File	10	AW	SFXO	Order Suffix	String	Generic Edit	3	0
55	F4201Z1	Sales Order Header Unedited Transaction File	17	SY	SFXO	Order Suffix	String	Generic Edit	3	0
56	F4209	Held Orders	8	HO	SFXO	Order Suffix	String	Generic Edit	3	0
57	F4211Z1	Sales Order Detail Unedited Transaction File	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
58	F4220	Basic Serial Numbers	15	SW	SFXO	Order Suffix	String	Generic Edit	3	0
TOP40G: Grower Management
59	F40G03	Grower Harvest	115	GH	SFXO	Order Suffix	String	Generic Edit	3	0
60	F40G95	Pay On Proceeds Log File	11	PP	SFXO	Order Suffix	String	Generic Edit	3	0
TOP41: Inventory Management
61	F41291Z	Landed Cost Cache Table	6	IG	SFXO	Order Suffix	String	Generic Edit	3	0
62	F4160	Tag Inventory File	2	IT	SFXO	Order Suffix	String	Generic Edit	3	0
63	F41UI001	Inventory Transactions Detail File	43	IT	SFXO	Order Suffix	String	Generic Edit	3	0
TOP41F: Apparel Management
64	F41F301T	Purchase Order Header Style Items Tag File	4	AP	SFXO	Order Suffix	String	Generic Edit	3	0
65	FCW65	Work Order Header for Style Items	4	OF	SFXO	Order Suffix	String	Generic Edit	3	0
66	FCW67	Style Work Order Parts List	9	WM	SFXO	Order Suffix	String	Generic Edit	3	0
67	FCW68	Style Work Order Routings	4	WL	SFXO	Order Suffix	String	Generic Edit	3	0
68	FCW89	Work Order Inventory Issues for Style Items	5	WM	SFXO	Order Suffix	String	Generic Edit	3	0
TOP42: Sales Management
69	F4074	Price Adjustment Ledger File	4	AL	SFXO	Order Suffix	String	Generic Edit	3	0
70	F42005	Sales Commission File	3	SC	SFXO	Order Suffix	String	Generic Edit	3	0
71	F4201	Sales Order Header File	4	SH	SFXO	Order Suffix	String	Generic Edit	3	0
72	F42019	Sales Order Header History File	4	SH	SFXO	Order Suffix	String	Generic Edit	3	0
73	F4211	Sales Order Detail File	5	SD	SFXO	Order Suffix	String	Generic Edit	3	0
74	F42119	Sales Order History File	5	SD	SFXO	Order Suffix	String	Generic Edit	3	0
75	F42160	Sales Order Detail Commission Information	4	SD	SFXO	Order Suffix	String	Generic Edit	3	0
76	F42199	S.O. Detail Ledger File	5	SL	SFXO	Order Suffix	String	Generic Edit	3	0
77	F42565	Invoice Print File	76	IW	SFXO	Order Suffix	String	Generic Edit	3	0
78	F4290	Delivery Note History	8	SE	SFXO	Order Suffix	String	Generic Edit	3	0
79	F42UI005	Sales Commission File	3	SC	SFXO	Order Suffix	String	Generic Edit	3	0
80	F42UI01	SO Header Cache File (MBF)	9	ZH	SFXO	Order Suffix	String	Generic Edit	3	0
81	F42UI11	SO Detail Cache File (MBF)	9	ZD	SFXO	Order Suffix	String	Generic Edit	3	0
82	F47027T	Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
83	F47047T	Tag for F47047- EDI Invoice Detail (Sales) - Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
84	F47107T	Tag for F47107- EDI Response to RFQ Detail - Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
85	F47147T	Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP42B: Sales Order Entry
86	F4011ZT	Batch Receiver File - Order Details Tag	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
87	F42160Z1	Detail Commission Unedited Transaction File	13	S3	SFXO	Order Suffix	String	Generic Edit	3	0
88	F42420	Audit Log Transaction	14	AL	SFXO	Order Suffix	String	Generic Edit	3	0
89	F47012T	EDI Purchase Order Detail Tag - Inbound	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
90	F47092T	EDI Request for Quote Detail Tag - Inbound	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
91	F47132T	EDI Purchase Order Change Detail Tag - Inbound	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43: Procurement
92	F4301	Purchase Order Header	4	PH	SFXO	Order Suffix	String	Generic Edit	3	0
93	F4301Z	PO Header Work File	8	PA	SFXO	Order Suffix	String	Generic Edit	3	0
94	F4301Z1	Purchase Order Header Unedited Transaction Table	17	SY	SFXO	Order Suffix	String	Generic Edit	3	0
95	F4305	Log Master	6	PL	SFXO	Order Suffix	String	Generic Edit	3	0
96	F43080	Approvals Fields Constants	14	PD	SFXO	Order Suffix	String	Generic Edit	3	0
97	F43092	Purchase Order Receipt Routing File	4	PX	SFXO	Order Suffix	String	Generic Edit	3	0
98	F43092Z	Receipt Routing Work File	9	PV	SFXO	Order Suffix	String	Generic Edit	3	0
99	F43092Z1	Receipt Routing Unedited Transaction Table	17	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
100	F43099	Receipt Routing Ledger File	4	PO	SFXO	Order Suffix	String	Generic Edit	3	0
101	F4310X	CM Purchase Order Cross Reference	5	CM	SFXO	Order Suffix	String	Generic Edit	3	0
102	F4311	Purchase Order Detail File	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
103	F4311T	Purchase Order Detail Tag File	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
104	F4311Z	Purchase Order Generator File	8	PW	SFXO	Order Suffix	String	Generic Edit	3	0
105	F4311Z1	Purchase Order Detail Unedited Transaction Table	17	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
106	F43121	Purchase Order Receiver File	6	PR	SFXO	Order Suffix	String	Generic Edit	3	0
107	F43121T	Purchase Order Receiver Tag File	12	PR	SFXO	Order Suffix	String	Generic Edit	3	0
108	F43121TB	Purchase Order Receiver Tag Table	5	PR	SFXO	Order Suffix	String	Generic Edit	3	0
109	F43121Z	Receiver workfile	5	PW	SFXO	Order Suffix	String	Generic Edit	3	0
110	F43121Z1	Receipts Unedited Transaction Table	23	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
111	F43147	Freight Distribution Workfile	8	FD	SFXO	Order Suffix	String	Generic Edit	3	0
112	F4314Z	Voucher Match Selection File	105	PN	SFXO	Order Suffix	String	Generic Edit	3	0
113	F4316	Purchase Order Multiple Account File	4	P3	SFXO	Order Suffix	String	Generic Edit	3	0
114	F4316T	Purchase Order Multiple Account Tag File	4	P3	SFXO	Order Suffix	String	Generic Edit	3	0
115	F4317	Purchase Order Detail Non-Billable	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
116	F4318	Approval/Rejection Reasons	4	PY	SFXO	Order Suffix	String	Generic Edit	3	0
117	F43199	P.O. Detail Ledger File - Flexible Version	4	OL	SFXO	Order Suffix	String	Generic Edit	3	0
118	F4330	Supplier Selection File	14	P0	SFXO	Order Suffix	String	Generic Edit	3	0
119	F4331	Quantity Breaks File	11	P1	SFXO	Order Suffix	String	Generic Edit	3	0
120	F4332	Multiple Requisition File	14	P2	SFXO	Order Suffix	String	Generic Edit	3	0
121	F4333WF	Purchase Order Dispatch Work File	5	PO	SFXO	Order Suffix	String	Generic Edit	3	0
122	F4343	Purchase Rebate History	7	RH	SFXO	Order Suffix	String	Generic Edit	3	0
123	F43632Z	Open Purchase Order by Item Work File	8	OI	SFXO	Order Suffix	String	Generic Edit	3	0
124	F43UI50C	PO Print Clauses Table	6	WC	SFXO	Order Suffix	String	Generic Edit	3	0
125	F43UI50D	PO Print Detail Work File	6	PW	SFXO	Order Suffix	String	Generic Edit	3	0
126	F43UI50H	PO Print Header Work File	5	PA	SFXO	Order Suffix	String	Generic Edit	3	0
127	F74U0141	ACM - Application / Certificate Master	4	AC	SFXO	Order Suffix	String	Generic Edit	3	0
128	F74U0142	ACM - Application / Certificate Status History	4	DH	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43A: Purchase Order Receipt/Routing
129	F43126	Purchase Order Receiver Multiple Account	5	P4	SFXO	Order Suffix	String	Generic Edit	3	0
130	F43126T	Purchase Order Receiver Multiple Account Tag File	5	P4	SFXO	Order Suffix	String	Generic Edit	3	0
131	F43127	Purchase Order Receiver Non-Billable	5	PR	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43B: Voucher Match and Landed Cost
132	F43146T	Voucher Match Multiple Account Tag File	4	P5	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43E: Requisition Self Service
133	F43E09	F43E09 - Approvals Activity Table	6	AA	SFXO	Order Suffix	String	Generic Edit	3	0
134	F43E11	Requisition Detail	4	RD	SFXO	Order Suffix	String	Generic Edit	3	0
135	F43E121	eRequisition Receiver file	4	ER	SFXO	Order Suffix	String	Generic Edit	3	0
136	F43E16	Requisition Multiple Account File	4	P3	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43S: Supplier Self Service
137	F43001	Procurement Self-Service Transaction Log	10	SA	SFXO	Order Suffix	String	Generic Edit	3	0
138	F4313	POFLIP	5	PF	SFXO	Order Suffix	String	Generic Edit	3	0
TOP44H: Homebuilder Management
139	F4450	Lot Proceed Header (World)	4	JD	SFXO	Order Suffix	String	Generic Edit	3	0
140	F4451	Lot Proceed Detail (World)	7	JF	SFXO	Order Suffix	String	Generic Edit	3	0
141	F4456	Lot Proceed Entry (World)	4	JI	SFXO	Order Suffix	String	Generic Edit	3	0
142	F44H601	Bid Header	4	BH	SFXO	Order Suffix	String	Generic Edit	3	0
143	F44H611	Bid Details	4	BD	SFXO	Order Suffix	String	Generic Edit	3	0
144	F44H611W	Bid Details Work File	5	BW	SFXO	Order Suffix	String	Generic Edit	3	0
145	F44H711	Lot Start Workfile	28	SW	SFXO	Order Suffix	String	Generic Edit	3	0
146	F44H711P	After Start Purchasing	4	TP	SFXO	Order Suffix	String	Generic Edit	3	0
147	F44H711Z	HB Lot Start Unedited Transaction File	41	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
148	F44H71W1	Lot Start Generation Workfile	28	GW	SFXO	Order Suffix	String	Generic Edit	3	0
149	F44H73W1	Lot Start - P.O. / Committment Generation Work File	13	CG	SFXO	Order Suffix	String	Generic Edit	3	0
TOP45: Advanced Pricing
150	F4079	Rebate Transaction Detail	12	SV	SFXO	Order Suffix	String	Generic Edit	3	0
151	F4574	Key Reference Table	57	KR	SFXO	Order Suffix	String	Generic Edit	3	0
152	F4575	Ship and Debit History	5	AH	SFXO	Order Suffix	String	Generic Edit	3	0
153	F4575TMP	Ship and Debit History - Temp Table	5	AH	SFXO	Order Suffix	String	Generic Edit	3	0
154	F4576	Ship and Debit Claims	4	AC	SFXO	Order Suffix	String	Generic Edit	3	0
155	F4576TMP	Ship and Debit Claims- Temp Table	4	AC	SFXO	Order Suffix	String	Generic Edit	3	0
156	F4576Z1	Ship and Debit Claims Unedited Transaction Table	17	Z1	SFXO	Order Suffix	String	Generic Edit	3	0
TOP46: Warehouse Management
157	F4600	Warehouse Requests	10	R1	SFXO	Order Suffix	String	Generic Edit	3	0
158	F4600PU	Warehouse Requests - Purged	10	R1	SFXO	Order Suffix	String	Generic Edit	3	0
159	F4602	Location Detail Information	82	IF	SFXO	Order Suffix	String	Generic Edit	3	0
160	F4611	Warehouse Suggestions	16	R2	SFXO	Order Suffix	String	Generic Edit	3	0
161	F4611PU	Warehouse Suggestions - Purged	16	R2	SFXO	Order Suffix	String	Generic Edit	3	0
162	F4611Z1	Unedited Suggestion Table	29	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
163	F46130	Putaway Reservations	5	R3	SFXO	Order Suffix	String	Generic Edit	3	0
164	F46130PU	Putaway Reservations - Purged	5	R3	SFXO	Order Suffix	String	Generic Edit	3	0
165	F4620	Carton Detail Information	11	CD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP46L: License Plating
166	F46L12	License Plate Commitment	6	LC	SFXO	Order Suffix	String	Generic Edit	3	0
167	F46L99	License Plate History	15	LM	SFXO	Order Suffix	String	Generic Edit	3	0
168	F46LUI01	Assign/Remove Items To LP Work File	29	WF	SFXO	Order Suffix	String	Generic Edit	3	0
TOP47: Electronic Commerce
169	F47006	EDI Order Header - Outbound Tax Table	19	ST	SFXO	Order Suffix	String	Generic Edit	3	0
170	F47007	EDI Order Detail - Outbound Tax Table	20	DT	SFXO	Order Suffix	String	Generic Edit	3	0
171	F47011	EDI Purchase Order Header - Inbound	22	SY	SFXO	Order Suffix	String	Generic Edit	3	0
172	F47011TX	EDI Purchase Order Header Tax - Inbound	18	ST	SFXO	Order Suffix	String	Generic Edit	3	0
173	F47012	EDI Purchase Order Detail - Inbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
174	F4701260	EDI Purchase Order Detail Commission Inbound	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
175	F47012TX	EDI Purchase Order Detail Tax - Inbound	19	DT	SFXO	Order Suffix	String	Generic Edit	3	0
176	F47016	EDI Purchase Order Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
177	F470161	EDI Purchase Order Additional Header - Outbound	12	S3	SFXO	Order Suffix	String	Generic Edit	3	0
178	F47017	EDI Purchase Order Detail - Outbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
179	F470171	EDI Purchase Order Additional Detail - Outbound	12	S4	SFXO	Order Suffix	String	Generic Edit	3	0
180	F47021	EDI P.O. Acknowledgment Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
181	F47022	EDI P.O. Acknowledgment Detail - Inbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
182	F47026	EDI P.O. Acknowledgment Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
183	F47027	EDI P.O. Acknowledgment Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
184	F47031	EDI Shipping Notice Header - Inbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
185	F47032	EDI Shipping Notice Detail - Inbound	21	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
186	F47037	EDI Shipping Notice Detail - Outbound	22	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
187	F470371	EDI Shipping Notice Detail - Outbound	22	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
188	F470371X	EDI Shipping Notice Detail Tax - Outbound	24	DT	SFXO	Order Suffix	String	Generic Edit	3	0
189	F47041	EDI Invoice Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
190	F47042	EDI Invoice Detail - Inbound	20	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
191	F47044	EDI Invoice Summary - Inbound	19	SW	SFXO	Order Suffix	String	Generic Edit	3	0
192	F47046	EDI Invoice Header (Sales) - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
193	F470461	EDI Invoice Additional Header - Outbound	14	S3	SFXO	Order Suffix	String	Generic Edit	3	0
194	F47047	EDI Invoice Detail (Sales) - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
195	F470471	EDI Invoice Additional Detail - Outbound	14	S4	SFXO	Order Suffix	String	Generic Edit	3	0
196	F47057	EDI Payment Order Remittance Advice - Outbound	52	D3	SFXO	Order Suffix	String	Generic Edit	3	0
197	F47057W	EDI Payment Order Remittance Advice - Work	52	D3	SFXO	Order Suffix	String	Generic Edit	3	0
198	F47061	EDI Planning Schedule Header - Inbound	26	MJ	SFXO	Order Suffix	String	Generic Edit	3	0
199	F47066	EDI Planning Schedule Header - Outbound	26	MJ	SFXO	Order Suffix	String	Generic Edit	3	0
200	F47071	EDI Receiving Advice Header - Inbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
201	F47072	EDI Receiving Advice Detail - Inbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
202	F47076	EDI Receiving Advice Header - Outbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
203	F47077	EDI Receiving Advice Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
204	F47091	EDI Request for Quote Header - Inbound	22	SY	SFXO	Order Suffix	String	Generic Edit	3	0
205	F47091TX	EDI Request for Quote Header Tax - Inbound	18	ST	SFXO	Order Suffix	String	Generic Edit	3	0
206	F47092	EDI Request for Quote Detail - Inbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
207	F4709260	EDI Request for Quote Detail Commission - Inbound	4	QD	SFXO	Order Suffix	String	Generic Edit	3	0
208	F47096	EDI Request for Quote Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
209	F47097	EDI Request for Quote Detail - Outbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
210	F47101	EDI Response to RFQ Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
211	F47102	EDI Response to RFQ Detail - Inbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
212	F47106	EDI Response to RFQ Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
213	F471061	EDI Response to RFQ Additional Header - Outbound	14	S3	SFXO	Order Suffix	String	Generic Edit	3	0
214	F47107	EDI Response to RFQ Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
215	F471071	EDI Response to RFQ Additional Detail - Outbound	14	S4	SFXO	Order Suffix	String	Generic Edit	3	0
216	F47131	EDI Purchase Order Change Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
217	F47131TX	EDI Purchase Order Change Header Tax - Inbound	18	ST	SFXO	Order Suffix	String	Generic Edit	3	0
218	F47132	EDI Purchase Order Change Detail - Inbound	20	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
219	F4713260	EDI Purchase Order Change Detail Commission - Inbound	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
220	F47132TX	EDI Purchase Order Change Detail Tax - Inbound	19	DT	SFXO	Order Suffix	String	Generic Edit	3	0
221	F47136	EDI Purchase Order Change Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
222	F47137	EDI Purchase Order Change Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
223	F47141	EDI P.O. Change Acknowledgment Header - Inbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
224	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	20	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
225	F47146	EDI P.O. Change Acknowledgment Header - Outbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
226	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	21	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
227	F47156	EDI Shipping Schedule Header - Outbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
228	F47157	EDI Shipping Schedule Detail - Outbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP48: Work Order Processing
229	F4801	Work Order Master File	3	WA	SFXO	Order Suffix	String	Generic Edit	3	0
230	F4801S	Purge - Work Order Master file	3	WA	SFXO	Order Suffix	String	Generic Edit	3	0
231	F4801Z1	Outbound Work Order Header	22	SY	SFXO	Order Suffix	String	Generic Edit	3	0
232	F4802	Work Order Instructions File	3	WB	SFXO	Order Suffix	String	Generic Edit	3	0
233	F4802H	Work Order Instructions File Header	3	WC	SFXO	Order Suffix	String	Generic Edit	3	0
234	F48UI001	X4801 Master Business Function Workfile	6	WA	SFXO	Order Suffix	String	Generic Edit	3	0
TOP49: Transportation Management
235	F47092TX	EDI Request for Quote Detail Tax - Inbound	19	DT	SFXO	Order Suffix	String	Generic Edit	3	0
236	F49T311	Purchase Order Detail - OTM	4	TP	SFXO	Order Suffix	String	Generic Edit	3	0
TOP53: Change Management
237	F5302	F5302 World Specs	36	DK	SFXO	Order Suffix	String	Generic Edit	3	0
238	F5311	Change Request Details Table	123	DK	SFXO	Order Suffix	String	Generic Edit	3	0
239	F5311Z1	Change Request Details Table Workfile	128	DK	SFXO	Order Suffix	String	Generic Edit	3	0
TOP55: Reserved for Clients
240	F74H1009	Intrastat - Small Transaction Work Table	5	IS	SFXO	Order Suffix	String	Generic Edit	3	0
241	F74P0710	Credit Order History	12	PL	SFXO	Order Suffix	String	Generic Edit	3	0
TOP70: Multi-National Products - obsolete-do not reuse
242	F700018	Generic VAT - Informed Taxes by Report - COMM - 70	5	TE	SFXO	Order Suffix	String	Generic Edit	3	0
TOP74: EMEA Localization
243	F0018T	Intrastat Revision	4	TD	SFXO	Order Suffix	String	Generic Edit	3	0
244	F740018	Intrastat Revision Additional - CZE - 74	4	AI	SFXO	Order Suffix	String	Generic Edit	3	0
245	F740018D	Data extraction ESL - 74	4	DE	SFXO	Order Suffix	String	Generic Edit	3	0
246	F740018O	Original Transaction Detail for Data Extraction	4	OT	SFXO	Order Suffix	String	Generic Edit	3	0
247	F740018T	Tag File F0018 - EMEA - 74	4	TF	SFXO	Order Suffix	String	Generic Edit	3	0
248	F740018W	Data extraction ESL - Workfile - 74	4	DE	SFXO	Order Suffix	String	Generic Edit	3	0
249	F74093	Worktable for Printing IVA Summary - Italy	7	HC	SFXO	Order Suffix	String	Generic Edit	3	0
TOP74S: Spain
250	F74S340	V.A.T. Declaration Mark File - ESP - 00	3	MF	SFXO	Order Suffix	String	Generic Edit	3	0
TOP74U: United Kingdom Localizations
251	F74U0121	CIS PO Transaction Tag File - UK - 04	4	MP	SFXO	Order Suffix	String	Generic Edit	3	0
252	F74U0405	SPC Certificate Holding Table - UK - 43	5	CH	SFXO	Order Suffix	String	Generic Edit	3	0
253	F74U0408	SPC Lower Level Retention - UK - 43	4	LR	SFXO	Order Suffix	String	Generic Edit	3	0
254	F74U0409	SPC Lower Level MCD - UK - 43	4	LM	SFXO	Order Suffix	String	Generic Edit	3	0
255	F74U0420	SPC - Application Master - UK - 43	7	SE	SFXO	Order Suffix	String	Generic Edit	3	0
256	F74U0422	SPC Application/Certificate Cross Reference File - UK - 43	4	AC	SFXO	Order Suffix	String	Generic Edit	3	0
257	F74U0424	SPC Subcontractor Payment Liability - UK - 43	4	PL	SFXO	Order Suffix	String	Generic Edit	3	0
258	F74U0425	SPC - Certificate Master - UK - 43	7	SF	SFXO	Order Suffix	String	Generic Edit	3	0
259	F74U420A	SPC Application Amount Drill Down - UK - 43	5	PA	SFXO	Order Suffix	String	Generic Edit	3	0
260	F74U424A	SPC Subcontractor Accrual Data - UK - 43	4	PL	SFXO	Order Suffix	String	Generic Edit	3	0
261	F74U424W	SPC Subcontractor Accrual Workfile - UK - 43	4	WF	SFXO	Order Suffix	String	Generic Edit	3	0
262	F74U4311	EPM - Purchase Order Tag File - 74U	4	PT	SFXO	Order Suffix	String	Generic Edit	3	0
263	F74U4312	SPC - Purchase Order Additional Information - UK - 43	4	SC	SFXO	Order Suffix	String	Generic Edit	3	0
264	F74U4314	SPC - Purchase Order Retention - UK - 43	4	SD	SFXO	Order Suffix	String	Generic Edit	3	0
265	F74U4316	SPC - Purchase Order Line Additional Information - UK - 43	4	SC	SFXO	Order Suffix	String	Generic Edit	3	0
266	F74U4318	SPC - Purchase Order Line Retention - UK - 43	4	SD	SFXO	Order Suffix	String	Generic Edit	3	0
267	F74U4319	SPC Cumulative Labour Material Split - UK - 43	4	CS	SFXO	Order Suffix	String	Generic Edit	3	0
TOP74Y: Italy - Reporting System Only
268	F74Y018	Intrastat Additional Info for Services - ITA - 00	4	IA	SFXO	Order Suffix	String	Generic Edit	3	0
TOP74Z: Czech Republic
269	F74ZUI02	Czech VAT Report - CZE - 74Z - Work File	11	CZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP75C: China - Reporting System Only
270	F0018CN	China - Transmitted vouchers to JinSui - 04	4	CT	SFXO	Order Suffix	String	Generic Edit	3	0
TOP75I: India
271	F75I008	Purchase Order Receiver Tag File - IND - 43	5	PO	SFXO	Order Suffix	String	Generic Edit	3	0
272	F75I100	TDS Ceritificate Master Maintenance	54	QB	SFXO	Order Suffix	String	Generic Edit	3	0
273	F75I101	TDS Certificate Work Maintenance	54	QB	SFXO	Order Suffix	String	Generic Edit	3	0
274	F75I322	Excise - Work File for F04211 & F4101	5	Q3	SFXO	Order Suffix	String	Generic Edit	3	0
275	F75I322E	Excise - Work File for F04211 & F4101(Based on F75I322)	5	Q3	SFXO	Order Suffix	String	Generic Edit	3	0
276	F75I323	Purchase Order Receiver AR3 Information - IND - 43	5	RA	SFXO	Order Suffix	String	Generic Edit	3	0
277	F75I4074	Price Adj Ledger Tag File - 03B	4	AL	SFXO	Order Suffix	String	Generic Edit	3	0
278	F75I701	Bill of Entry - Header	9	QH	SFXO	Order Suffix	String	Generic Edit	3	0
279	F75I741	Service Tax A/P File - IND - 04	12	ST	SFXO	Order Suffix	String	Generic Edit	3	0
TOP75T: Taiwan
280	F75T004	GUI/VAT Transaction Header - 75T	77	TH	SFXO	Order Suffix	String	Generic Edit	3	0
281	F75T0049	GUI/VAT Transaction Header History - 75T	77	TH	SFXO	Order Suffix	String	Generic Edit	3	0
282	F75T004P	GUI/VAT Transaction Header POS - 75T	74	TH	SFXO	Order Suffix	String	Generic Edit	3	0
283	F75T005	GUI/VAT Transaction Detail - 75T	45	TD	SFXO	Order Suffix	String	Generic Edit	3	0
284	F75T0059	GUI/VAT Transaction Detail History - 75T	45	TD	SFXO	Order Suffix	String	Generic Edit	3	0
285	F75T005P	GUI/VAT Transaction Detail POS - 75T	44	TD	SFXO	Order Suffix	String	Generic Edit	3	0
286	F75T005T	GUI/VAT Transaction Detail Temp - 75T	45	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76A: Argentina
287	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	38	WF	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76B: Brazil - Reporting System Only
288	F7611B	Nota Fiscal Detail - BRA - 42	16	FD	SFXO	Order Suffix	String	Generic Edit	3	0
289	F761BA	AS Fiscal file book - 09	15	FB	SFXO	Order Suffix	String	Generic Edit	3	0
290	F76421	Sales Order Header Tag File - Brazil - 42	4	SI	SFXO	Order Suffix	String	Generic Edit	3	0
291	F76422	Sales Order Detail Tag File - Brazil - 42	4	SJ	SFXO	Order Suffix	String	Generic Edit	3	0
292	F76422UI	Work File for temporary F76422 Records - Brazil - 42	4	WF	SFXO	Order Suffix	String	Generic Edit	3	0
293	F76431	Purchase Order Header Tag File - Brazil - 43	4	PI	SFXO	Order Suffix	String	Generic Edit	3	0
294	F76432	Purchase Order Detail Tag File - Brazil - 43	4	PJ	SFXO	Order Suffix	String	Generic Edit	3	0
295	F76B705	Purchase Order ISS Tax Information - BR - 04	4	IS	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76C: Colombia
296	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	5	CT	SFXO	Order Suffix	String	Generic Edit	3	0
297	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	8	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76E: Ecuador
298	F76E0018	Print Withholding Workfile - EC - 04	6	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP89: Conversion Programs
299	F4074TEM	Price Adjustment Ledger File - Temp for Upgrade	4	AL	SFXO	Order Suffix	String	Generic Edit	3	0
300	F42005A	Sales Commission File - Temporary	3	SC	SFXO	Order Suffix	String	Generic Edit	3	0
301	F4311TA	Temp table for ERP 9.0 upgrade	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
302	F43121TA	ERP 9.0 temp F43121T for upgrade	5	PR	SFXO	Order Suffix	String	Generic Edit	3	0
303	F43199A	Temp F43199 for ERP 9.0 Upgrade	4	OL	SFXO	Order Suffix	String	Generic Edit	3	0
TOPF31: Lean Transactions
304	FF311114	Related Purchase Orders for Lean Pay on Consumption Issues	12	PC	SFXO	Order Suffix	String	Generic Edit	3	0
TOPH90: ONEWORLD TOOLS
305	F01131	PPAT Message Control File	29	ZZ	SFXO	Order Suffix	String	Generic Edit	3	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

305 columns | 910 | SFXO