OPC_HST_SODT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_SODT

Columns
# Name Data Type Length
1 ID BIGINT 8
2 CNO CHARACTER VARYING(10) 10
3 COST CHARACTER VARYING(10) 10
4 DEALNO CHARACTER VARYING(8) 8
5 EXPDATE CHARACTER VARYING(10) 10
6 IOPER CHARACTER VARYING(4) 4
7 NOTAMT NUMERIC(19,4) 19
8 NOTCCY CHARACTER VARYING(3) 3
9 PORT CHARACTER VARYING(4) 4
10 PRFEENO CHARACTER VARYING(8) 8
11 PRODUCT CHARACTER VARYING(6) 6
12 PS CHARACTER VARYING(1) 1
13 REVDATE CHARACTER VARYING(10) 10
14 SOPRODUCT CHARACTER VARYING(6) 6
15 PRODTYPE CHARACTER VARYING(2) 2
16 SOPRODTYPE CHARACTER VARYING(2) 2
17 BR CHARACTER VARYING(2) 2
18 SEQ CHARACTER VARYING(4) 4
19 DEALDATE CHARACTER VARYING(10) 10
20 EXERDATE CHARACTER VARYING(10) 10
21 INPUTDATE CHARACTER VARYING(10) 10
22 LSTMNTDTE CHARACTER VARYING(10) 10
23 STARTDATE CHARACTER VARYING(10) 10
24 VERDATE CHARACTER VARYING(10) 10
25 VERIND CHARACTER VARYING(1) 1
26 EXERIND CHARACTER VARYING(1) 1
27 BROK CHARACTER VARYING(10) 10
28 BROKAMT NUMERIC(19,4) 19
29 BROKCCY CHARACTER VARYING(3) 3
30 BROKCDATE CHARACTER VARYING(10) 10
31 BROKRATE_8 NUMERIC(18,8) 19
32 BRPRCINDTE CHARACTER VARYING(10) 10
33 CASHAMT NUMERIC(19,4) 19
34 CASHAUTHDTE CHARACTER VARYING(10) 10
35 CASHAUTHIND CHARACTER VARYING(1) 1
36 CASHAUTHOPER CHARACTER VARYING(4) 4
37 CASHCCY CHARACTER VARYING(3) 3
38 CASHDATE CHARACTER VARYING(10) 10
39 CASHFEEFINCENT CHARACTER VARYING(15) 15
40 CASHFEENO CHARACTER VARYING(8) 8
41 CASHIND CHARACTER VARYING(1) 1
42 CASHPR CHARACTER VARYING(1) 1
43 CASHSACCT CHARACTER VARYING(15) 15
44 CASHSMEANS CHARACTER VARYING(7) 7
45 CASHSOPER CHARACTER VARYING(4) 4
46 CORPCOST CHARACTER VARYING(10) 10
47 CORPPORT CHARACTER VARYING(4) 4
48 CORPSPREAD_8 NUMERIC(18,8) 19
49 CORPSPREADAMT NUMERIC(19,4) 19
50 CORPTRAD CHARACTER VARYING(4) 4
51 CREDITCODE CHARACTER VARYING(7) 7
52 CUSTCDATE CHARACTER VARYING(10) 10
53 CUTOFF CHARACTER VARYING(20) 20
54 DEALLINKNO CHARACTER VARYING(20) 20
55 DEALSRCE CHARACTER VARYING(10) 10
56 DEALTEXT CHARACTER VARYING(70) 70
57 DEALTIME CHARACTER VARYING(8) 8
58 DELTA_8 NUMERIC(18,8) 19
59 ETCCY CHARACTER VARYING(3) 3
60 ETFEENO CHARACTER VARYING(8) 8
61 ETPAYRECIND CHARACTER VARYING(1) 1
62 ETSACCT CHARACTER VARYING(15) 15
63 ETSMEANS CHARACTER VARYING(7) 7
64 EXERACT CHARACTER VARYING(1) 1
65 EXERINPUTDATE CHARACTER VARYING(10) 10
66 EXEROPER CHARACTER VARYING(4) 4
67 FEEIND CHARACTER VARYING(1) 1
68 INPUTTIME CHARACTER VARYING(8) 8
69 INTRINSICVALUE NUMERIC(19,4) 19
70 LOSS NUMERIC(19,4) 19
71 OPTIONTYPE CHARACTER VARYING(1) 1
72 ORIGPREMAMT NUMERIC(19,4) 19
73 ORIGPREMRATE_8 NUMERIC(18,8) 19
74 PLMETHOD CHARACTER VARYING(1) 1
75 PRCCY CHARACTER VARYING(3) 3
76 PRFEEFINCENT CHARACTER VARYING(15) 15
77 PRPAYRECIND CHARACTER VARYING(1) 1
78 PRSACCT CHARACTER VARYING(15) 15
79 PRSMEANS CHARACTER VARYING(7) 7
80 RATECODE CHARACTER VARYING(7) 7
81 REVOPER CHARACTER VARYING(4) 4
82 REVREASON CHARACTER VARYING(2) 2
83 REVTEXT CHARACTER VARYING(70) 70
84 SEQLEG CHARACTER VARYING(3) 3
85 STRIKE_8 NUMERIC(18,8) 19
86 STYLE CHARACTER VARYING(2) 2
87 TENOR CHARACTER VARYING(2) 2
88 TIMEVALUE NUMERIC(19,4) 19
89 TRAD CHARACTER VARYING(4) 4
90 UPDATECOUNTER BIGINT 8
91 VOLATILITY_8 NUMERIC(18,8) 19
92 VOPER CHARACTER VARYING(4) 4
93 YIELDCURVE CHARACTER VARYING(9) 9
94 DELTA_TYPE CHARACTER VARYING(1) 1
95 EFFECTIVE_STRT_DT TIMESTAMP 8
96 EFFECTIVE_END_DT TIMESTAMP 8
97 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
98 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
99 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
100 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8