OBP24_CZ_SC_OR_CTR_FACILITY

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_CZ_SC_OR_CTR_FACILITY

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 DOUBLE PRECISION 8
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 DOUBLE PRECISION 8
36 BALLOON_COMP_AMT DOUBLE PRECISION 8
37 ADVISED_REPAY_PRD CHARACTER VARYING(50) 50
38 ADVISED_REPAY_AMT DOUBLE PRECISION 8
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8