OBP24_FLX_LN_ACCT_PREFERENCES_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_FLX_LN_ACCT_PREFERENCES_B

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 ACCELERATED_PAYMENT_FLAG CHARACTER(1) 1
3 RESTRICTED_ACCOUNT_FLAG CHARACTER(1) 1
4 REDRAW_FLAG CHARACTER(1) 1
5 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
6 PRINCIPAL_OFFSET_FLAG CHARACTER(1) 1
7 STATEMENT_FLAG CHARACTER(1) 1
8 INTERNET_BANKING_FLAG CHARACTER(1) 1
9 MOBILE_BANKING_FLAG CHARACTER(1) 1
10 BRANCH_FLAG CHARACTER(1) 1
11 PHONE_BANKING_FLAG CHARACTER(1) 1
12 REPAYMENT_GRACE_DAYS BIGINT 8
13 STATEMENT_OPTION CHARACTER VARYING(40) 40
14 STATEMENT_FREQUENCY CHARACTER VARYING(40) 40
15 NEXT_REPAYMENT_REVIEW_DATE TIMESTAMP 8
16 PRIMARY_REASON_FOR_CLOSURE CHARACTER VARYING(200) 200
17 SECONDARY_REASON_FOR_CLOSURE CHARACTER VARYING(200) 200
18 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
19 MOVE_TO_REGULAR_ON_DISB_FLAG CHARACTER(1) 1
20 SCHEDULE_DRAWN_ON CHARACTER VARYING(40) 40
21 CURRENCY_CODE CHARACTER VARYING(3) 3
22 OFFICER_CODE CHARACTER VARYING(40) 40
23 APPROPRIATION_PERFORMING_SEQ CHARACTER VARYING(40) 40
24 APPROPRIATION_NON_PRFRMNG_SEQ CHARACTER VARYING(40) 40
25 APPROPRIATION_CONTROL BIGINT 8
26 APPROPRIATION_CONTROL_NPL BIGINT 8
27 REPAY_REVIEW_LEAD_DAYS BIGINT 8
28 IS_REGULATED_LOAN CHARACTER(1) 1
29 CREATED_BY CHARACTER VARYING(254) 254
30 CREATION_DATE TIMESTAMP 8
31 LAST_UPDATED_BY CHARACTER VARYING(254) 254
32 LAST_UPDATE_DATE TIMESTAMP 8
33 OBJECT_VERSION_NUMBER BIGINT 8
34 OBJECT_STATUS CHARACTER(1) 1
35 EMP_REFERRED_ACCT_FLAG CHARACTER(1) 1
36 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8