items

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Item ID
fork	integer	plain		forks.ID	Fork ID (`null` for base module)
ownergroup	integer	plain		groups.ID	Owner group ID (`null`=PUBLIC)
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
creationdate	bigint	plain			Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
model	integer	plain		items.ID	Model item ID; only for non-MODEL
visibility	smallint	plain			Default: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text	main			Product name
manufacturer	text	main			Default: ''Manufacturer (brand or company name)
itemnum	text	main			Default: ''Item number (SKU)
barcode	text	main			Default: ''Barcode (e.g. GTIN, EAN or UPC code)
type	smallint	plain			Default: 0Item type (`0`=SIMPLE, `1`=SERIALS, `2`=CHARGES, `3`=SERIALSANDCHARGES, `4`=SET, `5`=CONTAINER, `6`=NOSTOCK, `7`=MODEL)
forcestock	smallint	plain			Force stock check on depletion (`0`=STORAGE, `1`=LOCATION)
applicability	smallint	plain			Default: 0Applicability (`0`=ALWAYS, `1`=NEVER, `2`=BILLINGONLY, `3`=PROCUREMENTONLY)
unit	character varying(3)	extended			Default: ''Unit code as defined by (UN/CEFACT Recommendation 20)
sellingprice	double precision	plain			Default: 0Default selling price per unit
purchaseprice	double precision	plain			Default: 0Default purchase price per unit
taxrate	double precision	plain			Tax rate in percent
weight	double precision	plain			Default: 0Shipping weight per unit in kilogram
classcode	text	main			Default: ''Product classification code (e.g. GPC, CPV or UNSPSC code)
tariffcode	text	main			Default: ''Tariff code (e.g. HS, CN or HTS code)
origin	character varying(2)	extended			Default: ''Origin country code (ISO 3166-1 alpha-2)
description	text	extended			Default: ''Detailed general description
foreigntaxrates	json	extended			Country-specific tax rates in percent; use country code as object key
picbinfile	integer	plain		binfiles.ID	Binary file ID; is read-only (not for `PUT` or `PATCH`)
subitems	json	extended			JSON-encoded items (array)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_items_fork					gin	fork
fk_items_model					btree	model
fk_items_ownergroup					gin	ownergroup
fk_items_picbinfile					btree	picbinfile
i_items_barcode					btree	barcode
i_items_itemnum					btree	itemnum
i_items_name					btree	name
i_items_nofork					gin	fork
i_items_noowner					gin	ownergroup
pk_items					btree	ID
s_items_barcode					gin	barcode
s_items_itemnum					gin	itemnum
s_items_manufacturer					gin	manufacturer
s_items_name					gin	name

Name	Type
c_items_type	check
dc_items_applicability	check
dc_items_barcode	check
dc_items_classcode	check
dc_items_description	check
dc_items_forcestock	check
dc_items_foreigntaxrates	check
dc_items_itemnum	check
dc_items_manufacturer	check
dc_items_name	check
dc_items_origin	check
dc_items_subitems	check
dc_items_tariffcode	check
dc_items_taxrate	check
dc_items_type	check
dc_items_visibility	check
dc_items_weight	check
fk_items_creator	foreign_key
fk_items_fork	foreign_key
fk_items_model	foreign_key
fk_items_ownergroup	foreign_key
fk_items_picbinfile	foreign_key
pk_items	primary_key

Name	Type	Events	Function	Definition
td_items_serials	before	delete	ftd_items_serials
ti_items_model	before	insert	ftiu_items_model
tu_items_model	before	update	ftiu_items_model
tu_items_type	before	update	ft_integrity

Loading...