FCT_BNK_DV_FLOW_OF_FUNDS_SSS_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 NET_TRANSFER DOUBLE PRECISION 8
14 DISBURSEMENT DOUBLE PRECISION 8
15 PAYOUTS DOUBLE PRECISION 8
16 INTEREST DOUBLE PRECISION 8
17 REPAYMENTS 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 NET_OTHER DOUBLE PRECISION 8
25 GROWTH NUMERIC(38,2) 19
26 RUN_OFF DOUBLE PRECISION 8
27 EXTERNAL_REFINANCE DOUBLE PRECISION 8
28 MINIMUM_REPAYMENT DOUBLE PRECISION 8
29 REPAYMENT_FREQUENCY_MONTHLY_COUNT NUMERIC(38,0) 19
30 MEASURES_CURRENT_MONTH_TOTAL DOUBLE PRECISION 8
31 MEASURES_PREVIOUS_MONTH_TOTAL DOUBLE PRECISION 8
32 MARGIN_LOAN_MONTH_AMOUNT DOUBLE PRECISION 8
33 MARGIN_AMOUNT_RATE DOUBLE PRECISION 8
34 INT_LOAN_AMT DOUBLE PRECISION 8
35 INT_LOAN_AMT_MARGIN DOUBLE PRECISION 8