PeopleSoft 9
Asset Management

Table Name AM_REV_AUD_HDR

Table Description
AM_REV_AUD_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes No
BOOK CHAR(10) Yes No
DTTM_STAMP PSDATETIME Yes No
IMPAIR_DT PSDATE No No
CATEGORY CHAR(5) No No
IMPAIR_FREQUENCY 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
REVALUE_METHOD CHAR(1) No No
INCL_CUR_PD_DEPR CHAR(1) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_AM_REV_AUD_HDR PK Yes
PS0AM_REV_AUD_HDR IE1 No
Member(s) of "PS_AM_REV_AUD_HDR" Index
BUSINESS_UNIT
BOOK
DTTM_STAMP
Member(s) of "PS0AM_REV_AUD_HDR" Index
IMPAIR_DT
BUSINESS_UNIT
BOOK
DTTM_STAMP

Published December 16, 2006