	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

321 columns | 910 | SUB

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0012	Automatic Accounting Instructions Master	5	KG	SUB	Subsidiary	String	Generic Edit	8	0
2	F0018	Taxes	4	TD	SUB	Subsidiary	String	Generic Edit	8	0
3	F00189	WF - Tax Reconciliation	4	TG	SUB	Subsidiary	String	Generic Edit	8	0
4	F0902	Account Balances	33	GB	SUB	Subsidiary	String	Generic Edit	8	0
5	F0911	Account Ledger	19	GL	SUB	Subsidiary	String	Generic Edit	8	0
6	F5301	Change Request Master Table	18	DI	SUB	Subsidiary	String	Generic Edit	8	0
TOP03: Accounts Receivable
7	F0311	Accounts Receivable Ledger	51	RP	SUB	Subsidiary	String	Generic Edit	8	0
TOP03B: Enhanced Accounts Receivable
8	F03B11	Customer Ledger	52	RP	SUB	Subsidiary	String	Generic Edit	8	0
9	F03B11P	Customer Ledger Purge File	52	RP	SUB	Subsidiary	String	Generic Edit	8	0
10	F03B11Z1	Batch Invoices	69	VJ	SUB	Subsidiary	String	Generic Edit	8	0
11	F03B11Z2	F03B11 Interoperability Table	65	SY	SUB	Subsidiary	String	Generic Edit	8	0
12	F03B575	Auto Debit Invoice Select and Build	61	RD	SUB	Subsidiary	String	Generic Edit	8	0
13	F09UI011	Receipt Prepost Work File	14	GL	SUB	Subsidiary	String	Generic Edit	8	0
TOP04: Accounts Payable
14	F0411	Accounts Payable Ledger	50	RP	SUB	Subsidiary	String	Generic Edit	8	0
15	F0411A	WF - As Of Accounts Payable Ledger	50	RP	SUB	Subsidiary	String	Generic Edit	8	0
16	F0411P	Purge - Accounts Payable Ledger	50	RP	SUB	Subsidiary	String	Generic Edit	8	0
17	F0411Z1	Voucher Transactions - Batch Upload	68	VL	SUB	Subsidiary	String	Generic Edit	8	0
18	F0411Z3	F0411 Interoperability Table	73	SZ	SUB	Subsidiary	String	Generic Edit	8	0
19	F09UI005	Tax Offsets User Index	9	GL	SUB	Subsidiary	String	Generic Edit	8	0
20	F09UI006	Tax (F0018) Replica	4	TD	SUB	Subsidiary	String	Generic Edit	8	0
TOP05: Time Accounting and HRM Base
21	F06106	Employee Pay Instructions	16	YM	SUB	Subsidiary	String	Generic Edit	8	0
22	F0618	Employee Transaction History	12	YT	SUB	Subsidiary	String	Generic Edit	8	0
TOP05T: Time Entry
23	F06116	Employee Transaction Detail File	12	YT	SUB	Subsidiary	String	Generic Edit	8	0
24	F06116Z1	Employee Transactions - Batch File	29	VL	SUB	Subsidiary	String	Generic Edit	8	0
25	F06116Z2	ESS Timecard History	29	VM	SUB	Subsidiary	String	Generic Edit	8	0
26	F0624	Burden Distribution File	10	J#	SUB	Subsidiary	String	Generic Edit	8	0
27	F06241	Burden Distribution File	10	J#	SUB	Subsidiary	String	Generic Edit	8	0
28	F06278	Retro Timecard Detail File	15	YT	SUB	Subsidiary	String	Generic Edit	8	0
29	F06290	Payroll Accounting Journal Work File	6	YR	SUB	Subsidiary	String	Generic Edit	8	0
30	F063951	Payroll Journal (Compressed) File	24	GL	SUB	Subsidiary	String	Generic Edit	8	0
31	F06904	Automatic Accounting Instructions	9	Y#	SUB	Subsidiary	String	Generic Edit	8	0
32	F069136	Tip Disbursement	12	JE	SUB	Subsidiary	String	Generic Edit	8	0
TOP06: Payroll (old) - Obsolete-do not reuse
33	F069096	Payroll General Constants	15	YK	SUB	Subsidiary	String	Generic Edit	8	0
TOP07: Payroll
34	F05290	WF - Payroll Journal (Detail)	24	JR	SUB	Subsidiary	String	Generic Edit	8	0
35	F06490	Payroll/Accounts Payable Ledger Detail	21	JR	SUB	Subsidiary	String	Generic Edit	8	0
36	F06491	Payroll/Accounts Payable Ledger Detail	14	J6	SUB	Subsidiary	String	Generic Edit	8	0
37	F0724	Burden Distribution File	13	YS	SUB	Subsidiary	String	Generic Edit	8	0
38	F07241	Burden Distribution File	13	YS	SUB	Subsidiary	String	Generic Edit	8	0
39	F07490	Payroll - Accounts Payable Detail (One World)	21	JR	SUB	Subsidiary	String	Generic Edit	8	0
40	F07491	Payroll - Accounts Payable Summary File	14	J6	SUB	Subsidiary	String	Generic Edit	8	0
41	F07UI200	Timecard History Work File	15	TH	SUB	Subsidiary	String	Generic Edit	8	0
TOP08AD: ADP Integration
42	F051371	ADP Employee DBA Instructions	21	AD	SUB	Subsidiary	String	Generic Edit	8	0
TOP09: General Accounting
43	F0901	Account Master	5	GM	SUB	Subsidiary	String	Generic Edit	8	0
44	F0902B	Account Balances - 52 Period Accounting	73	GB	SUB	Subsidiary	String	Generic Edit	8	0
45	F0902P	Purge - Account Balances	33	GB	SUB	Subsidiary	String	Generic Edit	8	0
46	F0902Z1	Account Balances - Batch File	36	GB	SUB	Subsidiary	String	Generic Edit	8	0
47	F0911P	Purge - Account Ledger	19	GL	SUB	Subsidiary	String	Generic Edit	8	0
48	F0911R	WF - Account Ledger Reconciliation	19	GL	SUB	Subsidiary	String	Generic Edit	8	0
49	F0911Z1	Journal Entry Transactions - Batch File	36	VN	SUB	Subsidiary	String	Generic Edit	8	0
50	F0911Z4	F0911 Interoperability Table	41	SZ	SUB	Subsidiary	String	Generic Edit	8	0
51	F0912A	Index Computation Entry File	45	RI	SUB	Subsidiary	String	Generic Edit	8	0
52	F092181	Online Consolidation Detail File	3	LR	SUB	Subsidiary	String	Generic Edit	8	0
53	F09522	Cash Forecast Data	13	FD	SUB	Subsidiary	String	Generic Edit	8	0
54	F09525	Cash Forecast Bank Accounts	5	FB	SUB	Subsidiary	String	Generic Edit	8	0
55	F09622	Transaction Type Cross Reference	6	TT	SUB	Subsidiary	String	Generic Edit	8	0
56	F09UI004	Variable Numerator Allocations work file	11	R#	SUB	Subsidiary	String	Generic Edit	8	0
57	F09UI008	Global Business Unit Change	7	GM	SUB	Subsidiary	String	Generic Edit	8	0
58	F09UI010	WorkFile for R097011	8	WF	SUB	Subsidiary	String	Generic Edit	8	0
59	F09UI014	Annual Close Work Table	4	GB	SUB	Subsidiary	String	Generic Edit	8	0
60	F09UI015	Indexed Computations Multi-Tiered Entries	19	GL	SUB	Subsidiary	String	Generic Edit	8	0
61	F09UI016	Account Balance Compare Exceptions	20	GW	SUB	Subsidiary	String	Generic Edit	8	0
62	F09UI017	Cash Forecast Detail	21	FW	SUB	Subsidiary	String	Generic Edit	8	0
63	F09UI123	Advanced Variable Numerator Worktable	6	VW	SUB	Subsidiary	String	Generic Edit	8	0
64	F48S82	Burden Base Rules	12	BR	SUB	Subsidiary	String	Generic Edit	8	0
65	F52G02	Burdening Summarized Ledger	46	BS	SUB	Subsidiary	String	Generic Edit	8	0
66	F52G11	Burdening Detail Ledger	12	BD	SUB	Subsidiary	String	Generic Edit	8	0
67	F52G11WF	Temporary Burdened Detail Ledger Workfile	12	BW	SUB	Subsidiary	String	Generic Edit	8	0
68	F52G60	Burden Rate Calculations Workfile	31	BW	SUB	Subsidiary	String	Generic Edit	8	0
69	F70UI001	Work File for G/L by Cat. Code Localization	17	WA	SUB	Subsidiary	String	Generic Edit	8	0
70	F740911	Work File for G/L Report by Category Code Localization	20	WA	SUB	Subsidiary	String	Generic Edit	8	0
TOP09E: Expense Reimbursment
71	F20106	Account Mapping Definition	4	EM	SUB	Subsidiary	String	Generic Edit	8	0
TOP10: Financial Reporting
72	F1002	Multi-Site Consolidation Transfer File	9	GQ	SUB	Subsidiary	String	Generic Edit	8	0
73	F1002Z1	Unedited MSC Interoperability Table	18	SZ	SUB	Subsidiary	String	Generic Edit	8	0
74	F1003	Multi-Site Consolidation Transfer File - Category Codes	8	GR	SUB	Subsidiary	String	Generic Edit	8	0
75	F10430	Multi-Site Consolidation - Account Structure	4	CF	SUB	Subsidiary	String	Generic Edit	8	0
76	F10471	Elimination Rules (OW)	7	ER	SUB	Subsidiary	String	Generic Edit	8	0
77	F10909	Object/Subsidiary Control Table	3	G1	SUB	Subsidiary	String	Generic Edit	8	0
78	F10UI001	Account Structure Build Workfile	5	CF	SUB	Subsidiary	String	Generic Edit	8	0
79	F10UI006	MSC - F1002 Elimination Work File	8	GE	SUB	Subsidiary	String	Generic Edit	8	0
TOP11: Multi Currency
80	F1114	Company Conversions Parameter File	27	C2	SUB	Subsidiary	String	Generic Edit	8	0
TOP12: Fixed Assets
81	F1202	Asset Account Balances File	33	FL	SUB	Subsidiary	String	Generic Edit	8	0
82	F1202P	Asset Account Balances Purge Table	33	FL	SUB	Subsidiary	String	Generic Edit	8	0
83	F1204	Location Tracking Table	17	FM	SUB	Subsidiary	String	Generic Edit	8	0
84	F1204P	Location Tracking Purge Table	17	FM	SUB	Subsidiary	String	Generic Edit	8	0
85	F12141	Disposal Account Rule Table	7	DT	SUB	Subsidiary	String	Generic Edit	8	0
TOP13: Plant/Equipment Management
86	F1304	Equipment Location Billing	8	FN	SUB	Subsidiary	String	Generic Edit	8	0
87	F1305	Equipment Distribution Rules	8	FV	SUB	Subsidiary	String	Generic Edit	8	0
TOP13E: Equipment Cost Analysis
88	F1383	Equipment Analysis Costs	20	EC	SUB	Subsidiary	String	Generic Edit	8	0
89	F1385	Equipment Analysis Rules	6	ER	SUB	Subsidiary	String	Generic Edit	8	0
TOP14: Modeling - Planning & Budgeting
90	F1403	Forecast Basis	6	BD	SUB	Subsidiary	String	Generic Edit	8	0
91	F1404	Forecast Results - Header	6	BY	SUB	Subsidiary	String	Generic Edit	8	0
92	F14041	Forecast Results - Detail	6	BZ	SUB	Subsidiary	String	Generic Edit	8	0
TOP15: Property Management
93	F1511	Tenant/Lease Billings Detail	14	NJ	SUB	Subsidiary	String	Generic Edit	8	0
94	F15110B	Expense Participation Class Account	8	OB	SUB	Subsidiary	String	Generic Edit	8	0
95	F1511B	Lease Billings Master	14	NJ	SUB	Subsidiary	String	Generic Edit	8	0
96	F1511H	Tenant/Lease Billings Detail History	14	N#	SUB	Subsidiary	String	Generic Edit	8	0
97	F1511HB	Lease Billings History	14	NC	SUB	Subsidiary	String	Generic Edit	8	0
98	F151521	Lease E.P. Accounts Not Subject to Cap	7	LO	SUB	Subsidiary	String	Generic Edit	8	0
99	F15153	Lease Cap History	9	LC	SUB	Subsidiary	String	Generic Edit	8	0
100	F15199W	G/L Transaction Summarization Work File	8	NB	SUB	Subsidiary	String	Generic Edit	8	0
101	F1530	Expense Participation Class Master	5	NG	SUB	Subsidiary	String	Generic Edit	8	0
102	F15301	E.P. Class Account Overrides	4	AO	SUB	Subsidiary	String	Generic Edit	8	0
103	F15303	E.P. Class Expenses History	6	CH	SUB	Subsidiary	String	Generic Edit	8	0
104	F1531	Expense Participation Class Adjustment	20	OM	SUB	Subsidiary	String	Generic Edit	8	0
105	F1532B	Expense Participation Audit File	9	NT	SUB	Subsidiary	String	Generic Edit	8	0
106	F1533B	Tenant Account Exclusions	51	NM	SUB	Subsidiary	String	Generic Edit	8	0
107	F1538B1	Occupancy Gross Up Audit	9	GU	SUB	Subsidiary	String	Generic Edit	8	0
108	F1538B2	Exclusion/Redistribution	5	RD	SUB	Subsidiary	String	Generic Edit	8	0
109	F1539A	EP Billing Account Adjustments Audit	21	AU	SUB	Subsidiary	String	Generic Edit	8	0
110	F1539C	EP Billing Class Adjustments Audit File	17	AU	SUB	Subsidiary	String	Generic Edit	8	0
111	F1539E	EP Billing Account Exclusions Audit	22	AU	SUB	Subsidiary	String	Generic Edit	8	0
112	F1539FC	EP Billing Adj Factor EP Class Audit	15	AU	SUB	Subsidiary	String	Generic Edit	8	0
113	F1539FL	EP Billing Adj Factor Lease Audit	21	AU	SUB	Subsidiary	String	Generic Edit	8	0
TOP15L: Adv Real Estate Forecasting
114	F15L108	AREF Base Account Definition	8	AD	SUB	Subsidiary	String	Generic Edit	8	0
115	F15L109	AREF Budget Results	23	BR	SUB	Subsidiary	String	Generic Edit	8	0
116	F15L110	AREF Account Status	35	AS	SUB	Subsidiary	String	Generic Edit	8	0
TOP16: Profit Management (EPS)
117	F1602	Cost Analyzer Balances	54	CB	SUB	Subsidiary	String	Generic Edit	8	0
118	F1602Z1	External Cost Analyzer Balances - Interoperability Table	76	CZ	SUB	Subsidiary	String	Generic Edit	8	0
119	F1603	Cost Analyzer View Structure	19	CV	SUB	Subsidiary	String	Generic Edit	8	0
120	F1610	Cost Calculation Definitions	17	CD	SUB	Subsidiary	String	Generic Edit	8	0
TOP17: Customer Service Management
121	F1721	Contract Detail	20	CD	SUB	Subsidiary	String	Generic Edit	8	0
122	F3111Z2	Warranty Claim/Supplier Recovery processing	68	WP	SUB	Subsidiary	String	Generic Edit	8	0
123	F3112Z2	Warranty Claim/Supplier Recovery processing	74	WL	SUB	Subsidiary	String	Generic Edit	8	0
124	F4801Z2	Warranty Claim/Supplier Recovery processing	40	WS	SUB	Subsidiary	String	Generic Edit	8	0
TOP17C: Call Management
125	F1755	Case Master	101	ZA	SUB	Subsidiary	String	Generic Edit	8	0
126	F1760	Time Entry	19	ZB	SUB	Subsidiary	String	Generic Edit	8	0
127	F1797	S/WM Address Book Information	22	CS	SUB	Subsidiary	String	Generic Edit	8	0
TOP18: Resource Scheduling
128	F186602	Labor Rules Tag File	26	TF	SUB	Subsidiary	String	Generic Edit	8	0
TOP30: Product Data Management
129	F300211	Lean Multi Level Bill of Material Detail	77	ED	SUB	Subsidiary	String	Generic Edit	8	0
130	F3002Z1	Bill of Material Transaction File	71	SZ	SUB	Subsidiary	String	Generic Edit	8	0
131	F300311	Lean Multi-Level Routing Detail File	39	EH	SUB	Subsidiary	String	Generic Edit	8	0
132	F3003Z1	Routing Transactions File	55	SZ	SUB	Subsidiary	String	Generic Edit	8	0
TOP31: Shop Floor Control
133	F3111	Work Order Parts List	55	WM	SUB	Subsidiary	String	Generic Edit	8	0
134	F3111S	Purge - Shop Floor Parts List	55	WM	SUB	Subsidiary	String	Generic Edit	8	0
135	F3111Z1	Outbound Work Order Parts List	68	SZ	SUB	Subsidiary	String	Generic Edit	8	0
136	F3112	Work Order Routing	62	WL	SUB	Subsidiary	String	Generic Edit	8	0
137	F3112S	Purge Shop Floor Control Routing Instructions	62	WL	SUB	Subsidiary	String	Generic Edit	8	0
138	F3112Z1	Outbound Work Order Routings	74	SZ	SUB	Subsidiary	String	Generic Edit	8	0
139	F31UI427	Labor Variance User Index	5	W1	SUB	Subsidiary	String	Generic Edit	8	0
140	F31UI802	Accumulate Amounts by Account	7	WG	SUB	Subsidiary	String	Generic Edit	8	0
141	F31UI803	Work File for Summarizing Journal Entries	7	SG	SUB	Subsidiary	String	Generic Edit	8	0
TOP31B: Blend Management
142	F31BAAI	Blend Automatic Accounting Instructions	10	BL	SUB	Subsidiary	String	Generic Edit	8	0
TOP40: Inventory/OP Base
143	F3002	Bill of Material Master File	58	IX	SUB	Subsidiary	String	Generic Edit	8	0
144	F3003	Routing Master File	42	IR	SUB	Subsidiary	String	Generic Edit	8	0
145	F3011	Bill of Materials Change File	58	IZ	SUB	Subsidiary	String	Generic Edit	8	0
146	F4011Z	Batch Receiver File - Order Details	196	SZ	SUB	Subsidiary	String	Generic Edit	8	0
147	F40243	Commodity Relationship	3	CR	SUB	Subsidiary	String	Generic Edit	8	0
148	F40551	G/L Account and Commodity Structure Relationship	3	GL	SUB	Subsidiary	String	Generic Edit	8	0
149	F4080	Related Order Cross Reference Table	15	RO	SUB	Subsidiary	String	Generic Edit	8	0
150	F4095	Distribution/Manufacturing - AAI Values	9	ML	SUB	Subsidiary	String	Generic Edit	8	0
151	F49211	Sales Order Detail File - Tag File	107	UD	SUB	Subsidiary	String	Generic Edit	8	0
152	F49211Z1	Sales Order Detail Tag Unedited Transaction File	126	S1	SUB	Subsidiary	String	Generic Edit	8	0
153	F49219	Sales Order Detail - Tag History File	84	UD	SUB	Subsidiary	String	Generic Edit	8	0
TOP41: Inventory Management
154	F4111	Item Ledger File	54	IL	SUB	Subsidiary	String	Generic Edit	8	0
TOP41F: Apparel Management
155	FCW65	Work Order Header for Style Items	22	OF	SUB	Subsidiary	String	Generic Edit	8	0
156	FCW67	Style Work Order Parts List	62	WM	SUB	Subsidiary	String	Generic Edit	8	0
157	FCW68	Style Work Order Routings	66	WL	SUB	Subsidiary	String	Generic Edit	8	0
TOP42: Sales Management
158	F42800G1	Sales Update G Batch Detail Workfile	15	DG	SUB	Subsidiary	String	Generic Edit	8	0
159	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	77	UZ	SUB	Subsidiary	String	Generic Edit	8	0
TOP42B: Sales Order Entry
160	F49299	S.O. Detail Tag Ledger File	107	UD	SUB	Subsidiary	String	Generic Edit	8	0
TOP43: Procurement
161	F40910	Commitment Integrity Report Work File	12	P#	SUB	Subsidiary	String	Generic Edit	8	0
162	F4095TEM	F4095 Temporary Table	9	ML	SUB	Subsidiary	String	Generic Edit	8	0
163	F43080	Approvals Fields Constants	131	PD	SUB	Subsidiary	String	Generic Edit	8	0
164	F4311	Purchase Order Detail File	129	PD	SUB	Subsidiary	String	Generic Edit	8	0
165	F4311Z	Purchase Order Generator File	133	PW	SUB	Subsidiary	String	Generic Edit	8	0
166	F4311Z1	Purchase Order Detail Unedited Transaction Table	142	SZ	SUB	Subsidiary	String	Generic Edit	8	0
167	F43121	Purchase Order Receiver File	51	PR	SUB	Subsidiary	String	Generic Edit	8	0
168	F43121Z1	Receipts Unedited Transaction Table	68	SZ	SUB	Subsidiary	String	Generic Edit	8	0
169	F43147	Freight Distribution Workfile	24	FD	SUB	Subsidiary	String	Generic Edit	8	0
170	F4314Z	Voucher Match Selection File	151	PN	SUB	Subsidiary	String	Generic Edit	8	0
171	F4316	Purchase Order Multiple Account File	10	P3	SUB	Subsidiary	String	Generic Edit	8	0
172	F4316M	Model Purchase Order Multiple Account File	5	P4	SUB	Subsidiary	String	Generic Edit	8	0
173	F43199	P.O. Detail Ledger File - Flexible Version	129	OL	SUB	Subsidiary	String	Generic Edit	8	0
174	F4342	Purchase Inclusion Rules	6	RK	SUB	Subsidiary	String	Generic Edit	8	0
175	F4343	Purchase Rebate History	14	RH	SUB	Subsidiary	String	Generic Edit	8	0
176	F43UI50D	PO Print Detail Work File	39	PW	SUB	Subsidiary	String	Generic Edit	8	0
TOP43A: Purchase Order Receipt/Routing
177	F43126	Purchase Order Receiver Multiple Account	13	P4	SUB	Subsidiary	String	Generic Edit	8	0
TOP43E: Requisition Self Service
178	F43E16	Requisition Multiple Account File	11	P3	SUB	Subsidiary	String	Generic Edit	8	0
TOP43Q: Strategic Sourcing
179	F43Q11	Event Detail	16	ED	SUB	Subsidiary	String	Generic Edit	8	0
TOP44H: Homebuilder Management
180	F4450	Lot Proceed Header (World)	36	JD	SUB	Subsidiary	String	Generic Edit	8	0
181	F4456	Lot Proceed Entry (World)	36	JI	SUB	Subsidiary	String	Generic Edit	8	0
182	F4457	Takeoff File (World)	10	JJ	SUB	Subsidiary	String	Generic Edit	8	0
183	F4458	Takeoff (World)	10	JK	SUB	Subsidiary	String	Generic Edit	8	0
184	F44H201	Lot Master	108	LM	SUB	Subsidiary	String	Generic Edit	8	0
185	F44H201H	Lot Master History	109	LM	SUB	Subsidiary	String	Generic Edit	8	0
186	F44H201Z	HB Lot Master Unedited Transaction File	121	SZ	SUB	Subsidiary	String	Generic Edit	8	0
187	F44H590	Closing Worksheet Accounting Instructions	7	CI	SUB	Subsidiary	String	Generic Edit	8	0
188	F44H591	Closing Worksheet Entries	10	CW	SUB	Subsidiary	String	Generic Edit	8	0
189	F44H602	Takeoff Master File	8	TO	SUB	Subsidiary	String	Generic Edit	8	0
190	F44H602H	Takeoff History File	9	TH	SUB	Subsidiary	String	Generic Edit	8	0
191	F44H602W	Take Off Summary Workfile	8	TS	SUB	Subsidiary	String	Generic Edit	8	0
192	F44H611	Bid Details	12	BD	SUB	Subsidiary	String	Generic Edit	8	0
193	F44H611W	Bid Details Work File	16	BW	SUB	Subsidiary	String	Generic Edit	8	0
194	F44H711	Lot Start Workfile	3	SW	SUB	Subsidiary	String	Generic Edit	8	0
195	F44H711P	After Start Purchasing	13	TP	SUB	Subsidiary	String	Generic Edit	8	0
196	F44H711Z	HB Lot Start Unedited Transaction File	16	SZ	SUB	Subsidiary	String	Generic Edit	8	0
197	F44H712	Lot Start Workfile Takeoff Detail	3	ST	SUB	Subsidiary	String	Generic Edit	8	0
198	F44H71W1	Lot Start Generation Workfile	4	GW	SUB	Subsidiary	String	Generic Edit	8	0
199	F44H73W1	Lot Start - P.O. / Committment Generation Work File	4	CG	SUB	Subsidiary	String	Generic Edit	8	0
200	F44H73W2	Lot Start - Budget Generation Workfile	4	BG	SUB	Subsidiary	String	Generic Edit	8	0
TOP45: Advanced Pricing
201	F4574	Key Reference Table	74	KR	SUB	Subsidiary	String	Generic Edit	8	0
TOP47: Electronic Commerce
202	F47012	EDI Purchase Order Detail - Inbound	197	SZ	SUB	Subsidiary	String	Generic Edit	8	0
203	F47017	EDI Purchase Order Detail - Outbound	143	SZ	SUB	Subsidiary	String	Generic Edit	8	0
204	F47022	EDI P.O. Acknowledgment Detail - Inbound	143	SZ	SUB	Subsidiary	String	Generic Edit	8	0
205	F47027	EDI P.O. Acknowledgment Detail - Outbound	197	SZ	SUB	Subsidiary	String	Generic Edit	8	0
206	F47037	EDI Shipping Notice Detail - Outbound	154	SZ	SUB	Subsidiary	String	Generic Edit	8	0
207	F47047	EDI Invoice Detail (Sales) - Outbound	197	SZ	SUB	Subsidiary	String	Generic Edit	8	0
208	F47057	EDI Payment Order Remittance Advice - Outbound	101	D3	SUB	Subsidiary	String	Generic Edit	8	0
209	F47057W	EDI Payment Order Remittance Advice - Work	101	D3	SUB	Subsidiary	String	Generic Edit	8	0
210	F47072	EDI Receiving Advice Detail - Inbound	144	SZ	SUB	Subsidiary	String	Generic Edit	8	0
211	F47077	EDI Receiving Advice Detail - Outbound	144	SZ	SUB	Subsidiary	String	Generic Edit	8	0
212	F47092	EDI Request for Quote Detail - Inbound	197	SZ	SUB	Subsidiary	String	Generic Edit	8	0
213	F47097	EDI Request for Quote Detail - Outbound	143	SZ	SUB	Subsidiary	String	Generic Edit	8	0
214	F47102	EDI Response to RFQ Detail - Inbound	143	SZ	SUB	Subsidiary	String	Generic Edit	8	0
215	F47107	EDI Response to RFQ Detail - Outbound	196	SZ	SUB	Subsidiary	String	Generic Edit	8	0
216	F47132	EDI Purchase Order Change Detail - Inbound	198	SZ	SUB	Subsidiary	String	Generic Edit	8	0
217	F47137	EDI Purchase Order Change Detail - Outbound	144	SZ	SUB	Subsidiary	String	Generic Edit	8	0
218	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	145	SZ	SUB	Subsidiary	String	Generic Edit	8	0
219	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	199	SZ	SUB	Subsidiary	String	Generic Edit	8	0
220	F47157	EDI Shipping Schedule Detail - Outbound	152	SZ	SUB	Subsidiary	String	Generic Edit	8	0
TOP48: Work Order Processing
221	F4801	Work Order Master File	21	WA	SUB	Subsidiary	String	Generic Edit	8	0
222	F4801S	Purge - Work Order Master file	21	WA	SUB	Subsidiary	String	Generic Edit	8	0
223	F4801Z1	Outbound Work Order Header	40	SY	SUB	Subsidiary	String	Generic Edit	8	0
224	F48710	Work Order Mass Update Template Table	105	WT	SUB	Subsidiary	String	Generic Edit	8	0
225	F48UI001	X4801 Master Business Function Workfile	24	WA	SUB	Subsidiary	String	Generic Edit	8	0
TOP48S: Service Billing
226	F48096	Billing Rate / Mark up Table	7	WQ	SUB	Subsidiary	String	Generic Edit	8	0
227	F4812	Billing Detail Workfile	10	WD	SUB	Subsidiary	String	Generic Edit	8	0
228	F48127	Tax Derivation Information	8	WO	SUB	Subsidiary	String	Generic Edit	8	0
229	F4812H	Billing Workfile History	10	WD	SUB	Subsidiary	String	Generic Edit	8	0
230	F4812HS	Billing Workfile History Purged Save	10	WD	SUB	Subsidiary	String	Generic Edit	8	0
231	F48520	Invoice Summary Access	5	AE	SUB	Subsidiary	String	Generic Edit	8	0
232	F48S0618	Payroll Reclassification Workfile	12	YT	SUB	Subsidiary	String	Generic Edit	8	0
233	F48S910	Billing Detail Journal Workfile	18	W2	SUB	Subsidiary	String	Generic Edit	8	0
234	F48S911	Summarized Journal Workfile	16	W3	SUB	Subsidiary	String	Generic Edit	8	0
235	F48S912	G/L Link	23	W6	SUB	Subsidiary	String	Generic Edit	8	0
236	F48S95	Billing AAI Information	8	WV	SUB	Subsidiary	String	Generic Edit	8	0
237	F48SUI01	Billing Detail Print Workfile	10	WD	SUB	Subsidiary	String	Generic Edit	8	0
TOP51: Job Costing
238	F5109	Chart Type Master	2	GJ	SUB	Subsidiary	String	Generic Edit	8	0
239	F51092	Multiple Cost Code Setup	3	MC	SUB	Subsidiary	String	Generic Edit	8	0
240	F5111	Forecast Detail	5	FD	SUB	Subsidiary	String	Generic Edit	8	0
241	F51901	Cost Code Schedule	22	GP	SUB	Subsidiary	String	Generic Edit	8	0
242	F51911	Draw Reporting Master	7	GK	SUB	Subsidiary	String	Generic Edit	8	0
TOP52: Contract Billing
243	F5202	Contract Billing Line Detail	19	G6	SUB	Subsidiary	String	Generic Edit	8	0
244	F5212	T and M - Unit Price and Lumpsum Cross Reference Accounts	9	G5	SUB	Subsidiary	String	Generic Edit	8	0
TOP52G: Government Contracting
245	F52G21	Contract Specific Labor Category Cross Reference	11	LR	SUB	Subsidiary	String	Generic Edit	8	0
246	F52G90	Invoice Printing Work Table	43	WT	SUB	Subsidiary	String	Generic Edit	8	0
TOP53: Change Management
247	F5302	F5302 World Specs	12	DK	SUB	Subsidiary	String	Generic Edit	8	0
248	F5314	Planned Change Order Master Table	28	D2	SUB	Subsidiary	String	Generic Edit	8	0
249	F5315	Change Order Master Table	27	D3	SUB	Subsidiary	String	Generic Edit	8	0
TOP55: Reserved for Clients
250	F74H105S	Slovakian Invoice Accounting Summary	10	AS	SUB	Subsidiary	String	Generic Edit	8	0
251	F74T205	Checks Collected	9	CC	SUB	Subsidiary	String	Generic Edit	8	0
252	F74TL004	Trial Balance Temp File	6	TB	SUB	Subsidiary	String	Generic Edit	8	0
253	F74TL005	Account Table Turkish Localization	6	AT	SUB	Subsidiary	String	Generic Edit	8	0
254	F74T550	General Ledger Work File - Turkish	8	DK	SUB	Subsidiary	String	Generic Edit	8	0
TOP74: EMEA Localization
255	F74093	Worktable for Printing IVA Summary - Italy	4	HC	SUB	Subsidiary	String	Generic Edit	8	0
256	F74900	Foreign Receivables and Payables - EMEA	59	RP	SUB	Subsidiary	String	Generic Edit	8	0
257	F74UI91	WF - Account Detail - EMEA - 74	13	AD	SUB	Subsidiary	String	Generic Edit	8	0
TOP74H: Hungary
258	F741202	Work File Accumulated Asset Movement Dep - HUN - 74	12	WF	SUB	Subsidiary	String	Generic Edit	8	0
TOP74P: Poland
259	F74902T	Account Balance Tag File - COM - 09 - 74P	41	AT	SUB	Subsidiary	String	Generic Edit	8	0
260	F74P03BW	A/R Trial Balance - POL - 03B - 74P	9	P3	SUB	Subsidiary	String	Generic Edit	8	0
261	F74P04W	A/P Trial Balance Work Table - POL - 04 - 74P	9	P2	SUB	Subsidiary	String	Generic Edit	8	0
TOP74R: CIS
262	F74R9001	Correspondence Account Setup - RUS -09 - 74R	2	CA	SUB	Subsidiary	String	Generic Edit	8	0
263	F74R9029	Open Accounts - RUS - 09 - 74R	13	OA	SUB	Subsidiary	String	Generic Edit	8	0
TOP74U: United Kingdom Localizations
264	F74U0412	Application Commitment Workfile - UK - 43	26	AC	SUB	Subsidiary	String	Generic Edit	8	0
265	F74U0414	Certificate Commitment Workfile - UK - 43	26	CC	SUB	Subsidiary	String	Generic Edit	8	0
266	F74U0416	Purchase Order Commitment Workfile - UK - 43	26	PC	SUB	Subsidiary	String	Generic Edit	8	0
267	F74U0420	SPC - Application Master - UK - 43	17	SE	SUB	Subsidiary	String	Generic Edit	8	0
268	F74U0424	SPC Subcontractor Payment Liability - UK - 43	26	PL	SUB	Subsidiary	String	Generic Edit	8	0
269	F74U0425	SPC - Certificate Master - UK - 43	18	SF	SUB	Subsidiary	String	Generic Edit	8	0
270	F74U0429	SPL Cross Reference Table - UK - 43	5	CR	SUB	Subsidiary	String	Generic Edit	8	0
271	F74U424A	SPC Subcontractor Accrual Data - UK - 43	10	PL	SUB	Subsidiary	String	Generic Edit	8	0
272	F74U424W	SPC Subcontractor Accrual Workfile - UK - 43	10	WF	SUB	Subsidiary	String	Generic Edit	8	0
TOP74Z: Czech Republic
273	F74ZUI01	Corresponding Accounts	4	CZ	SUB	Subsidiary	String	Generic Edit	8	0
TOP75C: China - Reporting System Only
274	F75C015	Cash Flow Data - China	16	CF	SUB	Subsidiary	String	Generic Edit	8	0
275	F75C201	Modification Methods Information - CHINA	8	MM	SUB	Subsidiary	String	Generic Edit	8	0
TOP75I: India
276	F75I302	Excise - Period Master	12	QA	SUB	Subsidiary	String	Generic Edit	8	0
277	F75I310W	Voucher Entry Record	5	RE	SUB	Subsidiary	String	Generic Edit	8	0
278	F75I408	VAT/CST Account Master	4	VC	SUB	Subsidiary	String	Generic Edit	8	0
TOP75T: Taiwan
279	F75T012	GUI/VAT GL Account Mapping - 75T	3	GL	SUB	Subsidiary	String	Generic Edit	8	0
TOP76A: Argentina
280	F76A19	Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A	19	TI	SUB	Subsidiary	String	Generic Edit	8	0
281	F76A19P	Taxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A	19	TI	SUB	Subsidiary	String	Generic Edit	8	0
282	F76A19Z1	Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A	37	VK	SUB	Subsidiary	String	Generic Edit	8	0
283	F76A394	Adjustments - 76A	13	C4	SUB	Subsidiary	String	Generic Edit	8	0
284	F76AUI24	Taxes Work File - ARG - 03B - 76A	19	TI	SUB	Subsidiary	String	Generic Edit	8	0
285	F76AUI98	Cost Account Work Table - Work in Progress Adjustment - 76A	5	CA	SUB	Subsidiary	String	Generic Edit	8	0
TOP76B: Brazil - Reporting System Only
286	F7611B	Nota Fiscal Detail - BRA - 42	93	FD	SUB	Subsidiary	String	Generic Edit	8	0
287	F76B056	Account - SPED Fiscal Brazilian WF - BRA - 76B	9	WT	SUB	Subsidiary	String	Generic Edit	8	0
288	F76B0590	Electronic Reporting - Chart of Accounts	6	CH	SUB	Subsidiary	String	Generic Edit	8	0
289	F76B10	Account Ledger - IN68 - 09	5	AR	SUB	Subsidiary	String	Generic Edit	8	0
290	F76B11	Account Balances - IN68 - 09	5	AB	SUB	Subsidiary	String	Generic Edit	8	0
291	F76B410H	INSS-Work Table for Services Third Party Inbound NF H - 42	8	SI	SUB	Subsidiary	String	Generic Edit	8	0
292	F76B50	Item Ledger Table - IN68 - 42	17	CE	SUB	Subsidiary	String	Generic Edit	8	0
293	F76B64	Balances/JEs w/ Currency Correction Table - IN68 - 12	4	BS	SUB	Subsidiary	String	Generic Edit	8	0
294	F76B8602	IN86-Work Table for Suppliers and Customers - 04	4	PR	SUB	Subsidiary	String	Generic Edit	8	0
295	F76B901	IN86- Work Table for Account Master - 09	4	BA	SUB	Subsidiary	String	Generic Edit	8	0
296	F76B902	IN86-Work Table for Account Balance - 09	5	BC	SUB	Subsidiary	String	Generic Edit	8	0
297	F76B911	IN86-Work Table for Journal Entries - 09	5	BD	SUB	Subsidiary	String	Generic Edit	8	0
TOP76C: Colombia
298	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	51	RP	SUB	Subsidiary	String	Generic Edit	8	0
299	F76C0902	Debits and Credits T/B by object account - COL - 76C	14	GB	SUB	Subsidiary	String	Generic Edit	8	0
300	F76C1201	Adjustment By Inflation to the Cost / Deferred Charge - 76C	7	AC	SUB	Subsidiary	String	Generic Edit	8	0
301	F76C1202	Adjustment By Inflation Depreciation/Amortization - C - 76C	7	AD	SUB	Subsidiary	String	Generic Edit	8	0
302	F76C575	Work File Magnetic Media - COL - 04	18	Q1	SUB	Subsidiary	String	Generic Edit	8	0
303	F76C9415	Workfile for Dialy Book - COL - 09	11	LD	SUB	Subsidiary	String	Generic Edit	8	0
304	F76C9F01	DIAN Setup Concept Code by Format and Account - 09 - COL	5	SC	SUB	Subsidiary	String	Generic Edit	8	0
305	F76C9F02	DIAN Formats by AccountID - COL - 09	24	DF	SUB	Subsidiary	String	Generic Edit	8	0
306	F76CT1	Tributary Information - COL - 76C	17	TI	SUB	Subsidiary	String	Generic Edit	8	0
307	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	4	CT	SUB	Subsidiary	String	Generic Edit	8	0
308	F76CUI01	Account Master - Work File - COL - 76C	5	GM	SUB	Subsidiary	String	Generic Edit	8	0
309	F76CUI03	Account Cat. Code - Work File - COL - 76C	5	GM	SUB	Subsidiary	String	Generic Edit	8	0
TOP76H: Chile
310	F76H6205	Item Replacement Cost - CHI - 41	12	IR	SUB	Subsidiary	String	Generic Edit	8	0
311	F76H902T	Account Balances Tag File - CHI - 09 - 76H	41	AT	SUB	Subsidiary	String	Generic Edit	8	0
TOP89: Conversion Programs
312	F42119B	Sales Order History File - temporary for upgrade (2)	5	SD	SUB	Subsidiary	String	Generic Edit	8	0
313	F4211B	Sales Order Detail File - temporary for upgrade (2)	5	SD	SUB	Subsidiary	String	Generic Edit	8	0
314	F43199A	Temp F43199 for ERP 9.0 Upgrade	129	OL	SUB	Subsidiary	String	Generic Edit	8	0
TOPF30L: DFM Line Design
315	FF30L930	DFM Routings	43	LR	SUB	Subsidiary	String	Generic Edit	8	0
TOPF31: Lean Transactions
316	FF31011	TransactionID Master File	35	EH	SUB	Subsidiary	String	Generic Edit	8	0
317	FF31011S	Purge - TransactionID Master File	35	ER	SUB	Subsidiary	String	Generic Edit	8	0
318	FF31111	Lean Transaction Parts List	51	PL	SUB	Subsidiary	String	Generic Edit	8	0
319	FF31111S	Purge - Lean Transaction Parts List	51	PR	SUB	Subsidiary	String	Generic Edit	8	0
320	FF31112	Routing Transaction Table	38	EH	SUB	Subsidiary	String	Generic Edit	8	0
321	FF31112S	Purge - Routing Transaction Table	38	ET	SUB	Subsidiary	String	Generic Edit	8	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

321 columns | 910 | SUB