OPIC_DLDT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_OPIC_DLDT

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