MIXERP Database Documentation Database Schemas Tables Sequences Triggers Views MatViews Functions Types
Table core.account_masters
This table contains categories in which General Ledger (G.L) Account belongs to & collectively they form the Chart of Accounts. The category in this table cannot be edited by users. Thus, a user-interface for this table is not available. This table facilitates creating useful reports such as Profit & Loss A/c. and Balance Sheet.
# Column Name Nullable Data Type Max Length Description
1account_master_idsmallint0The primary key of this table, which is also a serial field.
2account_master_codecharacter varying3The unique alphanumeric code that generally abbreviates the value of account master name.
3account_master_namecharacter varying40The name of account master, which is also a unique field.
4normally_debitboolean0Select "Yes" if the account has nature of Debit balance or vice-versa.
5parent_account_master_idsmallint0The name of account master, which is also a unique field.

Foreign Keys

# Column Name Key Name References
5 parent_account_master_id account_masters_parent_account_master_id_fkey core.account_masters.account_master_id

Indices

Index Name Owner Access Method Definition Description
account_masters_pkey postgres btree account_master_id
account_master_parent_account_master_id_inx postgres btree parent_account_master_id
account_master_name_uix postgres btree upper(account_master_name::text)
account_master_code_uix postgres btree upper(account_master_code::text)

Check Constraints

Constraint Name Description

Default Values

# Column Name Default
4 normally_debit false

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description