PeopleSoft 9
Asset Management

Table Name RT_RATE_TBL

Table Description
RT_RATE_TBL
Columns
Name Datatype Is PK Is FK
RT_RATE_INDEX char(10) Yes Yes
TERM int Yes No
FROM_CUR char(3) Yes Yes
TO_CUR char(3) Yes Yes
RT_TYPE char(5) Yes No
EFFDT PSDATE Yes No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
SYNCID int No No
LASTUPDDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_RT_RATE_TBL PK Yes
PSART_RATE_TBL AK2 Yes
PSBRT_RATE_TBL IE2 No
Member(s) of "PS_RT_RATE_TBL" Index
RT_RATE_INDEX
TERM
FROM_CUR
TO_CUR
RT_TYPE
EFFDT
Member(s) of "PSART_RATE_TBL" Index
EFFDT
FROM_CUR
TO_CUR
TERM
RT_TYPE
RT_RATE_INDEX
Member(s) of "PSBRT_RATE_TBL" Index
SYNCID

Published December 16, 2006