OBP24_FLX_SH_LN_INTEREST_BASE_H_T

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SCHEDULE_ID CHARACTER VARYING(40) 40
2 INTEREST_TYPE BIGINT 8
3 BASE_CHANGE_EFFECTIVE_DATE TIMESTAMP 8
4 RESTED_PRINCIPAL_AMT DOUBLE PRECISION 8
5 PRINCIPAL_ARREARS_AMT DOUBLE PRECISION 8
6 INTEREST_ARREARS_AMT DOUBLE PRECISION 8
7 PREMIUM_ARREARS_AMT DOUBLE PRECISION 8
8 PENALTY_ARREARS_AMT DOUBLE PRECISION 8
9 COMPOUND_INTEREST_AMT DOUBLE PRECISION 8
10 FACE_VALUE_AMT DOUBLE PRECISION 8
11 ADVANCE_PAID_AMT DOUBLE PRECISION 8
12 DISBURSED_AMT DOUBLE PRECISION 8
13 SESSION_ID BIGINT 8
14 CURRENCY_CODE CHARACTER VARYING(3) 3
15 UNAPPLIED_PREMIUM_AMT DOUBLE PRECISION 8
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8