PeopleSoft 9
Asset Management

Table Name AM_IMP_AUD_DTL

Table Description
AM_IMP_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 No
IMPAIR_DT PSDATE No No
NET_BOOK_VALUE decimal(26,3) No No
NSP_PERCENT DECIMAL(26,6) No No
VIU_PERCENT DECIMAL(26,6) No No
NSP_AMOUNT decimal(26,3) No No
VIU_AMOUNT decimal(26,3) No No
IMPAIR_LOSS decimal(26,3) No No
REVAL_REVERSAL decimal(26,3) No No
COMMENTS_254 char(254) No No
IMPAIR_STATUS char(15) No No
CATEGORY char(5) No No
Index
Name Type Unique Member
PS_AM_IMP_AUD_DTL PK Yes
PS0AM_IMP_AUD_DTL IE1 No
Member(s) of "PS_AM_IMP_AUD_DTL" Index
BUSINESS_UNIT
BOOK
DTTM_STAMP
ASSET_ID
Member(s) of "PS0AM_IMP_AUD_DTL" Index
IMPAIR_DT
BUSINESS_UNIT
BOOK
DTTM_STAMP
ASSET_ID

Published December 16, 2006