PeopleSoft 9
Asset Management

Table Name AM_INDEX_DETAIL

Table Description
AM_INDEX_DETAIL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
INDEX_NAME char(20) Yes Yes
EFFDT PSDATE Yes Yes
INDEX_DETAIL_NAME char(35) Yes No
INDEX_AMOUNT decimal(26,3) No No
CURRENCY_CD char(3) No Yes
Index
Name Type Unique Member
PS_AM_INDEX_DETAIL PK Yes
Member(s) of "PS_AM_INDEX_DETAIL" Index
SETID
INDEX_NAME
EFFDT
INDEX_DETAIL_NAME

Published December 16, 2006