AM_REV_DTL_TMP

(SQL Table)
Index Back

Revalue Results Behind Grid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
4 NET_BOOK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 IN_SERVICE_DT Date(10) DATE In Service Date
7 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
8 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
9 NBV_REVAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Revaluation NBV
10 PREV_IMP_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Prior Impairment Loss
11 PRIOR_IMP_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Prior Impairment Loss only
12 PREV_REVAL_REVERSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Prior Reval Reversal
13 IMPAIR_STATUS Character(15) VARCHAR2(15) NOT NULL Impairment Status
D=Don't Impair
I=Impair

Y/N Table Edit

14 MARKED_FLG Character(1) VARCHAR2(1) NOT NULL Mark

Y/N Table Edit

15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
17 ACCUM_DEPR_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Accum. Depr. Adjustment
18 FMV Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair (Market) Value Amount
19 ORIGINAL_FMV Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair Market Value
20 REVALUATION Signed Number(28,3) DECIMAL(26,3) NOT NULL Revaluation
21 COST_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Adjustment
22 ACCUM_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Depreciation
23 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
24 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
25 COMMENTS_PB Character(1) VARCHAR2(1) NOT NULL Comments
26 COMMENTS Long Character CLOB Comment
27 REVAL_REVERSAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Revaluation Reversal
28 PREV_IMP_LOSS_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Prior Impairment Loss
29 AMOUNT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
30 PREV_IMP_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Imp Loss for Imp Cost Type oly
31 FV_TEMPLATE_ID Character(12) VARCHAR2(12) NOT NULL Fair Value Template ID

Prompt Table: AM_FV_TEMPLATE
Set Control Field: BUSINESS_UNIT

32 FV_GROUP_ID Character(20) VARCHAR2(20) NOT NULL FV Group ID used to group related FV Assets

Prompt Table: AM_FV_GROUP
Set Control Field: BUSINESS_UNIT