Package Center Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table linking packages to centers with center-specific pricing, tax configuration, renewal settings, and active status.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PackageCenterWid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| PackageCenterId | VARCHAR(36) | Yes | Source system unique identifier for the package-center association |
| PackageId | VARCHAR(36) | Yes | Unique identifier of the package |
| CenterId | VARCHAR(36) | Yes | Unique identifier of the center |
| PackageVersionId | VARCHAR(36) | Yes | Unique identifier of the specific package version |
| Price | NUMERIC(19,4) | Yes | Center-specific price for the package |
| CenterTaxId | VARCHAR(36) | Yes | Identifier of the tax configuration applied at this center |
| AutoRenewalPrice | FLOAT | Yes | Price applied on automatic renewal |
| RenewalDiscount | VARCHAR(150) | Yes | Discount value or description applied on renewal |
| Active | BOOLEAN | Yes | Indicates if the package is active at this center |
| CalculateServiceLevelTax | BOOLEAN | Yes | Indicates if tax is calculated at the service level |
| EnableItemLevelTax | INT | Yes | Flag to enable item-level tax calculation |
| Void | BOOLEAN | Yes | Soft-delete flag |
| tpcImportId | BIGINT | Yes | Import identifier from third-party commerce integration |
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
PackageCenterWid
Foreign Keys
| Column | References |
|---|---|
| PackageId | the package dimension |
| CenterId | the center dimension |
| PackageVersionId | the specific package version |
| CenterTaxId | the tax configuration |
Enumerator Values
| Column | Values |
|---|---|
| EnableItemLevelTax | 0 = Disabled 1 = Enabled |
Was this article helpful?
Your feedback helps us improve our documentation.