OPIC_FXIH

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