Table inventory_cogs_owed

Table inventory_cogs_owed is used to hold sku's that sold but are not in inventory to calculate the cost of good sold. Only inventory items that have their costs tracked are placed in this table. When inventory is received in, this table is reviewed to see if any of the received items require a cogs calculation. IF so, the any entries taht use this sku are re-queued for re-post so the cogs can be calculated.

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) 0 Refers to the id in table journal_main for a transaction
sku varchar (15) NOT NULL The sku that was not in stock for a sales transaction
qty float 0 Qty of the sku owed calculation of cost of goods sold
post_date date 0000-00-00 The post date of the transaction. This value is used for sorting when determining the cost method (FIFO, LIFO, average) to sequence properly