BNK_ID_NBRBANK_ACCOUNT_NUMTR_BNK_IHB_VW(SQL View) |
Index Back |
|---|---|
Treasury Internal Bank view |
| SELECT B.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.DEBIT_RT_INDEX , A.DEBIT_MARGIN_PTS , A.CREDIT_RT_INDEX , A.CREDIT_MARGIN_PTS FROM PS_BANK_ACCT_DEFN A , PS_BANK_CD_TBL B WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND B.BANK_TYPE = 'I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 2 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 3 | DEBIT_RT_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Debit Rate Index |
| 4 | DEBIT_MARGIN_PTS | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Debit Margin Point |
| 5 | CREDIT_RT_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Credit Rate Index |
| 6 | CREDIT_MARGIN_PTS | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Credit Margin Point |