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.