OPIC_ETCP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 CONTCODE CHARACTER VARYING(10) 10
3 DELVCODE CHARACTER VARYING(10) 10
4 DELVDATE TIMESTAMP 8
5 CP CHARACTER VARYING(2) 2
6 EXPIRDATE TIMESTAMP 8
7 STRKPRICE_8 NUMERIC(18,8) 19
8 CLSGPRICE_8 NUMERIC(18,8) 19
9 CLSGPRICEYST_8 NUMERIC(18,8) 19
10 LSTMNTDATE TIMESTAMP 8
11 PRICESOURCE_DDE CHARACTER VARYING(50) 50
12 UPDATECOUNTER BIGINT 8
13 TICKVALUE_8 NUMERIC(18,8) 19
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8