Discount dimension table
bi_dimdiscount
Field | Description | Field Type | Primary Key |
|---|---|---|---|
combinespecials | boolean | ||
deferred_expireson | date | ||
discountcode | Unique code of the discount applied on the corresponding invoice item. | varchar ( 32 ) | |
discountid | varchar ( 36 ) | ||
discountname | Name of the discount applied on the corresponding invoice item. | varchar ( 256 ) | |
discountpercentage | double precision | ||
discounttypeid | integer | ||
discounttypename | varchar ( 128 ) | ||
discountvalue | numeric | ||
discountwid | bigint | ||
endtime | double precision | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
friday | boolean | ||
giftcertificates | boolean | ||
isdeferrable | boolean | ||
maximumamount | numeric | ||
membershipleveldiscounts | boolean | ||
minimumamount | numeric | ||
monday | boolean | ||
organizationid | varchar ( 36 ) | ||
packageleveldiscounts | boolean | ||
podname | varchar ( 20 ) | ||
productleveldiscounts | boolean | ||
saturday | boolean | ||
serviceleveldiscounts | boolean | ||
starttime | double precision | ||
sunday | boolean | ||
thursday | boolean | ||
tuesday | boolean | ||
void | boolean | ||
wednesday | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |
vouchercount | INTEGER | Number of vouchers created on that discount campaign |