FCT_BNK_LN_AC_MONTH_HIST_INSIGHT
Description
OBP Unsecured Personal Loans with latest balance and latest date by product offer purpose and status from Balance history table not GL table. For Market Share Report
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_ID | CHARACTER VARYING(40) | 40 |
| 2 | OFFER_ID | CHARACTER VARYING(30) | 30 |
| 3 | PRODUCT_ID | CHARACTER VARYING(30) | 30 |
| 4 | OFFER_DESCRIPTION | CHARACTER VARYING(120) | 120 |
| 5 | LOAN_PURPOSE_TYPE | CHARACTER VARYING(100) | 100 |
| 6 | PURPOSE_DESC | CHARACTER VARYING(400) | 400 |
| 7 | STATUS_CODE | CHARACTER VARYING(50) | 50 |
| 8 | STATE_NAME | CHARACTER VARYING(105) | 105 |
| 9 | TRANS_DATE | TIMESTAMP | 8 |