AM_IMP_DTL_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	NET_BOOK_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Book Value
4	NSP_PERCENT	Number(27,6)	DECIMAL(26,6) NOT NULL	NSP Percentage(%)
5	VIU_PERCENT	Number(27,6)	DECIMAL(26,6) NOT NULL	VIU Percentage(%)
6	NSP_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Selling Price
7	VIU_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Value In Use
8	IMPAIR_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Impairment Loss
9	REVAL_REVERSAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation Reversal
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	IN_SERVICE_DT	Date(10)	DATE	In Service Date
12	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
13	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
14	NBV_REVAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation NBV
15	PREV_IMP_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prior Impairment Loss
16	PREV_REVAL_REVERSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prior Reval Reversal
17	IMPAIR_STATUS	Character(15)	VARCHAR2(15) NOT NULL	Impairment Status D=Don't Impair I=Impair Y/N Table Edit
18	MARKED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mark Y/N Table Edit
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
20	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
21	FV_TEMPLATE_ID	Character(12)	VARCHAR2(12) NOT NULL	Fair Value Template ID Prompt Table: AM_FV_TEMPLATE Set Control Field: BUSINESS_UNIT
22	FV_GROUP_ID	Character(20)	VARCHAR2(20) NOT NULL	FV Group ID used to group related FV Assets Prompt Table: %EDITTABLE