OPIC_SWDH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKFRC_OPIC_SWDH

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