m_tax_component

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_savings_account_transaction_tax_details.tax_component_id FK_savings_account_transaction_tax_details_tax_componentR
m_tax_component_history.tax_component_id FK_tax_component_history_tax_component_idR
m_tax_group_mappings.tax_component_id FK_tax_group_mappings_tax_componentR
name VARCHAR 50 null
percentage DECIMAL 19,6 null
debit_account_type_enum SMALLINT 5 √ NULL
debit_account_id BIGINT 19 √ NULL
acc_gl_account.id FK_tax_component_debit_gl_accountR
credit_account_type_enum SMALLINT 5 √ NULL
credit_account_id BIGINT 19 √ NULL
acc_gl_account.id FK_tax_component_credit_gl_accountR
start_date DATE 10 null
createdby_id BIGINT 19 null
m_appuser.id FK_tax_component_createdbyR
created_date DATETIME 19 null
lastmodifiedby_id BIGINT 19 null
m_appuser.id FK_tax_component_lastmodifiedbyR
lastmodified_date DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY 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