Discount Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Dimension table storing discount definitions including value/percentage, day-of-week applicability, time window restrictions, and item-type level eligibility. Populated from the discount/special offer master data.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| discountwid | BIGINT IDENTITY | No | Surrogate warehouse key for the discount dimension, auto-generated |
| discountid | VARCHAR(36) | Yes | Natural unique identifier (GUID) of the discount from the source system |
| discountvalue | NUMERIC(19,4) | Yes | Fixed monetary discount value (used when discount is a flat amount) |
| discountpercentage | DOUBLE PRECISION | Yes | Percentage discount value (used when discount is percentage-based) |
| monday | BOOLEAN | Yes | Whether the discount is applicable on Monday |
| tuesday | BOOLEAN | Yes | Whether the discount is applicable on Tuesday |
| wednesday | BOOLEAN | Yes | Whether the discount is applicable on Wednesday |
| thursday | BOOLEAN | Yes | Whether the discount is applicable on Thursday |
| friday | BOOLEAN | Yes | Whether the discount is applicable on Friday |
| saturday | BOOLEAN | Yes | Whether the discount is applicable on Saturday |
| sunday | BOOLEAN | Yes | Whether the discount is applicable on Sunday |
| starttime | DOUBLE PRECISION | Yes | Start time of the discount applicability window (decimal hours, e.g., 9.5 = 9:30 AM) |
| endtime | DOUBLE PRECISION | Yes | End time of the discount applicability window (decimal hours, e.g., 17.0 = 5:00 PM) |
| combinespecials | BOOLEAN | Yes | Whether this discount can be combined with other specials/offers |
| discounttypeid | INTEGER | Yes | Identifier for the type of discount (enumerated value) |
| giftcertificates | BOOLEAN | Yes | Whether gift certificates can be used with this discount |
| minimumamount | NUMERIC(19,4) | Yes | Minimum transaction amount required for the discount to apply |
| isdeferrable | BOOLEAN | Yes | Whether the discount can be deferred for later use |
| deferred_expireson | DATE | Yes | Expiration date for a deferred discount |
| serviceleveldiscounts | BOOLEAN | Yes | Whether the discount applies at the service level |
| packageleveldiscounts | BOOLEAN | Yes | Whether the discount applies at the package level |
| maximumamount | NUMERIC(19,4) | Yes | Maximum transaction amount for the discount to apply |
| productleveldiscounts | BOOLEAN | Yes | Whether the discount applies at the product level |
| membershipleveldiscounts | BOOLEAN | Yes | Whether the discount applies at the membership level |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE indicates the record is voided/inactive |
| discounttypename | VARCHAR(128) | Yes | Display name of the discount type |
| discountname | VARCHAR(256) | Yes | Name of the discount |
| discountcode | VARCHAR(32) | Yes | Short code identifier for the discount |
| vouchercount | INTEGER | Yes | Number of vouchers associated with this discount |
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
discountwid
Foreign Keys
| Column | References |
|---|---|
| organizationid | Bi_DimCenter |
Enumerator Values
| Column | Values |
|---|---|
| discounttypeid | 1 = Percentage 2 = Flat Amount 3 = Custom |
Was this article helpful?
Your feedback helps us improve our documentation.