OPIC_CPPR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 CCY1 CHARACTER VARYING(3) 3
3 CCY2 CHARACTER VARYING(3) 3
4 COST CHARACTER VARYING(10) 10
5 PORT CHARACTER VARYING(4) 4
6 TRAD CHARACTER VARYING(4) 4
7 VDATE TIMESTAMP 8
8 CCY1AMT NUMERIC(19,4) 19
9 CCY2AMT NUMERIC(19,4) 19
10 CCY1MKTAMT NUMERIC(19,4) 19
11 CCY2MKTAMT NUMERIC(19,4) 19
12 TDYPLAMT NUMERIC(19,4) 19
13 YSTPLAMT NUMERIC(19,4) 19
14 PMEPLAMT NUMERIC(19,4) 19
15 PYEPLAMT NUMERIC(19,4) 19
16 CCY1AMTYST NUMERIC(19,4) 19
17 CCY2AMTYST NUMERIC(19,4) 19
18 TDYNPVAMT NUMERIC(19,4) 19
19 YSTNPVAMT NUMERIC(19,4) 19
20 PMENPVAMT NUMERIC(19,4) 19
21 PYENPVAMT NUMERIC(19,4) 19
22 CCY1SPOTBASEAMTYST NUMERIC(19,4) 19
23 CCY2SPOTBASEAMTYST NUMERIC(19,4) 19
24 CCY1SPOTBASEAMT NUMERIC(19,4) 19
25 CCY2SPOTBASEAMT NUMERIC(19,4) 19
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