Table inventory_history

Table inventory_history holds the historical record of inventory as items as they are received and sold. Only items that are considered cost-trackable are stoed in this table. These include, stock-items, item assemblies, Serialized items, Master stock items. This table is the primary source of costing when calculating the cost of goods sold for tracking gross profit the the income statement.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
ref_id int(11) 0 This links the received item to the journal record where the item was received.
sku varchar(15) NULL The inventory item SKU
serialize_number varchar(24) NULL If the item is a serialized item, the serial number is stored here. NOTE: For serialized items, only one item may be received/sold per line on the order form.
remaining float 0 The number of units of the item remaining. This value will initially start out as the number received and will be reduced as items are sold.The value should never be less than zero.
unit_cost float 0 The cost the the item when it was purchased. This value is used when calculating the cost of good sold.
post_date datetime NULL The date the inventory item was received