PeopleSoft 9.0
Cash 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 No
TO_CUR CHAR(3) Yes No
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 AK1 Yes
PSBRT_RATE_TBL IE1 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 April 30, 2007