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_id | int(11) | 0 | INDEX - Referenced to the account id in the accounts table, table accounts. |
amount | real double | 0 | Total amount of the transaction. |
journal_id | int(11) | 0 | Lists the journal ID of the transaction. Refer to the section on the type of journals formore information. |
purchase_invoice_id | char(16) | NULL | List
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_id | int(11) | NULL | For sales and purchases, this field wil contain the reference SO/PO record number from the journal_main table. |
post_date | date | NULL | Lists
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. |