OBP24_FLX_LN_ACCT_ACCELERATED_PYMT_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 REVIEW_FREQUENCY CHARACTER VARYING(20) 20
3 ACCELERATED_PAYMENT_RATE DOUBLE PRECISION 8
4 CURRENCY_CODE CHARACTER VARYING(3) 3
5 EFFECTIVE_DATE TIMESTAMP 8
6 BASE_ACCELERATED_PAYMENT_AMT DOUBLE PRECISION 8
7 NEXT_REVIEW_DATE TIMESTAMP 8
8 ACTUAL_EFFECTIVE_DATE TIMESTAMP 8
9 FIXED_ACCELERATED_AMOUNT DOUBLE PRECISION 8
10 COMPUTATION_TYPE CHARACTER VARYING(25) 25
11 ACTUAL_BASE_ACCELERATED_AMT DOUBLE PRECISION 8
12 OBJECT_STATUS CHARACTER(1) 1
13 CREATION_DATE TIMESTAMP 8
14 LAST_UPDATE_DATE TIMESTAMP 8
15 LAST_UPDATED_BY CHARACTER VARYING(254) 254
16 CREATED_BY CHARACTER VARYING(254) 254
17 OBJECT_VERSION_NUMBER BIGINT 8
18 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
19 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
21 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8