OPIC_HST_ACCT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 ACCOUNTNO CHARACTER VARYING(15) 15
3 PRODUCT CHARACTER VARYING(6) 6
4 PRODTYPE CHARACTER VARYING(2) 2
5 ACCTTYPE CHARACTER VARYING(8) 8
6 TRAD CHARACTER VARYING(4) 4
7 CNO CHARACTER VARYING(11) 11
8 CCY CHARACTER VARYING(3) 3
9 AL CHARACTER VARYING(1) 1
10 RATECODE CHARACTER VARYING(7) 7
11 SPREAD_8 NUMERIC(18,8) 19
12 ACRFRSTLST CHARACTER VARYING(1) 1
13 PORT CHARACTER VARYING(4) 4
14 COST CHARACTER VARYING(10) 10
15 IOPER CHARACTER VARYING(4) 4
16 VOPER CHARACTER VARYING(4) 4
17 VERIND CHARACTER VARYING(1) 1
18 VERDATE TIMESTAMP 8
19 CLOSEOPER CHARACTER VARYING(4) 4
20 INPUTDATE TIMESTAMP 8
21 INPUTTIME CHARACTER VARYING(8) 8
22 BRPRCINDTE TIMESTAMP 8
23 CLOSEDATE TIMESTAMP 8
24 INTDAYCYCLE CHARACTER VARYING(2) 2
25 INTPAYCYCLE CHARACTER VARYING(1) 1
26 INTPAYRULE CHARACTER VARYING(1) 1
27 NEXTENDDATE TIMESTAMP 8
28 STMTDAY CHARACTER VARYING(2) 2
29 STMTDAYRULE CHARACTER VARYING(1) 1
30 STMTCYCLE CHARACTER VARYING(1) 1
31 NEXTSTMTDATE TIMESTAMP 8
32 LASTSTMTDATE TIMESTAMP 8
33 LASTSTMTACCR NUMERIC(19,4) 19
34 DLYINCEXP NUMERIC(19,4) 19
35 MTDINCEXP NUMERIC(19,4) 19
36 YTDINCEXP NUMERIC(19,4) 19
37 ACCROUTST NUMERIC(19,4) 19
38 INTPAIDYTD NUMERIC(19,4) 19
39 ACCRNXTMNTH NUMERIC(19,4) 19
40 OPENDATE TIMESTAMP 8
41 PMTDINCEXP NUMERIC(19,4) 19
42 PYTDINCEXP NUMERIC(19,4) 19
43 INTCAP CHARACTER VARYING(1) 1
44 MINBALANCE NUMERIC(19,4) 19
45 REVREASON CHARACTER VARYING(2) 2
46 REVTEXT CHARACTER VARYING(70) 70
47 REVDATE TIMESTAMP 8
48 MATDATE TIMESTAMP 8
49 LIENAMT NUMERIC(19,4) 19
50 LIENOFFCR CHARACTER VARYING(4) 4
51 LIENDATE TIMESTAMP 8
52 NOTICEDAYS CHARACTER VARYING(4) 4
53 LSTMNTDTE TIMESTAMP 8
54 TENOR CHARACTER VARYING(2) 2
55 PRODUCECONF CHARACTER VARYING(1) 1
56 ACCTTITLE CHARACTER VARYING(70) 70
57 COMPOUND CHARACTER VARYING(1) 1
58 INTRATE_8 NUMERIC(18,8) 19
59 BASIS CHARACTER VARYING(6) 6
60 NXTRATEREVDATE TIMESTAMP 8
61 RATEREVDAY CHARACTER VARYING(2) 2
62 RATEREVCYCLE CHARACTER VARYING(1) 1
63 RATEREVDAYRULE CHARACTER VARYING(1) 1
64 TIERBALTYPE CHARACTER VARYING(1) 1
65 BLOCKDATE TIMESTAMP 8
66 BLOCKTYPE CHARACTER VARYING(1) 1
67 BLOCKOPER CHARACTER VARYING(4) 4
68 BLOCKTEXT CHARACTER VARYING(70) 70
69 BLOCKREVDATE TIMESTAMP 8
70 BLOCKREVOPER CHARACTER VARYING(4) 4
71 BLOCKREVTEXT CHARACTER VARYING(70) 70
72 OVRREGCCIND CHARACTER VARYING(1) 1
73 OVRFEESIND CHARACTER VARYING(1) 1
74 ODRECACCT CHARACTER VARYING(15) 15
75 ODPAYACCT CHARACTER VARYING(15) 15
76 ODLIMIT NUMERIC(19,4) 19
77 ODEXPDATE TIMESTAMP 8
78 ODMINBAL NUMERIC(19,4) 19
79 ODAUTOTRANIND CHARACTER VARYING(1) 1
80 CLEARBAL NUMERIC(19,4) 19
81 UNCLEARBAL NUMERIC(19,4) 19
82 LASTSTMTNO CHARACTER VARYING(5) 5
83 ORIGMOVENO CHARACTER VARYING(8) 8
84 FIDTAXTYPE CHARACTER VARYING(1) 1
85 SWEEPACCTNO CHARACTER VARYING(15) 15
86 INTTEXT3 CHARACTER VARYING(35) 35
87 INTTEXT4 CHARACTER VARYING(35) 35
88 INTTEXT5 CHARACTER VARYING(35) 35
89 INTTEXT6 CHARACTER VARYING(35) 35
90 BROK CHARACTER VARYING(11) 11
91 YSTINCEXP NUMERIC(19,4) 19
92 PREVENDDATE TIMESTAMP 8
93 MATPAYIND CHARACTER VARYING(1) 1
94 INTTOBEPAID NUMERIC(19,4) 19
95 PRINTOBEPAID NUMERIC(19,4) 19
96 BASKETIND CHARACTER VARYING(1) 1
97 BASKETID CHARACTER VARYING(7) 7
98 BASKETINDATE TIMESTAMP 8
99 BASKETOUTDATE TIMESTAMP 8
100 CURBALANCE NUMERIC(19,4) 19
101 LASTPAYDATE TIMESTAMP 8
102 PAYDATE TIMESTAMP 8
103 PRIORINTACCR NUMERIC(19,4) 19
104 PRIORFEE1ACCR NUMERIC(19,4) 19
105 PRIORFEE2ACCR NUMERIC(19,4) 19
106 DEALSRCE CHARACTER VARYING(10) 10
107 AGENTIND CHARACTER VARYING(1) 1
108 UPDATECOUNTER BIGINT 8
109 AGENT2 CHARACTER VARYING(11) 11
110 AMT1 NUMERIC(19,4) 19
111 AMT2 NUMERIC(19,4) 19
112 RATE1_8 NUMERIC(18,8) 19
113 RATE2_8 NUMERIC(18,8) 19
114 DATE1 TIMESTAMP 8
115 DATE2 TIMESTAMP 8
116 MT940BIC CHARACTER VARYING(11) 11
117 MT940IND CHARACTER VARYING(1) 1
118 BVIND CHARACTER VARYING(1) 1
119 SWEEPTOACCTNO CHARACTER VARYING(15) 15
120 ODLIABACCTNO CHARACTER VARYING(15) 15
121 ALLOWMT941 CHARACTER VARYING(1) 1
122 ALLOWMT942 CHARACTER VARYING(1) 1
123 FLOORLIMITCR NUMERIC(19,4) 19
124 FLOORLIMITDR NUMERIC(19,4) 19
125 BVLIMITDATE TIMESTAMP 8
126 SWEEPTYPE CHARACTER VARYING(1) 1
127 DDAACCTIND CHARACTER VARYING(1) 1
128 FLOORLIMIT900910 NUMERIC(19,4) 19
129 CLSIND CHARACTER VARYING(1) 1
130 ODLIMITIND CHARACTER VARYING(1) 1
131 ODSUPPRESSTRF CHARACTER VARYING(1) 1
132 SUPPRESSMOVE CHARACTER VARYING(1) 1
133 FUNDCOST CHARACTER VARYING(10) 10
134 ALLOWNEGINT CHARACTER VARYING(1) 1
135 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
136 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
137 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
138 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
139 LIENENDDATE TIMESTAMP 8