Gift card dimension table
Table Name | Column Name | Description | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|---|
Bi_DimGiftCard_s3 | GiftCardId | VARCHAR(36) | PK | |||
Bi_DimGiftCard_s3 | GiftCardCode | NVARCHAR(256) | ||||
Bi_DimGiftCard_s3 | GiftCardValue | DECIMAL(19,4) | ||||
Bi_DimGiftCard_s3 | CreationDate | TIMESTAMP | ||||
Bi_DimGiftCard_s3 | GiftCardPurchasePrice | DECIMAL(19,4) | ||||
Bi_DimGiftCard_s3 | GiftCardValidityDays | INT | ||||
Bi_DimGiftCard_s3 | OrganizationId | VARCHAR(36) | ||||
Bi_DimGiftCard_s3 | isonetimeuse | BOOLEAN | ||||
Bi_DimGiftCard_s3 | 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 | |||
Bi_DimGiftCard_s3 | tax | DECIMAL(19,4) | ||||
Bi_DimGiftCard_s3 | centertaxid | VARCHAR(36) | ||||
Bi_DimGiftCard_s3 | ExpiryDate | DATE | ||||
Bi_DimGiftCard_s3 | ComissionEligible | BOOLEAN | ||||
Bi_DimGiftCard_s3 | FreeServiceCommissionEligible | BOOLEAN | ||||
Bi_DimGiftCard_s3 | Notes | NVARCHAR(65535) | ||||
Bi_DimGiftCard_s3 | GiftTypeId | VARCHAR(36) | ||||
Bi_DimGiftCard_s3 | RecipientName | NVARCHAR(1024) | ||||
Bi_DimGiftCard_s3 | RecipientId | VARCHAR(36) | ||||
Bi_DimGiftCard_s3 | AuthenticatedBy | VARCHAR(36) | ||||
Bi_DimGiftCard_s3 | GiftTypeCode | NVARCHAR(256) | ||||
Bi_DimGiftCard_s3 | GiftTypeName | NVARCHAR(1024) | ||||
Bi_DimGiftCard_s3 | GiftTypeDesc | NVARCHAR(4096) | ||||
Bi_DimGiftCard_s3 | GiftTypeFrequency | INT | ||||
Bi_DimGiftCard_s3 | void | BOOLEAN | ||||
Bi_DimGiftCard_s3 | IsBonusGiftcard | BOOLEAN | ||||
Bi_DimGiftCard_s3 | PromotionName | NVARCHAR(2048) | ||||
Bi_DimGiftCard_s3 | PromotionCode | NVARCHAR(512) | ||||
Bi_DimGiftCard_s3 | PromotionDescription | NVARCHAR(65535) | ||||
Bi_DimGiftCard_s3 | PrmotionRuleCriteria | NVARCHAR(2000) | ||||
Bi_DimGiftCard_s3 | PromotionRuleMinimumValue | DECIMAL(19,4) | ||||
Bi_DimGiftCard_s3 | PromotionRuleMaximumValue | DECIMAL(19,4) | ||||
Bi_DimGiftCard_s3 | PromotionRuleBonusValue | DECIMAL(19,4) | ||||
Bi_DimGiftCard_s3 | TemplateName | NVARCHAR(512) | ||||
Bi_DimGiftCard_s3 | TemplateDescription | NVARCHAR(4096) | ||||
Bi_DimGiftCard_s3 | EtlLastUpdatedOn | TIMESTAMP | ||||
Bi_DimGiftCard_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||||
Bi_DimGiftCard_s3 | PodName | VARCHAR(20) | ||||
Bi_DimGiftCard_s3 | groupid | BIGINT | ||||
Bi_DimGiftCard_s3 | ActivationDate | TIMESTAMP |