OPC_HST_FEES

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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