Table product

A saleable product other than tickets or vouchers (eg. merchandizing).

This table represents stock. When a product is sold an entry is created in the table item.

Column NameTypePropertiesDocu
productidseq32Primary-Key
namestring
descriptiontextNULL-able
inventoryint32amount that remains in the inventory, or -1 if it is unlimited
priceint32
barcodestringNULL-able usually the EAN code
flagsstringNULL-able filter: who can sell this product
taxint32NULL-able
tagsstringNULL-able additional tags for this product, can be used by scripts