Difference between revisions of "Gnucash mysql tables"

Revision as of 01:37, 26 February 2013

command line mysql query for a job report

The job number must be in the description of the "split" on every transaction. This puts it in the "splits" gnucash table in the "memo" field. command line query, all fields *

mysql -p database_name -e "select * from database_name.splits;"|grep 000003

command line query, specific fields

mysql -p database_name -e "SELECT memo, quantity_num FROM database_name.splits;" | grep 000003

mysql query, specific fields (memo, quantity_num) for value that contains search string text

mysql> SELECT memo, quantity_num FROM database_name.splits WHERE memo LIKE "%string_text%"

entries

appears to hold invoice data
i_price_num appears to be the line item amount with that last 6 decimal digits being cents

splits

This table appears to store all transaction specifics. quantity_num(value_num*quantity_num) contains the price of the split and the 2 LSD (least significant digits) = cents when value denomination = 100 (us dollers?).