accounts

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Account 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)
assigneduser	integer	plain		users.ID	Assigned user ID
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)
contact	integer	plain		contacts.ID	Contact ID
visibility	smallint	plain			Default: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
lastname	text	main			Default: ''Last name (surname or company name); is required if `firstname` is empty
firstname	text	main			Default: ''First name (given name); is required if `lastname` is empty
type	smallint	plain			Default: 0Account type (`0`=PROSPECT, `1`=CUSTOMER, `2`=SUPPLIER, `3`=CUSTOMERANDSUPPLIER, `4`=COMPETITOR, `5`=EMPLOYEE)
customernum	text	main			Default: ''Customer number; only for PROSPECT, CUSTOMERANDSUPPLIER, CUSTOMER or EMPLOYEE
suppliernum	text	main			Default: ''Supplier number; only for SUPPLIER or CUSTOMERANDSUPPLIER
taxid	text	extended			Default: ''Tax ID (e.g. VATIN or SSN)
currency	character varying(3)	extended			Currency code (ISO 4217)
locked	smallint	plain			Default: 0Deny booking of billing or procurement transactions
excludetax	smallint	plain			Default: 0Exclude from taxation
description	text	extended			Default: ''Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_accounts_assigneduser					gin	assigneduser
fk_accounts_contact					btree	contact
fk_accounts_fork					gin	fork
fk_accounts_ownergroup					gin	ownergroup
i_accounts_lastname_firstname					btree	lastname, firstname
i_accounts_nofork					gin	fork
i_accounts_noowner					gin	ownergroup
pk_accounts					btree	ID
s_accounts_customernum					gin	customernum
s_accounts_firstname					gin	firstname
s_accounts_lastname					gin	lastname
s_accounts_suppliernum					gin	suppliernum

Name	Type
c_accounts_name	check
c_accounts_type	check
dc_accounts_currency	check
dc_accounts_customernum	check
dc_accounts_description	check
dc_accounts_firstname	check
dc_accounts_lastname	check
dc_accounts_suppliernum	check
dc_accounts_taxid	check
dc_accounts_type	check
dc_accounts_visibility	check
fk_accounts_assigneduser	foreign_key
fk_accounts_contact	foreign_key
fk_accounts_creator	foreign_key
fk_accounts_fork	foreign_key
fk_accounts_ownergroup	foreign_key
pk_accounts	primary_key

Loading...