UPG_AM7_AET

(SQL Table)
Index Back

# 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