OPC_HST_FXDH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_FXDH

SDSNZP02_BANK..NROD_OPC_HST_FXDH

Columns
# Name Data Type Length
1 ID BIGINT 8
2 AMENDDATE CHARACTER VARYING(10) 10
3 BASETERMS CHARACTER VARYING(1) 1
4 BLOCKIND CHARACTER VARYING(1) 1
5 BR CHARACTER VARYING(2) 2
6 BRCOST CHARACTER VARYING(10) 10
7 BROK CHARACTER VARYING(11) 11
8 BROKAMT NUMERIC(21,4) 19
9 BROKCCY CHARACTER VARYING(3) 3
10 BROKCDATE CHARACTER VARYING(10) 10
11 BRPRCINDTE CHARACTER VARYING(10) 10
12 BRSPREAD_8 NUMERIC(20,8) 19
13 CCY CHARACTER VARYING(3) 3
14 CCYAMT NUMERIC(21,4) 19
15 CCYBAMT NUMERIC(21,4) 19
16 CCYBPD_8 NUMERIC(20,8) 19
17 CCYBRATE_8 NUMERIC(20,8) 19
18 CCYCLEARDATE CHARACTER VARYING(10) 10
19 CCYCLEAROPER CHARACTER VARYING(4) 4
20 CCYFAILDATE CHARACTER VARYING(10) 10
21 CCYFAILOPER CHARACTER VARYING(4) 4
22 CCYNPVAMT NUMERIC(21,4) 19
23 CCYPD_8 NUMERIC(20,8) 19
24 CCYRATE_8 NUMERIC(20,8) 19
25 CCYREVALAMT NUMERIC(21,4) 19
26 CCYSACCT CHARACTER VARYING(15) 15
27 CCYSETTDATE CHARACTER VARYING(10) 10
28 CCYSETTSTATUS CHARACTER VARYING(1) 1
29 CCYSMEANS CHARACTER VARYING(7) 7
30 CCYTERMS CHARACTER VARYING(1) 1
31 COMMAMT NUMERIC(21,4) 19
32 COMMCCY CHARACTER VARYING(3) 3
33 CONFCREATEDIND CHARACTER VARYING(1) 1
34 CORPCCY CHARACTER VARYING(3) 3
35 CORPCOST CHARACTER VARYING(10) 10
36 CORPPORT CHARACTER VARYING(4) 4
37 CORPSPREAD_8 NUMERIC(20,8) 19
38 CORPSPREADAMT NUMERIC(21,4) 19
39 CORPTRAD CHARACTER VARYING(4) 4
40 COST CHARACTER VARYING(11) 11
41 CTRAMT NUMERIC(21,4) 19
42 CTRBAMT NUMERIC(21,4) 19
43 CTRBRATE_8 NUMERIC(20,8) 19
44 CTRCCY CHARACTER VARYING(3) 3
45 CTRCLEARDATE CHARACTER VARYING(10) 10
46 CTRCLEAROPER CHARACTER VARYING(4) 4
47 CTRFAILDATE CHARACTER VARYING(10) 10
48 CTRFAILOPER CHARACTER VARYING(4) 4
49 CTRNPVAMT NUMERIC(21,4) 19
50 CTRPARTYDEALNO CHARACTER VARYING(8) 8
51 CTRPARTYPHONENO CHARACTER VARYING(20) 20
52 CTRPARTYPHONEOPER CHARACTER VARYING(4) 4
53 CTRPD_8 NUMERIC(20,8) 19
54 CTRRATE_8 NUMERIC(20,8) 19
55 CTRREVALAMT NUMERIC(21,4) 19
56 CTRSACCT CHARACTER VARYING(15) 15
57 CTRSETTDATE CHARACTER VARYING(10) 10
58 CTRSETTSTATUS CHARACTER VARYING(1) 1
59 CTRSMEANS CHARACTER VARYING(7) 7
60 CUST CHARACTER VARYING(11) 11
61 CUSTCDATE CHARACTER VARYING(10) 10
62 CUSTENTEREDIND CHARACTER VARYING(1) 1
63 CUSTREFNO CHARACTER VARYING(500) 500
64 DEALDATE CHARACTER VARYING(10) 10
65 DEALNO CHARACTER VARYING(8) 8
66 DEALNOEXCESS CHARACTER VARYING(8) 8
67 DEALSRCE CHARACTER VARYING(10) 10
68 DEALTEXT CHARACTER VARYING(70) 70
69 DEALTIME CHARACTER VARYING(8) 8
70 DISAGGCCY CHARACTER VARYING(3) 3
71 DISAGGFWDCOST CHARACTER VARYING(10) 10
72 DISAGGFWDPORT CHARACTER VARYING(4) 4
73 DISAGGFWDTRAD CHARACTER VARYING(4) 4
74 DISAGGSPOTCOST CHARACTER VARYING(10) 10
75 DISAGGSPOTPORT CHARACTER VARYING(4) 4
76 DISAGGSPOTTRAD CHARACTER VARYING(4) 4
77 EXCCUSTLIM CHARACTER VARYING(1) 1
78 EXCOVERALLLIM CHARACTER VARYING(1) 1
79 FARNEARIND CHARACTER VARYING(1) 1
80 FINCNTR1 CHARACTER VARYING(10) 10
81 FINCNTR2 CHARACTER VARYING(10) 10
82 FIXRATECODE CHARACTER VARYING(7) 7
83 FIXRATEIND CHARACTER VARYING(1) 1
84 FWDPREMAMT NUMERIC(21,4) 19
85 INPUTDATE CHARACTER VARYING(10) 10
86 INPUTTIME CHARACTER VARYING(8) 8
87 INTERNALRATE_8 NUMERIC(20,8) 19
88 IOPER CHARACTER VARYING(4) 4
89 LINKDEALNO CHARACTER VARYING(8) 8
90 LINKPRODTYPE CHARACTER VARYING(2) 2
91 LINKPRODUCT CHARACTER VARYING(6) 6
92 LSTMNTDATE CHARACTER VARYING(10) 10
93 MARGINAMT NUMERIC(21,4) 19
94 MARGINCCY CHARACTER VARYING(3) 3
95 MARGINFEEAMT NUMERIC(21,4) 19
96 MARGINFEECCY CHARACTER VARYING(3) 3
97 MARGINFEEREBAMT NUMERIC(21,4) 19
98 MARGINFEEREBCCY CHARACTER VARYING(3) 3
99 MARGINFEEREBSETTACCT CHARACTER VARYING(15) 15
100 MARGINFEEREBSETTMEANS CHARACTER VARYING(7) 7
101 MARGINFEESETTACCT CHARACTER VARYING(15) 15
102 MARGINFEESETTMEANS CHARACTER VARYING(7) 7
103 NETDEAL CHARACTER VARYING(11) 11
104 NETSI CHARACTER VARYING(1) 1
105 NSRCCYSEQ CHARACTER VARYING(4) 4
106 NSRCTRSEQ CHARACTER VARYING(4) 4
107 NSRNOCCY CHARACTER VARYING(8) 8
108 NSRNOCTR CHARACTER VARYING(8) 8
109 ODATE CHARACTER VARYING(10) 10
110 OPTIONIND CHARACTER VARYING(1) 1
111 ORIGOCAMT NUMERIC(21,4) 19
112 PAYAUTHDTE CHARACTER VARYING(10) 10
113 PAYAUTHIND CHARACTER VARYING(1) 1
114 PAYAUTHOPER CHARACTER VARYING(4) 4
115 PAYOPER CHARACTER VARYING(4) 4
116 PHONCI CHARACTER VARYING(1) 1
117 PHONECDATE CHARACTER VARYING(10) 10
118 PHONECONFOPER CHARACTER VARYING(4) 4
119 PHONECONFTIME CHARACTER VARYING(8) 8
120 PHONETEXT CHARACTER VARYING(70) 70
121 PORT CHARACTER VARYING(4) 4
122 PRODCODE CHARACTER VARYING(6) 6
123 PRODTYPE CHARACTER VARYING(2) 2
124 PS CHARACTER VARYING(1) 1
125 RECAUTHDTE CHARACTER VARYING(10) 10
126 RECAUTHOPER CHARACTER VARYING(4) 4
127 RECOPER CHARACTER VARYING(4) 4
128 REVDATE CHARACTER VARYING(10) 10
129 REVDEALNO CHARACTER VARYING(8) 8
130 REVOPER CHARACTER VARYING(4) 4
131 REVREASON CHARACTER VARYING(2) 2
132 REVTEXT CHARACTER VARYING(70) 70
133 REXRATETOLIND CHARACTER VARYING(1) 1
134 SEQ CHARACTER VARYING(4) 4
135 SIIND CHARACTER VARYING(1) 1
136 SIINDPAY CHARACTER VARYING(1) 1
137 SPOTCCY CHARACTER VARYING(3) 3
138 SPOTCOST CHARACTER VARYING(10) 10
139 SPOTDATE CHARACTER VARYING(10) 10
140 SPOTFWDIND CHARACTER VARYING(1) 1
141 SPOTIND CHARACTER VARYING(1) 1
142 SPOTPORT CHARACTER VARYING(4) 4
143 SPOTTRAD CHARACTER VARYING(4) 4
144 SWAPDEAL CHARACTER VARYING(8) 8
145 SWAPVDATE CHARACTER VARYING(10) 10
146 SWIFTMATCHIND CHARACTER VARYING(1) 1
147 TENOR CHARACTER VARYING(2) 2
148 TENOREXCEEDIND CHARACTER VARYING(1) 1
149 TRACECNT CHARACTER VARYING(3) 3
150 TRAD CHARACTER VARYING(4) 4
151 TRCEDATE CHARACTER VARYING(10) 10
152 VDATE CHARACTER VARYING(10) 10
153 VERDATE CHARACTER VARYING(10) 10
154 VERIND CHARACTER VARYING(1) 1
155 VOPER CHARACTER VARYING(4) 4
156 PORTFOLIO_DATE CHARACTER VARYING(10) 10
157 DELTA_TYPE CHARACTER VARYING(1) 1
158 EFFECTIVE_STRT_DT TIMESTAMP 8
159 EFFECTIVE_END_DT TIMESTAMP 8
160 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
161 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
162 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
163 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8