UPG_AM7_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
5	RETIREMENT_PCT	Signed Number(20,12)	DECIMAL(18,12) NOT NULL	Retirement PCT
6	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	SETID_LAST	Character(5)	VARCHAR2(5) NOT NULL	Last SetID
9	CALENDAR_ID_LAST	Character(2)	VARCHAR2(2) NOT NULL	LAST CALENDAR_ID
10	RETIRE_CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Retirement Convention
11	BEGIN_DEPR_DT	Date(10)	DATE	Begin Depr Date
12	BEGIN_DEPR_FY	Number(4,0)	SMALLINT NOT NULL	Begin Depreciation Fiscal Year
13	BEGIN_DEPR_PD	Number(3,0)	SMALLINT NOT NULL	Begin Depreciation Period
14	LIFE	Number(4,0)	SMALLINT NOT NULL	Useful Life
15	SUSPENDED_PERIODS	Number(4,0)	SMALLINT NOT NULL	Number of Suspended Periods
16	END_DEPR_DT	Date(10)	DATE	End Depreciation Date
17	END_DEPR_FY	Number(4,0)	SMALLINT NOT NULL	End Depreciation Year
18	END_DEPR_PD	Number(3,0)	SMALLINT NOT NULL	End Depreciation Period
19	BEGIN_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Begin Depr Period Fraction
20	CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Book Depreciation Convention or Cost Convention
21	GROUP_ASSET_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Group Asset Flag G=Group Asset M=Group Member N=None
22	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
23	BEGIN_DT_LAST_PD	Date(10)	DATE	Last Period Begin Date
24	COUNTER3	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Counter 3
25	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.
26	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
27	COUNTER8	Number(8,0)	INTEGER NOT NULL	Counter - Unsigned 8