Item

Back to list of main tables

The item table stores one record for each item you supply. Stock on hand of an item is not stored here - look in the “item_line” table

Field name	Description	Type	Indexed
ABC_category	Alpha 20
account_income_ID	The ID of the account used when selling this item (not used unless linking to accounting software)	UUID
account_purchases_ID	The ID of the account used when buying this item (not used unless linking to accounting software)	UUID
account_stock_ID	The ID of the account used when holding stock (and asset) for this item (not used unless linking to accounting software)	UUID
atc_category	A WHO Anatomical/Thereapeutic classification	Alpha 30
builds_only	Only issue this item on builds	Boolean
buy_price	The notional buy price of the item in your home currency	Real
catalogue_code	A secondary code for the item- you can optionally include this code when searching for items	Alpha 20	*
category_ID	The ID of the category assigned to this item	UUID	*
category2_ID	UUID
category3_ID	UUID
code	The item code	Alpha 18	*
critical stock	Boolean
cross_ref_item_ID	UUID
ddd factor	Real
ddd_value	The defined daily dose for the item	Alpha 8
default_pack_size	The size used for comparing quotes	Real
(default_price)	Not an item field: Is set per-store, so is a field in item_store_join table	Real
department_ID	The key of the department this item belongs to (internal)	UUID	*
description	Long description of the item	Text
dose_picture	Stores the image for patient medication	Blob
essential_drug_list	True if the item is on your essential drug list	Boolean
expiry_date_mandatory	If true, you will have to enter an expiry date when receiving this item on a goods receipt or supplier invoice	Boolean
flags	Used for quickly marking items for reporting purposes	Alpha 161) Increased from 8 in v3.13	*
hold_for_issue	If true, this item can not be added to customer invoices	Boolean
hold_for_receive	If true, this item can not be received on supplier invoices	Boolean
ID	Internal reference	UUID	*
ignore_for_orders	If true, this item will never be added to an order automatically	Boolean
indic_price	Real
instructions	Text
interaction_group_ID	UUID	*
internal_analysis	Real
is_sync	Boolean
item_name	The name of the item	Alpha 80	*
item_type	“gn” = general, “sv” = service, “cr” = cross reference	Alpha 3
manufacture_method	Text
margin	The default margin for this item	Real
medication_purpose	Text
message	Text that will be displayed in a window when this item is issued or received	Text
non_stock	True means that the item is immediately supplied to a particular customer on receipt.	Boolean
non_stock_name_ID	The ID of the customer (name) the item is to be supplied to	UUID
normal_stock	Boolean
other_names	Used to record alternative names of the same item- can include brand names	Text	*
outer_pack_size	Long
pack_to_one_on_recieve	Boolean
price_editable	Can the price be edited at issue time?	Boolean
print_units_in_dis_labels	Boolean
reference_bom_quantity	The quantity that the entered bill of materials will produce	Long
sms_code	The code that the SMS sender uses to identify the item	Alpha 20
sms_pack_size	When an SMS user orders, this is the pack size they are referring to	Real	*
start_of_year_date	Date
strength	Used if reports need the strength separate to the item name [from version 4.04]	Real
strenghtUnits	If strength is specified, this is the units (e.g. “mg”) [from version 4.04]	Text
unit_ID	The internal key of the units for this item	UUID	*
user_field_1	for customised use by user. Labels for user fields can be set in the preferences	Alpha 30
user_field_2	for customised use by user	Alpha 30
user_field_3	for customised use by user	Alpha 30
user_field_4	for customised use by user	Boolean
user_field_5	for customised use by user	Real
user_field_6	for customised use by user	Alpha 80
user_field_7	for customised use by user	Boolean	*
VEN_category	for customised use by user	Text
volume_per_outer_pack	Real
volume_per_pack	volume in m3 for one reference pack	Real
warning_quantity	attempts to issue greater than this quantity will give the user an alert to stop accidental issuing of large quantities	Long
weight	the weight in kg of one reference pack	Real