	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

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

330 columns | 920 | SUB