Guest coupon dimension table
bi_dimguestcoupon
Field | Description | Field Type | Primary Key |
|---|---|---|---|
baseinvoiceid | varchar ( 36 ) | ||
campaignid | varchar ( 36 ) | ||
cashback | varchar ( 1024 ) | ||
centerid | varchar ( 36 ) | ||
couponnumber | If applicable, this is the coupon number corresponding to the discount. | integer | |
couponruleid | varchar ( 36 ) | ||
couponupdatedby | varchar ( 36 ) | ||
couponupdatedon | timestamp without time zone | ||
discountid | varchar ( 36 ) | ||
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 | |
expirydate | Expiry date of the corresponding campaign, coupon, or voucher. | timestamp without time zone | |
guestcouponid | varchar ( 36 ) | ||
guestcouponwid | bigint | ||
invoiceid | varchar ( 36 ) | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
printdate | timestamp without time zone | ||
redeemedbyall | integer | ||
redemptiondt | timestamp without time zone | ||
redemptionnotes | varchar ( 1024 ) | ||
skiprereq | integer | ||
userid | varchar ( 36 ) | ||
void | integer | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |