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. |