m_tax_component

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_loan_charge_tax_details.tax_component_id fk_loan_charge_tax_details_component R
m_savings_account_transaction_tax_details.tax_component_id FK_savings_account_transaction_tax_details_tax_component R
m_tax_component_history.tax_component_id FK_tax_component_history_tax_component_id R
m_tax_group_mappings.tax_component_id FK_tax_group_mappings_tax_component R
name varchar 50 null
percentage numeric 19,6 null
debit_account_type_enum int2 5 √ null
debit_account_id int8 19 √ null
acc_gl_account.id FK_tax_component_debit_gl_account R
credit_account_type_enum int2 5 √ null
credit_account_id int8 19 √ null
acc_gl_account.id FK_tax_component_credit_gl_account R
start_date date 13 null
createdby_id int8 19 null
m_appuser.id FK_tax_component_createdby R
created_date timestamp 29,6 null
lastmodifiedby_id int8 19 null
m_appuser.id FK_tax_component_lastmodifiedby R
lastmodified_date timestamp 29,6 null

Indexes

Constraint Name Type Sort Column(s)
m_tax_component_pkey Primary key Asc id
FK_tax_component_createdby Performance Asc createdby_id
FK_tax_component_credit_gl_account Performance Asc credit_account_id
FK_tax_component_debit_gl_account Performance Asc debit_account_id
FK_tax_component_lastmodifiedby Performance Asc lastmodifiedby_id

Relationships

Close relationships within degrees of separation