SETIDBANK_CDBANK_ACCT_KEYBNK_BALANCE_VW(SQL View) |
Index Back |
|---|---|
Bank Balances View |
| SELECT A.SETID, A.BANK_CD, B.BANK_ACCT_KEY, C.BANK_STMT_DT, C.STMT_BAL_OPEN, C.STMT_BAL_AVAIL, C.STMT_BAL_CLOSE FROM PS_BANK_CD_TBL A, PS_BANK_ACCT_DEFN B, PS_BNK_BALANCE_TBL C WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.BNK_ID_NBR = C.BNK_ID_NBR AND B.BANK_ACCOUNT_NUM = C.BANK_ACCOUNT_NUM AND C.BANK_STMT_DT = (SELECT MAX(D.BANK_STMT_DT) FROM PS_BNK_BALANCE_TBL D WHERE C.BNK_ID_NBR = D.BNK_ID_NBR AND C.BANK_ACCOUNT_NUM = D.BANK_ACCOUNT_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 3 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 4 | BANK_STMT_DT | Date(10) | DATE | "The bank statement date |
| 5 | STMT_BAL_OPEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement opening balance as submitted by the bank. |
| 6 | STMT_BAL_AVAIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement available balance as submitted by the bank. |
| 7 | STMT_BAL_CLOSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement closing balance as submitted by the bank. |