	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

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

275 columns | 812 | SUB