RT_RATE_TBL

index back

Market Rate Data Table

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

PeopleSoft Field Name Field Type Column Type Description
RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

Prompt Table: RT_INDEX_TBL

TERM Number(5,0) INTEGER NOT NULL Term
FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

Prompt Table: CURRENCY_CD_TBL

TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

Prompt Table: CURRENCY_CD_TBL

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

EFFDT Date(10) DATE Effective Date

Default: %date

RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
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.
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.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19