Table inventory_assy_list

Table inventory_assy_list hold the list of items used to assmeble an inventory item of type item assembly.

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) NOT NULL Refers to the the id value in the inventory table of the item being assembled.
sku varchar (15) NOT NULL Holds the sku of the inventory item that is part of the assembly refered to be ref_id
description varchar (32) NOT NULL Holds the description of the sku. This may vary from the short name description pulled in be default in the bom tab in the maintain inventory script.
qty float 0 Holds the quantity of the sku used in the assembly. The number need not be an integer.