acc_accounting_rule

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_rule_tags.acc_rule_id FK_acc_accounting_rule_idR
name VARCHAR 100 √ NULL
office_id BIGINT 19 √ NULL
m_office.id FK_acc_accounting_rule_m_officeR
debit_account_id BIGINT 19 √ NULL
acc_gl_account.id FK_acc_accounting_rule_acc_gl_account_debitR
allow_multiple_debits BIT 1 b'0'
credit_account_id BIGINT 19 √ NULL
acc_gl_account.id FK_acc_accounting_rule_acc_gl_account_creditR
allow_multiple_credits BIT 1 b'0'
description VARCHAR 500 √ NULL
system_defined BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_acc_accounting_rule_acc_gl_account_credit Performance Asc credit_account_id
FK_acc_accounting_rule_acc_gl_account_debit Performance Asc debit_account_id
FK_acc_accounting_rule_m_office Performance Asc office_id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation