OPIC_NPVH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 BRPROCDATE TIMESTAMP 8
3 CCY CHARACTER VARYING(3) 3
4 CTRCCY CHARACTER VARYING(3) 3
5 VDATE TIMESTAMP 8
6 BIDOFFERIND CHARACTER VARYING(1) 1
7 PRODCODE CHARACTER VARYING(6) 6
8 PRODTYPE CHARACTER VARYING(2) 2
9 CCYSPOTDATE TIMESTAMP 8
10 CTRSPOTDATE TIMESTAMP 8
11 PAIRSPOTDATE TIMESTAMP 8
12 CCYSPOTRATE DOUBLE PRECISION 8
13 CTRSPOTRATE DOUBLE PRECISION 8
14 CCYREVALRATE DOUBLE PRECISION 8
15 CTRREVALRATE DOUBLE PRECISION 8
16 CCYNPVRATE_10 NUMERIC(18,10) 19
17 CTRNPVRATE_10 NUMERIC(18,10) 19
18 CCYNPVFACTOR_10 NUMERIC(18,10) 19
19 CTRNPVFACTOR_10 NUMERIC(18,10) 19
20 CCYDISCNPVRATE_10 NUMERIC(18,10) 19
21 CTRDISCNPVRATE_10 NUMERIC(18,10) 19
22 CCYDISCNPVFACTOR_10 NUMERIC(18,10) 19
23 CTRDISCNPVFACTOR_10 NUMERIC(18,10) 19
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8