Co-Operative PeopleTools Table Reference

Table: PS_RT_RATE_TBL	Return to Index
RT_RATE_TBL	Return to Index

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

PeopleSoft Field Name Description
RT_RATE_INDEX Market Rate Index
Prompt Table: RT_INDEX_TBL
TERM Term
FROM_CUR From Currency Code
Prompt Table: CURRENCY_CD_TBL
TO_CUR To Currency Code
Prompt Table: CURRENCY_CD_TBL
RT_TYPE 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
EFFDT Effective Date
Default: %date
RATE_MULT Rate Multiplier
RATE_DIV Rate Divisor
SYNCID 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.
LASTUPDDTTM 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.
Author: PeopleTools
Return to Index © Go-Faster Consultancy Ltd. Last updated 24 July 2010

PeopleSoft Field Name	Description
RT_RATE_INDEX	Market Rate Index Prompt Table: RT_INDEX_TBL
TERM	Term
FROM_CUR	From Currency Code Prompt Table: CURRENCY_CD_TBL
TO_CUR	To Currency Code Prompt Table: CURRENCY_CD_TBL
RT_TYPE	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
EFFDT	Effective Date Default: %date
RATE_MULT	Rate Multiplier
RATE_DIV	Rate Divisor
SYNCID	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.
LASTUPDDTTM	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.

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd. Last updated 24 July 2010

RT_RATE_TBL

Table: PS_RT_RATE_TBL