FCT_BNK_DV_FLOW_OF_FUNDS_SSS_SALES_SUMMARY_DEP_INSIGHT
Description
Monthly Cost Centre Summary of OBP Term Deposit amount flows by sales measures for Disbursements, Payouts, Repayments Interest Cash Back Interal and external refinance growth runoff actuals and budget
Source Object (CTAS)
SDSNZP05_BANK..FCT_BNK_DV_FLOW_OF_FUNDS_SSS_SALES_SUMMARY_DEP
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(50) | 50 |
| 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 | SOURCE_PRODUCT_L3_DESC | CHARACTER VARYING(100) | 100 |
| 13 | SOURCE_PRODUCT_L4_DESC | CHARACTER VARYING(100) | 100 |
| 14 | OFFER_DESC | CHARACTER VARYING(120) | 120 |
| 15 | ACTUAL_AMOUNT | DOUBLE PRECISION | 8 |
| 16 | PORTFOLIO_GROWTH | DOUBLE PRECISION | 8 |
| 17 | REAL_GROWTH | DOUBLE PRECISION | 8 |
| 18 | PORTFOLIO | DOUBLE PRECISION | 8 |
| 19 | ACTUAL_AMOUNT_MTD | DOUBLE PRECISION | 8 |
| 20 | ACTUAL_AMOUNT_QTD | DOUBLE PRECISION | 8 |
| 21 | ACTUAL_AMOUNT_FYTD | DOUBLE PRECISION | 8 |