tm.fielddefinition

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