TR_BNK_HIS_VW(SQL View) |
Index Back |
|---|
| SELECT BANK_ACCOUNT_NUM ,BNK_ID_NBR ,VALUE_DT ,SUM(BALANCE) ,CASE WHEN SUM(BALANCE) < 0 THEN 10 ELSE 5 END ,'' FROM PS_BANK_BALANCES WHERE BANK_STMT_CODE = '015' AND %DateAdd(VALUE_DT,7) > %CurrentDateIn GROUP BY BANK_ACCOUNT_NUM,BNK_ID_NBR,VALUE_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 2 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 3 | VALUE_DT | Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 4 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 5 | TR_CHART_COLOR | Number(3,0) | SMALLINT NOT NULL | Chart Color |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |