OBP24_HST_FLX_SH_SCHEDULE_ITEM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_FLX_SH_SCHEDULE_ITEM

Columns
# Name Data Type Length
1 STAGE_NUM BIGINT 8
2 STAGE_START_DATE TIMESTAMP 8
3 INSTALLMENT_NUM BIGINT 8
4 START_DATE TIMESTAMP 8
5 DUE_DATE TIMESTAMP 8
6 INTEREST_RATE DOUBLE PRECISION 8
7 SERVICE_CHARGE_AMT DOUBLE PRECISION 8
8 PRINCIPAL_BALANCE_AMT DOUBLE PRECISION 8
9 INTEREST_AMT DOUBLE PRECISION 8
10 PRINCIPAL_AMT DOUBLE PRECISION 8
11 UNCHARGED_INTEREST_AMT DOUBLE PRECISION 8
12 CARRY_FORWARD_INTEREST_AMT DOUBLE PRECISION 8
13 CALC_DAYS_QTY BIGINT 8
14 AMORTIZED_INTEREST_AMT DOUBLE PRECISION 8
15 INSTALLMENT_POSTPND_DATE TIMESTAMP 8
16 CAPITALIZED_ARREARS_AMT DOUBLE PRECISION 8
17 CURRENCY_CODE CHARACTER VARYING(3) 3
18 AMOUNT_TYPE CHARACTER VARYING(40) 40
19 DUE_AMT DOUBLE PRECISION 8
20 SCHEDULE_ID CHARACTER VARYING(40) 40
21 PREMIUM_AMOUNT DOUBLE PRECISION 8
22 INSTALLMENT_AMT DOUBLE PRECISION 8
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8