Discount dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimDiscount_s3 | DiscountId | VARCHAR(36) | PK |
Bi_DimDiscount_s3 | DiscountCode | NVARCHAR(32) | |
Bi_DimDiscount_s3 | OrganizationId | VARCHAR(36) | |
Bi_DimDiscount_s3 | DiscountName | NVARCHAR(256) | |
Bi_DimDiscount_s3 | DiscountValue | DECIMAL(19,4) | |
Bi_DimDiscount_s3 | DiscountPercentage | FLOAT | |
Bi_DimDiscount_s3 | Monday | BOOLEAN | |
Bi_DimDiscount_s3 | Tuesday | BOOLEAN | |
Bi_DimDiscount_s3 | Wednesday | BOOLEAN | |
Bi_DimDiscount_s3 | Thursday | BOOLEAN | |
Bi_DimDiscount_s3 | Friday | BOOLEAN | |
Bi_DimDiscount_s3 | Saturday | BOOLEAN | |
Bi_DimDiscount_s3 | Sunday | BOOLEAN | |
Bi_DimDiscount_s3 | StartTime | FLOAT | |
Bi_DimDiscount_s3 | EndTime | FLOAT | |
Bi_DimDiscount_s3 | CombineSpecials | BOOLEAN | |
Bi_DimDiscount_s3 | DiscountTypeId | INT | |
Bi_DimDiscount_s3 | GiftCertificates | BOOLEAN | |
Bi_DimDiscount_s3 | MinimumAmount | DECIMAL(19,4) | |
Bi_DimDiscount_s3 | isDeferrable | BOOLEAN | |
Bi_DimDiscount_s3 | deferred_expireson | DATE | |
Bi_DimDiscount_s3 | serviceleveldiscounts | BOOLEAN | |
Bi_DimDiscount_s3 | Packageleveldiscounts | BOOLEAN | |
Bi_DimDiscount_s3 | MaximumAmount | DECIMAL(19,4) | |
Bi_DimDiscount_s3 | ProductLevelDiscounts | BOOLEAN | |
Bi_DimDiscount_s3 | MembershipLevelDiscounts | BOOLEAN | |
Bi_DimDiscount_s3 | DiscountTypeName | NVARCHAR(128) | |
Bi_DimDiscount_s3 | Void | BOOLEAN | |
Bi_DimDiscount_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimDiscount_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimDiscount_s3 | PodName | VARCHAR(20) | |
Bi_DimDiscount_s3 | groupid | BIGINT | |
Bi_DimDiscount_s3 | vouchercount | INTEGER |