Service center dimension table
bi_dimservicecenter
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centerid | varchar ( 36 ) | ||
centertaxid | varchar ( 36 ) | ||
demandgroupid | varchar ( 36 ) | ||
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 | |
includestax | boolean | ||
memberserviceprice | double precision | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
servicecenterid | varchar ( 36 ) | ||
servicecenterwid | bigint | ||
serviceid | varchar ( 36 ) | ||
serviceprice | double precision | ||
showincatalog | boolean | ||
ssgvalue | double precision | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |
taxgroupid | VARCHAR(36) | Indicates the tax group that is associated with the service at the center. Join with bi_dimtaxgroupdetails on “taxgroupid” column for more details. | |
taxgroupname | NVARCHAR(1020) | Indicates the tax group name that is associated with the service at the center. Join with bi_dimtaxgroupdetails on “taxgroupname” column for more details. |