obp24_hst_flx_or_lndg_prd_grp_xref

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 application_id character varying 150
2 prod_grp_serial_no smallint 16
3 request_amount double precision 53
4 request_amount_currency character varying 9
5 requested_tenor_days double precision 53
6 requested_tenor_months double precision 53
7 requested_tenor_years double precision 53
8 approved_amount double precision 53
9 approved_amount_currency character varying 9
10 approved_tenor_days double precision 53
11 approved_tenor_months double precision 53
12 approved_tenor_years double precision 53
13 is_collateral_required character varying 3
14 is_mof character varying 3
15 is_settlement_required character varying 3
16 purpose_type character varying 120
17 purpose character varying 765
18 facility_category character varying 120
19 is_lrm_applicable character varying 3
20 is_lef_applicable character varying 3
21 is_lmi_applicable character varying 3
22 is_cvrd_by_consmr_protection character varying 3
23 is_general_insurance_opted character varying 3
24 facility_id character varying 120
25 is_fndg_tbl_reqd character varying 3
26 pricing_tkt_no_fndg_tbl character varying 120
27 contri_amount double precision 53
28 contri_amount_ccy character varying 9
29 legal_fee_amount double precision 53
30 legal_fee_ccy character varying 9
31 total_fee_amount double precision 53
32 total_fee_ccy character varying 9
33 purchase_amount double precision 53
34 purchase_ccy character varying 9
35 is_cci_capitalized character varying 3
36 is_fee_capitalized character varying 3
37 is_lmi_capitalized character varying 3
38 is_bundle_fee_capitalized character varying 3
39 cushion_approved_amt double precision 53
40 cushion_approved_amt_ccy character varying 9
41 tot_capitalized_amt double precision 53
42 tot_capitalized_amt_ccy character varying 9
43 cap_orig_fees double precision 53
44 cap_orig_fees_ccy character varying 9
45 cap_lmi_amount double precision 53
46 cap_lmi_amount_ccy character varying 9
47 cap_cci_amount double precision 53
48 cap_cci_amount_ccy character varying 9
49 cap_intr_amount double precision 53
50 cap_intr_amount_ccy character varying 9
51 cap_srvc_fees double precision 53
52 cap_srvc_fees_ccy character varying 9
53 cap_bundle_fees double precision 53
54 cap_bundle_fees_ccy character varying 9
55 lmi_base_amt double precision 53
56 lmi_base_amt_ccy character varying 9
57 borrowing_entity character varying 150
58 uncap_facility_amt double precision 53
59 uncap_facility_amt_ccy character varying 9
60 is_fee_insurance_cap character varying 3
61 cushion_amount double precision 53
62 cushion_amount_ccy character varying 9
63 cap_adv_intr_amount double precision 53
64 cap_adv_intr_amount_ccy character varying 9
65 pre_approved_limit_ref_id character varying 765
66 is_pre_approved character varying 3
67 exp_settlement_date timestamp without time zone
68 collateral_required character varying 60
69 is_settlement_skipped character varying 3
70 fee_level_type character varying 60
71 fee_level_entity_id character varying 60
72 is_flexi_credit_facility character varying 3
73 cci_quote_id character varying 120
74 cdc_source_system_code character varying 12
75 cdc_record_type character varying 48
76 cdc_commit_timestamp timestamp without time zone
77 cdc_extract_timestamp timestamp without time zone