Campaign discount fact table

factcampaigndiscountid

DECIMAL(19,0)

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.

campaignid

VARCHAR(36)

The unique identifier that indicates the Campaign details(Bi_DimCampaign).

Bi_DimCampaign_s3

campaignId

couponid

VARCHAR(36)

The unique identifier that indicates the Coupn details(Bi_DimGuestCoupon).

Bi_DimGuestCoupon_s3

guestcouponid

centerid

VARCHAR(36)

A unique identifier for the center, generated in Centre dimension(Bi_DimCenter).

Bi_DimCenter_s3

centerid

PodName

VARCHAR(20)

Internal to the ETL, says from which POD data is being synced the table

userid

VARCHAR(36)

A unique identifier for the guest, generated in User dimension(Bi_DimUser).

Bi_Dimuser_s3

userid

VoucherCode

NVARCHAR(1024)

If applicable, this is the voucher code corresponding to the discount.

discountvalue

FLOAT

The value of the discount for the corresponding campaign, coupon, or voucher.

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.

appfactor

NUMERIC(19,4)

The ratio between discount value and total discount value.

void

BOOLEAN

Indicates if the row should be inserted or deleted. 1- delete, 0-insert

OrganizationID

VARCHAR(36)

A unique identifier for the organition for which this data belongs

Bi_DimCenter_s3

OrganizationId

groupid

BIGINT

Internal to Zenoti. Used for data processing.

discountid

VARCHAR(36)

Unique identifier for a given campaign discount

InvoiceNo

VARCHAR(160)

Invoice number that helps in identifying and tracking the invoice.