pitm_ID

Stock items ID

pitm_pgrp_ID

Stock item group

Stock item group. Link to tp_ProductGroups (Stock item groups)

pitm_picl_ID

tp_ProductItemClasses

pitm_ptyp_ID

Type

Type. Link to tp_ProductTypes (Stock item types)

pitm_pcat_ID

Category

Category. Link to tp_ProductCategories (Stock item categories)

pitm_meit_ID

Unit of measurement

Unit of measurement for stock item quantity. Link to tp_MeasureItems (Stock item units of measurement)

pitm_meit_ID_InputDocuments

Additional unit of measurement for stock-in records

pitm_meit_ID_OutputDocuments

Additional unit of measurement for stock-out records

pitm_meit_ID_MoveDocuments

Additional unit of measurement for stock movement records

pitm_meit_ID_WriteOffDocuments

Additional unit of measurement for stock adjustment records

pitm_meit_ID_StoreInventories

Additional unit of measurement for stocktaking records

pitm_meit_ID_CompoundDocuments

Additional unit of measurement for production records

pitm_meit_ID_DecomposeDocuments

Additional unit of measurement for butchering records

pitm_meit_ID_StoreExperiments

Additional unit of measurement for development records

pitm_meit_ID_ExternalMoveDocuments

Additional unit of measurement for records of stock movement between two different companies

pitm_meit_ID_StoreRegister

Additional unit of measurement for stock on hand

pitm_psrv_ID

Stock item concurrence

Stock item concurrence. Link to tp_ProductServices (Stock item concurrences)

pitm_part_ID_Alco

pitm_patp_ID

tp_ProductAlcoTypes

pitm_del_ID

Indicates whether an object is deleted. If the value is not NULL, the object is deleted and is located in the Recycle bin. Link to tp_Deleted (Recycle bin)

pitm_Name

Name

Name

pitm_Article

SKU

SKU

pitm_Description

Description

Description

pitm_VAT

VAT %

VAT,%

pitm_Protein

Protein

Protein

pitm_ProteinVolume

Quantity (for proteins)

Quantity (for proteins)

pitm_Fat

Fats

Fats

pitm_FatVolume

Quantity (for fats)

Quantity (for fats)

pitm_Carbohydrate

Carbohydrates

Carbohydrates

pitm_CarbohydrateVolume

Quantity (for carbohydrates)

Quantity (for carbohydrates)

pitm_Calory

Calories

Calories

pitm_CaloryVolume

Quantity (for calorie value)

Quantity (for calorie value)

pitm_PhotoFileName

Photograph file name

Photo file name

pitm_Photo

Photograph

pitm_ValidityPeriod

Shelf life

Shelf life

pitm_IsFake

Deduct

If 0 is specified, the stock item will not be deducted from store. This is useful, for example, when specifying water in recipes.