OBP24_HST_FLX_IN_COMP_CONSTITUENT_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CONSTITUENT_ID CHARACTER VARYING(300) 300
2 BKDT_TIMESTAMP CHARACTER VARYING(40) 40
3 LOG_ID CHARACTER VARYING(300) 300
4 INTEREST_CONSTITUENT_TYPE CHARACTER VARYING(50) 50
5 RATE DOUBLE PRECISION 8
6 BALANCE_AMT DOUBLE PRECISION 8
7 BALANCE_CCY CHARACTER VARYING(20) 20
8 ONE_DAY_INTEREST_AMT DOUBLE PRECISION 8
9 ONE_DAY_INTEREST_CCY CHARACTER VARYING(20) 20
10 TRANSACTION_DESCRIPTION CHARACTER VARYING(250) 250
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8