ZenotiHelp

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.