OBP24_HST_FLX_PR_SIMPLE_VARIANCES

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VARIANCE_CODE CHARACTER VARYING(40) 40
2 APPLICATION_METHOD CHARACTER VARYING(20) 20
3 START_DATE TIMESTAMP 8
4 END_DATE TIMESTAMP 8
5 START_DAYS_NUM BIGINT 8
6 START_MONTHS_NUM BIGINT 8
7 START_YEARS_NUM BIGINT 8
8 END_DAYS_NUM BIGINT 8
9 END_MONTHS_NUM BIGINT 8
10 END_YEARS_NUM BIGINT 8
11 REASON_TXT CHARACTER VARYING(200) 200
12 VARIANCE_COMMENT_TXT CHARACTER VARYING(600) 600
13 FIXED_AMT DOUBLE PRECISION 8
14 FIXED_CCY_CODE CHARACTER VARYING(40) 40
15 PERCENTAGE DOUBLE PRECISION 8
16 DISCOUNT_CODE CHARACTER VARYING(128) 128
17 MARGIN_INDEX_CODE CHARACTER VARYING(128) 128
18 VARIANCE_TYPE_CODE CHARACTER VARYING(20) 20
19 TIERED_VARIANCE_CODE CHARACTER VARYING(40) 40
20 TIER_ORDER_NUM BIGINT 8
21 ELEMENT_DATE TIMESTAMP 8
22 CREATED_BY CHARACTER VARYING(254) 254
23 CREATION_DATE TIMESTAMP 8
24 APPROVED_BY CHARACTER VARYING(254) 254
25 DISCOUNT_AMT_OR_PERCENTAGE DOUBLE PRECISION 8
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