OPC_HST_ACCT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_ACCT

SDSNZP02_BANK..NROD_OPC_HST_ACCT

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