Table inventory

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.
Primary Key: YES
Indexed: YES
Unique: YES

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
MS - Master Stock Item
NS - Non-stock item
DO - Description Only
SV - Service
LB - Labor
AS - Assembly
AI - Activity Item
CI - Charge Item
SR - Serialized

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: