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

FieldDescription
id
int
Unique ID
typeid
int
Type ID
key
string
Key for the field definition. Should only consist of lowercase alphanumeric characters
description<langcode>
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