	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

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

245 columns | 920 | ICU