PeopleSoft 9
Asset Management

Table Name AM_REV_AUD_DTL

Table Description
AM_REV_AUD_DTL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
BOOK CHAR(10) Yes Yes
DTTM_STAMP PSDATETIME Yes Yes
ASSET_ID char(12) Yes Yes
IMPAIR_STATUS CHAR(15) No No
COST DECIMAL(26,3) No No
ACCUM_DEPR DECIMAL(26,3) No No
NET_BOOK_VALUE DECIMAL(26,3) No No
FMV DECIMAL(26,3) No No
REVALUATION DECIMAL(26,3) No No
COST_ADJ DECIMAL(26,3) No No
ACCUM_DEPR_ADJ DECIMAL(26,3) No No
PREV_IMP_LOSS DECIMAL(26,3) No No
PREV_REVAL_REVERSE DECIMAL(26,3) No No
REVAL_REVERSAL DECIMAL(26,3) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_AM_REV_AUD_DTL PK Yes
Member(s) of "PS_AM_REV_AUD_DTL" Index
BUSINESS_UNIT
BOOK
DTTM_STAMP
ASSET_ID

Published December 16, 2006