OBP24_FLX_SH_PRIN_SCHED_ITEM_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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