	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

249 columns | 812 | SFXO

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018	Sales/Use/V.A.T. Tax File	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	Invoice Transactions - Batch File	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	A/R Check Detail File	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 File	84	VL	SFXO	Order Suffix	String	Generic Edit	3	0
19	F0411Z3	F0411 Interoperability Table	89	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
20	F09UI006	Tax (F0018) Replica	7	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP12: Fixed Assets
21	F1217	Equipment Master Extension	23	WR	SFXO	Order Suffix	String	Generic Edit	3	0
22	F1217P	Equipment Master Extension Purge Table	23	WR	SFXO	Order Suffix	String	Generic Edit	3	0
23	F1217Z1	Unedited Equipment Tag Transactions	36	WR	SFXO	Order Suffix	String	Generic Edit	3	0
24	F1217Z2	Unedited Equipment Tag Transactions	36	WR	SFXO	Order Suffix	String	Generic Edit	3	0
TOP17: Customer Service Management
25	F3111Z2	Warranty Claim/Supplier Recovery processing	16	WP	SFXO	Order Suffix	String	Generic Edit	3	0
26	F3112Z2	Warranty Claim/Supplier Recovery processing	16	WL	SFXO	Order Suffix	String	Generic Edit	3	0
27	F4801Z2	Warranty Claim/Supplier Recovery processing	22	WS	SFXO	Order Suffix	String	Generic Edit	3	0
TOP31: Shop Floor Control
28	F3111	Work Order Parts List	3	WM	SFXO	Order Suffix	String	Generic Edit	3	0
29	F3111S	Purge - Shop Floor Parts List	3	WM	SFXO	Order Suffix	String	Generic Edit	3	0
30	F3111Z1	Outbound Work Order Parts List	16	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
31	F3112	Work Order Routing	3	WL	SFXO	Order Suffix	String	Generic Edit	3	0
32	F3112S	Purge Shop Floor Control Routing Instructions	3	WL	SFXO	Order Suffix	String	Generic Edit	3	0
33	F3112Z1	Outbound Work Order Routings	16	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
34	F4801S	Purge - Work Order Master file	3	WA	SFXO	Order Suffix	String	Generic Edit	3	0
35	F4801Z1	Outbound Work Order Header	22	SY	SFXO	Order Suffix	String	Generic Edit	3	0
36	F4802S	Purge Work Order Instructions	3	WB	SFXO	Order Suffix	String	Generic Edit	3	0
TOP31B: Blend Management
37	F31B85	Weigh Tag Master	31	WT	SFXO	Order Suffix	String	Generic Edit	3	0
TOP32: Configuration Management
38	F3201	Configurator Master Table	5	CM	SFXO	Order Suffix	String	Generic Edit	3	0
39	F32019	Configurator Master History Table	5	CH	SFXO	Order Suffix	String	Generic Edit	3	0
TOP34: Requirements Planning
40	F3411	MPS/MRP/DRP Message File	12	MM	SFXO	Order Suffix	String	Generic Edit	3	0
41	F3430	Vendor Schedule Quantity File	6	MV	SFXO	Order Suffix	String	Generic Edit	3	0
42	F3435	Vendor Schedule Commitment File	6	MC	SFXO	Order Suffix	String	Generic Edit	3	0
43	F3440	Vendor Schedule History File	6	MH	SFXO	Order Suffix	String	Generic Edit	3	0
44	F3450	Adhoc Vendor Schedule File	17	MA	SFXO	Order Suffix	String	Generic Edit	3	0
45	F4321	Supplier Schedule Master File	4	PB	SFXO	Order Suffix	String	Generic Edit	3	0
46	F4321T	Supplier Schedule Master Tag File	4	PB	SFXO	Order Suffix	String	Generic Edit	3	0
TOP34A: Advanced Planning & Scheduling
47	F34A60	Last Outbound Purchase Order/Transfer Order	14	OB	SFXO	Order Suffix	String	Generic Edit	3	0
TOP40: Inventory/OP Base
48	F4001Z	Batch Receiver File - Order Headings	27	SY	SFXO	Order Suffix	String	Generic Edit	3	0
49	F40051	Return Material Authorization	28	RD	SFXO	Order Suffix	String	Generic Edit	3	0
50	F4011Z	Batch Receiver File - Order Details	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
51	F4011Z60	Batch Receiver File - Order Details Commissions	4	DC	SFXO	Order Suffix	String	Generic Edit	3	0
52	F40741	Preference Adjustment History	5	PH	SFXO	Order Suffix	String	Generic Edit	3	0
53	F4080	Related Order Cross Reference Table	9	RO	SFXO	Order Suffix	String	Generic Edit	3	0
54	F40UI00T	Tax Work File	5	PN	SFXO	Order Suffix	String	Generic Edit	3	0
55	F40UI74	Price Adjustment History Work File	10	AW	SFXO	Order Suffix	String	Generic Edit	3	0
56	F4201Z1	Sales Order Header Unedited Transaction File	17	SY	SFXO	Order Suffix	String	Generic Edit	3	0
57	F4209	Held Orders	8	HO	SFXO	Order Suffix	String	Generic Edit	3	0
58	F4211Z1	Sales Order Detail Unedited Transaction File	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
59	F4220	Basic Serial Numbers	15	SW	SFXO	Order Suffix	String	Generic Edit	3	0
TOP40G: Grower Management
60	F40G03	Grower Harvest	112	GH	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
TOP42: Sales Management
64	F4074	Price Adjustment Ledger File	4	AL	SFXO	Order Suffix	String	Generic Edit	3	0
65	F42005	Sales Commission File	3	SC	SFXO	Order Suffix	String	Generic Edit	3	0
66	F4201	Sales Order Header File	4	SH	SFXO	Order Suffix	String	Generic Edit	3	0
67	F42019	Sales Order Header History File	4	SH	SFXO	Order Suffix	String	Generic Edit	3	0
68	F4211	Sales Order Detail File	5	SD	SFXO	Order Suffix	String	Generic Edit	3	0
69	F42119	Sales Order History File	5	SD	SFXO	Order Suffix	String	Generic Edit	3	0
70	F42160	Sales Order Detail Commission Information	4	SD	SFXO	Order Suffix	String	Generic Edit	3	0
71	F42199	S.O. Detail Ledger File	5	SL	SFXO	Order Suffix	String	Generic Edit	3	0
72	F42565	Invoice Print File	76	IW	SFXO	Order Suffix	String	Generic Edit	3	0
73	F4290	Delivery Note History	8	SE	SFXO	Order Suffix	String	Generic Edit	3	0
74	F42UI005	Sales Commission File	3	SC	SFXO	Order Suffix	String	Generic Edit	3	0
75	F42UI01	SO Header Cache File (MBF)	9	ZH	SFXO	Order Suffix	String	Generic Edit	3	0
76	F42UI11	SO Detail Cache File (MBF)	9	ZD	SFXO	Order Suffix	String	Generic Edit	3	0
77	F47027T	Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
78	F47047T	Tag for F47047- EDI Invoice Detail (Sales) - Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
79	F47107T	Tag for F47107- EDI Response to RFQ Detail - Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
80	F47147T	Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound	32	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP42B: Sales Order Entry
81	F4011ZT	Batch Receiver File - Order Details Tag	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
82	F42160Z1	Detail Commission Unedited Transaction File	13	S3	SFXO	Order Suffix	String	Generic Edit	3	0
83	F42420	Audit Log Transaction	14	AL	SFXO	Order Suffix	String	Generic Edit	3	0
84	F47012T	EDI Purchase Order Detail Tag - Inbound	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
85	F47092T	EDI Request for Quote Detail Tag - Inbound	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
86	F47132T	EDI Purchase Order Change Detail Tag - Inbound	19	UZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43: Procurement
87	F4301	Purchase Order Header	4	PH	SFXO	Order Suffix	String	Generic Edit	3	0
88	F4301Z	PO Header Work File	8	PA	SFXO	Order Suffix	String	Generic Edit	3	0
89	F4301Z1	Purchase Order Header Unedited Transaction Table	17	SY	SFXO	Order Suffix	String	Generic Edit	3	0
90	F4305	Log Master	6	PL	SFXO	Order Suffix	String	Generic Edit	3	0
91	F43080	Approvals Fields Constants	14	PD	SFXO	Order Suffix	String	Generic Edit	3	0
92	F43092	Purchase Order Receipt Routing File	4	PX	SFXO	Order Suffix	String	Generic Edit	3	0
93	F43092Z	Receipt Routing Work File	9	PV	SFXO	Order Suffix	String	Generic Edit	3	0
94	F43092Z1	Receipt Routing Unedited Transaction Table	17	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
95	F43099	Receipt Routing Ledger File	4	PO	SFXO	Order Suffix	String	Generic Edit	3	0
96	F4311	Purchase Order Detail File	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
97	F4311T	Purchase Order Detail Tag File	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
98	F4311Z	Purchase Order Generator File	8	PW	SFXO	Order Suffix	String	Generic Edit	3	0
99	F4311Z1	Purchase Order Detail Unedited Transaction Table	17	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
100	F43121	Purchase Order Receiver File	6	PR	SFXO	Order Suffix	String	Generic Edit	3	0
101	F43121T	Purchase Order Receiver Tag File	12	PR	SFXO	Order Suffix	String	Generic Edit	3	0
102	F43121TB	Purchase Order Receiver Tag Table	5	PR	SFXO	Order Suffix	String	Generic Edit	3	0
103	F43121Z	Receiver workfile	5	PW	SFXO	Order Suffix	String	Generic Edit	3	0
104	F43121Z1	Receipts Unedited Transaction Table	23	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
105	F4314Z	Voucher Match Selection File	105	PN	SFXO	Order Suffix	String	Generic Edit	3	0
106	F4316	Purchase Order Multiple Account File	4	P3	SFXO	Order Suffix	String	Generic Edit	3	0
107	F4316T	Purchase Order Multiple Account Tag File	4	P3	SFXO	Order Suffix	String	Generic Edit	3	0
108	F4318	Approval/Rejection Reasons	4	PY	SFXO	Order Suffix	String	Generic Edit	3	0
109	F43199	P.O. Detail Ledger File - Flexible Version	4	OL	SFXO	Order Suffix	String	Generic Edit	3	0
110	F4330	Supplier Selection File	14	P0	SFXO	Order Suffix	String	Generic Edit	3	0
111	F4331	Quantity Breaks File	11	P1	SFXO	Order Suffix	String	Generic Edit	3	0
112	F4332	Multiple Requisition File	14	P2	SFXO	Order Suffix	String	Generic Edit	3	0
113	F4333WF	Purchase Order Dispatch Work File	5	PO	SFXO	Order Suffix	String	Generic Edit	3	0
114	F4343	Purchase Rebate History	7	RH	SFXO	Order Suffix	String	Generic Edit	3	0
115	F43632Z	Open Purchase Order by Item Work File	8	OI	SFXO	Order Suffix	String	Generic Edit	3	0
116	F43E09	F43E09 - Approvals Activity Table	6	AA	SFXO	Order Suffix	String	Generic Edit	3	0
117	F43UI50D	PO Print Detail Work File	6	PW	SFXO	Order Suffix	String	Generic Edit	3	0
118	F43UI50H	PO Print Header Work File	5	PA	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43A: Purchase Order Receipt/Routing
119	F43126	Purchase Order Receiver Multiple Account	5	P4	SFXO	Order Suffix	String	Generic Edit	3	0
120	F43126T	Purchase Order Receiver Multiple Account Tag File	5	P4	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43B: Voucher Match and Landed Cost
121	F43146T	Voucher Match Multiple Account Tag File	4	P5	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43E: Requisition Self Service
122	F43E11	Requisition Detail	4	RD	SFXO	Order Suffix	String	Generic Edit	3	0
123	F43E121	eRequisition Receiver file	4	ER	SFXO	Order Suffix	String	Generic Edit	3	0
124	F43E16	Requisition Multiple Account File	4	P3	SFXO	Order Suffix	String	Generic Edit	3	0
TOP43S: Supplier Self Service
125	F43001	Procurement Self-Service Transaction Log	10	SA	SFXO	Order Suffix	String	Generic Edit	3	0
126	F4313	POFLIP	5	PF	SFXO	Order Suffix	String	Generic Edit	3	0
TOP44H: Homebuilder Management
127	F4450	Lot Proceed Header (World)	4	JD	SFXO	Order Suffix	String	Generic Edit	3	0
128	F4451	Lot Proceed Detail (World)	7	JF	SFXO	Order Suffix	String	Generic Edit	3	0
129	F4456	Lot Proceed Entry (World)	4	JI	SFXO	Order Suffix	String	Generic Edit	3	0
130	F44H601	Bid Header	4	BH	SFXO	Order Suffix	String	Generic Edit	3	0
131	F44H611	Bid Details	4	BD	SFXO	Order Suffix	String	Generic Edit	3	0
132	F44H611W	Bid Details Work File	5	BW	SFXO	Order Suffix	String	Generic Edit	3	0
133	F44H711	Lot Start Workfile	28	SW	SFXO	Order Suffix	String	Generic Edit	3	0
134	F44H711P	After Start Purchasing	4	TP	SFXO	Order Suffix	String	Generic Edit	3	0
135	F44H711Z	HB Lot Start Unedited Transaction File	41	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
136	F44H71W1	Lot Start Generation Workfile	28	GW	SFXO	Order Suffix	String	Generic Edit	3	0
137	F44H73W1	Lot Start - P.O. / Committment Generation Work File	13	CG	SFXO	Order Suffix	String	Generic Edit	3	0
TOP45: Advanced Pricing
138	F4079	Rebate Transaction Detail	12	SV	SFXO	Order Suffix	String	Generic Edit	3	0
139	F4574	Key Reference Table	57	KR	SFXO	Order Suffix	String	Generic Edit	3	0
140	F4575	Ship and Debit History	5	AH	SFXO	Order Suffix	String	Generic Edit	3	0
141	F4575TMP	Ship and Debit History - Temp Table	5	AH	SFXO	Order Suffix	String	Generic Edit	3	0
142	F4576	Ship and Debit Claims	4	AC	SFXO	Order Suffix	String	Generic Edit	3	0
143	F4576TMP	Ship and Debit Claims- Temp Table	4	AC	SFXO	Order Suffix	String	Generic Edit	3	0
144	F4576Z1	Ship and Debit Claims Unedited Transaction Table	17	Z1	SFXO	Order Suffix	String	Generic Edit	3	0
TOP46: Warehouse Management
145	F4600	Warehouse Requests	10	R1	SFXO	Order Suffix	String	Generic Edit	3	0
146	F4600PU	Warehouse Requests - Purged	10	R1	SFXO	Order Suffix	String	Generic Edit	3	0
147	F4602	Location Detail Information	82	IF	SFXO	Order Suffix	String	Generic Edit	3	0
148	F4611	Warehouse Suggestions	16	R2	SFXO	Order Suffix	String	Generic Edit	3	0
149	F4611PU	Warehouse Suggestions - Purged	16	R2	SFXO	Order Suffix	String	Generic Edit	3	0
150	F4611Z1	Unedited Suggestion Table	29	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
151	F46130	Putaway Reservations	5	R3	SFXO	Order Suffix	String	Generic Edit	3	0
152	F46130PU	Putaway Reservations - Purged	5	R3	SFXO	Order Suffix	String	Generic Edit	3	0
153	F4620	Carton Detail Information	11	CD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP46L: License Plating
154	F46L12	License Plate Commitment	6	LC	SFXO	Order Suffix	String	Generic Edit	3	0
155	F46L99	License Plate History	15	LM	SFXO	Order Suffix	String	Generic Edit	3	0
156	F46LUI01	Assign/Remove Items To LP Work File	29	WF	SFXO	Order Suffix	String	Generic Edit	3	0
TOP47: Electronic Commerce
157	F47011	EDI Purchase Order Header - Inbound	22	SY	SFXO	Order Suffix	String	Generic Edit	3	0
158	F47012	EDI Purchase Order Detail - Inbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
159	F4701260	EDI Purchase Order Detail Commission Inbound	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
160	F47016	EDI Purchase Order Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
161	F470161	EDI Purchase Order Additional Header - Outbound	12	S3	SFXO	Order Suffix	String	Generic Edit	3	0
162	F47017	EDI Purchase Order Detail - Outbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
163	F470171	EDI Purchase Order Additional Detail - Outbound	12	S4	SFXO	Order Suffix	String	Generic Edit	3	0
164	F47021	EDI P.O. Acknowledgment Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
165	F47022	EDI P.O. Acknowledgment Detail - Inbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
166	F47026	EDI P.O. Acknowledgment Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
167	F47027	EDI P.O. Acknowledgment Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
168	F47031	EDI Shipping Notice Header - Inbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
169	F47032	EDI Shipping Notice Detail - Inbound	21	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
170	F47037	EDI Shipping Notice Detail - Outbound	22	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
171	F470371	EDI Shipping Notice Detail - Outbound	22	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
172	F47041	EDI Invoice Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
173	F47042	EDI Invoice Detail - Inbound	20	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
174	F47044	EDI Invoice Summary - Inbound	19	SW	SFXO	Order Suffix	String	Generic Edit	3	0
175	F47046	EDI Invoice Header (Sales) - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
176	F470461	EDI Invoice Additional Header - Outbound	14	S3	SFXO	Order Suffix	String	Generic Edit	3	0
177	F47047	EDI Invoice Detail (Sales) - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
178	F470471	EDI Invoice Additional Detail - Outbound	14	S4	SFXO	Order Suffix	String	Generic Edit	3	0
179	F47057	EDI Payment Order Remittance Advice - Outbound	52	D3	SFXO	Order Suffix	String	Generic Edit	3	0
180	F47057W	EDI Payment Order Remittance Advice - Work	52	D3	SFXO	Order Suffix	String	Generic Edit	3	0
181	F47061	EDI Planning Schedule Header - Inbound	26	MJ	SFXO	Order Suffix	String	Generic Edit	3	0
182	F47066	EDI Planning Schedule Header - Outbound	26	MJ	SFXO	Order Suffix	String	Generic Edit	3	0
183	F47071	EDI Receiving Advice Header - Inbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
184	F47072	EDI Receiving Advice Detail - Inbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
185	F47076	EDI Receiving Advice Header - Outbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
186	F47077	EDI Receiving Advice Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
187	F47091	EDI Request for Quote Header - Inbound	22	SY	SFXO	Order Suffix	String	Generic Edit	3	0
188	F47092	EDI Request for Quote Detail - Inbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
189	F4709260	EDI Request for Quote Detail Commission - Inbound	4	QD	SFXO	Order Suffix	String	Generic Edit	3	0
190	F47096	EDI Request for Quote Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
191	F47097	EDI Request for Quote Detail - Outbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
192	F47101	EDI Response to RFQ Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
193	F47102	EDI Response to RFQ Detail - Inbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
194	F47106	EDI Response to RFQ Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
195	F471061	EDI Response to RFQ Additional Header - Outbound	14	S3	SFXO	Order Suffix	String	Generic Edit	3	0
196	F47107	EDI Response to RFQ Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
197	F471071	EDI Response to RFQ Additional Detail - Outbound	14	S4	SFXO	Order Suffix	String	Generic Edit	3	0
198	F47131	EDI Purchase Order Change Header - Inbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
199	F47132	EDI Purchase Order Change Detail - Inbound	20	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
200	F4713260	EDI Purchase Order Change Detail Commission - Inbound	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
201	F47136	EDI Purchase Order Change Header - Outbound	19	SY	SFXO	Order Suffix	String	Generic Edit	3	0
202	F47137	EDI Purchase Order Change Detail - Outbound	19	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
203	F47141	EDI P.O. Change Acknowledgment Header - Inbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
204	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	20	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
205	F47146	EDI P.O. Change Acknowledgment Header - Outbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
206	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	21	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
207	F47156	EDI Shipping Schedule Header - Outbound	20	SY	SFXO	Order Suffix	String	Generic Edit	3	0
208	F47157	EDI Shipping Schedule Detail - Outbound	18	SZ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP48: Work Order Processing
209	F4801	Work Order Master File	3	WA	SFXO	Order Suffix	String	Generic Edit	3	0
210	F4802	Work Order Instructions File	3	WB	SFXO	Order Suffix	String	Generic Edit	3	0
211	F4802H	Work Order Instructions File Header	3	WC	SFXO	Order Suffix	String	Generic Edit	3	0
212	F48UI001	X4801 Master Business Function Workfile	6	WA	SFXO	Order Suffix	String	Generic Edit	3	0
TOP53: Change Management
213	F5302	F5302 World Specs	36	DK	SFXO	Order Suffix	String	Generic Edit	3	0
214	F5311	Change Request Details Table	123	DK	SFXO	Order Suffix	String	Generic Edit	3	0
215	F5311Z1	Change Request Details Table Workfile	128	DK	SFXO	Order Suffix	String	Generic Edit	3	0
TOP55: Reserved for Clients
216	F74H1009	Intrastat - Small Transaction Work Table	5	IS	SFXO	Order Suffix	String	Generic Edit	3	0
217	F74P0710	Credit Order History	12	PL	SFXO	Order Suffix	String	Generic Edit	3	0
218	F74U0141	ACM - Application / Certificate Master	4	AC	SFXO	Order Suffix	String	Generic Edit	3	0
219	F74U0142	ACM - Application / Certificate Status History	4	DH	SFXO	Order Suffix	String	Generic Edit	3	0
TOP74: EMEA Localization
220	F0018T	Intrastat Revision	4	TD	SFXO	Order Suffix	String	Generic Edit	3	0
221	F740018	Intrastat Revision Additional - CZE - 74	4	AI	SFXO	Order Suffix	String	Generic Edit	3	0
222	F740018T	Tag File F0018 - EMEA - 74	4	TF	SFXO	Order Suffix	String	Generic Edit	3	0
223	F74093	Workfile for Printing IVA Summary - Italy	7	HC	SFXO	Order Suffix	String	Generic Edit	3	0
TOP74U: United Kingdom Localizations
224	F74U4311	EPM - Purchase Order Tag File - 74U	4	PT	SFXO	Order Suffix	String	Generic Edit	3	0
TOP75C: China - Reporting System Only
225	F0018CN	China - Transmitted vouchers to JinSui	4	CT	SFXO	Order Suffix	String	Generic Edit	3	0
TOP75T: Taiwan
226	F75T004	GUI/VAT Transaction Header - 75T	62	TH	SFXO	Order Suffix	String	Generic Edit	3	0
227	F75T0049	GUI/VAT Transaction Header History - 75T	62	TH	SFXO	Order Suffix	String	Generic Edit	3	0
228	F75T004P	GUI/VAT Transaction Header POS - 75T	62	TH	SFXO	Order Suffix	String	Generic Edit	3	0
229	F75T005	GUI/VAT Transaction Detail - 75T	32	TD	SFXO	Order Suffix	String	Generic Edit	3	0
230	F75T0059	GUI/VAT Transaction Detail History - 75T	32	TD	SFXO	Order Suffix	String	Generic Edit	3	0
231	F75T005P	GUI/VAT Transaction Detail POS - 75T	32	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76A: Argentina
232	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	38	WF	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76B: Brazil - Reporting System Only
233	F7611B	Nota Fiscal Detail - Brazil	16	FD	SFXO	Order Suffix	String	Generic Edit	3	0
234	F761BA	AS Fiscal file book	15	FB	SFXO	Order Suffix	String	Generic Edit	3	0
235	F76421	Sales Order Header Tag File - Brazil	4	SI	SFXO	Order Suffix	String	Generic Edit	3	0
236	F76422	Sales Order Detail Tag File - Brazil	4	SJ	SFXO	Order Suffix	String	Generic Edit	3	0
237	F76422UI	Work File for temporary F76422 Records - Brazil	4	WF	SFXO	Order Suffix	String	Generic Edit	3	0
238	F76431	Purchase Order Header Tag File - Brazil	4	PI	SFXO	Order Suffix	String	Generic Edit	3	0
239	F76432	Purchase Order Detail Tag File - Brazil	4	PJ	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76C: Colombia
240	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	5	CT	SFXO	Order Suffix	String	Generic Edit	3	0
241	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	8	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP76E: Ecuador
242	F76E0018	Print Withholding Workfile - EC - 04	6	TD	SFXO	Order Suffix	String	Generic Edit	3	0
TOP89: Conversion Programs
243	F4074TEM	Price Adjustment Ledger File - Temp for Upgrade	4	AL	SFXO	Order Suffix	String	Generic Edit	3	0
244	F42005A	Sales Commission File - Temporary	3	SC	SFXO	Order Suffix	String	Generic Edit	3	0
245	F4311TA	Temp table for ERP 9.0 upgrade	4	PD	SFXO	Order Suffix	String	Generic Edit	3	0
246	F43121TA	ERP 9.0 temp F43121T for upgrade	5	PR	SFXO	Order Suffix	String	Generic Edit	3	0
247	F43199A	Temp F43199 for ERP 9.0 Upgrade	4	OL	SFXO	Order Suffix	String	Generic Edit	3	0
TOPF31: Lean Transactions
248	FF311114	Related Purchase Orders for Lean Pay on Consumption Issues	12	PC	SFXO	Order Suffix	String	Generic Edit	3	0
TOPH90: ONEWORLD TOOLS
249	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

249 columns | 812 | SFXO