AM_IMP_AUD_DTL

(SQL Table)
Index Back

Impairment Audit Detail

# 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 DTTM_STAMP DateTime(26) TIMESTAMP NOT NULL 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.
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 IMPAIR_DT Date(10) DATE NOT NULL Impairment Date
6 NET_BOOK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value
7 NSP_PERCENT Number(27,6) DECIMAL(26,6) NOT NULL NSP Percentage(%)
8 VIU_PERCENT Number(27,6) DECIMAL(26,6) NOT NULL VIU Percentage(%)
9 NSP_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Selling Price
10 VIU_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Value In Use
11 IMPAIR_LOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Impairment Loss
12 REVAL_REVERSAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Revaluation Reversal
13 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
14 IMPAIR_STATUS Character(15) VARCHAR2(15) NOT NULL Impairment Status
D=Don't Impair
I=Impair
15 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category