Table inventory_cogs_usage

Table inventory_cogs_usage links the inventory purchase inventory_history table with the journal_main table to account for cogs calculations. The table basically indicates how many of what sku from what purchase went to what order.

Table Type: InnoDB

Field Type Default Description
category_id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
journal_main_id int (11) NOT NULL Refers to the id in table journal_main for a transaction
qty float 0 Qty of the sku used from the history table
inventory_history_id int (11) NOT NULL Refers to the history id of when the item was placed into stock.