OPIC_OTSH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 DEALNO CHARACTER VARYING(8) 8
3 SEQ CHARACTER VARYING(4) 4
4 REFIXDATE TIMESTAMP 8
5 REFIXTIME CHARACTER VARYING(8) 8
6 VDATE TIMESTAMP 8
7 WEIGHT NUMERIC(19,4) 19
8 REFIXRATE_8 NUMERIC(18,8) 19
9 WEIGHTTODATE NUMERIC(19,4) 19
10 SPOTTODATE_8 NUMERIC(18,8) 19
11 REVIND CHARACTER VARYING(1) 1
12 AMT1 NUMERIC(19,4) 19
13 CHAR1 CHARACTER VARYING(20) 20
14 DATE1 TIMESTAMP 8
15 RATE1_8 NUMERIC(18,8) 19
16 LSTMNTDATE TIMESTAMP 8
17 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
20 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8