OPIC_FXTR

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 VDATE TIMESTAMP 8
5 CCY1 CHARACTER VARYING(3) 3
6 CCY2 CHARACTER VARYING(3) 3
7 COST CHARACTER VARYING(10) 10
8 PORT CHARACTER VARYING(4) 4
9 TRAD CHARACTER VARYING(4) 4
10 CCY1AMT NUMERIC(19,4) 19
11 CCY2AMT NUMERIC(19,4) 19
12 CCYRATE_8 NUMERIC(18,8) 19
13 CCYTERMS CHARACTER VARYING(1) 1
14 BASEAMT NUMERIC(19,4) 19
15 LOCALCCYAMT NUMERIC(19,4) 19
16 IOPER CHARACTER VARYING(4) 4
17 BRPRCINDTE TIMESTAMP 8
18 INPUTTIME CHARACTER VARYING(8) 8
19 VERDATE TIMESTAMP 8
20 VOPER CHARACTER VARYING(4) 4
21 VERIND CHARACTER VARYING(1) 1
22 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
23 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8