OPIC_ACCT_FATCA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER(2) 2
2 ACCOUNTNO CHARACTER(15) 15
3 PRODUCT CHARACTER(6) 6
4 PRODTYPE CHARACTER(2) 2
5 ACCTTYPE CHARACTER(8) 8
6 TRAD CHARACTER(4) 4
7 CNO CHARACTER(11) 11
8 CCY CHARACTER(3) 3
9 AL CHARACTER(1) 1
10 RATECODE CHARACTER(7) 7
11 SPREAD_8 NUMERIC(18,8) 19
12 ACRFRSTLST CHARACTER(1) 1
13 PORT CHARACTER(4) 4
14 COST CHARACTER(10) 10
15 IOPER CHARACTER(4) 4
16 VOPER CHARACTER(4) 4
17 VERIND CHARACTER(1) 1
18 VERDATE TIMESTAMP 8
19 CLOSEOPER CHARACTER(4) 4
20 INPUTDATE TIMESTAMP 8
21 INPUTTIME CHARACTER(8) 8
22 BRPRCINDTE TIMESTAMP 8
23 CLOSEDATE TIMESTAMP 8
24 INTDAYCYCLE CHARACTER(2) 2
25 INTPAYCYCLE CHARACTER(1) 1
26 INTPAYRULE CHARACTER(1) 1
27 NEXTENDDATE TIMESTAMP 8
28 STMTDAY CHARACTER(2) 2
29 STMTDAYRULE CHARACTER(1) 1
30 STMTCYCLE CHARACTER(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(1) 1
44 MINBALANCE NUMERIC(19,4) 19
45 REVREASON CHARACTER(2) 2
46 REVTEXT CHARACTER(70) 70
47 REVDATE TIMESTAMP 8
48 MATDATE TIMESTAMP 8
49 LIENAMT NUMERIC(19,4) 19
50 LIENOFFCR CHARACTER(4) 4
51 LIENDATE TIMESTAMP 8
52 NOTICEDAYS CHARACTER(4) 4
53 LSTMNTDTE TIMESTAMP 8
54 TENOR CHARACTER(2) 2
55 PRODUCECONF CHARACTER(1) 1
56 ACCTTITLE CHARACTER(70) 70
57 COMPOUND CHARACTER(1) 1
58 INTRATE_8 NUMERIC(18,8) 19
59 BASIS CHARACTER(6) 6
60 NXTRATEREVDATE TIMESTAMP 8
61 RATEREVDAY CHARACTER(2) 2
62 RATEREVCYCLE CHARACTER(1) 1
63 RATEREVDAYRULE CHARACTER(1) 1
64 TIERBALTYPE CHARACTER(1) 1
65 BLOCKDATE TIMESTAMP 8
66 BLOCKTYPE CHARACTER(1) 1
67 BLOCKOPER CHARACTER(4) 4
68 BLOCKTEXT CHARACTER(70) 70
69 BLOCKREVDATE TIMESTAMP 8
70 BLOCKREVOPER CHARACTER(4) 4
71 BLOCKREVTEXT CHARACTER(70) 70
72 OVRREGCCIND CHARACTER(1) 1
73 OVRFEESIND CHARACTER(1) 1
74 ODRECACCT CHARACTER(15) 15
75 ODPAYACCT CHARACTER(15) 15
76 ODLIMIT NUMERIC(19,4) 19
77 ODEXPDATE TIMESTAMP 8
78 ODMINBAL NUMERIC(19,4) 19
79 ODAUTOTRANIND CHARACTER(1) 1
80 CLEARBAL NUMERIC(19,4) 19
81 UNCLEARBAL NUMERIC(19,4) 19
82 LASTSTMTNO CHARACTER(5) 5
83 ORIGMOVENO CHARACTER(8) 8
84 FIDTAXTYPE CHARACTER(1) 1
85 SWEEPACCTNO CHARACTER(15) 15
86 INTTEXT3 CHARACTER(35) 35
87 INTTEXT4 CHARACTER(35) 35
88 INTTEXT5 CHARACTER(35) 35
89 INTTEXT6 CHARACTER(35) 35
90 BROK CHARACTER(11) 11
91 YSTINCEXP NUMERIC(19,4) 19
92 PREVENDDATE TIMESTAMP 8
93 MATPAYIND CHARACTER(1) 1
94 INTTOBEPAID NUMERIC(19,4) 19
95 PRINTOBEPAID NUMERIC(19,4) 19
96 BASKETIND CHARACTER(1) 1
97 BASKETID CHARACTER(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(10) 10
107 AGENTIND CHARACTER(1) 1
108 UPDATECOUNTER NUMERIC(15,0) 19
109 AGENT2 CHARACTER(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(11) 11
117 MT940IND CHARACTER(1) 1
118 BVIND CHARACTER(1) 1
119 SWEEPTOACCTNO CHARACTER(15) 15
120 ODLIABACCTNO CHARACTER(15) 15
121 ALLOWMT941 CHARACTER(1) 1
122 ALLOWMT942 CHARACTER(1) 1
123 FLOORLIMITCR NUMERIC(19,4) 19
124 FLOORLIMITDR NUMERIC(19,4) 19
125 BVLIMITDATE TIMESTAMP 8
126 SWEEPTYPE CHARACTER(1) 1
127 DDAACCTIND CHARACTER(1) 1
128 FLOORLIMIT900910 NUMERIC(19,4) 19
129 CLSIND CHARACTER(1) 1
130 ODLIMITIND CHARACTER(1) 1
131 ODSUPPRESSTRF CHARACTER(1) 1
132 SUPPRESSMOVE CHARACTER(1) 1
133 FUNDCOST CHARACTER(10) 10
134 ALLOWNEGINT CHARACTER(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