BNK_SUM_BANK_VW(SQL View) |
Index Back |
|---|---|
Bank Acct Bal Sum by Bank Vw |
| SELECT BANK_CD , CURRENCY_CD , BANK_STMT_DT , SUM(STMT_BAL_OPEN) , SUM(STMT_BAL_CLOSE) , STMT_BAL_CLOSE_DT , SUM(STMT_BAL_AVAIL) , BNK_ID_NBR FROM PS_BNK_BAL_AAA_VW GROUP BY BANK_CD , BNK_ID_NBR ,CURRENCY_CD , BANK_STMT_DT , STMT_BAL_CLOSE_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 2 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 3 | BANK_STMT_DT | Date(10) | DATE | "The bank statement date |
| 4 | STMT_BAL_OPEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement opening balance as submitted by the bank. |
| 5 | STMT_BAL_CLOSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement closing balance as submitted by the bank. |
| 6 | STMT_BAL_CLOSE_DT | Date(10) | DATE | The bank statement closing balance date as submitted by the bank. |
| 7 | STMT_BAL_AVAIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement available balance as submitted by the bank. |
| 8 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |