dunning

Module: collection

Payment reminder notices with dunning levels and status.

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