FCT_BNK_CRHDS_CTR_FACILITY_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 AUTO_FACILITY_ID CHARACTER VARYING(50) 50
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 FACILITY_ID CHARACTER VARYING(50) 50
4 CALL_TYPE CHARACTER VARYING(50) 50
5 COMMITMENT_TYPE CHARACTER VARYING(50) 50
6 IS_EXISTING_FACILITY CHARACTER VARYING(5) 5
7 BANKING_TYPE CHARACTER VARYING(50) 50
8 LOAN_TYPE CHARACTER VARYING(50) 50
9 PAYMENT_OPTION CHARACTER VARYING(50) 50
10 LOAN_TERM DOUBLE PRECISION 8
11 INT_ONLY_TERM DOUBLE PRECISION 8
12 REM_FIX_RT_PER DOUBLE PRECISION 8
13 SEC_ASST_TYPE CHARACTER VARYING(50) 50
14 LOAN_AMOUNT NUMERIC(22,2) 19
15 OWNR_PERC DOUBLE PRECISION 8
16 N_DAYS_FIR_PAY_MON DOUBLE PRECISION 8
17 ACC_KEEP_PRD CHARACTER VARYING(50) 50
18 SENS_INT_RT DOUBLE PRECISION 8
19 SENS_REPY_M DOUBLE PRECISION 8
20 SENS_REPY_Y DOUBLE PRECISION 8
21 CONT_REPY_M DOUBLE PRECISION 8
22 CONT_REPY_Y DOUBLE PRECISION 8
23 INT_RT_NAME_1 CHARACTER VARYING(50) 50
24 INT_RT_VAL_1 DOUBLE PRECISION 8
25 INT_RT_NAME_2 CHARACTER VARYING(50) 50
26 INT_RT_VAL_2 DOUBLE PRECISION 8
27 INT_RT_NAME_3 CHARACTER VARYING(50) 50
28 INT_RT_VAL_3 DOUBLE PRECISION 8
29 INT_RT_NAME_4 CHARACTER VARYING(50) 50
30 INT_RT_VAL_4 DOUBLE PRECISION 8
31 INT_RT_NAME_5 CHARACTER VARYING(50) 50
32 INT_RT_VAL_5 DOUBLE PRECISION 8
33 INT_RT_NAME_6 CHARACTER VARYING(50) 50
34 INT_RT_VAL_6 DOUBLE PRECISION 8
35 ACC_KEEP_AMT NUMERIC(22,2) 19
36 BALLOON_COMP_AMT NUMERIC(22,2) 19
37 ADVISED_REPAY_PRD CHARACTER VARYING(50) 50
38 ADVISED_REPAY_AMT NUMERIC(22,2) 19