pricelists

Module: pricelists

Price lists with date validity and account assignments.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Price list ID
fork forks.ID	integer			Fork ID (`null` for base module)
ownergroup groups.ID	integer			Owner group ID (`null`=PUBLIC)
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
activity	smallint		0	Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text			Name
type	smallint		0	Price list type (`0`=BILLING_MIN, `1`=BILLING_MAX, `2`=PROCUREMENT_MIN, `3`=PROCUREMENT_MAX, `4`=PRODUCTION_MIN, `5`=PRODUCTION_MAX)
currency	character varying(3)			Currency code (ISO 4217)
discount	double precision		0	Default relative discount in percent
datefrom	bigint			Start date as a Unix timestamp; must be less than or equal to `dateto`
dateto	bigint			End date as a Unix timestamp; must be greater than or equal to `datefrom`
applytoall	smallint		0	Apply to all accounts regardless of association via `pricelists2accounts`
description	text		''	Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_pricelists_fork					gin	fork
fk_pricelists_ownergroup					gin	ownergroup
i_pricelists_nofork					gin	fork
i_pricelists_noowner					gin	ownergroup
pk_pricelists					btree	ID
s_pricelists_name					gin	name

Name	Type
c_pricelists_date	check
dc_pricelists_activity	check
dc_pricelists_currency	check
dc_pricelists_description	check
dc_pricelists_discount	check
dc_pricelists_name	check
dc_pricelists_type	check
fk_pricelists_fork	foreign_key
fk_pricelists_ownergroup	foreign_key
pk_pricelists	primary_key

Loading...