Campaign discounts fact table
This table lists the fact table columns used for the Campaign discounts data model.
Bi_FactCampaignDiscount
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
appfactor | NUMERIC(19,4) | The ratio between discount value and total discount value. | |||
campaignwid | BIGint | The unique identifier that indicates the Campaign details(Bi_DimCampaign). | Bi_DimCampaign campaignwid | ||
centerwid | BIGint | A unique identifier for the center, generated in Centre dimension(Bi_DimCenter). | Bi_DimCenter centerwid | ||
couponwid | BIGint | The unique identifier that indicates the Coupn details(Bi_DimGuestCoupon). | Bi_DimGuestCoupon guestcouponiwid | ||
discountvalue | FLOAT | The value of the discount for the corresponding campaign, coupon, or voucher. | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
factcampaigndiscountid | BIGint | A unique identifier for each record generated in the fact table. | |||
factcampaigndiscountwid | BIGint | A unique identifier for each record generated in the fact table. | Yes | ||
invoiceid | VARCHAR(36) | A unique identifier for the invoice. It is unique within the organization. | |||
invoiceitemid | VARCHAR(36) | A unique identifier for each line item within the invoice. | |||
OrganizationID | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
PODID | integer | Internal to the ETL, says from which POD data is being synced the table | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
totaldiscountvalue | FLOAT | The total value of the discount for the corresponding invoice item id. This is the sum of the applicable discounts for that invoice item id. | |||
userwid | BIGint | A unique identifier for the guest, generated in User dimension(Bi_DimUser). | Bi_Dimuser userwid | ||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
VoucherCode | NVARCHAR(1024) | If applicable, this is the voucher code corresponding to the discount. | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||
discountwid | VARCHAR(36) | Unique identifier for a given campaign discount | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||