Gift card dimension table
bi_dimgiftcard
Field | Description | Field Type | Primary Key |
|---|---|---|---|
authenticatedby | varchar ( 36 ) | ||
centertaxid | varchar ( 36 ) | ||
comissioneligible | boolean | ||
creationdate | timestamp without time zone | ||
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 | timestamp without time zone | ||
freeservicecommissioneligible | boolean | ||
giftcardcode | The unique code of the gift or prepaid card. | varchar ( 1024 ) | |
giftcardid | varchar ( 36 ) | ||
giftcardpurchaseprice | The price at which the gift or prepaid card is sold. | numeric | |
giftcardvaliditydays | The number of days for which the gift or prepaid card is valid. | integer | |
giftcardvalue | The value assigned to the gift or prepaid card at the time of purchase. | numeric | |
giftcardwid | bigint | ||
gifttypecode | varchar ( 256 ) | ||
gifttypedesc | varchar ( 65535 ) | ||
gifttypefrequency | integer | ||
gifttypeid | varchar ( 36 ) | ||
gifttypename | varchar ( 1024 ) | ||
isbonusgiftcard | This flag indicates whether the gift card is a bonus gift card. - True indicates that it is a bonus gift card. - False indicates that it is not a bonus gift card. | boolean | |
isgiftcard | This flag indicates whether the card is a gift card or a prepaid card. - True indicates that the purchase of a gift card. - False indicates the purchase of a prepaid card. | boolean | |
isonetimeuse | This flag indicates if the gift or prepaid card can be used once or multiple times. - True indicates that the gift or prepaid card can be used only once. - False indicates that the gift or prepaid card can be used multiple times. | boolean | |
notes | varchar ( 65535 ) | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
prmotionrulecriteria | The rule based on which the gift card promotion is applicable. They are usually given based on either the price of the gift cards purchased, or the number of gift cards purchased. | varchar ( 2000 ) | |
promotioncode | The unique code assigned to the gift card promotion. | varchar ( 512 ) | |
promotiondescription | The description of the offer for the gift card promotion. | varchar ( 32000 ) | |
promotionname | The name of the gift card promotion. | varchar ( 2048 ) | |
promotionrulebonusvalue | This is the value assigned to the bonus gift card. | numeric | |
promotionrulemaximumvalue | Maximum purchase price of the gift card to be eligible for the free bonus gift card. | numeric | |
promotionruleminimumvalue | Minimum purchase price of the gift card to be eligible for the free bonus gift card. | numeric | |
recipientid | varchar ( 36 ) | ||
recipientname | The name of the recipient for whom the gift or prepaid card is purchased. | varchar ( 1024 ) | |
tax | numeric | ||
templatedescription | Description of the gift card template used to create the corresponding gift card. | varchar ( 8192 ) | |
templatename | Name of the gift card template used to create the corresponding gift card. | varchar ( 1024 ) | |
void | This flag indicates whether the gift or prepaid card is inactive. A gift or prepaid card is considered inactive if it has been removed from the system. - True indicates that the gift or prepaid card is inactive. - False indicates that the gift or prepaid card is active. | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |
ActivationDate | Date on which Giftcard is activated in UTC | TIMESTAMP |