obp24_hst_flx_ln_acct_preferences_b

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_id character varying 120
2 accelerated_payment_flag character varying 3
3 restricted_account_flag character varying 3
4 redraw_flag character varying 3
5 staff_account_flag character varying 3
6 principal_offset_flag character varying 3
7 statement_flag character varying 3
8 internet_banking_flag character varying 3
9 mobile_banking_flag character varying 3
10 branch_flag character varying 3
11 phone_banking_flag character varying 3
12 repayment_grace_days bigint 64
13 statement_option character varying 120
14 statement_frequency character varying 120
15 next_repayment_review_date timestamp without time zone
16 primary_reason_for_closure character varying 600
17 secondary_reason_for_closure character varying 600
18 account_closure_date timestamp without time zone
19 move_to_regular_on_disb_flag character varying 3
20 schedule_drawn_on character varying 120
21 currency_code character varying 9
22 officer_code character varying 120
23 appropriation_performing_seq character varying 120
24 appropriation_non_prfrmng_seq character varying 120
25 appropriation_control bigint 64
26 appropriation_control_npl bigint 64
27 repay_review_lead_days bigint 64
28 is_regulated_loan character varying 3
29 created_by character varying 762
30 creation_date timestamp without time zone
31 last_updated_by character varying 762
32 last_update_date timestamp without time zone
33 object_version_number bigint 64
34 object_status character varying 3
35 emp_referred_acct_flag character varying 3
36 domain_object_extn character varying 300
37 cdc_source_system_code character varying 12
38 cdc_record_type character varying 48
39 cdc_commit_timestamp timestamp without time zone
40 cdc_extract_timestamp timestamp without time zone