FCT_BNK_NEW_ACCOUNTS_OPENED_CASA_TD_REPORT_INSIGHT
Description
New OBP CASA and Term DEposit Accounts with their balance offer and date opened
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | BRANCH_NUMBER | CHARACTER VARYING(10) | 10 |
| 2 | BRANCH_NAME | CHARACTER VARYING(105) | 105 |
| 3 | OPPORTUNITY_ID | CHARACTER VARYING(40) | 40 |
| 4 | CUSTOMER_NAME | CHARACTER VARYING(250) | 250 |
| 5 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 6 | CURRENT_BALANCE | DOUBLE PRECISION | 8 |
| 7 | OFFER | CHARACTER VARYING(120) | 120 |
| 8 | DATE_OPEN | DATE | 4 |