OBP24_FLX_ST_PREF_EXECUT_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBA_OBP_FLX_ST_PREF_EXECUT_B

SDSNZP05_BANK..NROD_OBP_FLX_ST_PREF_EXECUT_B

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