OPIC_FXTW

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 PRODCODE CHARACTER VARYING(6) 6
5 PRODTYPE CHARACTER VARYING(2) 2
6 TRAD CHARACTER VARYING(4) 4
7 PORT CHARACTER VARYING(4) 4
8 COST CHARACTER VARYING(11) 11
9 INPUTDATE TIMESTAMP 8
10 INPUTTIME CHARACTER VARYING(8) 8
11 DEALDATE TIMESTAMP 8
12 VDATE TIMESTAMP 8
13 CUST CHARACTER VARYING(11) 11
14 BROK CHARACTER VARYING(11) 11
15 ODATE TIMESTAMP 8
16 PS CHARACTER VARYING(1) 1
17 DEALSRCE CHARACTER VARYING(10) 10
18 REVDATE TIMESTAMP 8
19 VERDATE TIMESTAMP 8
20 CCY CHARACTER VARYING(3) 3
21 CCYAMT NUMERIC(19,4) 19
22 CCYTERMS CHARACTER VARYING(1) 1
23 CCYRATE_8 NUMERIC(18,8) 19
24 CCYPD_8 NUMERIC(18,8) 19
25 CCYBAMT NUMERIC(19,4) 19
26 CCYBRATE_8 NUMERIC(18,8) 19
27 CCYBPD_8 NUMERIC(18,8) 19
28 BASETERMS CHARACTER VARYING(1) 1
29 CTRCCY CHARACTER VARYING(3) 3
30 CTRAMT NUMERIC(19,4) 19
31 CTRTERMS CHARACTER VARYING(1) 1
32 CTRRATE_8 NUMERIC(18,8) 19
33 CTRPD_8 NUMERIC(18,8) 19
34 SWAPDEALNO CHARACTER VARYING(8) 8
35 DETAILIND CHARACTER VARYING(8) 8
36 CCY1 CHARACTER VARYING(3) 3
37 CCY2 CHARACTER VARYING(3) 3
38 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
39 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
40 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
41 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8