Gift card and prepaid card liability fact table
This table lists the fact table columns used for the gift cards data model.
Bi_FactGiftCards
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
Centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter centerwid | ||
OrganizationID | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
RedemptionCenterwid | bigint | A unique identifier for the center at which giftcard or pre paid card is redeemed.(Bi_DimCenter) | Bi_DimCenter centerwid | ||
GiftCardUserwid | bigint | Unique identifier for the gift card or prepaid card and user combination. This is a non-blank value that gets populated for every gift card or prepaid card and user combination.(Bi_DimGiftCardUser) | Bi_DimGiftCardUser GiftCardUserwid | ||
Itemwid | bigint | A unique identifier for the Item(Bi_DimItems). | Bi_DimItems itemwid | ||
RedemptionItemwid | bigint | The unique identifier of the item redeemed using the gift card or prepaid card.(Bi_DimItems) | Bi_DimItems itemwid | ||
ItemTypewid | smallint | A unique identifier for the Item Type(Bi_DimItemType). | Bi_DimItemType itemtypewid | ||
RedemptionUserwid | bigint | A unique identifier for the guest who redeemed the gift card or prepaid card.(Bi_Dimuser) | Bi_Dimuser userwid | ||
Userwid | bigint | A unique identifier for the guest, generated in User dimension(Bi_DimUser). | Bi_Dimuser userwid | ||
ClosedDate | TIMESTAMP | The date when the status of the invoice is marked as 'closed' | |||
Discount | FLOAT | Discount applied during sale of the gift card or prepaid card. | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
ExpiryDate | DATE | Expiry date of the gift card or prepaid card sold. | |||
FactGiftCardID | bigint | A unique identifier for each record generated in the fact table. | |||
FactGiftCardwid | bigint | A unique identifier for each record generated in the fact table. | Yes | ||
FactorToPrice | FLOAT | The ratio between sale price and giftcard value. | |||
GiftCardValue | FLOAT | The value assigned to the gift card or prepaid card at the time of purchase. | |||
InvoiceID | VARCHAR(36) | A unique identifier, within the organization, for the corresponding invoice. | |||
InvoiceItemID | VARCHAR(36) | The unique identifier for each line item within the invoice. | |||
PaymentDate | TIMESTAMP | The date of redemption of items using the gift card or prepaid card. | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
PODID | integer | Internal to the ETL, says from which POD data is being synced the table | |||
RecordTypeID | smallint | Indicates whether the transaction was a sale, refund, or redemption. | |||
RedemAmount | FLOAT | The value redeemed from the gift card or prepaid card . | |||
SaleDate | TIMESTAMP | The date on which the corresponding invoice was created. | |||
SalePrice | FLOAT | Sale price of the gift card or prepaid card. | |||
Tax | FLOAT | Tax applied during sale of the gift card or prepaid card. | |||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||
ActivationDate | TIMESTAMP | Date on which Giftcard is activated in center time. | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||