BNK_CURR_RVL_VW (SQL View)	Index Back
Rate Revaluation View View to aid in revaluing transaction amounts to the base currency of a bank account.

BNK_CURR_RVL_VW

(SQL View)

Rate Revaluation View

View to aid in revaluing transaction amounts to the base currency of a bank account.

SELECT A.SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.CURRENCY_CD , C.CURRENCY_CD , C.RATE_INDEX , C.CUR_RT_TYPE , R.EFFDT , B.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , R.RATE_MULT , R.RATE_DIV , D.DECIMAL_POSITIONS FROM PS_BANK_ACCT_DEFN A , PS_BANK_CD_TBL B ,PS_BANK_ACCT_CURR C ,PS_RT_RATE_TBL R ,PS_CURRENCY_CD_TBL D WHERE A.SETID = C.SETID AND B.SETID = A.SETID AND B.BANK_CD = C.BANK_CD AND A.BANK_CD = C.BANK_CD AND A.BANK_CD_CPTY = C.BANK_CD_CPTY AND A.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND R.RT_RATE_INDEX = C.RATE_INDEX AND R.TERM = 0 AND R.FROM_CUR = C.CURRENCY_CD AND R.TO_CUR = A.CURRENCY_CD AND R.RT_TYPE = C.CUR_RT_TYPE AND D.CURRENCY_CD = A.CURRENCY_CD AND D.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_CURRENCY_CD_TBL A_ED WHERE D.CURRENCY_CD = A_ED.CURRENCY_CD AND A_ED.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

4 BASE_CURRENCY_BNK Character(3) VARCHAR2(3) NOT NULL The base currency of the subject bank general ledger business unit.

5 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

6 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index

7 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

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

9 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

10 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

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

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

13 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
4	BASE_CURRENCY_BNK	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the subject bank general ledger business unit.
5	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
6	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index
7	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
8	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
9	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
10	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
11	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
12	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
13	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions