Item
- 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 60 | * |
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) | * |
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 |
1)
Increased from 8 in v3.13