OBP24_FLX_TD_DEPOSIT_RATE_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ARRANGEMENT_ID CHARACTER VARYING(50) 50
2 EFFECTIVE_DATE TIMESTAMP 8
3 SERIAL_ID DOUBLE PRECISION 8
4 ACCOUNT_ID CHARACTER VARYING(40) 40
5 DEPOSIT_ID DOUBLE PRECISION 8
6 EVENT_NAME CHARACTER VARYING(50) 50
7 NET_INTEREST_RATE DOUBLE PRECISION 8
8 PRINCIPAL_AMT DOUBLE PRECISION 8
9 PRINCIPAL_AMT_CCY CHARACTER VARYING(3) 3
10 BASE_INTEREST_RATE DOUBLE PRECISION 8
11 MARGIN DOUBLE PRECISION 8
12 USER_DISCR_MARGIN DOUBLE PRECISION 8
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8