OBP24_FLX_DD_ACCOUNTS_B_BAK

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CODE CHARACTER VARYING(40) 40
2 PARTY_CODE CHARACTER VARYING(40) 40
3 BRANCH_CODE CHARACTER VARYING(10) 10
4 PRODUCT_CODE CHARACTER VARYING(30) 30
5 NICK_NAME CHARACTER VARYING(40) 40
6 CCY_CODE CHARACTER VARYING(10) 10
7 RESTRICTED_FLAG CHARACTER(1) 1
8 ACCT_OPENING_DATE TIMESTAMP 8
9 ACCT_CLOSURE_DATE TIMESTAMP 8
10 USER_DEFINED_STATUS_STR CHARACTER VARYING(500) 500
11 SYS_STAT_EFFECTIVE_DATE TIMESTAMP 8
12 SYS_STAT_PROCESS_DATE TIMESTAMP 8
13 SYS_STAT_TYPE CHARACTER VARYING(20) 20
14 SYS_STAT_REASON_CODES CHARACTER VARYING(50) 50
15 CREATED_BY CHARACTER VARYING(254) 254
16 LAST_UPDATED_BY CHARACTER VARYING(254) 254
17 CREATION_DATE TIMESTAMP 8
18 LAST_UPDATE_DATE TIMESTAMP 8
19 OBJECT_VERSION_NUMBER BIGINT 8
20 ENTITY_STATUS CHARACTER VARYING(40) 40
21 EMPLOYEE_ACCT_FLAG CHARACTER(1) 1
22 ACCOUNT_TITLE CHARACTER VARYING(500) 500
23 LANGUAGE_CODE CHARACTER VARYING(40) 40
24 RELATION_OFFICER_CODE CHARACTER VARYING(40) 40
25 MINOR_ACCOUNT_STATUS_TYPE CHARACTER VARYING(40) 40
26 MIN_BAL_REQUIRED_AMT DOUBLE PRECISION 8
27 MIN_BAL_VAL_START_DATE TIMESTAMP 8
28 MIN_BAL_VAL_END_DATE TIMESTAMP 8
29 STATEMENT_DELIVERY_TYPE CHARACTER VARYING(20) 20
30 STMT_FREQUENCY CHARACTER VARYING(20) 20
31 LAST_BAL_REFRESH_DATE TIMESTAMP 8
32 CURR_COUNT_DEBIT_TODAY DOUBLE PRECISION 8
33 CURR_AMT_DEBIT_TODAY DOUBLE PRECISION 8
34 FUTURE_COUNT_DEBIT_TODAY DOUBLE PRECISION 8
35 FUTURE_AMT_DEBIT_TODAY DOUBLE PRECISION 8
36 CURR_ADHOC_AMT_DEBIT_TODAY DOUBLE PRECISION 8
37 FUTURE_ADHOC_AMT_DEBIT_TODAY DOUBLE PRECISION 8
38 CURR_ADHOC_AMT_CREDIT_TODAY DOUBLE PRECISION 8
39 FUTURE_ADHOC_AMT_CREDIT_TODAY DOUBLE PRECISION 8
40 CURR_COUNT_CREDIT_TODAY DOUBLE PRECISION 8
41 CURR_AMT_CREDIT_TODAY DOUBLE PRECISION 8
42 FUTURE_COUNT_CREDIT_TODAY DOUBLE PRECISION 8
43 FUTURE_AMT_CREDIT_TODAY DOUBLE PRECISION 8
44 LAST_REFRESH_DATE TIMESTAMP 8
45 RELATION_SHIP_OFFICER CHARACTER VARYING(40) 40
46 CURR_AS_OF_DATE TIMESTAMP 8
47 PREV_AS_OF_DATE TIMESTAMP 8
48 SYS_STAT_SEC_REASON_CODES CHARACTER VARYING(50) 50
49 CURR_EXPECTED_INACTIVE_DATE TIMESTAMP 8
50 CURR_EXPECTED_DORMANCY_DATE TIMESTAMP 8
51 CURR_EXPECTED_UNCLAIMED_DATE TIMESTAMP 8
52 CURR_AS_OF_COUNTER DOUBLE PRECISION 8
53 PREV_EXPECTED_UNCLAIMED_DATE TIMESTAMP 8
54 PREV_EXPECTED_DORMANCY_DATE TIMESTAMP 8
55 PREV_EXPECTED_INACTIVE_DATE TIMESTAMP 8
56 LAST_CREDIT_DATE TIMESTAMP 8
57 LAST_DEBIT_DATE TIMESTAMP 8
58 PREVIOUS_LAST_CREDIT_DATE TIMESTAMP 8
59 PREVIOUS_LAST_DEBIT_DATE TIMESTAMP 8
60 MIN_BAL_TYPE CHARACTER VARYING(25) 25
61 AVG_FL_BAL_TO_DT_AMT DOUBLE PRECISION 8
62 CLR_BAL_ON_LAST_REF_AMT DOUBLE PRECISION 8
63 UNCLR_BAL_ON_LAST_REF_AMT DOUBLE PRECISION 8
64 EFFECTIVE_BACK_DATE TIMESTAMP 8
65 EFFECTIVE_AVG_BACK_DATE TIMESTAMP 8
66 LAST_STMT_CLOSING_BAL_AMT DOUBLE PRECISION 8
67 LAST_STMT_OPENING_BAL_AMT DOUBLE PRECISION 8
68 LAST_STMT_GENERATED_TILL TIMESTAMP 8
69 NET_BAL_ON_LAST_REF_AMT DOUBLE PRECISION 8
70 PREVIOUS_LAST_CREDIT_AMT DOUBLE PRECISION 8
71 PREVIOUS_LAST_DEBIT_AMT DOUBLE PRECISION 8
72 LAST_CREDIT_AMT DOUBLE PRECISION 8
73 LAST_DEBIT_AMT DOUBLE PRECISION 8
74 BUSINESS_UNIT CHARACTER VARYING(40) 40
75 AS_OF_COUNTER DOUBLE PRECISION 8
76 AUF_LIMIT_AMT DOUBLE PRECISION 8
77 AUF_START_DATE TIMESTAMP 8
78 AUF_END_DATE TIMESTAMP 8
79 AUF_LENDABLE_PERCENTAGE DOUBLE PRECISION 8
80 OD_FACILITY_CODE CHARACTER VARYING(40) 40
81 PREV_OD_FACILITY_CODE CHARACTER VARYING(40) 40
82 OD_UTILIZATION_CODE CHARACTER VARYING(40) 40
83 CURR_BAL_EFFECT_DATE TIMESTAMP 8
84 CURR_CLEAR_AMT DOUBLE PRECISION 8
85 CURR_UNCLEAR_AMT DOUBLE PRECISION 8
86 CURR_UTIL_OD_LIMIT_AMT DOUBLE PRECISION 8
87 CURR_OVERLINE_AMT DOUBLE PRECISION 8
88 CURR_TOD_AMT DOUBLE PRECISION 8
89 CURR_TD_LIEN_AMT DOUBLE PRECISION 8
90 CURR_UTIL_AUF_LIMIT_AMT DOUBLE PRECISION 8
91 CURR_USER_HOLD_AMT DOUBLE PRECISION 8
92 CURR_SYS_HOLD_AMT DOUBLE PRECISION 8
93 FUTURE_BAL_EFFECT_DATE TIMESTAMP 8
94 FUTURE_CLEAR_AMT DOUBLE PRECISION 8
95 FUTURE_UNCLEAR_AMT DOUBLE PRECISION 8
96 FUTURE_UTIL_OD_LIMIT_AMT DOUBLE PRECISION 8
97 FUTURE_OVERLINE_AMT DOUBLE PRECISION 8
98 FUTURE_TOD_AMT DOUBLE PRECISION 8
99 FUTURE_TD_LIEN_AMT DOUBLE PRECISION 8
100 FUTURE_UTIL_AUF_LIMIT_AMT DOUBLE PRECISION 8
101 FUTURE_USER_HOLD_AMT DOUBLE PRECISION 8
102 FUTURE_SYS_HOLD_AMT DOUBLE PRECISION 8
103 OD_START_DATE TIMESTAMP 8
104 PERIODIC_FEE_AMT DOUBLE PRECISION 8
105 IS_CREDIT CHARACTER VARYING(1) 1
106 EARMARK_SEQUENCE DOUBLE PRECISION 8
107 MEMO_START_DATE TIMESTAMP 8
108 MEMO_END_DATE TIMESTAMP 8
109 ALT_ACCT_ID_CREDIT CHARACTER VARYING(40) 40
110 ALT_ACCT_TYPE_CREDIT CHARACTER VARYING(20) 20
111 ALT_ACCT_ID_DEBIT CHARACTER VARYING(40) 40
112 ALT_ACCT_ID_CHARGES CHARACTER VARYING(40) 40
113 LAST_REPRICE_DATE TIMESTAMP 8
114 INT_CAPITALISATION_FREQ CHARACTER VARYING(40) 40
115 INT_DAY_COUNT_CONVENTION CHARACTER VARYING(40) 40
116 FIRST_INACTIVE_REMINDER_DATE TIMESTAMP 8
117 FIRST_DORMANCY_REMINDER_DATE TIMESTAMP 8
118 FIRST_UNCLAIMED_REMINDER_DATE TIMESTAMP 8
119 SECOND_INACTIVE_REMINDER_DATE TIMESTAMP 8
120 SECOND_DORMANCY_REMINDER_DATE TIMESTAMP 8
121 SECOND_UNCLAIMED_REMINDER_DATE TIMESTAMP 8
122 SWEEP_IN_INSTRUCTION_NUM_CODE DOUBLE PRECISION 8
123 EOD_BALANCE_EFFECTIVE_DATE TIMESTAMP 8
124 LAST_EOD_BALANCE_AMT DOUBLE PRECISION 8
125 BOD_BALANCE_EFFECTIVE_DATE TIMESTAMP 8
126 LAST_BOD_BALANCE_AMT DOUBLE PRECISION 8
127 BENEFICIARY_ACCOUNT_ID CHARACTER VARYING(32) 32
128 HAS_OFFSET_ACCOUNT CHARACTER(1) 1
129 MARKET_ENTITY CHARACTER VARYING(40) 40
130 FUTURE_PREVIOUS_STATUS CHARACTER VARYING(50) 50
131 PREVIOUS_STATUS CHARACTER VARYING(50) 50
132 FUTURE_AS_OF_COUNTER DOUBLE PRECISION 8
133 FUTURE_AS_OF_DATE TIMESTAMP 8
134 STMT_CYCLE_DAY DOUBLE PRECISION 8
135 PREVENT_EXCESS_FLAG CHARACTER(1) 1
136 TEMP_EXCESS_START_DATE TIMESTAMP 8
137 TEMP_EXCESS_EXPIRY_DATE TIMESTAMP 8
138 TEMP_EXCESS_SANCTIONED_AMT DOUBLE PRECISION 8
139 TEMP_EXCESS_UTILIZED_AMT DOUBLE PRECISION 8
140 AUF_FACILITY_CODE CHARACTER VARYING(40) 40
141 BENEFICIARY_ACCOUNT_TYPE CHARACTER VARYING(50) 50
142 CURR_TEMPORARY_EXCESS_AMT DOUBLE PRECISION 8
143 FUTURE_TEMPORARY_EXCESS_AMT DOUBLE PRECISION 8
144 TE_FACILITY_CODE CHARACTER VARYING(40) 40
145 BRANCH_TRANSFER_DATE TIMESTAMP 8
146 FIXED_AMOUNT_PERIOD_FLAG CHARACTER(1) 1
147 ACCRUAL_STATUS CHARACTER VARYING(20) 20
148 OFFER_ID CHARACTER VARYING(40) 40
149 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
150 LAST_CUST_DEBIT_DATE TIMESTAMP 8
151 LAST_CUST_DEBIT_AMT DOUBLE PRECISION 8
152 LAST_CUST_CREDIT_DATE TIMESTAMP 8
153 LAST_CUST_CREDIT_AMT DOUBLE PRECISION 8
154 CRR_CODE CHARACTER VARYING(30) 30
155 FIXED_OD_END_DATE TIMESTAMP 8
156 WEAK_ACCOUNT_FLAG CHARACTER(1) 1
157 BUNDLE_ID CHARACTER VARYING(40) 40
158 BORROWING_ENTITY_ID CHARACTER VARYING(40) 40
159 CAMPAIGN_CODE CHARACTER VARYING(40) 40
160 CUMULATIVE_EXCESS_PAYMENT DOUBLE PRECISION 8
161 APPROPRIATION_SEQ CHARACTER VARYING(20) 20
162 NPA_LONG_OVERDUE_FLAG CHARACTER VARYING(1) 1
163 NPA_APPROPRIATION_SEQ CHARACTER VARYING(20) 20
164 LONG_OVERDUE_FIRST_FLAG CHARACTER VARYING(1) 1
165 REORDER_CHEQUEBOOK_FLAG CHARACTER(1) 1
166 BUNDLE_BEN_APP_FLG CHARACTER(1) 1
167 ACCOUNT_DELINQUENT_FLAG CHARACTER(1) 1
168 OD_EXPIRY_DATE TIMESTAMP 8
169 FIXED_RATE_PERIOD_END_DATE TIMESTAMP 8
170 RECOVERY_FLAG CHARACTER(1) 1
171 CURR_PERIOD_MIN_BAL DOUBLE PRECISION 8
172 CURR_PERIOD_MIN_BAL_EFF_DATE TIMESTAMP 8
173 CURRENT_ARR_INT_TODAY DOUBLE PRECISION 8
174 CURRENT_SUSP_ARR_INT_TODAY DOUBLE PRECISION 8
175 FUTURE_ARR_INT_TODAY DOUBLE PRECISION 8
176 FUTURE_SUSP_ARR_INT_TODAY DOUBLE PRECISION 8
177 CURRENT_ARR_FEES_TODAY DOUBLE PRECISION 8
178 CURRENT_SUSP_ARR_FEES_TODAY DOUBLE PRECISION 8
179 FUTURE_ARR_FEES_TODAY DOUBLE PRECISION 8
180 FUTURE_SUSP_ARR_FEES_TODAY DOUBLE PRECISION 8
181 CURRENT_ARR_PRINC_TODAY DOUBLE PRECISION 8
182 CURRENT_SUSP_ARR_PRINC_TODAY DOUBLE PRECISION 8
183 FUTURE_ARR_PRINC_TODAY DOUBLE PRECISION 8
184 FUTURE_SUSP_ARR_PRINC_TODAY DOUBLE PRECISION 8
185 PRODUCT_GROUP_CODE CHARACTER VARYING(20) 20
186 FLAG_CHECKING CHARACTER(1) 1
187 ODFACILITY_LINKED_COUNT DOUBLE PRECISION 8
188 INTEREST_CALCULATION_NATURE CHARACTER VARYING(20) 20
189 NO_OF_CONTRIBUTION_INST DOUBLE PRECISION 8
190 BUNDLE_START_DATE TIMESTAMP 8
191 BUNDLE_END_DATE TIMESTAMP 8
192 STMT_DOCUMENT_ID CHARACTER VARYING(40) 40
193 CURRENT_TOD_UTIL_DATE TIMESTAMP 8
194 CURRENT_CLEAR_UTIL_DATE TIMESTAMP 8
195 CURRENT_TE_UTIL_DATE TIMESTAMP 8
196 CURRENT_AUF_UTIL_DATE TIMESTAMP 8
197 CURRENT_OD_UTIL_DATE TIMESTAMP 8
198 CURRENT_OVERLINE_UTIL_DATE TIMESTAMP 8
199 PREV_TOD_UTIL_DATE TIMESTAMP 8
200 PREV_CLEAR_UTIL_DATE TIMESTAMP 8
201 PREV_TE_UTIL_DATE TIMESTAMP 8
202 PREV_AUF_UTIL_DATE TIMESTAMP 8
203 PREV_OD_UTIL_DATE TIMESTAMP 8
204 PREV_OVERLINE_UTIL_DATE TIMESTAMP 8
205 PURPOSE_CODE CHARACTER VARYING(20) 20
206 PURPOSE_TYPE CHARACTER VARYING(20) 20
207 WAIVE_FEES_HARDSHIP_RELIEF CHARACTER(1) 1
208 STAGE_VALUE CHARACTER VARYING(20) 20
209 FUND_ACQUISITION_SEQ CHARACTER VARYING(20) 20
210 OD_LIMIT_AMT DOUBLE PRECISION 8
211 EXCESS_UTILISATION_FLAG CHARACTER(1) 1
212 CURR_AUF_LIMIT_AMT DOUBLE PRECISION 8
213 FUTURE_AUF_LIMIT_AMT DOUBLE PRECISION 8
214 CURR_OD_LIMIT_AMT DOUBLE PRECISION 8
215 FUTURE_OD_LIMIT_AMT DOUBLE PRECISION 8
216 CURR_TE_LIMIT_AMT DOUBLE PRECISION 8
217 FUTURE_TE_LIMIT_AMT DOUBLE PRECISION 8
218 BORROWING_ENTITY_START_DT TIMESTAMP 8
219 TOTAL_OFFSET_CLEAR_AMT DOUBLE PRECISION 8
220 TOTAL_OFFSET_UNCLEAR_AMT DOUBLE PRECISION 8
221 CURR_CLR_BAL_TODAY_AMT DOUBLE PRECISION 8
222 CURR_UNCLR_BAL_TODAY_AMT DOUBLE PRECISION 8
223 FUTURE_CLR_BAL_TODAY_AMT DOUBLE PRECISION 8
224 FUTURE_UNCLR_BAL_TODAY_AMT DOUBLE PRECISION 8
225 BANK_CODE CHARACTER VARYING(10) 10
226 IS_FACILITY_SHARED CHARACTER VARYING(5) 5
227 ACCT_BANK_FACILITY CHARACTER VARYING(300) 300
228 IS_ALTERNATE CHARACTER VARYING(5) 5
229 ACCT_OPENING_PROCESS_DATE TIMESTAMP 8
230 EMP_PARTNER_ACCOUNT_FLAG CHARACTER(1) 1
231 REGULATED_ACCOUNT_FLAG CHARACTER(1) 1
232 PESUDO_INT_ENTRY_FLAG CHARACTER(1) 1
233 PESUDO_FEE_ENTRY_FLAG CHARACTER(1) 1
234 MAX_HARDSHIP_EXP_DATE TIMESTAMP 8
235 SWEEPIN_FLAG CHARACTER(1) 1
236 SWEEPOUT_FLAG CHARACTER(1) 1
237 STANDING_FLAG CHARACTER(1) 1
238 CHEQUE_BOOK_FLAG CHARACTER(1) 1
239 TOD_FLAG CHARACTER(1) 1
240 OVERLINE_FLAG CHARACTER(1) 1
241 INWARD_DIRECT_DEBIT_FLAG CHARACTER(1) 1
242 LOCAL_CHQ_REORDER_PCT DOUBLE PRECISION 8
243 MULTICITY_CHQ_REORDER_PCT DOUBLE PRECISION 8
244 LOCAL_CHQ_MAX_LEAVES DOUBLE PRECISION 8
245 MULTICITY_CHQ_MAX_LEAVES DOUBLE PRECISION 8
246 ATM_FLAG CHARACTER(1) 1
247 POS_FLAG CHARACTER(1) 1
248 TELE_BANKING_FLAG CHARACTER(1) 1
249 INTERNET_BANKING_FLAG CHARACTER(1) 1
250 MOBILE_BANKING_FLAG CHARACTER(1) 1
251 DEBIT_CARD_FLAG CHARACTER(1) 1
252 APPLICATION_ID CHARACTER VARYING(40) 40
253 STATEMENT_FLAG CHARACTER(1) 1
254 ATM_CARD_FLAG CHARACTER(1) 1
255 BROKER_FLAG CHARACTER(1) 1
256 CREDIT_INT_RATE DOUBLE PRECISION 8
257 OD_INT_RATE DOUBLE PRECISION 8
258 TOD_INT_RATE DOUBLE PRECISION 8
259 AUF_INT_RATE DOUBLE PRECISION 8
260 OL_INT_RATE DOUBLE PRECISION 8
261 SWEEP_OUT_INSTRUCTION_NUM_CODE DOUBLE PRECISION 8
262 STANDING_INSTRUCTION_NUM_CODE DOUBLE PRECISION 8
263 CHEQUE_INSTRUCTION_NUM_CODE DOUBLE PRECISION 8
264 PASSBOOK_HOLDER CHARACTER(1) 1
265 DELINQUENCY_START_DATE TIMESTAMP 8
266 DELINQUENCY_END_DATE TIMESTAMP 8
267 DELINQUENCY_UPDATE_DATE TIMESTAMP 8
268 DELINQUENCY_REASON CHARACTER VARYING(40) 40
269 RECOVERY_REASON CHARACTER VARYING(40) 40
270 RECOVERY_END_DATE TIMESTAMP 8
271 RECOVERY_START_DATE TIMESTAMP 8
272 LAST_CR_INT_CMP_DATE TIMESTAMP 8
273 LAST_DR_INT_CMP_DATE TIMESTAMP 8
274 OFFICE_ACCOUNT CHARACTER(1) 1
275 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
276 NEXT_STMT_GEN_DATE TIMESTAMP 8
277 UTILIZED_OFFSET_CLEAR_AMT DOUBLE PRECISION 8
278 UTILIZED_OFFSET_UNCLEAR_AMT DOUBLE PRECISION 8
279 LAST_ACTIVITY_DATE TIMESTAMP 8
280 STOP_CREDIT_INTEREST CHARACTER(1) 1
281 STOP_CR_INT_VALUE_DATE TIMESTAMP 8
282 STOP_CR_INT_POSTING_DATE TIMESTAMP 8
283 FCF_FLAG CHARACTER(1) 1
284 INTEREST_REPAY_TYPE_FCF CHARACTER VARYING(3) 3
285 DEBIT_ALLOWED_DATE_IOA_FCF TIMESTAMP 8
286 EARMARK_REF_NO_FCF CHARACTER VARYING(40) 40
287 VARIABLE_LIMIT_FCF DOUBLE PRECISION 8
288 IOA_AMT DOUBLE PRECISION 8
289 CUSTOMER_INIT_CLOSURE CHARACTER(1) 1
290 INACTIVITY_BALANCE DOUBLE PRECISION 8
291 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
292 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
293 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
294 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8