ZenotiHelp

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.