EOER_MSG_VW (SQL View)	Index Back
Exchange Rate ABM Data Shape Exchange Rate Application Business Message Data Shape The WHERE-Clause is the same as in View RT_DFLT_VW for the Exchange Rate

EOER_MSG_VW

(SQL View)

Exchange Rate ABM Data Shape

Exchange Rate Application Business Message Data Shape The WHERE-Clause is the same as in View RT_DFLT_VW for the Exchange Rate

SELECT DISTINCT A.FROM_CUR , A.TO_CUR , A.RT_TYPE , A.EFFDT , C.REF_CUR , A.RATE_MULT , A.RATE_DIV FROM PS_RT_RATE_TBL A LEFT OUTER JOIN PS_CURR_QUOTE_TBL C ON C.FROM_CUR = A.FROM_CUR AND C.TO_CUR = A.TO_CUR AND C.EFFDT <= A.EFFDT AND C.EFF_STATUS = 'A' AND C.RATE_TRIANGULATE = 'Y' , PS_RT_INDEX_TBL B WHERE A.RT_RATE_INDEX = B.RT_RATE_INDEX AND A.TERM = 0 AND B.DEFAULT_INDEX = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

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

3 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.

4 EFFDT Date(10) DATE Effective Date

5 REF_CUR Character(3) VARCHAR2(3) NOT NULL Reference Currency

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
2	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
3	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.
4	EFFDT	Date(10)	DATE	Effective Date
5	REF_CUR	Character(3)	VARCHAR2(3) NOT NULL	Reference Currency
6	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
7	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor