Guest coupon dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
Bi_DimGuestCoupon_s3 | guestcouponid | VARCHAR(36) | PK | ||
Bi_DimGuestCoupon_s3 | userid | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | discountid | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | couponnumber | INT | |||
Bi_DimGuestCoupon_s3 | printdate | TIMESTAMP | |||
Bi_DimGuestCoupon_s3 | expirydate | TIMESTAMP | |||
Bi_DimGuestCoupon_s3 | redemptiondt | TIMESTAMP | |||
Bi_DimGuestCoupon_s3 | redemptionnotes | NVARCHAR(800) | |||
Bi_DimGuestCoupon_s3 | cashback | NVARCHAR(32) | |||
Bi_DimGuestCoupon_s3 | invoiceid | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | couponruleid | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | baseinvoiceid | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | campaignid | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | skiprereq | BOOLEAN | |||
Bi_DimGuestCoupon_s3 | redeemedbyall | INT | |||
Bi_DimGuestCoupon_s3 | couponupdatedby | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | couponupdatedon | TIMESTAMP | |||
Bi_DimGuestCoupon_s3 | void | BOOLEAN | |||
Bi_DimGuestCoupon_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
Bi_DimGuestCoupon_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
Bi_DimGuestCoupon_s3 | PodName | VARCHAR(20) | |||
Bi_DimGuestCoupon_s3 | CenterId | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | organizationid | VARCHAR(36) | |||
Bi_DimGuestCoupon_s3 | groupid | BIGINT |