OPIC_FRDT

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 PRODUCT CHARACTER VARYING(6) 6
5 PRODTYPE CHARACTER VARYING(2) 2
6 TRAD CHARACTER VARYING(4) 4
7 INTSTRTDTE TIMESTAMP 8
8 INTENDDTE TIMESTAMP 8
9 CNO CHARACTER VARYING(11) 11
10 CCY CHARACTER VARYING(3) 3
11 CCYAMT NUMERIC(19,4) 19
12 PS CHARACTER VARYING(1) 1
13 RATECODE CHARACTER VARYING(7) 7
14 BASIS CHARACTER VARYING(6) 6
15 INTRATE_8 NUMERIC(18,8) 19
16 ACRFRSTLST CHARACTER VARYING(1) 1
17 BROK CHARACTER VARYING(11) 11
18 BROKCCY CHARACTER VARYING(3) 3
19 BROKAMT NUMERIC(19,4) 19
20 BROKRATE_8 NUMERIC(18,8) 19
21 PORT CHARACTER VARYING(4) 4
22 COST CHARACTER VARYING(11) 11
23 DEALDATE TIMESTAMP 8
24 DEALTIME CHARACTER VARYING(8) 8
25 IOPER CHARACTER VARYING(4) 4
26 VOPER CHARACTER VARYING(4) 4
27 BROKCDATE TIMESTAMP 8
28 CUSTCDATE TIMESTAMP 8
29 VERIND CHARACTER VARYING(1) 1
30 VERDATE TIMESTAMP 8
31 REVREASON CHARACTER VARYING(2) 2
32 REVDATE TIMESTAMP 8
33 REVTEXT CHARACTER VARYING(70) 70
34 PAYAUTHIND CHARACTER VARYING(1) 1
35 PAYOPER CHARACTER VARYING(4) 4
36 PAYAUTHDTE TIMESTAMP 8
37 RECOPER CHARACTER VARYING(4) 4
38 RECAUTHDTE TIMESTAMP 8
39 INPUTDATE TIMESTAMP 8
40 INPUTTIME CHARACTER VARYING(8) 8
41 DEALSRCE CHARACTER VARYING(10) 10
42 ARBDEALNO CHARACTER VARYING(10) 10
43 TRCEDATE TIMESTAMP 8
44 TRACECNT CHARACTER VARYING(3) 3
45 PAYMEANS CHARACTER VARYING(7) 7
46 PAYACCT CHARACTER VARYING(15) 15
47 RECMEANS CHARACTER VARYING(7) 7
48 RECACCT CHARACTER VARYING(15) 15
49 BRPRCINDTE TIMESTAMP 8
50 DEALTEXT CHARACTER VARYING(70) 70
51 RATEFIXDTE TIMESTAMP 8
52 SETTLEDTE TIMESTAMP 8
53 SETTLEAMT NUMERIC(19,4) 19
54 CINTRATE_8 NUMERIC(18,8) 19
55 CBASIS CHARACTER VARYING(6) 6
56 LSTMNTDATE TIMESTAMP 8
57 FIXEDDATE TIMESTAMP 8
58 REVOPER CHARACTER VARYING(4) 4
59 INTCCY CHARACTER VARYING(3) 3
60 INTEXCHRATE_8 NUMERIC(18,8) 19
61 INTEXCHTERMS CHARACTER VARYING(1) 1
62 FINCAL CHARACTER VARYING(15) 15
63 STARTRATE_8 NUMERIC(18,8) 19
64 ENDRATE_8 NUMERIC(18,8) 19
65 HEDGETRADIND CHARACTER VARYING(1) 1
66 UNDACCTNGTYPE CHARACTER VARYING(10) 10
67 UNDDEALNO CHARACTER VARYING(8) 8
68 UNDPRODUCT CHARACTER VARYING(6) 6
69 UNDSECID CHARACTER VARYING(20) 20
70 UNDTENOR CHARACTER VARYING(2) 2
71 UNDTYPE CHARACTER VARYING(2) 2
72 UNDHEDGESEQ CHARACTER VARYING(4) 4
73 ETASSIGNCUST CHARACTER VARYING(30) 30
74 ETAMT NUMERIC(19,4) 19
75 ETAUTHDTE TIMESTAMP 8
76 ETAUTHIND CHARACTER VARYING(1) 1
77 ETAUTHOPER CHARACTER VARYING(4) 4
78 ETCCY CHARACTER VARYING(3) 3
79 ETPAYRECIND CHARACTER VARYING(1) 1
80 ETSACCT CHARACTER VARYING(15) 15
81 ETSMEANS CHARACTER VARYING(7) 7
82 ETFEENO CHARACTER VARYING(8) 8
83 SPREADRATE_8 NUMERIC(18,8) 19
84 TENOR CHARACTER VARYING(2) 2
85 UPDATECOUNTER BIGINT 8
86 FEDEALNO CHARACTER VARYING(15) 15
87 FESEQ CHARACTER VARYING(4) 4
88 NETIND CHARACTER VARYING(1) 1
89 NEDATE TIMESTAMP 8
90 NETDEALNO CHARACTER VARYING(8) 8
91 CURRENTPL NUMERIC(19,4) 19
92 PAYUSUALID CHARACTER VARYING(15) 15
93 RECUSUALID CHARACTER VARYING(15) 15
94 CORPTRAD CHARACTER VARYING(4) 4
95 CORPPORT CHARACTER VARYING(4) 4
96 CORPSPREAD_8 NUMERIC(18,8) 19
97 CORPSPREADAMT NUMERIC(19,4) 19
98 INTERNALRATE_8 NUMERIC(18,8) 19
99 FLAG1 CHARACTER VARYING(1) 1
100 FLAG2 CHARACTER VARYING(1) 1
101 RATE1_8 NUMERIC(18,8) 19
102 RATE2_8 NUMERIC(18,8) 19
103 DATE1 TIMESTAMP 8
104 DATE2 TIMESTAMP 8
105 AMOUNT1 NUMERIC(19,4) 19
106 AMOUNT2 NUMERIC(19,4) 19
107 ACCRUALENDDATE TIMESTAMP 8
108 CORPCOST CHARACTER VARYING(10) 10
109 BTBIND CHARACTER VARYING(1) 1
110 BTBBRANCH CHARACTER VARYING(2) 2
111 BTBDEALNO CHARACTER VARYING(8) 8
112 BTBSEQ CHARACTER VARYING(4) 4
113 BTBPRODUCT CHARACTER VARYING(6) 6
114 BTBPRODTYPE CHARACTER VARYING(2) 2
115 BTBCCY CHARACTER VARYING(3) 3
116 BTBTRAD CHARACTER VARYING(4) 4
117 BTBPORT CHARACTER VARYING(4) 4
118 BTBCOST CHARACTER VARYING(11) 11
119 BTBCOMMUSUALID CHARACTER VARYING(15) 15
120 BTBMATUSUALID CHARACTER VARYING(15) 15
121 BTBCNO CHARACTER VARYING(11) 11
122 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
123 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
124 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
125 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8