Gift card dimension table
Table Name | Column Name | 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 | 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 |