RT_RATE_TBL (SQL Table)	Index Back
Market Rate Data Table Market Rates table. Key placed on Term used for Prompting for a specific terms.

RT_RATE_TBL

(SQL Table)

Market Rate Data Table

Market Rates table. Key placed on Term used for Prompting for a specific terms.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
Prompt Table: RT_INDEX_TBL

2 TERM Number(5,0) INTEGER NOT NULL Term

3 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code
Prompt Table: CURRENCY_CD_TBL

4 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code
Prompt Table: CURRENCY_CD_TBL

5 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

7 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

8 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index Prompt Table: RT_INDEX_TBL
2	TERM	Number(5,0)	INTEGER NOT NULL	Term
3	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code Prompt Table: CURRENCY_CD_TBL
4	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code Prompt Table: CURRENCY_CD_TBL
5	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
8	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
9	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.