FCT_BNK_DV_FLOW_OF_FUNDS_RRR_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TIME_PERIOD DATE 4
2 CATEGORY CHARACTER VARYING(256) 256
3 COST_CENTRE CHARACTER VARYING(240) 240
4 REGION CHARACTER VARYING(240) 240
5 STATE CHARACTER VARYING(3) 3
6 PRODUCT_GROUP CHARACTER VARYING(16) 16
7 OFFER_TYPE CHARACTER VARYING(120) 120
8 CHANNEL CHARACTER VARYING(400) 400
9 OCCUPANCY CHARACTER VARYING(14) 14
10 BUSINESS_LENDING_SEGMENT CHARACTER VARYING(240) 240
11 LVR_GROUP CHARACTER VARYING(9) 9
12 CLOSING_BALANCE DOUBLE PRECISION 8
13 DISBURSEMENT DOUBLE PRECISION 8
14 PAYOUTS DOUBLE PRECISION 8
15 INTEREST DOUBLE PRECISION 8
16 REPAYMENTS DOUBLE PRECISION 8
17 REPAYMENTS_AND_PAYOUTS DOUBLE PRECISION 8
18 PORTFOLIO DOUBLE PRECISION 8
19 CASH_BACK DOUBLE PRECISION 8
20 INFLOW DOUBLE PRECISION 8
21 OUTFLOW DOUBLE PRECISION 8
22 REPAYMENT_EXCESSES DOUBLE PRECISION 8
23 REPAYMENT_SHORTFALL DOUBLE PRECISION 8
24 REPAYMENT_CURTAILMENT DOUBLE PRECISION 8
25 REPAYMENT_DISHONOURED DOUBLE PRECISION 8
26 REPAYMENT_SCHEDULED DOUBLE PRECISION 8
27 NET_OTHER DOUBLE PRECISION 8
28 GROWTH NUMERIC(38,2) 19
29 RUN_OFF DOUBLE PRECISION 8
30 MINIMUM_REPAYMENT DOUBLE PRECISION 8
31 REPAYMENT_FREQUENCY_MONTHLY_COUNT NUMERIC(38,0) 19
32 EXTERNAL_REFINANCE DOUBLE PRECISION 8
33 INTERNAL_REFINANCE DOUBLE PRECISION 8
34 MEASURES_CURRENT_MONTH_TOTAL DOUBLE PRECISION 8
35 MEASURES_PREVIOUS_MONTH_TOTAL DOUBLE PRECISION 8
36 MARGIN_LOAN_MONTH_AMOUNT DOUBLE PRECISION 8
37 MARGIN_AMOUNT_RATE DOUBLE PRECISION 8
38 INT_LOAN_AMT DOUBLE PRECISION 8
39 INT_LOAN_AMT_MARGIN DOUBLE PRECISION 8