OBP24_FLX_ST_COMP_PREF_ITEM_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACC_ID CHARACTER VARYING(40) 40
2 COMP_PREF_ID CHARACTER VARYING(32) 32
3 INIT_DATE TIMESTAMP 8
4 PRIORITY DOUBLE PRECISION 8
5 SPLIT_VALUE DOUBLE PRECISION 8
6 STL_CCY CHARACTER VARYING(100) 100
7 COMP_PREF_ITEM_ID CHARACTER VARYING(32) 32
8 NEW_TDA_MAT_DATE TIMESTAMP 8
9 NEW_TDA_PRODUCT CHARACTER VARYING(40) 40
10 NEW_TDA_PARTY_ID CHARACTER VARYING(40) 40
11 TDA_MAT_DATE TIMESTAMP 8
12 TDA_ACCT_NO CHARACTER VARYING(40) 40
13 DDA_ACCT_NO CHARACTER VARYING(40) 40
14 DDA_CHEQUE_NO CHARACTER VARYING(16) 16
15 DDA_CHEQUE_DATE TIMESTAMP 8
16 CVV SMALLINT 2
17 CC_EXP_DATE CHARACTER VARYING(7) 7
18 CC_CARD_TYPE CHARACTER VARYING(6) 6
19 MC_ZIP CHARACTER VARYING(10) 10
20 MC_COUNTRY CHARACTER VARYING(100) 100
21 MC_STATE CHARACTER VARYING(105) 105
22 MC_CITY CHARACTER VARYING(50) 50
23 MC_LINE4 CHARACTER VARYING(105) 105
24 MC_LINE3 CHARACTER VARYING(105) 105
25 MC_LINE2 CHARACTER VARYING(105) 105
26 MC_LINE1 CHARACTER VARYING(105) 105
27 MC_CHARGE_BEARER CHARACTER VARYING(5) 5
28 MC_PAYABLE_CITY CHARACTER VARYING(105) 105
29 MC_PAYABLE_TO CHARACTER VARYING(100) 100
30 CLG_PAYEE_ACC_TYPE CHARACTER VARYING(5) 5
31 CLG_PAYEE_ACC CHARACTER VARYING(40) 40
32 CLG_DRAWEE_ACC CHARACTER VARYING(40) 40
33 CLG_INSTR_TYPE CHARACTER VARYING(5) 5
34 CLG_SORT_CODE CHARACTER VARYING(12) 12
35 CLG_INST_DATE TIMESTAMP 8
36 CLG_INST_NO CHARACTER VARYING(12) 12
37 CLG_EXTERNAL_REF_NO CHARACTER VARYING(40) 40
38 CLN_AGREEMENT_NO CHARACTER VARYING(32) 32
39 CLN_REMIT_ZIP CHARACTER VARYING(10) 10
40 CLN_REMIT_COUNTRY CHARACTER VARYING(105) 105
41 CLN_REMIT_STATE CHARACTER VARYING(105) 105
42 CLN_REMIT_CITY CHARACTER VARYING(105) 105
43 CLN_REMIT_LINE4 CHARACTER VARYING(105) 105
44 CLN_REMIT_LINE3 CHARACTER VARYING(105) 105
45 CLN_REMIT_LINE2 CHARACTER VARYING(105) 105
46 CLN_REMIT_LINE1 CHARACTER VARYING(105) 105
47 CLN_RECEIVER CHARACTER VARYING(32) 32
48 CLN_NETWORK_ID CHARACTER VARYING(32) 32
49 CLN_INCLD_COV CHARACTER(1) 1
50 CLN_CHRG_BEAR_TYPE CHARACTER VARYING(5) 5
51 CLN_COUNTRY CHARACTER VARYING(105) 105
52 CLN_REMITR_INFO CHARACTER VARYING(255) 255
53 CLN_REG_REPORT CHARACTER VARYING(50) 50
54 CLN_SEND_REC_INFO CHARACTER VARYING(255) 255
55 CLN_MSG_PRIORITY CHARACTER VARYING(50) 50
56 CLN_REMIT_INFO CHARACTER VARYING(255) 255
57 CLN_ENV_CONT CHARACTER VARYING(255) 255
58 CLN_REMIT_MSG CHARACTER(1) 1
59 CLN_INST_CODE CHARACTER VARYING(32) 32
60 CLN_BANK_OPER_CODE CHARACTER VARYING(32) 32
61 CLN_DEBT_BANK CHARACTER VARYING(50) 50
62 CLN_SENDING_INST CHARACTER VARYING(50) 50
63 CLN_CREDITOR CHARACTER VARYING(50) 50
64 CLN_INST_PARTY CHARACTER VARYING(50) 50
65 CLN_ULT_BENEF CHARACTER VARYING(50) 50
66 CLN_ACC_INST CHARACTER VARYING(50) 50
67 CLN_INTERMEDIARY CHARACTER VARYING(50) 50
68 CLN_INT_REIMB_INST CHARACTER VARYING(50) 50
69 CLN_REC_CORRSP CHARACTER VARYING(50) 50
70 CLN_OUR_CORRSP CHARACTER VARYING(50) 50
71 CLN_TXN_CATEGORY CHARACTER VARYING(32) 32
72 CLN_CONT_PARTY_ACT_NO CHARACTER VARYING(40) 40
73 CLN_BANK_CODE DOUBLE PRECISION 8
74 CLN_PAYEE_ACC_TYPE CHARACTER VARYING(5) 5
75 CLN_PAYEE_ACC CHARACTER VARYING(32) 32
76 CLN_EXTERNAL_REF_NO CHARACTER VARYING(40) 40
77 CLN_TRACE_ACC_NO CHARACTER VARYING(40) 40
78 PYMT_AGREEMENT_NO CHARACTER VARYING(32) 32
79 PYMT_REMIT_ZIP CHARACTER VARYING(10) 10
80 PYMT_REMIT_COUNTRY CHARACTER VARYING(105) 105
81 PYMT_REMIT_STATE CHARACTER VARYING(105) 105
82 PYMT_REMIT_CITY CHARACTER VARYING(105) 105
83 PYMT_REMIT_LINE4 CHARACTER VARYING(105) 105
84 PYMT_REMIT_LINE3 CHARACTER VARYING(105) 105
85 PYMT_REMIT_LINE2 CHARACTER VARYING(105) 105
86 PYMT_REMIT_LINE1 CHARACTER VARYING(105) 105
87 PYMT_RECEIVER CHARACTER VARYING(32) 32
88 PYMT_NETWORK_ID CHARACTER VARYING(32) 32
89 PYMT_INCLD_COV CHARACTER(1) 1
90 CHR_BEAR_TYPE CHARACTER VARYING(5) 5
91 PYMT_COUNTRY CHARACTER VARYING(105) 105
92 PYMT_REMITR_INFO CHARACTER VARYING(255) 255
93 PYMT_REG_REPORT CHARACTER VARYING(50) 50
94 PYMT_SEND_REC_INFO CHARACTER VARYING(255) 255
95 PYMT_MSG_PRIORITY CHARACTER VARYING(50) 50
96 PYMT_REMIT_INFO CHARACTER VARYING(255) 255
97 PYMT_ENV_CONT CHARACTER VARYING(255) 255
98 PYMT_REMIT_MSG CHARACTER(1) 1
99 PYMT_INST_CODE CHARACTER VARYING(32) 32
100 PYMT_BANK_OPER_CODE CHARACTER VARYING(32) 32
101 PYMT_DEBT_BANK CHARACTER VARYING(50) 50
102 PYMT_SENDING_INST CHARACTER VARYING(50) 50
103 PYMT_CREDITOR CHARACTER VARYING(50) 50
104 PYMT_INST_PARTY CHARACTER VARYING(50) 50
105 PYMT_ULT_BENEF CHARACTER VARYING(50) 50
106 PYMT_ACC_INST CHARACTER VARYING(50) 50
107 PYMT_INTERMEDIARY CHARACTER VARYING(50) 50
108 PYMT_INT_REIMB_INST CHARACTER VARYING(50) 50
109 PYMT_REC_CORRSP CHARACTER VARYING(50) 50
110 PYMT_OUR_CORRSP CHARACTER VARYING(50) 50
111 PYMT_TXN_CATEGORY CHARACTER VARYING(32) 32
112 PYMT_CONT_PARTY_ACT_NO CHARACTER VARYING(40) 40
113 PYMT_BANK_CODE DOUBLE PRECISION 8
114 PYMT_TRACE_ACC_NO CHARACTER VARYING(40) 40
115 PYMT_EXTERNAL_REF_NO CHARACTER VARYING(40) 40
116 PAYMENTS_REMARKS CHARACTER VARYING(255) 255
117 STL_TYPE CHARACTER VARYING(5) 5
118 LEDGER_BRANCH_CODE CHARACTER VARYING(10) 10
119 LEDGER_CODE CHARACTER VARYING(20) 20
120 TDA_INTERST_RATE_MARGIN DOUBLE PRECISION 8
121 TDA_USER_DISCREIOSNARY_MARGIN DOUBLE PRECISION 8
122 TDA_MARGIN DOUBLE PRECISION 8
123 TDA_NET_RATE DOUBLE PRECISION 8
124 TDA_MAT_AMT DOUBLE PRECISION 8
125 TDA_MAT_CCY_CODE CHARACTER VARYING(20) 20
126 TDA_DEPOSIT_NAME CHARACTER VARYING(40) 40
127 TDA_MAT_DATE_FACT CHARACTER VARYING(20) 20
128 NEW_TDA_INTERST_RATE_MARGIN DOUBLE PRECISION 8
129 NEW_TDA_USER_DISC_MARGIN DOUBLE PRECISION 8
130 NEW_TDA_MARGIN DOUBLE PRECISION 8
131 NEW_TDA_NET_RATE DOUBLE PRECISION 8
132 NEW_TDA_MAT_AMT DOUBLE PRECISION 8
133 NEW_TDA_MAT_CCY_CODE CHARACTER VARYING(20) 20
134 NEW_TDA_DEPOSIT_NAME CHARACTER VARYING(40) 40
135 NEW_TDA_MAT_DATE_FACT CHARACTER VARYING(20) 20
136 LOAN_ACOUNT_ACC_NUMBER CHARACTER VARYING(50) 50
137 LOAN_ACCOUNT_CUST_NAME CHARACTER VARYING(50) 50
138 NTDA_DAYS DOUBLE PRECISION 8
139 NTDA_MONTHS DOUBLE PRECISION 8
140 NTDA_YEARS DOUBLE PRECISION 8
141 TDA_DAYS DOUBLE PRECISION 8
142 TDA_MONTHS DOUBLE PRECISION 8
143 TDA_YEARS DOUBLE PRECISION 8
144 EXCHGE_RATE_PICUP CHARACTER VARYING(32) 32
145 BASE_RATE CHARACTER VARYING(32) 32
146 PROD_SPREAD CHARACTER VARYING(32) 32
147 CUS_SPREAD CHARACTER VARYING(32) 32
148 RATE_TYPE CHARACTER VARYING(32) 32
149 RATE_SERIAL CHARACTER VARYING(32) 32
150 RATE_REFRESH CHARACTER VARYING(32) 32
151 TXN_EXCHG_RATE CHARACTER VARYING(32) 32
152 FRWD_RATE CHARACTER VARYING(32) 32
153 PAYMENTS_INSTITUTION_ID CHARACTER VARYING(32) 32
154 PAYMENTS_INSTITUTION_TYPE CHARACTER VARYING(16) 16
155 CLG_INSTITUTION_ID CHARACTER VARYING(32) 32
156 CLG_INSTITUTION_TYPE CHARACTER VARYING(16) 16
157 CLN_MANDATE_ID CHARACTER VARYING(32) 32
158 TDA_INTREST_PAYOUT_FREQUENCY CHARACTER VARYING(12) 12
159 NEW_TDA_INTREST_FREQUENCY CHARACTER VARYING(12) 12
160 CLN_INSTITUTION_TYPE CHARACTER VARYING(16) 16
161 CLN_INSTITUTION_ID CHARACTER VARYING(32) 32
162 PAYMENTS_PHONE_NUMBER CHARACTER VARYING(32) 32
163 PAYMENTS_EMAIL_ID CHARACTER VARYING(32) 32
164 CLN_PHONE_NUMBER CHARACTER VARYING(32) 32
165 CLN_EMAIL_ID CHARACTER VARYING(32) 32
166 CLG_PAYEE_NAME CHARACTER VARYING(32) 32
167 TDA_PRICING_DIALOGUE_TICKET CHARACTER VARYING(32) 32
168 NTDA_PRICING_DIALOGUE_TICKET CHARACTER VARYING(32) 32
169 PAYEE_NAME CHARACTER VARYING(120) 120
170 MC_ISSUE_INSTITUTION_ID CHARACTER VARYING(32) 32
171 MC_ISSUE_INSTITUTION_TYPE CHARACTER VARYING(16) 16
172 MC_ISSUE_BENEFICIARY_NAME CHARACTER VARYING(255) 255
173 MC_ISSUE_INSTRUMENT_TYPE CHARACTER VARYING(8) 8
174 MC_ISSUE_INST_DATE TIMESTAMP 8
175 MC_ISSUE_LINE1 CHARACTER VARYING(105) 105
176 MC_ISSUE_LINE2 CHARACTER VARYING(105) 105
177 MC_ISSUE_LINE3 CHARACTER VARYING(105) 105
178 MC_ISSUE_LINE4 CHARACTER VARYING(105) 105
179 MC_ISSUE_CITY CHARACTER VARYING(50) 50
180 MC_ISSUE_STATE CHARACTER VARYING(105) 105
181 MC_ISSUE_COUNTRY CHARACTER VARYING(105) 105
182 MC_ISSUE_ZIP CHARACTER VARYING(105) 105
183 MC_ISSUE_DISPATCH_LINE1 CHARACTER VARYING(105) 105
184 MC_ISSUE_DISPATCH_LINE2 CHARACTER VARYING(105) 105
185 MC_ISSUE_DISPATCH_LINE3 CHARACTER VARYING(105) 105
186 MC_ISSUE_DISPATCH_LINE4 CHARACTER VARYING(105) 105
187 MC_ISSUE_DISPATCH_CITY CHARACTER VARYING(50) 50
188 MC_ISSUE_DISPATCH_STATE CHARACTER VARYING(105) 105
189 MC_ISSUE_DISPATCH_COUNTRY CHARACTER VARYING(105) 105
190 MC_ISSUE_DISPATCH_ZIP CHARACTER VARYING(105) 105
191 MC_ISSUE_DISPATCH_TYPE CHARACTER VARYING(8) 8
192 MC_LIQUIDATE_SERIAL_NO CHARACTER VARYING(32) 32
193 MC_LIQUIDATE_INSTRUMENT_NO CHARACTER VARYING(32) 32
194 MC_LIQUIDATE_INSTITUTION_ID CHARACTER VARYING(32) 32
195 MC_LIQUIDATE_INSTITUTION_TYPE CHARACTER VARYING(16) 16
196 MC_LIQUIDATE_INSTRUMENT_TYPE CHARACTER VARYING(8) 8
197 NEW_TDA_OFFER_ID CHARACTER VARYING(30) 30
198 PARTY_ID CHARACTER VARYING(40) 40
199 IS_RATE_REFRESH CHARACTER(1) 1
200 EXCHANGE_RATE_TYPE CHARACTER VARYING(40) 40
201 FORWARD_RATE CHARACTER VARYING(256) 256
202 VARIANCE DOUBLE PRECISION 8
203 MC_ISSUE_DISPATCH_DETAILS_NAME CHARACTER VARYING(255) 255
204 PRICE_DEFINATION_ID CHARACTER VARYING(50) 50
205 NAME CHARACTER VARYING(50) 50
206 FEE_CHARGE_TYPE CHARACTER VARYING(32) 32
207 PRICING_DIALOGUE_TICKET CHARACTER VARYING(50) 50
208 CHARGE_DATE TIMESTAMP 8
209 REFERENCE_NUMBER CHARACTER VARYING(50) 50
210 EARMARK_PARAMETER_TYPE CHARACTER VARYING(32) 32
211 EXCHGE_RATE_PICUP_DATE TIMESTAMP 8
212 COUNTER_PARTY_GENERATED_FLAG CHARACTER(1) 1
213 NOMINATED_PARTY_ID CHARACTER VARYING(40) 40
214 RELATED_PARTIES CHARACTER VARYING(4000) 4000
215 IS_LOCKED CHARACTER VARYING(1) 1
216 MASKED_CARD_NO CHARACTER VARYING(19) 19
217 AAN_NO CHARACTER VARYING(50) 50
218 CC_CARD_NAME CHARACTER VARYING(100) 100
219 MC_ISSUE_BRANCHCODE CHARACTER VARYING(32) 32
220 MC_LIQUIDATE_BRANCHCODE CHARACTER VARYING(32) 32
221 RECON_REF_NO CHARACTER VARYING(250) 250
222 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
223 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
224 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
225 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8