AM_CGU_IMP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
6	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9	LAST_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Last Interface ID
10	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
11	IMP_ZERO_COST_ROWS	Character(1)	VARCHAR2(1) NOT NULL	Copy Zero Impair/Revalue Rows
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
13	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
14	IMPAIR_DT	Date(10)	DATE	Impairment Date
15	CGU_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Generating Unit
16	IMP_REVERSE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Impairment Reversal
17	IMPAIR_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Impairment Frequency A=Annually M=Monthly Q=Quarterly S=Semiannually
18	IMPAIR_STRATEGY	Character(1)	VARCHAR2(1) NOT NULL	Impairment Strategy A=Impair by Assets C=Impair by CGU
19	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
20	NET_BOOK_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Book Value for CGU
21	NBV_REVAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation NBV
22	NSP_PERCENT	Number(27,6)	DECIMAL(26,6) NOT NULL	NSP Percentage(%)
23	VIU_PERCENT	Number(27,6)	DECIMAL(26,6) NOT NULL	VIU Percentage(%)
24	NSP_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Selling Price
25	VIU_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Value In Use
26	IMPAIR_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Impairment Loss
27	REVAL_REVERSAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation Reversal
28	PREV_IMP_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prior Impairment Loss
29	PREV_REVAL_REVERSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prior Reval Reversal
30	COPY_TO_OTH_BK	Character(1)	VARCHAR2(1) NOT NULL	Copy Impairment to other books
31	CGU_IMPAIR_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Impairment Loss
32	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
33	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
34	WHERE_CLAUSE2	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
35	IMP_COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type For Impairment Loss
36	REVERSE_COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type for Imp Reversal
37	EXC_AST_IMP_DT_AFT	Date(10)	DATE	Exclude Assets Impaired After
38	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
39	CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Book Depreciation Convention or Cost Convention
40	COMMENTS	Long Character	CLOB	Comment
41	INSERT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	insert flag
42	IMPAIR_ALL_ASSETS	Character(1)	VARCHAR2(1) NOT NULL	Impair All Assets In This CGU
43	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field
44	WHERE_CLAUSE3	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
45	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
46	WHERE_CLAUSE4	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
47	TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Transaction Code