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.