	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

238 columns | 910 | ICU

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0011	Batch Control Records	2	IC	ICU	Batch Number	Numeric	Generic Edit	8	0
2	F0011W	F0011W - WF - Batch To Detail	2	IC	ICU	Batch Number	Numeric	Generic Edit	8	0
3	F0018	Taxes	50	TD	ICU	Batch Number	Numeric	Generic Edit	8	0
4	F0911	Account Ledger	8	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP03: Accounts Receivable
5	F0311	Accounts Receivable Ledger	17	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
6	F0312	A/R Batch Cash Application	2	RU	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP03B: Enhanced Accounts Receivable
7	F03B11	Customer Ledger	9	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
8	F03B112	Invoice Revisions	17	RW	ICU	Batch Number	Numeric	Generic Edit	8	0
9	F03B112P	Invoice Revisions Purge File	17	RW	ICU	Batch Number	Numeric	Generic Edit	8	0
10	F03B11P	Customer Ledger Purge File	9	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
11	F03B11Z1	Batch Invoices	27	VJ	ICU	Batch Number	Numeric	Generic Edit	8	0
12	F03B11Z2	F03B11 Interoperability Table	22	SY	ICU	Batch Number	Numeric	Generic Edit	8	0
13	F03B13	Receipts Header	19	RY	ICU	Batch Number	Numeric	Generic Edit	8	0
14	F03B13P	Receipts Header Purge File	19	RY	ICU	Batch Number	Numeric	Generic Edit	8	0
15	F03B13Z1	Electronic Receipts Input	5	RU	ICU	Batch Number	Numeric	Generic Edit	8	0
16	F03B13Z2	F03B13 Interoperability Table	32	SY	ICU	Batch Number	Numeric	Generic Edit	8	0
17	F03B14	Receipts Detail	20	RZ	ICU	Batch Number	Numeric	Generic Edit	8	0
18	F03B14P	Receipts Detail Purge File	20	RZ	ICU	Batch Number	Numeric	Generic Edit	8	0
19	F03B14Z2	F03B14 Interoperability Table	33	SZ	ICU	Batch Number	Numeric	Generic Edit	8	0
20	F03B571	Auto Debit Batch Control	7	RC	ICU	Batch Number	Numeric	Generic Edit	8	0
21	F03B575	Auto Debit Invoice Select and Build	12	RD	ICU	Batch Number	Numeric	Generic Edit	8	0
22	F03B672	Draft Remittance	22	RD	ICU	Batch Number	Numeric	Generic Edit	8	0
23	F03BUI05	Auto Receipts Batch Workfile	4	R5	ICU	Batch Number	Numeric	Generic Edit	8	0
24	F09UI011	Receipt Prepost Work File	5	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP04: Accounts Payable
25	F0411	Accounts Payable Ledger	19	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
26	F0411A	WF - As Of Accounts Payable Ledger	19	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
27	F0411P	Purge - Accounts Payable Ledger	19	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
28	F0411Z1	Voucher Transactions - Batch Upload	37	VL	ICU	Batch Number	Numeric	Generic Edit	8	0
29	F0411Z3	F0411 Interoperability Table	41	SZ	ICU	Batch Number	Numeric	Generic Edit	8	0
30	F0413	Accounts Payable - Matching Document	8	RM	ICU	Batch Number	Numeric	Generic Edit	8	0
31	F0413A	WF - As Of Accounts Payable Payment Register	8	RM	ICU	Batch Number	Numeric	Generic Edit	8	0
32	F0413P	Purge - Accounts Payable Matching Documents	8	RM	ICU	Batch Number	Numeric	Generic Edit	8	0
33	F0413Z1	F0413 Interoperability Table	22	SY	ICU	Batch Number	Numeric	Generic Edit	8	0
34	F09UI005	Tax Offsets User Index	5	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
35	F09UI006	Tax (F0018) Replica	50	TD	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP05T: Time Entry
36	F06116	Employee Transaction Detail File	93	YT	ICU	Batch Number	Numeric	Generic Edit	8	0
37	F06116Z1	Employee Transactions - Batch File	107	VL	ICU	Batch Number	Numeric	Generic Edit	8	0
38	F06116Z2	ESS Timecard History	107	VM	ICU	Batch Number	Numeric	Generic Edit	8	0
39	F06241	Burden Distribution File	18	J#	ICU	Batch Number	Numeric	Generic Edit	8	0
40	F06278	Retro Timecard Detail File	93	YT	ICU	Batch Number	Numeric	Generic Edit	8	0
41	F063951	Payroll Journal (Compressed) File	35	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
42	F069136	Tip Disbursement	22	JE	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP06: Payroll (old) - Obsolete-do not reuse
43	F06210	Payroll Cycle Parameters	47	YD	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP07: Payroll
44	F05290	WF - Payroll Journal (Detail)	35	JR	ICU	Batch Number	Numeric	Generic Edit	8	0
45	F06053	Interim Check Parameters File	27	YW	ICU	Batch Number	Numeric	Generic Edit	8	0
46	F06156	Pay Check History Summary	18	YU	ICU	Batch Number	Numeric	Generic Edit	8	0
47	F06270	Retro Processing Parameter	56	JP	ICU	Batch Number	Numeric	Generic Edit	8	0
48	F06350I	WF - Paycheck (Interims)	48	Y4	ICU	Batch Number	Numeric	Generic Edit	8	0
49	F06490	Payroll/Accounts Payable Ledger Detail	2	JR	ICU	Batch Number	Numeric	Generic Edit	8	0
50	F06491	Payroll/Accounts Payable Ledger Detail	2	J6	ICU	Batch Number	Numeric	Generic Edit	8	0
51	F06492	Payroll - Accounts Payable Control	2	JC	ICU	Batch Number	Numeric	Generic Edit	8	0
52	F07210	Pay Cycle Parameters File	67	YD	ICU	Batch Number	Numeric	Generic Edit	8	0
53	F074001	New Hire Reporting Workfile - OneWorld Only	105	NH	ICU	Batch Number	Numeric	Generic Edit	8	0
54	F07490	Payroll - Accounts Payable Detail (One World)	2	JR	ICU	Batch Number	Numeric	Generic Edit	8	0
55	F07491	Payroll - Accounts Payable Summary File	2	J6	ICU	Batch Number	Numeric	Generic Edit	8	0
56	F07492	Payroll - Accounts Payable Control File	2	JC	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP08B: Benefits Administration
57	F08371	Reimbursement Spending Account Claims File	32	B6	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP09: General Accounting
58	F0911P	Purge - Account Ledger	8	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
59	F0911R	WF - Account Ledger Reconciliation	8	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
60	F0911Z1	Journal Entry Transactions - Batch File	25	VN	ICU	Batch Number	Numeric	Generic Edit	8	0
61	F0911Z4	F0911 Interoperability Table	30	SZ	ICU	Batch Number	Numeric	Generic Edit	8	0
62	F0916	Bank Statement Header	15	GH	ICU	Batch Number	Numeric	Generic Edit	8	0
63	F09616	Auto Bank Statement Header	14	GN	ICU	Batch Number	Numeric	Generic Edit	8	0
64	F09UI004	Variable Numerator Allocations work file	1	R#	ICU	Batch Number	Numeric	Generic Edit	8	0
65	F09UI007	Match Bank Tape to Recon File - ONE WORLD ONLY	12	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
66	F09UI013	Company by Batch Out of Balance	2	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
67	F09UI015	Indexed Computations Multi-Tiered Entries	8	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
68	F09UI618	Auto Bank Statement Process Work Table	19	NB	ICU	Batch Number	Numeric	Generic Edit	8	0
69	F52G11	Burdening Detail Ledger	52	BD	ICU	Batch Number	Numeric	Generic Edit	8	0
70	F70UI001	Work File for G/L by Cat. Code Localization	21	WA	ICU	Batch Number	Numeric	Generic Edit	8	0
71	F740911	Work File for G/L Report by Category Code Localization	25	WA	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP11C: Cash Basis
72	F11CUI01	A/R Cash Basis Work File	2	CB	ICU	Batch Number	Numeric	Generic Edit	8	0
73	F11CUI02	A/P Cash Basis Work File	2	CB	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP13: Plant/Equipment Management
74	F1304	Equipment Location Billing	3	FN	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP15: Property Management
75	F150122A	Share Factor Denominator Audit	1	SA	ICU	Batch Number	Numeric	Generic Edit	8	0
76	F1502WAB	Rent Increase Amounts	1	NF	ICU	Batch Number	Numeric	Generic Edit	8	0
77	F1502WB	Estimated EP Recurring Billings	1	N4	ICU	Batch Number	Numeric	Generic Edit	8	0
78	F1505H	Revenue Fee Generation History	1	OK	ICU	Batch Number	Numeric	Generic Edit	8	0
79	F1505HB	Revenue Fee Generation History	1	OK	ICU	Batch Number	Numeric	Generic Edit	8	0
80	F1511	Tenant/Lease Billings Detail	2	NJ	ICU	Batch Number	Numeric	Generic Edit	8	0
81	F15110B	Expense Participation Class Account	1	OB	ICU	Batch Number	Numeric	Generic Edit	8	0
82	F1511B	Lease Billings Master	2	NJ	ICU	Batch Number	Numeric	Generic Edit	8	0
83	F1511B1	Billing Batches Summary	3	NW	ICU	Batch Number	Numeric	Generic Edit	8	0
84	F1511H	Tenant/Lease Billings Detail History	2	N#	ICU	Batch Number	Numeric	Generic Edit	8	0
85	F1511HB	Lease Billings History	2	NC	ICU	Batch Number	Numeric	Generic Edit	8	0
86	F1513	FASB 13 Lease Control File	6	O3	ICU	Batch Number	Numeric	Generic Edit	8	0
87	F1513B	FASB 13 Lease Control	6	O3	ICU	Batch Number	Numeric	Generic Edit	8	0
88	F15153	Lease Cap History	1	LC	ICU	Batch Number	Numeric	Generic Edit	8	0
89	F151991	G/L Transaction A/R Application Work File	1	NB	ICU	Batch Number	Numeric	Generic Edit	8	0
90	F15199W	G/L Transaction Summarization Work File	1	NB	ICU	Batch Number	Numeric	Generic Edit	8	0
91	F15303	E.P. Class Expenses History	1	CH	ICU	Batch Number	Numeric	Generic Edit	8	0
92	F1532B	Expense Participation Audit File	5	NT	ICU	Batch Number	Numeric	Generic Edit	8	0
93	F1538	WF - Expence Participation Register	5	NZ	ICU	Batch Number	Numeric	Generic Edit	8	0
94	F1538B	EP Billing Register	6	NZ	ICU	Batch Number	Numeric	Generic Edit	8	0
95	F1538B1	Occupancy Gross Up Audit	1	GU	ICU	Batch Number	Numeric	Generic Edit	8	0
96	F1538B2	Exclusion/Redistribution	1	RD	ICU	Batch Number	Numeric	Generic Edit	8	0
97	F1539A	EP Billing Account Adjustments Audit	1	AU	ICU	Batch Number	Numeric	Generic Edit	8	0
98	F1539C	EP Billing Class Adjustments Audit File	1	AU	ICU	Batch Number	Numeric	Generic Edit	8	0
99	F1539E	EP Billing Account Exclusions Audit	1	AU	ICU	Batch Number	Numeric	Generic Edit	8	0
100	F1539FC	EP Billing Adj Factor EP Class Audit	1	AU	ICU	Batch Number	Numeric	Generic Edit	8	0
101	F1539FL	EP Billing Adj Factor Lease Audit	1	AU	ICU	Batch Number	Numeric	Generic Edit	8	0
102	F1540	Sales Report Control File	11	NR	ICU	Batch Number	Numeric	Generic Edit	8	0
103	F1540B	Sales Report Control	21	NR	ICU	Batch Number	Numeric	Generic Edit	8	0
104	F1548	Escalation Billing Register	5	N1	ICU	Batch Number	Numeric	Generic Edit	8	0
105	F1548B	Escalation Billing Register	6	N1	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP18: Resource Scheduling
106	F186205	Temp Cached Employees	1	TC	ICU	Batch Number	Numeric	Generic Edit	8	0
107	F186602	Labor Rules Tag File	101	TF	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP31: Shop Floor Control
108	F3106	W.O. Cross Reference File	5	SD	ICU	Batch Number	Numeric	Generic Edit	8	0
109	F3108	Summarized WO Cross-Reference	3	SJ	ICU	Batch Number	Numeric	Generic Edit	8	0
110	F31122	Work Order Time Transactions	15	WT	ICU	Batch Number	Numeric	Generic Edit	8	0
111	F31122S	Purge Work Order Time Transactions	15	WT	ICU	Batch Number	Numeric	Generic Edit	8	0
112	F31122Z1	Work Order Time Transactions Unedited Transaction Table	28	SZ	ICU	Batch Number	Numeric	Generic Edit	8	0
113	F31UI804	Exception Report Work FIle	14	WR	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP38: Agreement Management
114	F38111	Agreements Transaction Ledger	56	DZ	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP39: Advanced Stock Valuation
115	F3910	G/L Adjustment Table	17	SC	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP41: Inventory Management
116	F4111	Item Ledger File	26	IL	ICU	Batch Number	Numeric	Generic Edit	8	0
117	F41UI001	Inventory Transactions Detail File	10	IT	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP41B: Bulk Stock Management
118	F41511	Bulk Product Transaction File	12	PA	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP42: Sales Management
119	F42800G	Sales Update G Batch Workfile	3	SG	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP43: Procurement
120	F43092Z	Receipt Routing Work File	16	PV	ICU	Batch Number	Numeric	Generic Edit	8	0
121	F74U0141	ACM - Application / Certificate Master	34	AC	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP43S: Supplier Self Service
122	F4313	POFLIP	23	PF	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP45: Advanced Pricing
123	F4575	Ship and Debit History	41	AH	ICU	Batch Number	Numeric	Generic Edit	8	0
124	F4575TMP	Ship and Debit History - Temp Table	41	AH	ICU	Batch Number	Numeric	Generic Edit	8	0
125	F4576	Ship and Debit Claims	54	AC	ICU	Batch Number	Numeric	Generic Edit	8	0
126	F4576TMP	Ship and Debit Claims- Temp Table	54	AC	ICU	Batch Number	Numeric	Generic Edit	8	0
127	F4576Z1	Ship and Debit Claims Unedited Transaction Table	85	Z1	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP47: Electronic Commerce
128	F47056	EDI Payment Order Header - Outbound	15	D1	ICU	Batch Number	Numeric	Generic Edit	8	0
129	F470561	EDI Payment Order Bank N & A - Outbound	9	D2	ICU	Batch Number	Numeric	Generic Edit	8	0
130	F470561W	EDI Payment Order Bank N & A - Work	9	D2	ICU	Batch Number	Numeric	Generic Edit	8	0
131	F470562	EDI Payment Order Vendor N & A - Outbound	9	D4	ICU	Batch Number	Numeric	Generic Edit	8	0
132	F470562W	EDI Payment Order Vendor N & A - Work	9	D4	ICU	Batch Number	Numeric	Generic Edit	8	0
133	F470563	EDI Payment Order Payee N & A - Outbound	9	D5	ICU	Batch Number	Numeric	Generic Edit	8	0
134	F470563W	EDI Payment Order Payee N & A - Work	9	D5	ICU	Batch Number	Numeric	Generic Edit	8	0
135	F47056W	EDI Payment Order Header - Work	15	D1	ICU	Batch Number	Numeric	Generic Edit	8	0
136	F47057	EDI Payment Order Remittance Advice - Outbound	15	D3	ICU	Batch Number	Numeric	Generic Edit	8	0
137	F47057W	EDI Payment Order Remittance Advice - Work	15	D3	ICU	Batch Number	Numeric	Generic Edit	8	0
138	F47112	EDI Lockbox Header - Transaction	24	Z2	ICU	Batch Number	Numeric	Generic Edit	8	0
139	F47113	EDI Lockbox/Payment Detail - Batch	27	Z3	ICU	Batch Number	Numeric	Generic Edit	8	0
140	F47122	EDI Product Activity Data Detail - Inbound	54	MJ	ICU	Batch Number	Numeric	Generic Edit	8	0
141	F47127	EDI Product Activity Data Detail - Outbound	54	MJ	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP48S: Service Billing
142	F48011	Service Billing Batch Control	1	WG	ICU	Batch Number	Numeric	Generic Edit	8	0
143	F4812	Billing Detail Workfile	123	WD	ICU	Batch Number	Numeric	Generic Edit	8	0
144	F4812H	Billing Workfile History	123	WD	ICU	Batch Number	Numeric	Generic Edit	8	0
145	F4812HS	Billing Workfile History Purged Save	123	WD	ICU	Batch Number	Numeric	Generic Edit	8	0
146	F4822	Invoice Summary Work File	27	W4	ICU	Batch Number	Numeric	Generic Edit	8	0
147	F48221	Service Billing Retention Release Cross Reference File	1	WH	ICU	Batch Number	Numeric	Generic Edit	8	0
148	F48229	Delete Invoices Audit Table	4	W8	ICU	Batch Number	Numeric	Generic Edit	8	0
149	F4823	Voucher Summary	25	W0	ICU	Batch Number	Numeric	Generic Edit	8	0
150	F48S002	Draft and Final Cross Reference Work File	1	WM	ICU	Batch Number	Numeric	Generic Edit	8	0
151	F48S411	CSB Pay When Paid Table	16	BZ	ICU	Batch Number	Numeric	Generic Edit	8	0
152	F48S910	Billing Detail Journal Workfile	1	W2	ICU	Batch Number	Numeric	Generic Edit	8	0
153	F48S911	Summarized Journal Workfile	1	W3	ICU	Batch Number	Numeric	Generic Edit	8	0
154	F48S912	G/L Link	2	W6	ICU	Batch Number	Numeric	Generic Edit	8	0
155	F48SUI01	Billing Detail Print Workfile	123	WD	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP49: Transportation Management
156	F49631	Load In-transit Ledger	22	TO	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP51: Job Costing
157	F51911	Draw Reporting Master	15	GK	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP52: Contract Billing
158	F5201	Contract Master	4	G4	ICU	Batch Number	Numeric	Generic Edit	8	0
159	F5216	Milestone/Progress Billing Information	24	A6	ICU	Batch Number	Numeric	Generic Edit	8	0
160	F52161	Mileston/Progress Billing Line Cross Reference Details	11	A7	ICU	Batch Number	Numeric	Generic Edit	8	0
161	F5280W	Contract Revenue Summary Work File	32	GY	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP52G: Government Contracting
162	F4822H	Invoice Summary History	27	IH	ICU	Batch Number	Numeric	Generic Edit	8	0
163	F52G05	ACRN Detail Table	30	AD	ICU	Batch Number	Numeric	Generic Edit	8	0
164	F52G90	Invoice Printing Work Table	27	WT	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP55: Reserved for Clients
165	F74T101	Check History Table	11	CH	ICU	Batch Number	Numeric	Generic Edit	8	0
166	F74T550	General Ledger Work File - Turkish	21	DK	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74: EMEA Localization
167	F740018D	Data extraction ESL - 74	25	DE	ICU	Batch Number	Numeric	Generic Edit	8	0
168	F740018W	Data extraction ESL - Workfile - 74	25	DE	ICU	Batch Number	Numeric	Generic Edit	8	0
169	F74030HA	Dutch-Next Batch Number and Sequence Number	2	ST	ICU	Batch Number	Numeric	Generic Edit	8	0
170	F74093	Worktable for Printing IVA Summary - Italy	49	HC	ICU	Batch Number	Numeric	Generic Edit	8	0
171	F74900	Foreign Receivables and Payables - EMEA	15	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74H: Hungary
172	F74H309	Gains & Losses Unrealized Account ing - HUN - 03B	14	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
173	F74H409	A/P Gains & Losses Unrealized Accounting - HUN - 04	14	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
174	F74H910	JE VAT Differences - HUN - 09	8	VD	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74P: Poland
175	F74P9100	Cash Desk Transaction - POL - 74P	14	CD	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74R: CIS
176	F74R0011	Batch Tag File - RUS - 09 - 74R	2	IC	ICU	Batch Number	Numeric	Generic Edit	8	0
177	F74R0100	Petty Cash Transactions - RUS - 00 - 74R	15	PC	ICU	Batch Number	Numeric	Generic Edit	8	0
178	F74R311	Prepayment Detail Tax File - RUS - 03B	25	DE	ICU	Batch Number	Numeric	Generic Edit	8	0
179	F74R410	Tax on Hold - RUS - 04	17	TH	ICU	Batch Number	Numeric	Generic Edit	8	0
180	F74R9011	Correspondence Rules - RUS -09 - 74R	17	CR	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74S: Spain
181	F74S55	Expenses and Exchange Rate for Payments - Spain - 04	6	Q5	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74U: United Kingdom Localizations
182	F74U0420	SPC - Application Master - UK - 43	27	SE	ICU	Batch Number	Numeric	Generic Edit	8	0
183	F74U0425	SPC - Certificate Master - UK - 43	29	SF	ICU	Batch Number	Numeric	Generic Edit	8	0
184	F74U424A	SPC Subcontractor Accrual Data - UK - 43	6	PL	ICU	Batch Number	Numeric	Generic Edit	8	0
185	F74U424W	SPC Subcontractor Accrual Workfile - UK - 43	6	WF	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74Y: Italy - Reporting System Only
186	F743B14I	Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B	7	TI	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP74Z: Czech Republic
187	F74Z0010	Cash Desk Document Printed - CZE - 74Z	9	ZO	ICU	Batch Number	Numeric	Generic Edit	8	0
188	F74ZUI01	Corresponding Accounts	6	CZ	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP75A: Australia - Reporting System Only
189	F75A0010	Australian Employee Termination Details	82	A0	ICU	Batch Number	Numeric	Generic Edit	8	0
190	F75A0140	Australian Payment Summary	4	ZG	ICU	Batch Number	Numeric	Generic Edit	8	0
191	F75A0145	Payment Summary ATO file build work file	1	ZZ	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP75C: China - Reporting System Only
192	F75C015	Cash Flow Data - China	10	CF	ICU	Batch Number	Numeric	Generic Edit	8	0
193	F75C4203	Chinese VAT on Free Goods Cross Reference - China - 42	9	FC	ICU	Batch Number	Numeric	Generic Edit	8	0
194	F75C911	CNAO - E1 Document Number mapping - China	3	DN	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP75I: India
195	F75I611	TCS Prepayment Transaction File - IND-03B	15	TT	ICU	Batch Number	Numeric	Generic Edit	8	0
196	F75I732	Service Tax A/R File Additional Info - IND - 03B	13	ST	ICU	Batch Number	Numeric	Generic Edit	8	0
197	F75I742	Service Tax A/P File Additional Info - IND - 04	14	ST	ICU	Batch Number	Numeric	Generic Edit	8	0
198	F75IUI7	Service Tax Credit Register - Work File - IND	10	WF	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP75T: Taiwan
199	F75T004	GUI/VAT Transaction Header - 75T	9	TH	ICU	Batch Number	Numeric	Generic Edit	8	0
200	F75T0049	GUI/VAT Transaction Header History - 75T	9	TH	ICU	Batch Number	Numeric	Generic Edit	8	0
201	F75T004P	GUI/VAT Transaction Header POS - 75T	70	TH	ICU	Batch Number	Numeric	Generic Edit	8	0
202	F75T004Z	GUI/VAT Transaction Header - Work - 75T	64	ZH	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP76A: Argentina
203	F76A392	Calculated costs header - 76A	6	C2	ICU	Batch Number	Numeric	Generic Edit	8	0
204	F76A41	CERG G/L - Lot Detail - ARG - 09 - 76A	1	LD	ICU	Batch Number	Numeric	Generic Edit	8	0
205	F76A4111	Item Ledger Tag File - ARG - 76A	3	IL	ICU	Batch Number	Numeric	Generic Edit	8	0
206	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	24	WF	ICU	Batch Number	Numeric	Generic Edit	8	0
207	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	27	WF	ICU	Batch Number	Numeric	Generic Edit	8	0
208	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	36	WF	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP76B: Brazil - Reporting System Only
209	F76B10	Account Ledger - IN68 - 09	19	AR	ICU	Batch Number	Numeric	Generic Edit	8	0
210	F76B20	Account Payable and Receivable Table - IN68 - 03B	15	PR	ICU	Batch Number	Numeric	Generic Edit	8	0
211	F76B835	FCONT Account Ledger Operation - 76B	1	AO	ICU	Batch Number	Numeric	Generic Edit	8	0
212	F76B8602	IN86-Work Table for Suppliers and Customers - 04	15	PR	ICU	Batch Number	Numeric	Generic Edit	8	0
213	F76B911	IN86-Work Table for Journal Entries - 09	11	BD	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP76C: Colombia
214	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	9	RP	ICU	Batch Number	Numeric	Generic Edit	8	0
215	F76C034A	A/R Check Detail file As Of - COL - 03B	20	RZ	ICU	Batch Number	Numeric	Generic Edit	8	0
216	F76C575	Work File Magnetic Media - COL - 04	1	Q1	ICU	Batch Number	Numeric	Generic Edit	8	0
217	F76C9415	Workfile for Dialy Book - COL - 09	4	LD	ICU	Batch Number	Numeric	Generic Edit	8	0
218	F76C9F02	DIAN Formats by AccountID - COL - 09	9	DF	ICU	Batch Number	Numeric	Generic Edit	8	0
219	F76CT1	Tributary Information - COL - 76C	1	TI	ICU	Batch Number	Numeric	Generic Edit	8	0
220	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	8	CT	ICU	Batch Number	Numeric	Generic Edit	8	0
221	F76CUI02	Tax Detail - Work File - COL - 76C	56	TD	ICU	Batch Number	Numeric	Generic Edit	8	0
222	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	57	TD	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP76E: Ecuador
223	F76E0018	Print Withholding Workfile - EC - 04	9	TD	ICU	Batch Number	Numeric	Generic Edit	8	0
224	F76E4010	Withholding Certificate Information - EC - 04	3	CE	ICU	Batch Number	Numeric	Generic Edit	8	0
225	F76E4020	Withholding Certificate Information w/ SRI - EC - 04	4	CR	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP76H: Chile
226	F76H6001	Actual Cost Process Header - CHI - 41 - 76H	23	PH	ICU	Batch Number	Numeric	Generic Edit	8	0
227	F76H611	Actual Item Ledger File - CHI - 41 - 76H	27	AL	ICU	Batch Number	Numeric	Generic Edit	8	0
228	F76H6201	Replacement Cost Process Header - CHI - 41	14	RH	ICU	Batch Number	Numeric	Generic Edit	8	0
229	F76HUI32	Workfile for R76H3B40 - CHI - 42 - 76H	14	WF	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP76M: Mexico
230	F76M0314	Receipt Detail Tag File - Mexico	9	MA	ICU	Batch Number	Numeric	Generic Edit	8	0
231	F76M0414	F0414 - Payment Detail Tag File - Mexico	7	RT	ICU	Batch Number	Numeric	Generic Edit	8	0
232	F76M930	AR VAT on Gain/loss MEX - 76M	18	AP	ICU	Batch Number	Numeric	Generic Edit	8	0
233	F76M940	AP VAT on Gain/loss - MEX - 76M	15	AP	ICU	Batch Number	Numeric	Generic Edit	8	0
234	F76M990	GL VAT on Gain/loss MEX - 76M	16	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP80D: Plant Manager Dashboard
235	F80D120	SOD Violations	1	SV	ICU	Batch Number	Numeric	Generic Edit	8	0
TOP89: Conversion Programs
236	F05290T	Needed for upgrade from Xe to B9	1	JR	ICU	Batch Number	Numeric	Generic Edit	8	0
237	F063951T	Needed for upgrade from Xe to B9	1	GL	ICU	Batch Number	Numeric	Generic Edit	8	0
TOPF31: Lean Transactions
238	FF31201	Cross Reference	1	CR	ICU	Batch Number	Numeric	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

238 columns | 910 | ICU