OBP24_HST_FLX_AC_RATE_LOCK

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 RATE_LOCK_ID CHARACTER VARYING(40) 40
3 QUOTE_CREATION_DATE TIMESTAMP 8
4 EXPECTED_RATE_LOCK_USAGE_DATE TIMESTAMP 8
5 EXPIRY_DATE TIMESTAMP 8
6 FIXED_RATE_PERIOD_IN_MONTHS DOUBLE PRECISION 8
7 IS_PURCHASED CHARACTER(1) 1
8 IS_UTILIZED CHARACTER(1) 1
9 LOCKED_AMOUNT DOUBLE PRECISION 8
10 LOCKED_AMOUNT_CCY_CODE CHARACTER VARYING(3) 3
11 MOST_RECENT_UTILIZATION_DATE TIMESTAMP 8
12 PURCHASE_DATE TIMESTAMP 8
13 REPAYMENT_TYPE CHARACTER VARYING(10) 10
14 UTILIZATION_PERIOD_IN_DAYS DOUBLE PRECISION 8
15 CREATED_BY CHARACTER VARYING(254) 254
16 CREATION_DATE TIMESTAMP 8
17 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
18 LAST_UPDATED_BY CHARACTER VARYING(254) 254
19 LAST_UPDATE_DATE TIMESTAMP 8
20 OBJECT_STATUS CHARACTER(1) 1
21 PRODUCT_ID CHARACTER VARYING(40) 40
22 CREATION_DATE_RATE_LOCK_CTR DOUBLE PRECISION 8
23 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
24 ACCOUNT_TYPE CHARACTER VARYING(20) 20
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8