BNK_SUM_CURR_VW(SQL View) |
Index Back |
|---|---|
Bank Acct Bal Sum by Curr Vw |
| select currency_cd,bank_stmt_dt, sum(STMT_BAL_OPEN), SUM(STMT_BAL_AVAIL), SUM(STMT_BAL_CLOSE), STMT_BAL_CLOSE_DT from PS_BNK_BAL_AAA_VW group by currency_cd,bank_stmt_dt,STMT_BAL_CLOSE_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 2 | BANK_STMT_DT | Date(10) | DATE | "The bank statement date |
| 3 | STMT_BAL_OPEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement opening balance as submitted by the bank. |
| 4 | STMT_BAL_AVAIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement available 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. |