FCT_BNK_DV_FLOW_OF_FUNDS_SSS_SALES_SUMMARY_INSIGHT
Description
Monthly Cost Centre Summary of OBP Loan Account amount flows by sales measures for Disbursements, Payouts, Repayments Interest Cash Back Interal and external refinance growth runoff actuals and budget
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | TIME_PERIOD | DATE | 4 |
| 2 | MONTH_END_ID | NUMERIC(38,0) | 19 |
| 3 | QUARTER_END_ID | NUMERIC(38,0) | 19 |
| 4 | FINANCIAL_END_ID | NUMERIC(38,0) | 19 |
| 5 | SALES_MEASURE | CHARACTER VARYING(256) | 256 |
| 6 | GEOGRAPHIC_STATE | CHARACTER VARYING(3) | 3 |
| 7 | REGION | CHARACTER VARYING(240) | 240 |
| 8 | COST_CENTRE_NAME | CHARACTER VARYING(240) | 240 |
| 9 | APPLICATION_CHANNEL | CHARACTER VARYING(400) | 400 |
| 10 | PRODUCT_GROUP | CHARACTER VARYING(30) | 30 |
| 11 | SOURCE_PRODUCT_L2 | CHARACTER VARYING(100) | 100 |
| 12 | OFFER_DESC | CHARACTER VARYING(120) | 120 |
| 13 | LVR_GROUP | CHARACTER VARYING(50) | 50 |
| 14 | ACTUAL_AMOUNT | DOUBLE PRECISION | 8 |
| 15 | BUDGET_AMOUNT | NUMERIC(38,0) | 19 |
| 16 | DISBURSEMENT_AMT | DOUBLE PRECISION | 8 |
| 17 | REAL_GROWTH | DOUBLE PRECISION | 8 |
| 18 | PORTFOLIO_GROWTH | DOUBLE PRECISION | 8 |
| 19 | RUN_OFF | DOUBLE PRECISION | 8 |
| 20 | PAYOUTS | DOUBLE PRECISION | 8 |
| 21 | REPAYMENTS | DOUBLE PRECISION | 8 |
| 22 | WRITE_OFF | DOUBLE PRECISION | 8 |
| 23 | UNCLASSIFIED | DOUBLE PRECISION | 8 |
| 24 | BDGT_DISBURSEMENT | NUMERIC(38,0) | 19 |
| 25 | BDGT_REAL_GROWTH | NUMERIC(38,0) | 19 |
| 26 | ACTUAL_AMOUNT_MTD | DOUBLE PRECISION | 8 |
| 27 | BUDGET_AMOUNT_MTD | NUMERIC(38,0) | 19 |
| 28 | ACTUAL_AMOUNT_QTD | DOUBLE PRECISION | 8 |
| 29 | BUDGET_AMOUNT_QTD | NUMERIC(38,0) | 19 |
| 30 | ACTUAL_AMOUNT_FYTD | DOUBLE PRECISION | 8 |
| 31 | BUDGET_AMOUNT_FYTD | NUMERIC(38,0) | 19 |