Table chart_of_accounts

Table chart_of_accounts holds the general ledger cost accounts used for every transaction in PhreeBooks. The table is created and loaded during install and can be altered in the General Ledger -> Chart of Accounts menu.

NOTE: A general ledger account cannot be deleted if there is a journal entry posted against the account.

Table Type: InnoDB

Field Type Default Description
id char (15) NOT NULL PRIMARY KEY - Identifies the chart of account number (or value).
descriptionvarchar (64)NOT NULLProvides a texual description of the account. Set by the user and used for reports.
subaccountenum (0, 1)0Flag to indicate if this account is a subaccount of another account
primary_acct_idchar(15)NULLIf the subaccount is set, this field holds the account that is the master account.
account_typeint (4)0INDEX - Specifies the type of account. See chart of accoutn types for a description of allowed account types.
next_refchar (15)NOT NULLThis field is not used at this time.
account_inactiveenum (0, 1)0Specifies if the account is active or inactive.