ZenotiHelp

Org Custom Fields Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide

Dimension table storing organization-level custom field definitions, including field type, validation rules, display settings, and default/list values. Populated from the organization's custom field configuration.

Columns

Column Name Data Type Nullable Description
fieldwid BIGINT IDENTITY No Surrogate warehouse key for the custom fields dimension
fieldid VARCHAR(36) Yes Natural unique identifier of the custom field
printonreceipt BOOLEAN Yes Flag indicating whether the field value is printed on receipts
fieldtypeid VARCHAR(36) Yes Identifier of the field type definition
listid VARCHAR(36) Yes Identifier of the associated list (for dropdown/list-type fields)
fieldorder INTEGER Yes Display order of the field in the UI
customfieldtype INTEGER Yes Enumerated type code for the custom field
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
active BOOLEAN Yes Flag indicating whether the custom field is currently active
allowguesttoview BOOLEAN Yes Flag indicating whether guests can view this field
allowguesttoedit BOOLEAN Yes Flag indicating whether guests can edit this field
isrequired BOOLEAN Yes Flag indicating whether the field is mandatory
showingrid BOOLEAN Yes Flag indicating whether the field appears in grid/list views
entitydefinitionfk NUMERIC(19,0) Yes Foreign key to the entity definition the field belongs to
referenceentitydeffk NUMERIC(19,0) Yes Foreign key to a referenced entity definition (for lookup fields)
spanacrosscolumns BOOLEAN Yes Flag indicating whether the field spans multiple columns in the layout
updatedon TIMESTAMP Yes Timestamp of the last update in the source system
matchregex VARCHAR(65535) Yes Regular expression pattern used for input validation
validationmsglabel VARCHAR(65535) Yes Validation error message displayed when input does not match
fieldname VARCHAR(65535) Yes Display name of the custom field
fieldtypename VARCHAR(65535) Yes Display name of the field type
listname VARCHAR(65535) Yes Display name of the associated list
datatype VARCHAR(65535) Yes Data type of the field value (e.g., String, Integer, Date)
fieldcode VARCHAR(512) Yes Short code identifying the custom field
formatfunc VARCHAR(65535) Yes Formatting function applied to the field value
listvalue VARCHAR(65535) Yes Comma-separated or structured list of allowed values
defaultvalue VARCHAR(65535) Yes Default value assigned to the field
fielddesc VARCHAR(65535) Yes Detailed description of the custom field
listdesc VARCHAR(65535) Yes Description of the associated list
fieldattributes VARCHAR(65535) Yes JSON or structured attributes for additional field configuration
etlgroupid BIGINT Yes Identifier of the tenant group for multi-tenant isolation

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

fieldwid

Foreign Keys

Column References
fieldtypeid Field type reference
listid List definition reference
entitydefinitionfk Entity definition reference
referenceentitydeffk Entity definition reference (lookup target)

Enumerator Values

Column Values
customfieldtype 1 = Text
2 = Number
3 = Date
4 = Dropdown
5 = Checkbox
6 = Radio
datatype String representation of the field data type
Was this article helpful?
Your feedback helps us improve our documentation.