SETIDBANK_CDBANK_ACCT_KEYBNK_ID_NBRBANK_ACCOUNT_NUMBASE_CURRENCY_BNKTXN_CURRENCY_CDRATE_INDEXCUR_RT_TYPEEFFDTDefault Value: %date
BNK_CURR_RVL_V2(SQL View) |
Index Back |
|---|---|
Rate Revaluation ViewView to aid in revaluing transaction amounts to the base currency of a bank account. |
| SELECT A.SETID , A.BANK_CD , B.BANK_ACCT_KEY , A.BNK_ID_NBR , B.BANK_ACCOUNT_NUM , B.CURRENCY_CD , C.CURRENCY_CD , C.RATE_INDEX , C.CUR_RT_TYPE , D.EFFDT , D.RATE_MULT , D.RATE_DIV , E.DECIMAL_POSITIONS FROM PS_BANK_CD_TBL A ,PS_BANK_ACCT_DEFN B ,PS_BANK_ACCT_CURR C ,PS_RT_RATE_TBL D ,PS_CURRENCY_CD_TBL E WHERE B.SETID = A.SETID AND B.BANK_CD = A.BANK_CD AND B.BANK_CD_CPTY = A.BANK_CD AND C.SETID = B.SETID AND C.BANK_CD = B.BANK_CD AND C.BANK_CD_CPTY = B.BANK_CD_CPTY AND C.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND D.RT_RATE_INDEX = C.RATE_INDEX AND D.TERM = 0 AND D.FROM_CUR = C.CURRENCY_CD AND D.TO_CUR = B.CURRENCY_CD AND D.RT_TYPE = C.CUR_RT_TYPE AND E.CURRENCY_CD = B.CURRENCY_CD AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CURRENCY_CD_TBL WHERE CURRENCY_CD = E.CURRENCY_CD AND 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 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 5 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 6 | BASE_CURRENCY_BNK |
Character(3) | VARCHAR2(3) NOT NULL | The base currency of the subject bank general ledger business unit. |
| 7 | TXN_CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 8 | RATE_INDEX |
Character(10) | VARCHAR2(10) NOT NULL | Rate index |
| 9 | CUR_RT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 10 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 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 |