Org custom fields dimension table
bi_dimorgcustomfields
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | boolean | ||
allowguesttoedit | boolean | ||
allowguesttoview | boolean | ||
customfieldtype | integer | ||
datatype | varchar ( 65535 ) | ||
defaultvalue | varchar ( 65535 ) | ||
entitydefinitionfk | numeric | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
fieldattributes | varchar ( 65535 ) | ||
fieldcode | varchar ( 512 ) | ||
fielddesc | varchar ( 65535 ) | ||
fieldid | varchar ( 36 ) | ||
fieldname | varchar ( 65535 ) | ||
fieldorder | integer | ||
fieldtypeid | varchar ( 36 ) | ||
fieldtypename | varchar ( 65535 ) | ||
fieldwid | bigint | ||
formatfunc | varchar ( 65535 ) | ||
groupid | numeric | ||
isrequired | boolean | ||
listdesc | varchar ( 65535 ) | ||
listid | varchar ( 36 ) | ||
listname | varchar ( 65535 ) | ||
listvalue | varchar ( 65535 ) | ||
matchregex | varchar ( 65535 ) | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
printonreceipt | boolean | ||
referenceentitydeffk | numeric | ||
showingrid | boolean | ||
spanacrosscolumns | boolean | ||
updatedon | timestamp without time zone | ||
validationmsglabel | varchar ( 65535 ) | ||
void | boolean | ||
etlgroupid | Internal to Zenoti. Used for data processing. | BIGINT |