BNK_SUM_CUR_VW2(SQL View) |
Index Back |
|---|---|
Bank Acct Bal Sum by Curr Vw |
| SELECT CURRENCY_CD , BANK_STMT_DT , SUM(STMT_BAL_OPEN) STMT_BAL_OPEN , SUM(STMT_BAL_AVAIL) STMT_BAL_AVAIL , SUM(STMT_BAL_CLOSE) STMT_BAL_CLOSE , STMT_BAL_CLOSE_DT , BNK_ID_NBR , BANK_CD FROM PS_BNK_BAL_AAA_VW GROUP BY CURRENCY_CD , BANK_STMT_DT , STMT_BAL_CLOSE_DT , BNK_ID_NBR , BANK_CD |
| # | 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. |
| 7 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 8 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |