bi_dimservice
Field | Description | Field Type | Primary Key |
|---|---|---|---|
businessunitdescription | varchar ( 65535 ) | ||
businessunitid | varchar ( 36 ) | ||
businessunitname | The business unit to which the service belongs. | varchar ( 800 ) | |
catalognew | integer | ||
catalogrecommended | integer | ||
categorycode | varchar ( 128 ) | ||
categoryid | varchar ( 36 ) | ||
categoryname | The category of the service. This is set up as Sub-category in core. | varchar ( 1024 ) | |
code | varchar ( 128 ) | ||
comissioneligible | boolean | ||
commissionfactor | double precision | ||
commissiontype | integer | ||
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 | |
flatcommissionvalue | double precision | ||
frequency | double precision | ||
hasvariant | This flag indicates whether the service has a variant. - True indicates that the service does have a variant. - False indicated that the service does not have a variant. - Not applicable. | integer | |
isaddon | A flag indicating whether the service is an add-on. - True indicates that the service is an add-on - False indicates that the service is not an add-on | boolean | |
isvariant | This flag indicates whether the service is a variant. - True: indicates that the service is a variant. - False: indicates that the service is not a variant. - Not Applicable | integer | |
organizationid | varchar ( 36 ) | ||
parentcategorycode | varchar ( 128 ) | ||
parentcategoryid | varchar ( 36 ) | ||
parentcategoryname | The parent category of the service. This is setup as category in core. | varchar ( 1024 ) | |
podname | varchar ( 20 ) | ||
recoverytime | integer | ||
resourcecode | varchar ( 128 ) | ||
servicecatalogprice | varchar ( 128 ) | ||
servicedesc | varchar ( 4096 ) | ||
servicedisplayname | varchar ( 512 ) | ||
serviceid | varchar ( 36 ) | ||
serviceinternalcost | The internal cost that a center incurs for a service. | numeric | |
servicelength | The ideal time taken to complete a service (in minutes), as set up in Zenoti. | integer | |
servicename | The name of the service. | varchar ( 1024 ) | |
servicenotes | varchar ( 65535 ) | ||
servicewid | bigint | ||
showincatalog | integer | ||
showprice | boolean | ||
tags | The tags associated with the service. | varchar ( 65535 ) | |
void | A flag indicating whether the service is inactive. A service is considered inactive if it has been removed from the system. - True indicates that the service is inactive - False indicates that the service is active | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |