PeopleSoft 9
Asset Management

Table Name AM_IMP_AUD_HDR

Table Description
AM_IMP_AUD_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes No
IMPAIR_DT PSDATE No No
CATEGORY char(5) No No
CGU_ID char(20) No Yes
IMP_REVERSE_FLG char(1) No No
IMPAIR_FREQUENCY char(1) No No
IMPAIR_STRATEGY char(1) No No
ACCOUNTING_DT PSDATE No No
CONVENTION char(2) No No
COPY_TO_OTH_BK char(1) No No
CURRENCY_CD char(3) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_AM_IMP_AUD_HDR PK Yes
PS0AM_IMP_AUD_HDR IE1 No
PS1AM_IMP_AUD_HDR IE2 No
Member(s) of "PS_AM_IMP_AUD_HDR" Index
BUSINESS_UNIT
BOOK
DTTM_STAMP
Member(s) of "PS0AM_IMP_AUD_HDR" Index
IMPAIR_DT
BUSINESS_UNIT
BOOK
DTTM_STAMP
Member(s) of "PS1AM_IMP_AUD_HDR" Index
CGU_ID
BUSINESS_UNIT
BOOK
DTTM_STAMP

Published December 16, 2006