ZenotiHelp

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.