OPIC_SPSH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_OPIC_SPSH

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 DEALNO CHARACTER VARYING(8) 8
3 SEQ CHARACTER VARYING(4) 4
4 FIXINCIND CHARACTER VARYING(1) 1
5 AETRAD CHARACTER VARYING(4) 4
6 ASSIGNIND CHARACTER VARYING(1) 1
7 BVAMORTAMT NUMERIC(19,4) 19
8 BVINTAMT NUMERIC(19,4) 19
9 BRPRCINDTE TIMESTAMP 8
10 BROK CHARACTER VARYING(11) 11
11 BROKFEEAMT NUMERIC(19,4) 19
12 BROKFEECCY CHARACTER VARYING(3) 3
13 CHARGEAMT NUMERIC(19,4) 19
14 CLEARDATE TIMESTAMP 8
15 CLEARINPUTDATE TIMESTAMP 8
16 CLEAROPER CHARACTER VARYING(4) 4
17 COMMAMT NUMERIC(19,4) 19
18 COMMRATE_8 NUMERIC(18,8) 19
19 COMREFNO CHARACTER VARYING(16) 16
20 CONFDATE TIMESTAMP 8
21 CONFOPER CHARACTER VARYING(4) 4
22 COST CHARACTER VARYING(10) 10
23 COUPONNO CHARACTER VARYING(7) 7
24 CCYAUTHDATE TIMESTAMP 8
25 CCYAUTHIND CHARACTER VARYING(1) 1
26 CCYAUTHOPER CHARACTER VARYING(4) 4
27 CCY CHARACTER VARYING(3) 3
28 CNO CHARACTER VARYING(10) 10
29 CUSTCONFDATE TIMESTAMP 8
30 CUSTREFNO CHARACTER VARYING(16) 16
31 DEALDATE TIMESTAMP 8
32 DEALSRCE CHARACTER VARYING(10) 10
33 DEALTEXT CHARACTER VARYING(70) 70
34 DEALTIME CHARACTER VARYING(8) 8
35 DISCAMT NUMERIC(19,4) 19
36 DISCRATE_8 NUMERIC(18,8) 19
37 DISPRICE_8 NUMERIC(18,8) 19
38 FACEAMT NUMERIC(19,4) 19
39 FAILDATE TIMESTAMP 8
40 FAILINPUTDATE TIMESTAMP 8
41 FAILOPER CHARACTER VARYING(4) 4
42 FAILINTAMT NUMERIC(19,4) 19
43 FEEAMT NUMERIC(19,4) 19
44 GAINAMT NUMERIC(19,4) 19
45 INPUTDATE TIMESTAMP 8
46 IOPER CHARACTER VARYING(4) 4
47 INPUTTIME CHARACTER VARYING(8) 8
48 INVTYPE CHARACTER VARYING(1) 1
49 LINKORDERNO CHARACTER VARYING(8) 8
50 LINKSEQ CHARACTER VARYING(4) 4
51 LOSSAMT NUMERIC(19,4) 19
52 MUTFUNDIND CHARACTER VARYING(1) 1
53 ORIGAMT NUMERIC(19,4) 19
54 ORIGQTY NUMERIC(19,4) 19
55 PORT CHARACTER VARYING(4) 4
56 PREMAMT NUMERIC(19,4) 19
57 PRICE_8 NUMERIC(18,8) 19
58 PRINAMT NUMERIC(19,4) 19
59 PRINAGIND CHARACTER VARYING(1) 1
60 PROCEEDAMT NUMERIC(19,4) 19
61 PRODUCT CHARACTER VARYING(6) 6
62 PRODTYPE CHARACTER VARYING(2) 2
63 PS CHARACTER VARYING(1) 1
64 PURCHINTAMT NUMERIC(19,4) 19
65 QTY NUMERIC(19,4) 19
66 REVDATE TIMESTAMP 8
67 REVOPER CHARACTER VARYING(4) 4
68 REVREASON CHARACTER VARYING(2) 2
69 REVTEXT CHARACTER VARYING(70) 70
70 REVTIME CHARACTER VARYING(8) 8
71 SECSACCT CHARACTER VARYING(15) 15
72 SECAUTHDATE TIMESTAMP 8
73 SECAUTHIND CHARACTER VARYING(1) 1
74 SECAUTHOPER CHARACTER VARYING(4) 4
75 SECID CHARACTER VARYING(20) 20
76 SERIES CHARACTER VARYING(5) 5
77 CCYSACCT CHARACTER VARYING(15) 15
78 SETTDATE TIMESTAMP 8
79 CCYSMEANS CHARACTER VARYING(7) 7
80 SPREADRATE_8 NUMERIC(18,8) 19
81 SUPPCONFIND CHARACTER VARYING(1) 1
82 SYMBOLID CHARACTER VARYING(8) 8
83 VATAMT NUMERIC(19,4) 19
84 TRAD CHARACTER VARYING(4) 4
85 VERIND CHARACTER VARYING(1) 1
86 VERDATE TIMESTAMP 8
87 VOPER CHARACTER VARYING(4) 4
88 WHENISSIND CHARACTER VARYING(1) 1
89 YIELD_8 NUMERIC(18,8) 19
90 EXCHCNO CHARACTER VARYING(11) 11
91 EXCHCOMMAMT NUMERIC(19,4) 19
92 EXCHCCY CHARACTER VARYING(3) 3
93 CNARR CHARACTER VARYING(70) 70
94 FROMDAYS CHARACTER VARYING(4) 4
95 TODAYS CHARACTER VARYING(4) 4
96 DELAYDELIVIND CHARACTER VARYING(1) 1
97 ISSUER CHARACTER VARYING(11) 11
98 RATCNO CHARACTER VARYING(11) 11
99 CRATING CHARACTER VARYING(10) 10
100 RATECODE CHARACTER VARYING(7) 7
101 AGENCY CHARACTER VARYING(11) 11
102 WHTAMT NUMERIC(19,4) 19
103 EXCHIND CHARACTER VARYING(1) 1
104 OFFASSAMT NUMERIC(19,4) 19
105 ESTAMT NUMERIC(19,4) 19
106 ASSIGNEDQTY NUMERIC(19,4) 19
107 CONVINTAMT NUMERIC(19,4) 19
108 CONVINTBAMT NUMERIC(19,4) 19
109 SETTAMT NUMERIC(19,4) 19
110 SETTBASEAMT NUMERIC(19,4) 19
111 COSTAMT NUMERIC(19,4) 19
112 COSTBAMT NUMERIC(19,4) 19
113 INTCCY CHARACTER VARYING(3) 3
114 SETTCCY CHARACTER VARYING(3) 3
115 SETTPROCEXCHRATE_8 NUMERIC(18,8) 19
116 SETTPROCTERMS CHARACTER VARYING(1) 1
117 SETTPROCPREMDISC_8 NUMERIC(18,8) 19
118 INTSETTEXCHRATE_8 NUMERIC(18,8) 19
119 INTSETTTERMS CHARACTER VARYING(1) 1
120 INTSETTPREMDISC_8 NUMERIC(18,8) 19
121 SETTBASEEXCHRATE_8 NUMERIC(18,8) 19
122 SETTBASETERMS CHARACTER VARYING(1) 1
123 SETTBASEPREMDISC_8 NUMERIC(18,8) 19
124 INTBASEEXCHRATE_8 NUMERIC(18,8) 19
125 INTBASETERMS CHARACTER VARYING(1) 1
126 INTBASEPREMDISC_8 NUMERIC(18,8) 19
127 AMENDDATE TIMESTAMP 8
128 AMENDTIME CHARACTER VARYING(8) 8
129 AMENDOPER CHARACTER VARYING(4) 4
130 FEDEALNO CHARACTER VARYING(15) 15
131 INTERNALYIELD_8 NUMERIC(18,8) 19
132 INTERNALDISCRATE_8 NUMERIC(18,8) 19
133 INTERNALPRICE_8 NUMERIC(18,8) 19
134 INTERNALPROCEEDAMT NUMERIC(19,4) 19
135 INTERNALSPREADRATE_8 NUMERIC(18,8) 19
136 MARKUPCOMMAMT NUMERIC(19,4) 19
137 AMORTYIELD_8 NUMERIC(18,8) 19
138 AMORTIND CHARACTER VARYING(1) 1
139 PLEDGEID CHARACTER VARYING(30) 30
140 PAIREDFACEAMT NUMERIC(19,4) 19
141 PAIREDAMT NUMERIC(19,4) 19
142 PAIREDIND CHARACTER VARYING(1) 1
143 CURRSPLITSEQ CHARACTER VARYING(4) 4
144 UPDATECOUNTER BIGINT 8
145 BTBDEALNO CHARACTER VARYING(8) 8
146 BTBPORT CHARACTER VARYING(4) 4
147 USUALID CHARACTER VARYING(15) 15
148 LINKDEALNO CHARACTER VARYING(8) 8
149 LINKIND CHARACTER VARYING(1) 1
150 BLOCKIND CHARACTER VARYING(1) 1
151 SPLITIND CHARACTER VARYING(1) 1
152 INDEXRATIO_8 NUMERIC(18,8) 19
153 SWIFTBOTHIND CHARACTER VARYING(1) 1
154 NEWISSUEIND CHARACTER VARYING(1) 1
155 CCPIND CHARACTER VARYING(1) 1
156 EXTCOMPARE CHARACTER VARYING(1) 1
157 NOVFACEAMT NUMERIC(19,4) 19
158 PAYMENTHOLDIND CHARACTER VARYING(1) 1
159 CONVIND CHARACTER VARYING(1) 1
160 EXTBSKTID CHARACTER VARYING(20) 20
161 EXTCONVID CHARACTER VARYING(15) 15
162 SRIND CHARACTER VARYING(1) 1
163 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
164 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
165 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
166 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
167 EXCISEAMT NUMERIC(19,4) 19
168 INTRADAY CHARACTER VARYING(1) 1