OPIC_FXHR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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