Field |
Type |
Default |
Description |
id |
char (15) |
NOT NULL |
PRIMARY KEY - Identifies the chart of account number
(or value). |
description | varchar (64) | NOT NULL | Provides a texual description of the account. Set by the user and used for reports. |
subaccount | enum (0, 1) | 0 | Flag to indicate if this account is a subaccount of another account |
primary_acct_id | char(15) | NULL | If the subaccount is set, this field holds the account that is the master account. |
account_type | int (4) | 0 | INDEX - Specifies the type of account. See chart of accoutn types for a description of allowed account types. |
next_ref | char (15) | NOT NULL | This field is not used at this time. |
account_inactive | enum (0, 1) | 0 | Specifies if the account is active or inactive. |