m_charge

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
acc_product_mapping.charge_id FK_acc_product_mapping_m_charge R
m_client_charge.charge_id FK_m_client_charge_m_charge R
m_loan_charge.charge_id m_loan_charge_ibfk_1 R
m_loan_tranche_charges.charge_id FK_m_loan_tranche_charges_m_charge R
m_product_loan_charge.charge_id m_product_loan_charge_ibfk_1 R
m_savings_account_charge.charge_id m_savings_account_charge_ibfk_1 R
m_savings_product_charge.charge_id m_savings_product_charge_ibfk_1 R
m_share_account_charge.charge_id m_share_account_charge_ibfk_1 R
m_share_product_charge.charge_id m_share_product_charge_ibfk_1 R
name varchar 100 √ null
currency_code varchar 3 null
charge_applies_to_enum int2 5 null
charge_time_enum int2 5 null
charge_calculation_enum int2 5 null
charge_payment_mode_enum int2 5 √ null
amount numeric 19,6 null
fee_on_day int2 5 √ null
fee_interval int2 5 √ null
fee_on_month int2 5 √ null
is_penalty bool 1 false
is_active bool 1 null
is_deleted bool 1 false
min_cap numeric 19,6 √ NULL::numeric
max_cap numeric 19,6 √ NULL::numeric
fee_frequency int2 5 √ null
is_free_withdrawal bool 1 false
free_withdrawal_charge_frequency int4 10 √ 0
restart_frequency int4 10 √ 0
restart_frequency_enum int4 10 √ 0
is_payment_type bool 1 √ false
payment_type_id int4 10 √ null
m_payment_type.id FK_m_payment_detail_m_payment_types R
income_or_liability_account_id int8 19 √ null
acc_gl_account.id FK_m_charge_acc_gl_account R
tax_group_id int8 19 √ null
m_tax_group.id FK_m_charge_m_tax_group R

Indexes

Constraint Name Type Sort Column(s)
m_charge_pkey Primary key Asc id
FK_m_charge_acc_gl_account Performance Asc income_or_liability_account_id
FK_m_charge_m_tax_group Performance Asc tax_group_id
FK_m_payment_detail_m_payment_types Performance Asc payment_type_id
m_charge_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation