| Field | Type | Default | Description |
|---|---|---|---|
| id | auto_increment | N/A | PRIMARY KEY - unique id assigned to each account entry |
| type | char | c | INDEX - Defines the type of entry. Handy to know when building
reports to specify as a hidden criteria to filter out unwanted
accounts. Defined types are: c - Customer v - Vendor e - Employee b - Branch |
| short_name | varchar(20) | NOT NULL | INDEX - This field holds a short reference name (called Customer ID, Vendor ID, etc.) used to help organize the accounts. Acts as a unique identifer in a more user readable fashion than the id field. |
| inactive | enum (0,1) | 0 | Flag to mark and account as inactive. Can be used to prevent orders to a account. |
| contact_first | varchar (32) | NULL | Used for employee type accounts to hold the employee first name. |
| contact_middle | varchar (32) | NULL | Used for employee type accounts to hold the employee middle name or initial |
| contact_last | varchar (32) | NULL | Used for employee type accounts to hold the employee last name |
| store_id | varchar (15) | NOT NULL | |
| gl_type_account | varchar (15) | NOT NULL | Holds the general ledger account to use as the default in the order screen. When set, this account will appear in the line item account position. |
| gov_id_number | varchar (16) | NOT NULL | Holds the employee id number, tax resale number of the account |
| dept_rep_id | varchar (16) | NOT NULL | Holds the department rep id assigned to this account. When entered, the rep name will be inserted into the sales rep entry field of the order screen. |
| account_number | varchar (16) | NOT NULL | Holds an assigned customer or vendor account number. Useful on sales orders and purchase orders to identify your companies account number with your customer or supplier. |
| special_terms | varchar(32) | 0 | PhreeBooks allows individual payment terms by account. A value of 0 indicates that the default terms should be used. The value is encoded and can be changed in the Maintain Customer/Vendor screen. |
| first_date | date | 0000-00-00 | Set the first time the account is created. Useful to know how long the account has been active. |
| last_update | date | NULL | Indicates the last time the account was updated. Useful to know when the last time the account was accessed. |
| last_date_1 | date | NULL | |
| last_date_2 | date | NULL |