OPIC_ZFSC

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 MASTDEALNO CHARACTER VARYING(8) 8
3 SEQ CHARACTER VARYING(4) 4
4 SCHDSEQ CHARACTER VARYING(6) 6
5 STARTDATE TIMESTAMP 8
6 MATDATE TIMESTAMP 8
7 SECID CHARACTER VARYING(20) 20
8 DEALNO CHARACTER VARYING(8) 8
9 PROCEEDS NUMERIC(19,4) 19
10 YIELD_8 NUMERIC(18,8) 19
11 SPREAD_8 NUMERIC(18,8) 19
12 FACEVALUE NUMERIC(19,4) 19
13 OVERRIDE CHARACTER VARYING(1) 1
14 ACTIONED CHARACTER VARYING(1) 1
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8