OPIC_FEES

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 FEENO CHARACTER VARYING(8) 8
3 FEESEQ CHARACTER VARYING(4) 4
4 FEEPRODUCT CHARACTER VARYING(6) 6
5 FEEPRODTYPE CHARACTER VARYING(2) 2
6 DEALNO CHARACTER VARYING(8) 8
7 SEQ CHARACTER VARYING(4) 4
8 PRODUCT CHARACTER VARYING(6) 6
9 PRODTYPE CHARACTER VARYING(2) 2
10 CCY CHARACTER VARYING(3) 3
11 CCYAMT NUMERIC(19,4) 19
12 COST CHARACTER VARYING(10) 10
13 CNO CHARACTER VARYING(11) 11
14 TENOR CHARACTER VARYING(2) 2
15 AL CHARACTER VARYING(1) 1
16 ACCTGMETHOD CHARACTER VARYING(1) 1
17 STARTDATE TIMESTAMP 8
18 ENDDATE TIMESTAMP 8
19 VDATE TIMESTAMP 8
20 IOPER CHARACTER VARYING(4) 4
21 INPUTDATE TIMESTAMP 8
22 INPUTTIME CHARACTER VARYING(8) 8
23 BRPRCINDTE TIMESTAMP 8
24 VERIND CHARACTER VARYING(1) 1
25 VEROPER CHARACTER VARYING(4) 4
26 VERDATE TIMESTAMP 8
27 SETTMEANS CHARACTER VARYING(7) 7
28 SETTACCT CHARACTER VARYING(15) 15
29 SETTAUTHIND CHARACTER VARYING(1) 1
30 SETTAUTHDTE TIMESTAMP 8
31 SETTOPER CHARACTER VARYING(4) 4
32 FEETEXT CHARACTER VARYING(70) 70
33 REVREASON CHARACTER VARYING(2) 2
34 REVDATE TIMESTAMP 8
35 REVTEXT CHARACTER VARYING(70) 70
36 LSTMNTDATE TIMESTAMP 8
37 SECID CHARACTER VARYING(20) 20
38 FEESIND CHARACTER VARYING(1) 1
39 FEEPER_8 NUMERIC(18,8) 19
40 DEALMDATE TIMESTAMP 8
41 DEALCCYAMT NUMERIC(19,4) 19
42 DEALVDATE TIMESTAMP 8
43 PORT CHARACTER VARYING(4) 4
44 TRAD CHARACTER VARYING(4) 4
45 DEALDATE TIMESTAMP 8
46 FINCENT CHARACTER VARYING(15) 15
47 COVERBYFX CHARACTER VARYING(1) 1
48 SETTCCY CHARACTER VARYING(3) 3
49 SETTEXCHRATE_8 NUMERIC(18,8) 19
50 SETTEXCHTERMS CHARACTER VARYING(1) 1
51 SETTAMTPERIOD NUMERIC(19,4) 19
52 DEALAMTPERIOD NUMERIC(19,4) 19
53 BASEAMTPERIOD NUMERIC(19,4) 19
54 NETDEAL CHARACTER VARYING(1) 1
55 NETFEENO CHARACTER VARYING(7) 7
56 ORIGCNO CHARACTER VARYING(11) 11
57 LSTPAIDDATE TIMESTAMP 8
58 UPDATECOUNTER BIGINT 8
59 AMORTMETHOD CHARACTER VARYING(1) 1
60 FEETYPE CHARACTER VARYING(2) 2
61 BASIS CHARACTER VARYING(6) 6
62 BASECCYAMT NUMERIC(19,4) 19
63 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
64 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
65 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
66 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8