OPC_HST_FXIH

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACCTNGTYPE CHARACTER VARYING(10) 10
3 AMENDDATE CHARACTER VARYING(10) 10
4 AMORTTYPEIND CHARACTER VARYING(1) 1
5 BASEFARPD_8 NUMERIC(20,8) 19
6 BASEFARRATE_8 NUMERIC(20,8) 19
7 BASENEARPD_8 NUMERIC(20,8) 19
8 BASENEARRATE_8 NUMERIC(20,8) 19
9 BASETERMS CHARACTER VARYING(1) 1
10 BR CHARACTER VARYING(2) 2
11 BRPRCINDTE CHARACTER VARYING(10) 10
12 CCY CHARACTER VARYING(3) 3
13 CCYAMT NUMERIC(21,4) 19
14 CCYBASIS CHARACTER VARYING(6) 6
15 CCYFARBAMT NUMERIC(21,4) 19
16 CCYFARNPVAMT NUMERIC(21,4) 19
17 CCYFARPD_8 NUMERIC(20,8) 19
18 CCYFARRATE_8 NUMERIC(20,8) 19
19 CCYFARREVALAMT NUMERIC(21,4) 19
20 CCYFARSPOTBAMT NUMERIC(21,4) 19
21 CCYINTAMT NUMERIC(21,4) 19
22 CCYINTRATE_8 NUMERIC(20,8) 19
23 CCYLINKDEALNO CHARACTER VARYING(10) 10
24 CCYNEARBAMT NUMERIC(21,4) 19
25 CCYNEARNPVAMT NUMERIC(21,4) 19
26 CCYNEARPD_8 NUMERIC(20,8) 19
27 CCYNEARRATE_8 NUMERIC(20,8) 19
28 CCYNEARREVALAMT NUMERIC(21,4) 19
29 CCYNEARSPOTBAMT NUMERIC(21,4) 19
30 CCYPRINAMT NUMERIC(21,4) 19
31 CCYPRINBAMT NUMERIC(21,4) 19
32 CCYRATECODE CHARACTER VARYING(7) 7
33 CCYTERMS CHARACTER VARYING(1) 1
34 COST CHARACTER VARYING(10) 10
35 CTRAMT NUMERIC(21,4) 19
36 CTRBASIS CHARACTER VARYING(6) 6
37 CTRCCY CHARACTER VARYING(3) 3
38 CTRFARBAMT NUMERIC(21,4) 19
39 CTRFARNPVAMT NUMERIC(21,4) 19
40 CTRFARREVALAMT NUMERIC(21,4) 19
41 CTRFARSPOTBAMT NUMERIC(21,4) 19
42 CTRINTAMT NUMERIC(21,4) 19
43 CTRINTRATE_8 NUMERIC(20,8) 19
44 CTRLINKDEALNO CHARACTER VARYING(10) 10
45 CTRNEARBAMT NUMERIC(21,4) 19
46 CTRNEARNPVAMT NUMERIC(21,4) 19
47 CTRNEARREVALAMT NUMERIC(21,4) 19
48 CTRNEARSPOTBAMT NUMERIC(21,4) 19
49 CTRPRINAMT NUMERIC(21,4) 19
50 CTRPRINBAMT NUMERIC(21,4) 19
51 CTRRATECODE CHARACTER VARYING(7) 7
52 DEALDATE CHARACTER VARYING(10) 10
53 DEALNO CHARACTER VARYING(8) 8
54 DEALTEXT CHARACTER VARYING(70) 70
55 DEALTYPE CHARACTER VARYING(1) 1
56 DISAGGCCY CHARACTER VARYING(3) 3
57 DISAGGFARFWDCOST CHARACTER VARYING(10) 10
58 DISAGGFARFWDPORT CHARACTER VARYING(4) 4
59 DISAGGFARFWDTRAD CHARACTER VARYING(4) 4
60 DISAGGFARSPOTCOST CHARACTER VARYING(10) 10
61 DISAGGFARSPOTPORT CHARACTER VARYING(4) 4
62 DISAGGFARSPOTTRAD CHARACTER VARYING(4) 4
63 DISAGGNEARFWDCOST CHARACTER VARYING(10) 10
64 DISAGGNEARFWDPORT CHARACTER VARYING(4) 4
65 DISAGGNEARFWDTRAD CHARACTER VARYING(4) 4
66 DISAGGNEARSPOTCOST CHARACTER VARYING(10) 10
67 DISAGGNEARSPOTPORT CHARACTER VARYING(4) 4
68 DISAGGNEARSPOTTRAD CHARACTER VARYING(4) 4
69 FEDEALNO CHARACTER VARYING(15) 15
70 FWDCOST CHARACTER VARYING(10) 10
71 FWDPORT CHARACTER VARYING(4) 4
72 FWDTRAD CHARACTER VARYING(4) 4
73 INPUTDATE CHARACTER VARYING(10) 10
74 INPUTTIME CHARACTER VARYING(8) 8
75 IOPER CHARACTER VARYING(4) 4
76 LSTMNTDTE CHARACTER VARYING(10) 10
77 MDATE CHARACTER VARYING(10) 10
78 NOTCCYAMT NUMERIC(21,4) 19
79 NOTCTRAMT NUMERIC(21,4) 19
80 PORT CHARACTER VARYING(4) 4
81 PRODTYPE CHARACTER VARYING(2) 2
82 PRODUCT CHARACTER VARYING(6) 6
83 PS CHARACTER VARYING(1) 1
84 REVDATE CHARACTER VARYING(10) 10
85 REVOPER CHARACTER VARYING(4) 4
86 REVREASON CHARACTER VARYING(2) 2
87 REVTEXT CHARACTER VARYING(70) 70
88 SEQ CHARACTER VARYING(4) 4
89 SPOTCCY CHARACTER VARYING(3) 3
90 SPOTCOST CHARACTER VARYING(10) 10
91 SPOTDATE CHARACTER VARYING(10) 10
92 SPOTPORT CHARACTER VARYING(4) 4
93 SPOTTRAD CHARACTER VARYING(4) 4
94 TENOR CHARACTER VARYING(2) 2
95 TRAD CHARACTER VARYING(4) 4
96 UNDCCYACCTGTYPE CHARACTER VARYING(10) 10
97 UNDCCYPRODTYPE CHARACTER VARYING(2) 2
98 UNDCCYPRODUCT CHARACTER VARYING(6) 6
99 UNDCCYTENOR CHARACTER VARYING(2) 2
100 UNDCTRACCTGTYPE CHARACTER VARYING(10) 10
101 UNDCTRPRODTYPE CHARACTER VARYING(2) 2
102 UNDCTRPRODUCT CHARACTER VARYING(6) 6
103 UNDCTRTENOR CHARACTER VARYING(2) 2
104 VDATE CHARACTER VARYING(10) 10
105 VERDATE CHARACTER VARYING(10) 10
106 VOPER CHARACTER VARYING(4) 4
107 PORTFOLIO_DATE CHARACTER VARYING(10) 10
108 DEALCCYFARNPVAMT NUMERIC(19,4) 19
109 DEALCCYNEARNPVAMT NUMERIC(19,4) 19
110 DEALCTRFARNPVAMT NUMERIC(19,4) 19
111 DEALCTRNEARNPVAMT NUMERIC(19,4) 19
112 DELTA_TYPE CHARACTER VARYING(1) 1
113 EFFECTIVE_STRT_DT TIMESTAMP 8
114 EFFECTIVE_END_DT TIMESTAMP 8
115 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
116 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
117 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
118 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8