Service Center Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table linking services to centers with center-specific pricing, tax configuration, demand group assignment, and catalog visibility.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| servicecenterwid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| servicecenterid | VARCHAR(36) | Yes | Source system unique identifier for the service-center association |
| serviceid | VARCHAR(36) | Yes | Unique identifier of the service |
| centerid | VARCHAR(36) | Yes | Unique identifier of the center |
| serviceprice | DOUBLE PRECISION | Yes | Standard price of the service at this center |
| includestax | BOOLEAN | Yes | Indicates if the service price includes tax |
| centertaxid | VARCHAR(36) | Yes | Identifier of the tax configuration applied at this center |
| void | BOOLEAN | Yes | Soft-delete flag |
| ssgvalue | DOUBLE PRECISION | Yes | Service-specific SSG (Service Sales Goal) value |
| demandgroupid | VARCHAR(36) | Yes | Identifier of the demand group the service belongs to |
| memberserviceprice | DOUBLE PRECISION | Yes | Member-specific price for the service |
| showincatalog | BOOLEAN | Yes | Indicates if the service is displayed in the catalog |
| taxgroupid | VARCHAR(36) | Yes | Identifier of the tax group applied to this service-center |
| taxgroupname | NVARCHAR(1020) | Yes | Display name of the tax group |
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
servicecenterwid
Foreign Keys
| Column | References |
|---|---|
| serviceid | the service dimension (Bi_DimService or equivalent) |
| centerid | the center dimension |
| centertaxid | the tax configuration |
| demandgroupid | the demand group dimension |
| taxgroupid | the tax group |
Was this article helpful?
Your feedback helps us improve our documentation.