Table accounts_history

Table accounts_history contains the  historical transactions for customers and vendors. Data from this table is useful for reports showing accout history, totals, and frequency.

Table Type: InnoDB

Field Type Default Description
id auto_increment N/A PRIMARY KEY - unique id assigned to each account entry
ref_id int(11) 0 Referenced the record id of the journal entry, table journal_main.
acct_idint(11)0INDEX - Referenced to the account id in the accounts table, table accounts.
amountreal double0Total amount of the transaction.
journal_idint(11)0Lists the journal ID of the transaction. Refer to the section on the type of journals formore information.
purchase_invoice_idchar(16)NULLList the PhreeBooks transaction reference. Will be the field Invoice Number for sales and purchases, PO Number/SO Number for purchase and sales orders.
so_po_ref_idint(11)NULLFor sales and purchases, this field wil contain the reference SO/PO record number from the journal_main table.
post_datedateNULLLists the date and time of the Post Date of the transaction. Not the actual date and time of when the record was posted but the Post Date field in the orders screen.