OPIC_ETDH

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 BROKNO CHARACTER VARYING(11) 11
5 BRPRCINDTE TIMESTAMP 8
6 COMMAMT NUMERIC(19,4) 19
7 COMMRATE NUMERIC(19,4) 19
8 CONTCODE CHARACTER VARYING(10) 10
9 CONTPRICE_8 NUMERIC(18,8) 19
10 COST CHARACTER VARYING(11) 11
11 DEALDATE TIMESTAMP 8
12 DELVDATE TIMESTAMP 8
13 EXCHANGE CHARACTER VARYING(11) 11
14 INPUTDATE TIMESTAMP 8
15 INPUTTIME CHARACTER VARYING(8) 8
16 IOPER CHARACTER VARYING(4) 4
17 NUMCONT NUMERIC(19,4) 19
18 PORT CHARACTER VARYING(4) 4
19 PS CHARACTER VARYING(1) 1
20 REVDATE TIMESTAMP 8
21 REVOPER CHARACTER VARYING(4) 4
22 REVREASON CHARACTER VARYING(2) 2
23 REVTEXT CHARACTER VARYING(70) 70
24 VERDATE TIMESTAMP 8
25 VERIND CHARACTER VARYING(1) 1
26 VOPER CHARACTER VARYING(4) 4
27 LSTMNTDTE TIMESTAMP 8
28 TRADER CHARACTER VARYING(4) 4
29 PSDEALNO CHARACTER VARYING(8) 8
30 PSOPER CHARACTER VARYING(4) 4
31 PSDATE TIMESTAMP 8
32 CP CHARACTER VARYING(1) 1
33 EXPIRDATE TIMESTAMP 8
34 STRKPRICE_8 NUMERIC(18,8) 19
35 SETMEANS CHARACTER VARYING(7) 7
36 SETACCT CHARACTER VARYING(15) 15
37 DELIVERYIND CHARACTER VARYING(1) 1
38 PREMAMT NUMERIC(19,4) 19
39 ACCTMETHOD CHARACTER VARYING(1) 1
40 TRDTIME CHARACTER VARYING(8) 8
41 EXECCOMMRATE NUMERIC(19,4) 19
42 EXECCOMMAMT NUMERIC(19,4) 19
43 FEECCY CHARACTER VARYING(3) 3
44 CNO CHARACTER VARYING(10) 10
45 CUSTMARGIN NUMERIC(19,4) 19
46 PURPOSE CHARACTER VARYING(1) 1
47 CUSTRATE NUMERIC(19,4) 19
48 CUSTAMT NUMERIC(19,4) 19
49 CUSTACCTNO CHARACTER VARYING(18) 18
50 CUSTFEECCY CHARACTER VARYING(3) 3
51 PRODUCT CHARACTER VARYING(6) 6
52 PRODTYPE CHARACTER VARYING(2) 2
53 PSMETHOD CHARACTER VARYING(4) 4
54 DEALTEXT CHARACTER VARYING(70) 70
55 UNDDEALNO CHARACTER VARYING(8) 8
56 UNDPRODUCT CHARACTER VARYING(6) 6
57 UNDTYPE CHARACTER VARYING(2) 2
58 UNDSECID CHARACTER VARYING(20) 20
59 UNDACCTNGTYPE CHARACTER VARYING(10) 10
60 UNDTENOR CHARACTER VARYING(2) 2
61 UNDSEQ CHARACTER VARYING(4) 4
62 CREDITCODE CHARACTER VARYING(3) 3
63 ORIGNUMCONT NUMERIC(19,4) 19
64 HDGESPOTPRICE_8 NUMERIC(18,8) 19
65 HDGEFWDPOINTS_8 NUMERIC(18,8) 19
66 SPOTTRAD CHARACTER VARYING(4) 4
67 SPOTPORT CHARACTER VARYING(4) 4
68 SPOTCOST CHARACTER VARYING(11) 11
69 ORIGBROKNO CHARACTER VARYING(10) 10
70 ORIGDEALNO CHARACTER VARYING(8) 8
71 FEEAMT NUMERIC(19,4) 19
72 CCYAMT NUMERIC(19,4) 19
73 PSSEQ CHARACTER VARYING(4) 4
74 REVPSDATE TIMESTAMP 8
75 REVTIME CHARACTER VARYING(8) 8
76 REVMETHOD CHARACTER VARYING(1) 1
77 TDYREALPL NUMERIC(19,4) 19
78 YSTREALPL NUMERIC(19,4) 19
79 CASHIND CHARACTER VARYING(1) 1
80 DISPCONTPRICE_8 NUMERIC(18,8) 19
81 REVCOMMAMT NUMERIC(19,4) 19
82 REVFEEAMT NUMERIC(19,4) 19
83 REVNUMCONT NUMERIC(19,4) 19
84 EXERDATE TIMESTAMP 8
85 EXERIND CHARACTER VARYING(1) 1
86 EXEROPER CHARACTER VARYING(4) 4
87 DELVCODE CHARACTER VARYING(10) 10
88 LINKDEALNO CHARACTER VARYING(15) 15
89 LINKSEQ CHARACTER VARYING(4) 4
90 AMOUNT1 NUMERIC(19,4) 19
91 AMOUNT2 NUMERIC(19,4) 19
92 AMOUNT3 NUMERIC(19,4) 19
93 CHAR1 CHARACTER VARYING(20) 20
94 CHAR2 CHARACTER VARYING(20) 20
95 CHAR3 CHARACTER VARYING(20) 20
96 DATE1 TIMESTAMP 8
97 DATE2 TIMESTAMP 8
98 FLAG1 CHARACTER VARYING(1) 1
99 RATE1_8 NUMERIC(18,8) 19
100 RATE2_8 NUMERIC(18,8) 19
101 TDYUNREALPL NUMERIC(19,4) 19
102 YSTUNREALPL NUMERIC(19,4) 19
103 PMEUNREALPL NUMERIC(19,4) 19
104 PYEUNREALPL NUMERIC(19,4) 19
105 INTSOURCE CHARACTER VARYING(20) 20
106 UPDATECOUNTER BIGINT 8
107 TDYINTRINSICVAL NUMERIC(19,4) 19
108 YSTINTRINSICVAL NUMERIC(19,4) 19
109 TDYMKTEXTVAL NUMERIC(19,4) 19
110 YSTMKTEXTVAL NUMERIC(19,4) 19
111 TENOR CHARACTER VARYING(2) 2
112 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
113 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
114 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
115 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8