POOL_IDBANK_CDBANK_ACCT_KEYBANK_POOL_BALVW(SQL View) |
Index Back |
|---|---|
View for Bank Pool View Page |
| SELECT DISTINCT B.POOL_ID , B.BANK_CD , B.BANK_ACCT_KEY , B.DESCR , C.CURRENCY_CD , C.STMT_BAL_AVAIL FROM PS_BANK_ACCT_DEFN B , PS_BANK_CD_TBL A , PS_BNK_BALANCE_TBL C WHERE A.BANK_CD = B.BANK_CD AND a.setid=b.setid AND B.BANK_ACCOUNT_NUM = C.BANK_ACCOUNT_NUM AND A.BNK_ID_NBR = C.BNK_ID_NBR AND C.BANK_STMT_DT = ( SELECT MAX(D.BANK_STMT_DT) FROM PS_BNK_BALANCE_TBL D WHERE D.BNK_ID_NBR = A.BNK_ID_NBR AND D.BANK_ACCOUNT_NUM = B.BANK_ACCOUNT_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POOL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
| 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | STMT_BAL_AVAIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement available balance as submitted by the bank. |