OBP24_FLX_TD_CONTRACTCHANGE_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ARRANGEMENT_ID CHARACTER VARYING(80) 80
2 CONTRACT_MOD_DATE TIMESTAMP 8
3 ACCOUNT_ID CHARACTER VARYING(40) 40
4 CONTRACT_MOD_COUNTER DOUBLE PRECISION 8
5 PARTY_ID CHARACTER VARYING(40) 40
6 CURRENCY_ID CHARACTER VARYING(3) 3
7 OLD_PRINCIPAL_AMT DOUBLE PRECISION 8
8 NEW_PRINCIPAL_AMT DOUBLE PRECISION 8
9 OLD_PAYOUT_FREQUENCY CHARACTER VARYING(40) 40
10 NEW_PAYOUT_FREQUENCY CHARACTER VARYING(40) 40
11 OLD_TERM_YEARS DOUBLE PRECISION 8
12 OLD_TERM_MONTHS DOUBLE PRECISION 8
13 OLD_TERM_DAYS DOUBLE PRECISION 8
14 NEW_TERM_YEARS DOUBLE PRECISION 8
15 NEW_TERM_MONTHS DOUBLE PRECISION 8
16 NEW_TERM_DAYS DOUBLE PRECISION 8
17 OLD_MATURITY_DATE TIMESTAMP 8
18 NEW_MATURITY_DATE TIMESTAMP 8
19 NEW_NET_INTEREST_RATE DOUBLE PRECISION 8
20 TRANSACTION_TYPE CHARACTER VARYING(40) 40
21 TRANSACTION_AMT DOUBLE PRECISION 8
22 CONTRACT_MOD_VALUE_DATE TIMESTAMP 8
23 UDM NUMERIC(13,2) 19
24 BASE_INTEREST_RATE NUMERIC(13,2) 19
25 MARGIN NUMERIC(13,2) 19
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8