OPIC_FFDH

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 BROKNO CHARACTER VARYING(11) 11
5 BRPRCINDTE TIMESTAMP 8
6 COMMAMT NUMERIC(19,4) 19
7 COMMRATE NUMERIC(19,4) 19
8 CONTCODE CHARACTER VARYING(10) 10
9 CONTPRICE_8 NUMERIC(18,8) 19
10 COST CHARACTER VARYING(11) 11
11 DEALDATE TIMESTAMP 8
12 DELVDATE TIMESTAMP 8
13 EXCHANGE CHARACTER VARYING(11) 11
14 INPUTDATE TIMESTAMP 8
15 INPUTTIME CHARACTER VARYING(8) 8
16 IOPER CHARACTER VARYING(4) 4
17 NUMCONT NUMERIC(19,4) 19
18 PORT CHARACTER VARYING(4) 4
19 PS CHARACTER VARYING(1) 1
20 REVDATE TIMESTAMP 8
21 REVOPER CHARACTER VARYING(4) 4
22 REVREASON CHARACTER VARYING(2) 2
23 REVTEXT CHARACTER VARYING(70) 70
24 VERDATE TIMESTAMP 8
25 VERIND CHARACTER VARYING(1) 1
26 VOPER CHARACTER VARYING(4) 4
27 LSTMNTDTE TIMESTAMP 8
28 TRADER CHARACTER VARYING(4) 4
29 PSDEALNO CHARACTER VARYING(8) 8
30 PSOPER CHARACTER VARYING(4) 4
31 PSDATE TIMESTAMP 8
32 SETMEANS CHARACTER VARYING(7) 7
33 SETACCT CHARACTER VARYING(15) 15
34 DELIVERYIND CHARACTER VARYING(1) 1
35 ACCTMETHOD CHARACTER VARYING(1) 1
36 TRDTIME CHARACTER VARYING(8) 8
37 EXECCOMMRATE NUMERIC(19,4) 19
38 EXECCOMMAMT NUMERIC(19,4) 19
39 FEECCY CHARACTER VARYING(3) 3
40 CNO CHARACTER VARYING(10) 10
41 CUSTMARGIN NUMERIC(19,4) 19
42 PURPOSE CHARACTER VARYING(1) 1
43 CUSTRATE NUMERIC(19,4) 19
44 CUSTAMT NUMERIC(19,4) 19
45 CUSTACCTNO CHARACTER VARYING(18) 18
46 CUSTFEECCY CHARACTER VARYING(3) 3
47 PRODUCT CHARACTER VARYING(6) 6
48 PRODTYPE CHARACTER VARYING(2) 2
49 PSMETHOD CHARACTER VARYING(4) 4
50 DEALTEXT CHARACTER VARYING(70) 70
51 UNDDEALNO CHARACTER VARYING(8) 8
52 UNDPRODUCT CHARACTER VARYING(6) 6
53 UNDTYPE CHARACTER VARYING(2) 2
54 UNDSECID CHARACTER VARYING(20) 20
55 UNDACCTNGTYPE CHARACTER VARYING(10) 10
56 UNDTENOR CHARACTER VARYING(2) 2
57 UNDSEQ CHARACTER VARYING(4) 4
58 CREDITCODE CHARACTER VARYING(3) 3
59 ORIGNUMCONT NUMERIC(19,4) 19
60 EFPSPOTPRICE_8 NUMERIC(18,8) 19
61 HDGESPOTPRICE_8 NUMERIC(18,8) 19
62 EFPFWDPOINTS_8 NUMERIC(18,8) 19
63 HDGEFWDPOINTS_8 NUMERIC(18,8) 19
64 SPOTTRAD CHARACTER VARYING(4) 4
65 SPOTPORT CHARACTER VARYING(4) 4
66 SPOTCOST CHARACTER VARYING(11) 11
67 ORIGBROKNO CHARACTER VARYING(10) 10
68 ORIGDEALNO CHARACTER VARYING(8) 8
69 FEEAMT NUMERIC(19,4) 19
70 CCYAMT NUMERIC(19,4) 19
71 EFPIND CHARACTER VARYING(1) 1
72 PSSEQ CHARACTER VARYING(4) 4
73 REVPSDATE TIMESTAMP 8
74 REVTIME CHARACTER VARYING(8) 8
75 REVMETHOD CHARACTER VARYING(1) 1
76 TDYREALPL NUMERIC(19,4) 19
77 YSTREALPL NUMERIC(19,4) 19
78 CASHIND CHARACTER VARYING(1) 1
79 DISPCONTPRICE_8 NUMERIC(18,8) 19
80 ALLOCTIME CHARACTER VARYING(8) 8
81 DELVCODE CHARACTER VARYING(10) 10
82 LINKDEALNO CHARACTER VARYING(15) 15
83 LINKSEQ CHARACTER VARYING(4) 4
84 REVCOMMAMT NUMERIC(19,4) 19
85 REVFEEAMT NUMERIC(19,4) 19
86 REVNUMCONT NUMERIC(19,4) 19
87 AMOUNT1 NUMERIC(19,4) 19
88 AMOUNT2 NUMERIC(19,4) 19
89 AMOUNT3 NUMERIC(19,4) 19
90 CHAR1 CHARACTER VARYING(20) 20
91 CHAR2 CHARACTER VARYING(20) 20
92 CHAR3 CHARACTER VARYING(20) 20
93 DATE1 TIMESTAMP 8
94 DATE2 TIMESTAMP 8
95 FLAG1 CHARACTER VARYING(1) 1
96 RATE1_8 NUMERIC(18,8) 19
97 RATE2_8 NUMERIC(18,8) 19
98 TDYUNREALPL NUMERIC(19,4) 19
99 YSTUNREALPL NUMERIC(19,4) 19
100 PMEUNREALPL NUMERIC(19,4) 19
101 PYEUNREALPL NUMERIC(19,4) 19
102 INTSOURCE CHARACTER VARYING(20) 20
103 UPDATECOUNTER BIGINT 8
104 DEALEXTVAL_8 NUMERIC(18,8) 19
105 ORIGDEALEXTVAL_8 NUMERIC(18,8) 19
106 TENOR CHARACTER VARYING(2) 2
107 IVATAX NUMERIC(19,4) 19
108 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
109 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
110 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
111 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8