PeopleSoft 9
Account Payables

Table Name RT_RATE_TBL

Table Description
RT_RATE_TBL
Columns
Name Datatype Is PK Is FK
RT_RATE_INDEX VARCHAR(10) Yes Yes
TERM int Yes No
FROM_CUR VARCHAR(3) Yes Yes
TO_CUR VARCHAR(3) Yes Yes
RT_TYPE VARCHAR(5) Yes Yes
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 June 06, 2007