	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

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

311 columns | 910 | OBJ