OPC_HST_FRDT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_FRDT

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