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 NameField TypeColumn TypeDescription
RT_RATE_INDEXCharacter(10)VARCHAR2(10) NOT NULLMarket Rate Index

Prompt Table: RT_INDEX_TBL

TERMNumber(5,0)INTEGER NOT NULLTerm
FROM_CURCharacter(3)VARCHAR2(3) NOT NULLFrom Currency Code

Prompt Table: CURRENCY_CD_TBL

TO_CURCharacter(3)VARCHAR2(3) NOT NULLTo Currency Code

Prompt Table: CURRENCY_CD_TBL

RT_TYPECharacter(5)VARCHAR2(5) NOT NULLDefines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL

EFFDTDate(10)DATEEffective Date

Default: %date

RATE_MULTSigned Number(17,8)DECIMAL(15,8) NOT NULLRate Multiplier
RATE_DIVNumber(16,8)DECIMAL(15,8) NOT NULLRate Divisor
SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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.
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19