AM_EXT_AUD_DTL

(SQL Table)
Index Back

Japan Extended 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 EXTENDED_STATUS Character(15) VARCHAR2(15) NOT NULL Extended Depr Status
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 ACCUM_DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Accumulated Depreciation
10 NET_BOOK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value
11 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value