OPC_HST_RPDT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_RPDT

Columns
# Name Data Type Length
1 ID BIGINT 8
2 BOOKVALAMT NUMERIC(21,4) 19
3 BR CHARACTER VARYING(2) 2
4 BRPRCINDTE CHARACTER VARYING(10) 10
5 CCY CHARACTER VARYING(3) 3
6 CHARGEAMT NUMERIC(21,4) 19
7 CLPRICE_8 NUMERIC(20,8) 19
8 CNO CHARACTER VARYING(10) 10
9 COMMPROCAMT NUMERIC(21,4) 19
10 COST CHARACTER VARYING(10) 10
11 COUPACCRNEXTMONTH NUMERIC(21,4) 19
12 COUPACCROUTSTAMT NUMERIC(21,4) 19
13 DEALNO CHARACTER VARYING(7) 7
14 DELIVTYPE CHARACTER VARYING(3) 3
15 DISCAMT NUMERIC(21,4) 19
16 DISCRATE_8 NUMERIC(20,8) 19
17 DISPRICE_8 NUMERIC(20,8) 19
18 DRPRICE_8 NUMERIC(20,8) 19
19 EXCHCCY CHARACTER VARYING(3) 3
20 EXCHCNO CHARACTER VARYING(10) 10
21 EXCHCOMMAMT NUMERIC(21,4) 19
22 FACEAMT NUMERIC(21,4) 19
23 HAIRCUT_8 NUMERIC(20,8) 19
24 INTBASERATE_8 NUMERIC(20,8) 19
25 INTBASETERMS CHARACTER VARYING(1) 1
26 INTEXCHRATE_8 NUMERIC(20,8) 19
27 INTEXCHTERMS CHARACTER VARYING(1) 1
28 INVTYPE CHARACTER VARYING(1) 1
29 IOPER CHARACTER VARYING(4) 4
30 MATPROCAMT NUMERIC(21,4) 19
31 MATPURCHINTAMT NUMERIC(21,4) 19
32 MDATE CHARACTER VARYING(10) 10
33 MDCLEANPRICE_8 NUMERIC(20,8) 19
34 MDCLEARDATE CHARACTER VARYING(10) 10
35 MDCLEAROPER CHARACTER VARYING(4) 4
36 MDDIRTYPRICE_8 NUMERIC(20,8) 19
37 MDFAILDATE CHARACTER VARYING(10) 10
38 MDFAILOPER CHARACTER VARYING(4) 4
39 MDFAILREFNO CHARACTER VARYING(7) 7
40 MKTVALUE NUMERIC(21,4) 19
41 NOTCCY CHARACTER VARYING(3) 3
42 NXTCPNAMT NUMERIC(21,4) 19
43 PMEDSCAMT NUMERIC(21,4) 19
44 PMEINCEXPAMT NUMERIC(21,4) 19
45 PMEMTMAMT NUMERIC(21,4) 19
46 PMEREPOINTAMT NUMERIC(21,4) 19
47 PMEREPOMTMAMT NUMERIC(21,4) 19
48 PORT CHARACTER VARYING(4) 4
49 PREMAMT NUMERIC(21,4) 19
50 PRINAMT NUMERIC(21,4) 19
51 PRINBASERATE_8 NUMERIC(20,8) 19
52 PRINBASETERMS CHARACTER VARYING(1) 1
53 PRINEXCHRATE_8 NUMERIC(20,8) 19
54 PRINEXCHTERMS CHARACTER VARYING(1) 1
55 PROCEEDAMT NUMERIC(21,4) 19
56 PRODTYPE CHARACTER VARYING(2) 2
57 PRODUCT CHARACTER VARYING(6) 6
58 PS CHARACTER VARYING(1) 1
59 PURCHINTAMT NUMERIC(21,4) 19
60 PVMATPROCAMT NUMERIC(21,4) 19
61 PYEDSCAMT NUMERIC(21,4) 19
62 PYEINCEXPAMT NUMERIC(21,4) 19
63 PYEMTMAMT NUMERIC(21,4) 19
64 PYEREPOINTAMT NUMERIC(21,4) 19
65 PYEREPOMTMAMT NUMERIC(21,4) 19
66 QTY NUMERIC(21,4) 19
67 RATE1_8 NUMERIC(20,8) 19
68 RATE2_8 NUMERIC(20,8) 19
69 REINVESTIND CHARACTER VARYING(1) 1
70 REINVESTLINKSEQNO CHARACTER VARYING(3) 3
71 REPOCOST CHARACTER VARYING(10) 10
72 REPOINTAMT NUMERIC(21,4) 19
73 REPOPRINAMT NUMERIC(21,4) 19
74 REPORATE_8 NUMERIC(20,8) 19
75 REVDATE CHARACTER VARYING(10) 10
76 RPOSMDATE CHARACTER VARYING(10) 10
77 SECID CHARACTER VARYING(20) 20
78 SEQ CHARACTER VARYING(3) 3
79 SETTAVGCOST NUMERIC(21,4) 19
80 SETTAVGCOSTYST NUMERIC(21,4) 19
81 SETTCCY CHARACTER VARYING(3) 3
82 SPREADRATE_8 NUMERIC(20,8) 19
83 TDYDSCAMT NUMERIC(21,4) 19
84 TDYINCEXPAMT NUMERIC(21,4) 19
85 TDYMTMAMT NUMERIC(21,4) 19
86 TDYPREMAMT NUMERIC(21,4) 19
87 TDYPURCHINTAMT NUMERIC(21,4) 19
88 TDYREPOINTAMT NUMERIC(21,4) 19
89 TDYREPOMTMAMT NUMERIC(21,4) 19
90 TEXT1 CHARACTER VARYING(35) 35
91 TEXT2 CHARACTER VARYING(35) 35
92 UNAMORTAMT NUMERIC(21,4) 19
93 UPDATECOUNTER NUMERIC(15,0) 19
94 VATAMT NUMERIC(21,4) 19
95 VDATE CHARACTER VARYING(10) 10
96 VDCLEANPRICE_8 NUMERIC(20,8) 19
97 VDCLEARDATE CHARACTER VARYING(10) 10
98 VDCLEAROPER CHARACTER VARYING(4) 4
99 VDDIRTYPRICE_8 NUMERIC(20,8) 19
100 VDFAILDATE CHARACTER VARYING(10) 10
101 VDFAILOPER CHARACTER VARYING(4) 4
102 VDFAILREFNO CHARACTER VARYING(7) 7
103 VERDATE CHARACTER VARYING(10) 10
104 WHTAMT NUMERIC(21,4) 19
105 YIELD_8 NUMERIC(20,8) 19
106 ASSIGNSEQ CHARACTER VARYING(3) 3
107 INPUTDATE CHARACTER VARYING(10) 10
108 AMOUNT1 NUMERIC(19,4) 19
109 AMOUNT2 NUMERIC(19,4) 19
110 BOOKVALAMTYST NUMERIC(19,4) 19
111 BORRLENDIND CHARACTER VARYING(1) 1
112 BTBPORT CHARACTER VARYING(4) 4
113 COLLUNIT CHARACTER VARYING(3) 3
114 CONVINTAMT NUMERIC(19,4) 19
115 CONVINTBAMT NUMERIC(19,4) 19
116 CPNPAIDAMT NUMERIC(19,4) 19
117 DATE1 CHARACTER VARYING(10) 10
118 DATE2 CHARACTER VARYING(10) 10
119 DEALTIME CHARACTER VARYING(8) 8
120 HCMATPURCHINTAMT NUMERIC(19,4) 19
121 HCPURCHINTAMT NUMERIC(19,4) 19
122 INDEXRATIO_8 NUMERIC(18,8) 19
123 INPUTTIME CHARACTER VARYING(8) 8
124 MDCURRSPLITSEQ CHARACTER VARYING(4) 4
125 MDPAIREDAMT NUMERIC(19,4) 19
126 MDPAIREDFACEAMT NUMERIC(19,4) 19
127 MDPAIREDIND CHARACTER VARYING(1) 1
128 NOVFACEAMT NUMERIC(19,4) 19
129 SECONDPRICE_8 NUMERIC(18,8) 19
130 VDCURRSPLITSEQ CHARACTER VARYING(4) 4
131 VDPAIREDAMT NUMERIC(19,4) 19
132 VDPAIREDFACEAMT NUMERIC(19,4) 19
133 VDPAIREDIND CHARACTER VARYING(1) 1
134 YSTDSCAMT NUMERIC(19,4) 19
135 YSTINCEXPAMT NUMERIC(19,4) 19
136 YSTMTMAMT NUMERIC(19,4) 19
137 YSTPREMAMT NUMERIC(19,4) 19
138 YSTPURCHINTAMT NUMERIC(19,4) 19
139 YSTREPOINTAMT NUMERIC(19,4) 19
140 YSTREPOMTMAMT NUMERIC(19,4) 19
141 DELTA_TYPE CHARACTER VARYING(1) 1
142 EFFECTIVE_STRT_DT TIMESTAMP 8
143 EFFECTIVE_END_DT TIMESTAMP 8
144 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
145 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
146 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
147 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8