ZenotiHelp

Product Center Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table linking products to centers with center-specific sale pricing, tax configuration, and inventory threshold settings.

Columns

Column Name Data Type Nullable Description
productcenterwid BIGINT IDENTITY No Surrogate warehouse identifier (auto-generated)
productcenterid VARCHAR(36) Yes Source system unique identifier for the product-center association
productid VARCHAR(36) Yes Unique identifier of the product
centerid VARCHAR(36) Yes Unique identifier of the center
saleprice DOUBLE PRECISION Yes Sale price of the product at this center
includestax BOOLEAN Yes Indicates if the sale price includes tax
centertaxid VARCHAR(36) Yes Identifier of the tax configuration applied at this center
void BOOLEAN Yes Soft-delete flag
DesiredInventory FLOAT Yes Target retail inventory level
OrderInventory FLOAT Yes Retail inventory level that triggers a reorder
AlertInventory FLOAT Yes Retail inventory level that triggers an alert
ConsumableDesiredInventory FLOAT Yes Target consumable inventory level
ConsumableOrderInventory FLOAT Yes Consumable inventory level that triggers a reorder
ConsumableAlertInventory FLOAT Yes Consumable inventory level that triggers an alert
taxgroupid VARCHAR(36) Yes Identifier of the tax group applied to this product-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

productcenterwid

Foreign Keys

Column References
productid the product dimension (Bi_DimProduct or equivalent)
centerid the center dimension
centertaxid the tax configuration
taxgroupid the tax group
Was this article helpful?
Your feedback helps us improve our documentation.