	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

20 COLUMNS | 1 INDEXES | 910 | 76H | F76H6205 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76H: Chile
1	910	F76H6205	IR	20	1	Item Replacement Cost - CHI - 41	Files	76H: Chile

TOP 910 | 76H | F76H6205 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IRH76LECO	Legal Company	String	Generic Edit	5	0	Allow NULL?
2	IRCFY	Century/Fiscal Year	Numeric	Generic Edit	4	0	Allow NULL?
3	IRFFP	From Period - From	Numeric	Generic Edit	2	0	Allow NULL?
4	IRITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
5	IRMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	IRLOCN	Location	String	Generic Edit	20	0	Allow NULL?
7	IRLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
8	IRLEDG	Cost Method	String	UDC (40 CM)	2	0	Allow NULL?
9	IRGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
10	IRMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
11	IROBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
12	IRSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
13	IRNQ01	Net Quantity 01	Numeric	Generic Edit	15	2	Allow NULL?
14	IRUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
15	IRAN01	Amount - Net Posting 01	Numeric	Generic Edit	15	2	Allow NULL?
16	IRUSER	User ID	String	Generic Edit	10	0	Allow NULL?
17	IRPID	Program ID	String	Generic Edit	10	0	Allow NULL?
18	IRJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
19	IRUPMJ	Date - Updated	Date	Generic Edit	6	0
20	IRTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

Number

Description

h76leco cfy ffp itm mcu locn + (Primary/Unique)

Element	Alias	Description	Sequence
1	H76LECO	Legal Company	Ascending
2	CFY	Century/Fiscal Year	Ascending
3	FFP	From Period - From	Ascending
4	ITM	Item Number - Short	Ascending
5	MCU	Business Unit	Ascending
6	LOCN	Location	Ascending
7	LOTN	Lot/Serial Number	Ascending
8	LEDG	Cost Method	Ascending
9	GLPT	Category - G/L	Ascending
10	MCUS	Business Unit - Subsequent	Ascending