dunning

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Dunning notice 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)
account	integer	plain		accounts.ID	Account ID
dunningnum	text	main			Dunning number
type	smallint	plain			Default: 0Dunning type (`0`=LISTING, `1`=REMINDER, `2`=NOTICE)
date	bigint	plain			Default: date_part('epoch', now())Designated date and time as a Unix timestamp (defaults to current date and time on creation)
duedate	bigint	plain			Due date as a Unix timestamp
status	smallint	plain			Default: 0Status (`0`=DRAFT, `1`=BOOKED, `2`=CANCELLED, `3`=CLOSED)
fee	double precision	plain			Default: 0Dunning fee
recipient	text	extended			Default: ''Recipient
address	text	extended			Default: ''Address (street and building/suite number)
postalcode	text	extended			Default: ''Postal or ZIP code
city	text	extended			Default: ''City or locality
region	text	extended			Default: ''Region or state
country	character varying(2)	extended			Default: ''Country code (ISO 3166-1 alpha-2)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_dunning_account					btree	account
fk_dunning_assigneduser					gin	assigneduser
fk_dunning_fork					gin	fork
fk_dunning_ownergroup					gin	ownergroup
i_dunning_date					btree	date
i_dunning_dunningnum					btree	dunningnum
i_dunning_nofork					gin	fork
i_dunning_noowner					gin	ownergroup
pk_dunning					btree	ID
s_dunning_dunningnum					gin	dunningnum
u_dunning_dunningnum_type					btree	dunningnum, type

Name	Type
dc_dunning_address	check
dc_dunning_city	check
dc_dunning_country	check
dc_dunning_dunningnum	check
dc_dunning_fee	check
dc_dunning_postalcode	check
dc_dunning_recipient	check
dc_dunning_region	check
dc_dunning_status	check
dc_dunning_type	check
fk_dunning_account	foreign_key
fk_dunning_assigneduser	foreign_key
fk_dunning_creator	foreign_key
fk_dunning_fork	foreign_key
fk_dunning_ownergroup	foreign_key
pk_dunning	primary_key

Name	Type	Events	Function	Definition
ti_dunning_status	before	insert	ftiu_dunning_status
tu_dunning_status	before	update	ftiu_dunning_status

Loading...