OPC_HST_FXTR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 CCY1 CHARACTER VARYING(3) 3
3 CCY1AMT NUMERIC(21,4) 19
4 CCY2 CHARACTER VARYING(3) 3
5 CCY2AMT NUMERIC(21,4) 19
6 COST CHARACTER VARYING(10) 10
7 DEALNO CHARACTER VARYING(8) 8
8 TRAD CHARACTER VARYING(4) 4
9 VDATE CHARACTER VARYING(10) 10
10 BR CHARACTER VARYING(2) 2
11 SEQ CHARACTER VARYING(4) 4
12 BASEAMT NUMERIC(19,4) 19
13 BRPRCINDTE CHARACTER VARYING(10) 10
14 CCYRATE_8 NUMERIC(18,8) 19
15 CCYTERMS CHARACTER VARYING(1) 1
16 INPUTTIME CHARACTER VARYING(8) 8
17 IOPER CHARACTER VARYING(4) 4
18 LOCALCCYAMT NUMERIC(19,4) 19
19 PORT CHARACTER VARYING(4) 4
20 VERDATE CHARACTER VARYING(10) 10
21 VERIND CHARACTER VARYING(1) 1
22 VOPER CHARACTER VARYING(4) 4
23 DELTA_TYPE CHARACTER VARYING(1) 1
24 EFFECTIVE_STRT_DT TIMESTAMP 8
25 EFFECTIVE_END_DT TIMESTAMP 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