The inventory table holds the items available for use PhreeBooks. The definitions are for the base inventory fields as shipped with PhreeBooks. The inventory manager allows additional fields to be added that are not defined within this help file. Refer to the section on Inventory Manager Overview for a detailed explanation of adding additional fields to this table.
Table Type: InnoDB
Field Name |
Type |
Size (value) |
Comment |
id | integer |
11 |
auto-increment field used to uniquely identify each inventory item. |
sku | varchar |
15 |
The unique sku or ID associated with a given inventory item. |
inactive | enum |
0, 1 |
Specifies if the inventory item is anactive item (true) or inactive (false) |
inventory_type | char |
2 |
Specifies the type of inventory item. Each type has different properties. The types are defined as follows: SI - Stock Item |
description_short | varchar |
32 |
Contains a short description of the inventory item for use primarily in the sales (customer) activities. |
description_purchase | varchar |
255 |
Contains the vendor description used promarily in the purchases (vendor) activities. This may include vendor part numbers, descriptions unique to the vendor that is ot to be visible to the customer, etc. |
account_sales_income | varchar |
15 |
Contains the default GL account used for sales (invoicing). This account only applies to the following inventory_type(s): All but Service (SV) |
account_inventory_wage | varchar |
15 |
Contains the default GL account used for inventory/wage valuation. As items are received, the items value is added to this account. Used for inventoray valuation activities. This account only applies to the following inventory_type(s): SI, MS, NS, SV, LB, and AS. |
account_cost_of_sales | varchar |
15 |
Contains the default GL account used for calculation of cost of sales. As items are sold, the items value is added to this account. Used for inventoray valuation activities. This account only applies to the following inventory_type(s): SI, MS, NS, SV, LB, and AS. |
cost_method | char |
1 |
Contais the cost method used for inventory_type(s): SI, MS, and AS. The valid values are (f) - FIFO; first-in first-out, (l) LIFO; last-in last-out, and (a) Average. |
item_taxable | enum |
0,1 |
Contains a boolean value used for tax calculations on whether the item is taxable or not. A value of 0 will not include the inventory item cost in the tax calculation. |
item_cost | float |
Contains the cost of the item from the last purchase. This field is set by Zenbooks and cannot be changed by the user. | |
full_price | float |
Specifies the base unit price before adjustment with the price manager. | |
item_weight | float |
Specifies the item weight in the units specified in the configuration options, lb (pounds) or kg (kilograms) are the current choices. | |
quantity_on_hand | float |
Specifies the current quantity on hand. This value will change for purchase/receive inventory, inventory adjustments and sales/invoices activities. | |
minimum_stock_level | float |
User specified minimum stock level used by the system to flag low stock warnings. | |
reorder_quantity | float |
User specified re-order quantity used to help the purchase order process. | |
serialize | enum |
0,1 |
Specifies if the inventory item is a serialized item. Serialized items can only be received as a single unit per line on POs and SOs as the serial number is assigned to the specific line item in question. |
creation_date | datetime |
Timestamp generated by the system during the initial entry of the item. | |
last_update | datetime |
Timestamp generated by the system the last time a user change was made. | |
last_journal_date | datetime |
Timestamp generated by the system to specify the last time a journal entry ws posted against the inventory item. |
Notes: