PeopleSoft 9
Asset Management

Table Name AM_FMV

Table Description
AM_FMV
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
EFFDT PSDATE Yes No
EFFSEQ SMALLINT Yes No
DATETIME_STAMP PSDATETIME No No
FMV DECIMAL(26,3) No No
APPRAISAL_DT PSDATE No No
VALUATION_METHOD CHAR(30) No No
OPRID CHAR(30) No No
FMV_LOAD_SOURCE CHAR(1) No No
CURRENCY_CD CHAR(3) No No
RT_TYPE CHAR(5) No No
COMMENTS TEXT No No
Index
Name Type Unique Member
PS_AM_FMV PK Yes
Member(s) of "PS_AM_FMV" Index
BUSINESS_UNIT
ASSET_ID
EFFDT
EFFSEQ

Published December 16, 2006