BNK_ID_NBRBNK_BTB_BKID_VW(SQL View) |
Index Back |
|---|---|
Book to Bank Search record |
| SELECT DISTINCT A.BNK_ID_NBR ,B.DESCR ,B.SETID ,B.BANK_CD ,B.COUNTRY FROM PS_BNK_BTB_HDR A ,PS_BANK_CD_TBL B WHERE B.BNK_ID_NBR=A.BNK_ID_NBR |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 4 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |