tm.fielddefinition

1 min

A field definition represents a specific information element of an order, contact, event or ticket. For example a contact firstname or an order creation time.

Fields

FIELD	TYPE	DESCRIPTION
id	int	Unique ID
typeid	int	Type ID
key	string	Key for the field definition. Should only consist of lowercase alphanumeric characters
description	mlstring	Human-readable name for the field definition
sqlclause	string	The actual definition of the field definition. Contains the sql clause that will retrieve the information element in the database.
width	int	Width of the field definition, when used in a view
align	string	Alignment of the field definition, when used in a view. Values can be 'left', 'right' or 'center'
uitype	string	Will decide how the field will be rendered when used in a view.
variablewidth	bool	Indicates whether the width for the field definition can be adapted when stretching a view that includes the field definition across the whole available width.
createdts	timestamp	Created timestamp
lastupdatets	timestamp	Last updated timestamp
isarchived	bool	Whether or not this item is archived