FCT_OBP_ROFT_MNTH_FLOW_OF_FUNDS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TIME_PERIOD DATE 4
2 CLOSING_PERIOD_DIM_ID INTEGER 4
3 CATEGORY CHARACTER VARYING(256) 256
4 COST_CENTRE CHARACTER VARYING(240) 240
5 REGION CHARACTER VARYING(240) 240
6 STATE CHARACTER VARYING(3) 3
7 PRODUCT_GROUP CHARACTER VARYING(30) 30
8 OFFER_TYPE CHARACTER VARYING(120) 120
9 CHANNEL CHARACTER VARYING(400) 400
10 OCCUPANCY CHARACTER VARYING(14) 14
11 BUSINESS_LENDING_SEGMENT_L3 CHARACTER VARYING(240) 240
12 LVR_GROUP CHARACTER VARYING(9) 9
13 MINIMUM_REPAYMENT DOUBLE PRECISION 8
14 CLOSING_BALANCE DOUBLE PRECISION 8
15 NET_TRANSFER DOUBLE PRECISION 8
16 INFLOW DOUBLE PRECISION 8
17 OUTFLOW DOUBLE PRECISION 8
18 REPAYMENT_EXCESSES DOUBLE PRECISION 8
19 REPAYMENT_SHORTFALL DOUBLE PRECISION 8
20 REPAYMENT_CURTAILMENT DOUBLE PRECISION 8
21 REPAYMENT_DISHONOURED DOUBLE PRECISION 8
22 REPAYMENT_SCHEDULED DOUBLE PRECISION 8
23 REPAYMENT_FREQUENCY_MONTHLY_COUNT NUMERIC(38,0) 19
24 DISBURSEMENT DOUBLE PRECISION 8
25 PAYOUTS DOUBLE PRECISION 8
26 INTEREST DOUBLE PRECISION 8
27 REPAYMENTS DOUBLE PRECISION 8
28 REPAYMENTS_AND_PAYOUTS DOUBLE PRECISION 8
29 CASH_BACK DOUBLE PRECISION 8
30 PORTFOLIO DOUBLE PRECISION 8
31 NET_OTHER DOUBLE PRECISION 8
32 GROWTH NUMERIC(38,2) 19
33 RUN_OFF DOUBLE PRECISION 8
34 EXTERNAL_REFINANCE DOUBLE PRECISION 8
35 INTERNAL_REFINANCE DOUBLE PRECISION 8
36 PREV_DISBURSEMENT DOUBLE PRECISION 8
37 PREV_PAYOUTS DOUBLE PRECISION 8
38 PREV_REPAYMENTS DOUBLE PRECISION 8
39 PREV_REPAYMENTS_AND_PAYOUTS DOUBLE PRECISION 8
40 PREV_INTEREST DOUBLE PRECISION 8
41 PREV_PORTFOLIO DOUBLE PRECISION 8
42 PREV_CASH_BACK DOUBLE PRECISION 8
43 PREV_INT_LOAN_AMT DOUBLE PRECISION 8
44 INT_DIS_LOAN_AMT DOUBLE PRECISION 8
45 INT_PAYO_LOANT_AMT DOUBLE PRECISION 8
46 INT_REPAY_LOANT_AMT DOUBLE PRECISION 8
47 INT_INTER_LOANT_AMT DOUBLE PRECISION 8
48 INT_PORTFOLIO_LOANT_AMT DOUBLE PRECISION 8
49 INT_CASHB_LOANT_AMT DOUBLE PRECISION 8
50 INT_DIS_MARGIN_RATE DOUBLE PRECISION 8
51 INT_PAYO_MARGIN_RATE DOUBLE PRECISION 8
52 INT_REPAY_MARGIN_RATE DOUBLE PRECISION 8
53 INT_INTER_MARGIN_RATE DOUBLE PRECISION 8
54 INT_PORTFOLIO_MARGIN_RATE DOUBLE PRECISION 8
55 INT_CASHB_MARGIN_RATE DOUBLE PRECISION 8
56 INT_LOAN_AMT DOUBLE PRECISION 8
57 INT_LOAN_AMT_MARGIN DOUBLE PRECISION 8