OPC_HST_RPRH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_RPRH

Columns
# Name Data Type Length
1 ID BIGINT 8
2 BASIS CHARACTER VARYING(6) 6
3 BR CHARACTER VARYING(2) 2
4 CCY CHARACTER VARYING(3) 3
5 CNO CHARACTER VARYING(11) 11
6 COLLATERALCODE CHARACTER VARYING(20) 20
7 COMPROCDAMT NUMERIC(21,4) 19
8 COST CHARACTER VARYING(10) 10
9 DEALDATE CHARACTER VARYING(10) 10
10 DEALNO CHARACTER VARYING(7) 7
11 DEALSCRE CHARACTER VARYING(10) 10
12 INTCALCTYPE CHARACTER VARYING(3) 3
13 IOPER CHARACTER VARYING(4) 4
14 MARGCALLPCT_8 NUMERIC(20,8) 19
15 MARGINPCT CHARACTER VARYING(5) 5
16 MATDATE CHARACTER VARYING(10) 10
17 MATPROCDAMT NUMERIC(21,4) 19
18 NOTAMT NUMERIC(21,4) 19
19 NOTCCY CHARACTER VARYING(3) 3
20 OPENREPOIND CHARACTER VARYING(1) 1
21 OPENREPOMATDAYS CHARACTER VARYING(3) 3
22 ORIGMDATE CHARACTER VARYING(10) 10
23 PORT CHARACTER VARYING(4) 4
24 PRODTYPE CHARACTER VARYING(2) 2
25 PRODUCT CHARACTER VARYING(6) 6
26 PS CHARACTER VARYING(1) 1
27 QUOTQTY NUMERIC(21,4) 19
28 RATECODE CHARACTER VARYING(7) 7
29 REPOAMT NUMERIC(21,4) 19
30 REPORATE_8 NUMERIC(20,8) 19
31 REVDATE CHARACTER VARYING(10) 10
32 RPIND CHARACTER VARYING(1) 1
33 SPREADRATE_8 NUMERIC(20,8) 19
34 TOTALINT NUMERIC(21,4) 19
35 TOTPROCDAMT NUMERIC(21,4) 19
36 TRAD CHARACTER VARYING(4) 4
37 VDATE CHARACTER VARYING(10) 10
38 VERDATE CHARACTER VARYING(10) 10
39 YIELD_8 NUMERIC(20,8) 19
40 INPUTDATE CHARACTER VARYING(10) 10
41 VERIND CHARACTER VARYING(1) 1
42 AETRAD CHARACTER VARYING(4) 4
43 AMOUNT1 NUMERIC(19,4) 19
44 AMOUNT2 NUMERIC(19,4) 19
45 ASSGNQTY NUMERIC(19,4) 19
46 ASSIGNDATE CHARACTER VARYING(10) 10
47 ASSIGNIND CHARACTER VARYING(1) 1
48 ASSIGNMETHOD CHARACTER VARYING(1) 1
49 AUTOASSIGN CHARACTER VARYING(1) 1
50 BLOCKIND CHARACTER VARYING(1) 1
51 BORRLENDIND CHARACTER VARYING(1) 1
52 BROK CHARACTER VARYING(11) 11
53 BROKFEEAMT NUMERIC(19,4) 19
54 BROKFEECCY CHARACTER VARYING(3) 3
55 BRPRCINDTE CHARACTER VARYING(10) 10
56 BTBDEALNO CHARACTER VARYING(8) 8
57 CCPIND CHARACTER VARYING(1) 1
58 CHARGEAMT NUMERIC(19,4) 19
59 CLOSEREPOIND CHARACTER VARYING(1) 1
60 CNARR CHARACTER VARYING(70) 70
61 COLLUNIT CHARACTER VARYING(3) 3
62 COMAUTHDATE CHARACTER VARYING(10) 10
63 COMAUTHIND CHARACTER VARYING(1) 1
64 COMAUTHOPER CHARACTER VARYING(4) 4
65 COMCCYSACCT CHARACTER VARYING(15) 15
66 COMCCYSMEANS CHARACTER VARYING(7) 7
67 COMMAMT NUMERIC(19,4) 19
68 COMMUSUALID CHARACTER VARYING(15) 15
69 COMPROCBASEAMT NUMERIC(19,4) 19
70 COMREFNO CHARACTER VARYING(16) 16
71 CONFCODE CHARACTER VARYING(4) 4
72 CONFDATE CHARACTER VARYING(10) 10
73 CONFOPER CHARACTER VARYING(4) 4
74 CONVINTAMT NUMERIC(19,4) 19
75 CONVINTBAMT NUMERIC(19,4) 19
76 COUPREINVEST CHARACTER VARYING(1) 1
77 COUPREINVRATE_8 NUMERIC(18,8) 19
78 CUSTCONFDATE CHARACTER VARYING(10) 10
79 CUSTREFNO CHARACTER VARYING(16) 16
80 DATE1 CHARACTER VARYING(10) 10
81 DATE2 CHARACTER VARYING(10) 10
82 DEALTEXT CHARACTER VARYING(70) 70
83 DEALTIME CHARACTER VARYING(8) 8
84 DELIVTYPE CHARACTER VARYING(3) 3
85 EMINPUTDATE CHARACTER VARYING(10) 10
86 EMIOPER CHARACTER VARYING(4) 4
87 EMPENAMT NUMERIC(19,4) 19
88 EXCHCNO CHARACTER VARYING(11) 11
89 EXCHCOMMAMT NUMERIC(19,4) 19
90 EXCHIND CHARACTER VARYING(1) 1
91 EXTCOMPARE CHARACTER VARYING(1) 1
92 FEEAMT NUMERIC(19,4) 19
93 FINBASERATE_8 NUMERIC(18,8) 19
94 FINBASETERMS CHARACTER VARYING(1) 1
95 FINEXCHRATEENTDATE CHARACTER VARYING(10) 10
96 FINEXCHRATEFIXDATE CHARACTER VARYING(10) 10
97 FINFXRATE_8 NUMERIC(18,8) 19
98 FININDEXRATE_8 NUMERIC(18,8) 19
99 FININDXRATEENTDATE CHARACTER VARYING(10) 10
100 FININDXRATEFIXDATE CHARACTER VARYING(10) 10
101 FINTERMS CHARACTER VARYING(1) 1
102 INDEXRATECODE CHARACTER VARYING(7) 7
103 INITBASERATE_8 NUMERIC(18,8) 19
104 INITBASETERMS CHARACTER VARYING(1) 1
105 INITFXRATE_8 NUMERIC(18,8) 19
106 INITINDEXRATE_8 NUMERIC(18,8) 19
107 INITTERMS CHARACTER VARYING(1) 1
108 INPUTTIME CHARACTER VARYING(8) 8
109 INTCALCDIND CHARACTER VARYING(1) 1
110 INTRATEENDDATE CHARACTER VARYING(10) 10
111 INTRATEFIXDATE CHARACTER VARYING(10) 10
112 LINKDEALNO CHARACTER VARYING(8) 8
113 LINKIND CHARACTER VARYING(3) 3
114 MATAUTHDATE CHARACTER VARYING(10) 10
115 MATAUTHIND CHARACTER VARYING(1) 1
116 MATAUTHOPER CHARACTER VARYING(4) 4
117 MATCCYSACCT CHARACTER VARYING(15) 15
118 MATCCYSMEANS CHARACTER VARYING(7) 7
119 MATPROCBASEAMT NUMERIC(19,4) 19
120 MATUSUALID CHARACTER VARYING(15) 15
121 MDPAYMENTHOLDIND CHARACTER VARYING(1) 1
122 MERGEIND CHARACTER VARYING(1) 1
123 MQTY NUMERIC(19,4) 19
124 NEWDEALNO CHARACTER VARYING(8) 8
125 NOTTOTLINT NUMERIC(19,4) 19
126 ORIGDEALNO CHARACTER VARYING(8) 8
127 ORIGPROCDAMT NUMERIC(19,4) 19
128 OVERRIDEWXTAXIND CHARACTER VARYING(1) 1
129 PRINBASERATEENTDATE CHARACTER VARYING(10) 10
130 PRINBASERATEFIXDATE CHARACTER VARYING(10) 10
131 RATE1_8 NUMERIC(18,8) 19
132 RATE2_8 NUMERIC(18,8) 19
133 REVOPER CHARACTER VARYING(4) 4
134 REVREASON CHARACTER VARYING(2) 2
135 REVTEXT CHARACTER VARYING(70) 70
136 REVTIME CHARACTER VARYING(8) 8
137 ROLLCAPINTIND CHARACTER VARYING(1) 1
138 ROLLDIFFAMT NUMERIC(19,4) 19
139 ROLLIND CHARACTER VARYING(1) 1
140 ROLLINPUTDATE CHARACTER VARYING(10) 10
141 ROLLPRININ NUMERIC(19,4) 19
142 ROLLPRINOUT NUMERIC(19,4) 19
143 ROLLREVDATE CHARACTER VARYING(10) 10
144 SAFEKEEPACCT CHARACTER VARYING(15) 15
145 SEQ CHARACTER VARYING(3) 3
146 SPLITIND CHARACTER VARYING(1) 1
147 STAMPDUTYAMT NUMERIC(19,4) 19
148 STATEDREPORATE_8 NUMERIC(18,8) 19
149 SUBSTITUTE CHARACTER VARYING(1) 1
150 SUPPCONFIND CHARACTER VARYING(1) 1
151 SWIFTBOTHIND CHARACTER VARYING(1) 1
152 TENOR CHARACTER VARYING(2) 2
153 TEXT1 CHARACTER VARYING(35) 35
154 TEXT2 CHARACTER VARYING(35) 35
155 UPDATECOUNTER BIGINT 8
156 VATAMT NUMERIC(19,4) 19
157 VDATENET CHARACTER VARYING(1) 1
158 VDPAYMENTHOLDIND CHARACTER VARYING(1) 1
159 VOPER CHARACTER VARYING(4) 4
160 WHTAMT NUMERIC(19,4) 19
161 DELTA_TYPE CHARACTER VARYING(1) 1
162 EFFECTIVE_STRT_DT TIMESTAMP 8
163 EFFECTIVE_END_DT TIMESTAMP 8
164 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
165 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
166 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
167 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8