OPC_HST_DLDT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_DLDT

SDSNZP02_BANK..NROD_OPC_HST_DLDT

Columns
# Name Data Type Length
1 ID BIGINT 8
2 AL CHARACTER VARYING(1) 1
3 BASIS CHARACTER VARYING(6) 6
4 BR CHARACTER VARYING(2) 2
5 BRPRCINDTE CHARACTER VARYING(10) 10
6 CCY CHARACTER VARYING(3) 3
7 CCYAMT NUMERIC(19,4) 19
8 CNO CHARACTER VARYING(10) 10
9 COST CHARACTER VARYING(11) 11
10 DEALDATE CHARACTER VARYING(10) 10
11 DEALNO CHARACTER VARYING(8) 8
12 DEALTEXT CHARACTER VARYING(70) 70
13 FUNDRATE_8 NUMERIC(18,8) 19
14 INTPAYCYCLE CHARACTER VARYING(2) 2
15 INTRATE CHARACTER VARYING(16) 16
16 INTRATE_8 NUMERIC(18,8) 19
17 IOPER CHARACTER VARYING(4) 4
18 LINKDEALNO CHARACTER VARYING(8) 8
19 MDATE CHARACTER VARYING(10) 10
20 ORIGDEALNO CHARACTER VARYING(8) 8
21 ORIGMDATE CHARACTER VARYING(10) 10
22 ORIGOCAMT NUMERIC(19,4) 19
23 PORT CHARACTER VARYING(4) 4
24 PRMDSCAMRTD NUMERIC(19,4) 19
25 PRODTYPE CHARACTER VARYING(2) 2
26 PRODUCT CHARACTER VARYING(6) 6
27 RATECODE CHARACTER VARYING(7) 7
28 REVDATE CHARACTER VARYING(10) 10
29 SCHDFLAG CHARACTER VARYING(1) 1
30 SCHEDULETYPE CHARACTER VARYING(2) 2
31 SECID CHARACTER VARYING(20) 20
32 SEQ CHARACTER VARYING(4) 4
33 SPREAD_8 NUMERIC(18,8) 19
34 TENOR CHARACTER VARYING(2) 2
35 TRAD CHARACTER VARYING(4) 4
36 VDATE CHARACTER VARYING(10) 10
37 VERDATE CHARACTER VARYING(10) 10
38 YIELD_8 NUMERIC(18,8) 19
39 PORTFOLIO_DATE CHARACTER VARYING(10) 10
40 INPUTDATE CHARACTER VARYING(10) 10
41 LSTMNTDATE CHARACTER VARYING(10) 10
42 VERIND CHARACTER VARYING(1) 1
43 LIENAMT NUMERIC(19,4) 19
44 LIENOFFCR CHARACTER VARYING(8) 8
45 LIENDATE CHARACTER VARYING(10) 10
46 ACCTGMETHOD CHARACTER VARYING(1) 1
47 ACRFRSTLST CHARACTER VARYING(1) 1
48 AGENTIND CHARACTER VARYING(1) 1
49 ALLOWNEGINT CHARACTER VARYING(1) 1
50 AMENDDATE CHARACTER VARYING(10) 10
51 AMOUNT1 NUMERIC(19,4) 19
52 AMOUNT2 NUMERIC(19,4) 19
53 ARBDEALNO CHARACTER VARYING(10) 10
54 BROK CHARACTER VARYING(11) 11
55 BROKAMT NUMERIC(19,4) 19
56 BROKCCY CHARACTER VARYING(3) 3
57 BROKEXCHRATE_8 NUMERIC(18,8) 19
58 BROKRATE_8 NUMERIC(18,8) 19
59 BTBBRANCH CHARACTER VARYING(2) 2
60 BTBCOMMUSUALID CHARACTER VARYING(15) 15
61 BTBCOST CHARACTER VARYING(10) 10
62 BTBCUSTOMER CHARACTER VARYING(10) 10
63 BTBDEALNO CHARACTER VARYING(8) 8
64 BTBFUNDCENTER CHARACTER VARYING(10) 10
65 BTBIND CHARACTER VARYING(1) 1
66 BTBMATUSUALID CHARACTER VARYING(15) 15
67 BTBPORT CHARACTER VARYING(4) 4
68 BTBPRODTYPE CHARACTER VARYING(2) 2
69 BTBPRODUCT CHARACTER VARYING(6) 6
70 BTBSEQ CHARACTER VARYING(4) 4
71 BTBTRAD CHARACTER VARYING(4) 4
72 COMMACCT CHARACTER VARYING(15) 15
73 COMMMEANS CHARACTER VARYING(7) 7
74 COMMTYPECODE CHARACTER VARYING(1) 1
75 COMMUSUALID CHARACTER VARYING(15) 15
76 CONTACTINFO CHARACTER VARYING(70) 70
77 CORPDEALNO CHARACTER VARYING(8) 8
78 CORPNETIND CHARACTER VARYING(1) 1
79 CORPPORT CHARACTER VARYING(4) 4
80 CORPSEQ CHARACTER VARYING(4) 4
81 CORPTRAD CHARACTER VARYING(4) 4
82 CUSIPISIN CHARACTER VARYING(12) 12
83 CUSTCDATE CHARACTER VARYING(10) 10
84 CUSTREFNO CHARACTER VARYING(35) 35
85 DATE1 CHARACTER VARYING(10) 10
86 DATE2 CHARACTER VARYING(10) 10
87 DEALREBOOKED CHARACTER VARYING(1) 1
88 DEALSRCE CHARACTER VARYING(10) 10
89 DEALTIME CHARACTER VARYING(8) 8
90 DELAYEDINTDATE CHARACTER VARYING(10) 10
91 DELAYEDINTIND CHARACTER VARYING(1) 1
92 DISCRATE_8 NUMERIC(18,8) 19
93 EARLYMATIND CHARACTER VARYING(1) 1
94 EFFECTIVESTATUSDATE CHARACTER VARYING(10) 10
95 EMINPUTDATE CHARACTER VARYING(10) 10
96 EMIOPER CHARACTER VARYING(4) 4
97 EMPENAMT NUMERIC(19,4) 19
98 FEDEALNO CHARACTER VARYING(15) 15
99 FINCAL CHARACTER VARYING(15) 15
100 FIRSTDEALNO CHARACTER VARYING(8) 8
101 FIRSTIPAYDATE CHARACTER VARYING(10) 10
102 FIXRULE CHARACTER VARYING(1) 1
103 FUNDBASIS CHARACTER VARYING(6) 6
104 FUNDCOST CHARACTER VARYING(11) 11
105 FUNDPORT CHARACTER VARYING(4) 4
106 FUNDTRAD CHARACTER VARYING(4) 4
107 GUARANTOR CHARACTER VARYING(10) 10
108 INPUTTIME CHARACTER VARYING(8) 8
109 INTAUTHDATE CHARACTER VARYING(10) 10
110 INTAUTHOPER CHARACTER VARYING(4) 4
111 INTCALCRULE CHARACTER VARYING(1) 1
112 INTCAPAMT NUMERIC(19,4) 19
113 INTCAPFLAG CHARACTER VARYING(1) 1
114 INTDATEDIR CHARACTER VARYING(2) 2
115 INTDATERULE CHARACTER VARYING(3) 3
116 INTPAYDAY CHARACTER VARYING(3) 3
117 INTSACCT CHARACTER VARYING(15) 15
118 INTSETTAUTHIND CHARACTER VARYING(1) 1
119 INTSIPAYIND CHARACTER VARYING(1) 1
120 INTSIRECIND CHARACTER VARYING(1) 1
121 INTSMEANS CHARACTER VARYING(7) 7
122 LASTAMOUNT NUMERIC(19,4) 19
123 LASTIPAYDATE CHARACTER VARYING(10) 10
124 LINKPRODTYPE CHARACTER VARYING(2) 2
125 LINKPRODUCT CHARACTER VARYING(6) 6
126 LINKSEQ CHARACTER VARYING(4) 4
127 MATACCT CHARACTER VARYING(15) 15
128 MATMEANS CHARACTER VARYING(7) 7
129 MATSTATUS CHARACTER VARYING(15) 15
130 MATTYPECODE CHARACTER VARYING(1) 1
131 MATUSUALID CHARACTER VARYING(15) 15
132 NETDEALNO CHARACTER VARYING(8) 8
133 NETSEQ CHARACTER VARYING(4) 4
134 NETSI CHARACTER VARYING(1) 1
135 NEWDEALNO CHARACTER VARYING(8) 8
136 NXTRATEREV CHARACTER VARYING(30) 30
137 PAYAUTHDTE CHARACTER VARYING(10) 10
138 PAYAUTHIND CHARACTER VARYING(1) 1
139 PAYAUTHOPER CHARACTER VARYING(4) 4
140 PAYOPER CHARACTER VARYING(4) 4
141 PRINDATEDIR CHARACTER VARYING(2) 2
142 PRINDATERULE CHARACTER VARYING(3) 3
143 PRINPAYCYCLE CHARACTER VARYING(2) 2
144 PRINPAYDAY CHARACTER VARYING(3) 3
145 PRINSIPAYIND CHARACTER VARYING(1) 1
146 PRINSIRECIND CHARACTER VARYING(1) 1
147 PRINTOTPAYMENTS NUMERIC(19,4) 19
148 PROFITRATE_8 NUMERIC(18,8) 19
149 RATEREVDTE CHARACTER VARYING(10) 10
150 REBOOKEDDEAL CHARACTER VARYING(1) 1
151 RECAUTHDTE CHARACTER VARYING(10) 10
152 RECAUTHOPER CHARACTER VARYING(4) 4
153 RECOPER CHARACTER VARYING(4) 4
154 REVDEALNO CHARACTER VARYING(8) 8
155 REVOPER CHARACTER VARYING(4) 4
156 REVREASON CHARACTER VARYING(2) 2
157 REVTEXT CHARACTER VARYING(70) 70
158 SERVER CHARACTER VARYING(15) 15
159 SIIND CHARACTER VARYING(1) 1
160 SIPAYIND CHARACTER VARYING(1) 1
161 SPINST CHARACTER VARYING(70) 70
162 STEPUPRATE_8 NUMERIC(18,8) 19
163 SWIFTMATCHIND CHARACTER VARYING(1) 1
164 TAXAMT NUMERIC(19,4) 19
165 TAXAUTHORITY CHARACTER VARYING(10) 10
166 TAXCHGDESC CHARACTER VARYING(25) 25
167 TAXPRODTYPE CHARACTER VARYING(2) 2
168 TAXPRODUCT CHARACTER VARYING(6) 6
169 TAXTYPE CHARACTER VARYING(1) 1
170 TEMPLATETYPE BIGINT 8
171 TEXT1 CHARACTER VARYING(35) 35
172 TEXT2 CHARACTER VARYING(35) 35
173 TRACECNT CHARACTER VARYING(3) 3
174 TRCEDATE CHARACTER VARYING(10) 10
175 UCPARTY CHARACTER VARYING(70) 70
176 UPDATECOUNTER BIGINT 8
177 VOPER CHARACTER VARYING(4) 4
178 DELTA_TYPE CHARACTER VARYING(1) 1
179 EFFECTIVE_STRT_DT TIMESTAMP 8
180 EFFECTIVE_END_DT TIMESTAMP 8
181 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
182 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
183 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
184 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8