	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

318 columns | 920 | OBJ

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

318 columns | 920 | OBJ