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 |