OPC_HST_SWDH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_SWDH

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTIVEIND CHARACTER VARYING(1) 1
3 BR CHARACTER VARYING(2) 2
4 BRPRCINDTE CHARACTER VARYING(10) 10
5 CNO CHARACTER VARYING(10) 10
6 COLLARDEALNO CHARACTER VARYING(8) 8
7 CORPCOST CHARACTER VARYING(10) 10
8 CORPPORT CHARACTER VARYING(4) 4
9 CORPTRAD CHARACTER VARYING(4) 4
10 COST CHARACTER VARYING(10) 10
11 CREDITCODE CHARACTER VARYING(7) 7
12 CUSTCDATE CHARACTER VARYING(10) 10
13 DEALDATE CHARACTER VARYING(10) 10
14 DEALIND CHARACTER VARYING(1) 1
15 DEALLINKNO CHARACTER VARYING(20) 20
16 DEALNO CHARACTER VARYING(8) 8
17 DEALTEXT CHARACTER VARYING(70) 70
18 INTDEAL CHARACTER VARYING(1) 1
19 INTRINSICVALUE NUMERIC(19,4) 19
20 IOPER CHARACTER VARYING(4) 4
21 LEGCNT CHARACTER VARYING(4) 4
22 LSTMNTDTE CHARACTER VARYING(10) 10
23 MATDATE CHARACTER VARYING(10) 10
24 NETPAYIND CHARACTER VARYING(1) 1
25 NOTCCY CHARACTER VARYING(3) 3
26 NOTCCYAMT NUMERIC(19,4) 19
27 NPVBAMT NUMERIC(19,4) 19
28 NPVBAMTPAY NUMERIC(19,4) 19
29 NPVBAMTREC NUMERIC(19,4) 19
30 OPTIONTYPE CHARACTER VARYING(1) 1
31 PLMETHOD CHARACTER VARYING(1) 1
32 PORT CHARACTER VARYING(4) 4
33 PRODTYPE CHARACTER VARYING(2) 2
34 PRODUCT CHARACTER VARYING(6) 6
35 REVDATE CHARACTER VARYING(10) 10
36 SEQ CHARACTER VARYING(4) 4
37 SETTLEDATE CHARACTER VARYING(10) 10
38 STARTDATE CHARACTER VARYING(10) 10
39 SWAPTYPE CHARACTER VARYING(1) 1
40 TRAD CHARACTER VARYING(4) 4
41 UPDATECOUNTER BIGINT 8
42 VANILLASWAPIND CHARACTER VARYING(1) 1
43 VERDATE CHARACTER VARYING(10) 10
44 PORTFOLIO_DATE CHARACTER VARYING(10) 10
45 INPUTDATE CHARACTER VARYING(10) 10
46 VERIND CHARACTER VARYING(1) 1
47 TRACEDATE CHARACTER VARYING(10) 10
48 AMOUNT1 NUMERIC(19,4) 19
49 AMOUNT2 NUMERIC(19,4) 19
50 AMOUNT3 NUMERIC(19,4) 19
51 BCREDITAMT NUMERIC(19,4) 19
52 BMFAMT NUMERIC(19,4) 19
53 BMFCCY CHARACTER VARYING(3) 3
54 BMFNAME CHARACTER VARYING(11) 11
55 BMKTAMT NUMERIC(19,4) 19
56 BMTMAMT NUMERIC(19,4) 19
57 BROK CHARACTER VARYING(10) 10
58 BROKAMT NUMERIC(19,4) 19
59 BROKCCY CHARACTER VARYING(3) 3
60 BROKCDATE CHARACTER VARYING(10) 10
61 BROKRATE_8 NUMERIC(18,8) 19
62 BTBBR CHARACTER VARYING(2) 2
63 BTBCNO CHARACTER VARYING(10) 10
64 BTBCOST CHARACTER VARYING(10) 10
65 BTBDEALNO CHARACTER VARYING(8) 8
66 BTBIND CHARACTER VARYING(1) 1
67 BTBPORT CHARACTER VARYING(4) 4
68 BTBPROD CHARACTER VARYING(6) 6
69 BTBPRODTYPE CHARACTER VARYING(2) 2
70 BTBSEQ CHARACTER VARYING(4) 4
71 BTBTRAD CHARACTER VARYING(4) 4
72 CHAR1 CHARACTER VARYING(20) 20
73 CLRAGNTAMT NUMERIC(19,4) 19
74 CLRAGNTCCY CHARACTER VARYING(3) 3
75 CLRAGNTNAME CHARACTER VARYING(11) 11
76 CNTRPTYGUARANTEE CHARACTER VARYING(1) 1
77 COUNTERREFID CHARACTER VARYING(16) 16
78 CREDITDEFAULTIND CHARACTER VARYING(1) 1
79 DATE1 CHARACTER VARYING(10) 10
80 DATE2 CHARACTER VARYING(10) 10
81 DEALSRCE CHARACTER VARYING(10) 10
82 DEALTIME CHARACTER VARYING(8) 8
83 ETAMT NUMERIC(19,4) 19
84 ETAMT2 NUMERIC(19,4) 19
85 ETASSIGNCUST CHARACTER VARYING(30) 30
86 ETAUTHDTE CHARACTER VARYING(10) 10
87 ETAUTHDTE2 CHARACTER VARYING(10) 10
88 ETAUTHIND CHARACTER VARYING(1) 1
89 ETAUTHIND2 CHARACTER VARYING(1) 1
90 ETAUTHOPER CHARACTER VARYING(4) 4
91 ETAUTHOPER2 CHARACTER VARYING(4) 4
92 ETCCY CHARACTER VARYING(3) 3
93 ETCCY2 CHARACTER VARYING(3) 3
94 ETFEEINTIND CHARACTER VARYING(1) 1
95 ETFEEINTIND2 CHARACTER VARYING(1) 1
96 ETFEENO CHARACTER VARYING(8) 8
97 ETFEENO2 CHARACTER VARYING(8) 8
98 ETINPUTDATE CHARACTER VARYING(10) 10
99 ETLEGSEQ CHARACTER VARYING(4) 4
100 ETLEGSEQ2 CHARACTER VARYING(4) 4
101 ETOPER CHARACTER VARYING(4) 4
102 ETPAYRECIND CHARACTER VARYING(1) 1
103 ETPAYRECIND2 CHARACTER VARYING(1) 1
104 ETSACCT CHARACTER VARYING(15) 15
105 ETSACCT2 CHARACTER VARYING(15) 15
106 ETSMEANS CHARACTER VARYING(7) 7
107 ETSMEANS2 CHARACTER VARYING(7) 7
108 EXERACT CHARACTER VARYING(1) 1
109 FLAG1 CHARACTER VARYING(1) 1
110 FLAG2 CHARACTER VARYING(1) 1
111 FLAG3 CHARACTER VARYING(1) 1
112 GUARANTOR CHARACTER VARYING(10) 10
113 IMM CHARACTER VARYING(10) 10
114 INPUTTIME CHARACTER VARYING(8) 8
115 INVTYPE CHARACTER VARYING(1) 1
116 MAXLEGSEQ CHARACTER VARYING(4) 4
117 MBSDEALTYPE CHARACTER VARYING(1) 1
118 MBSLEGIND CHARACTER VARYING(1) 1
119 MINLEGSEQ CHARACTER VARYING(4) 4
120 MULTICCYIND CHARACTER VARYING(1) 1
121 NOTEXCHRATEIND CHARACTER VARYING(1) 1
122 ORIGTERMDATE CHARACTER VARYING(10) 10
123 PTYGUARANTEE CHARACTER VARYING(1) 1
124 RATE1_8 NUMERIC(18,8) 19
125 RATE2_8 NUMERIC(18,8) 19
126 RATE3_8 NUMERIC(18,8) 19
127 REVOPER CHARACTER VARYING(4) 4
128 REVREASON CHARACTER VARYING(2) 2
129 REVTEXT CHARACTER VARYING(70) 70
130 SETOFF CHARACTER VARYING(1) 1
131 TAXFLG CHARACTER VARYING(1) 1
132 TENOR CHARACTER VARYING(2) 2
133 TRACECNT CHARACTER VARYING(3) 3
134 UNDACCTNGTYPE CHARACTER VARYING(10) 10
135 UNDDEALNO CHARACTER VARYING(8) 8
136 UNDHEDGESEQ CHARACTER VARYING(4) 4
137 UNDPRODUCT CHARACTER VARYING(6) 6
138 UNDSECID CHARACTER VARYING(20) 20
139 UNDTENOR CHARACTER VARYING(2) 2
140 UNDTYPE CHARACTER VARYING(2) 2
141 VARNOTIONALIND CHARACTER VARYING(1) 1
142 VOPER CHARACTER VARYING(4) 4
143 DELTA_TYPE CHARACTER VARYING(1) 1
144 EFFECTIVE_STRT_DT TIMESTAMP 8
145 EFFECTIVE_END_DT TIMESTAMP 8
146 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
147 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
148 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
149 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8