OPIC_FXDH

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