Gift cards fact table
TableName | Field | Field Type | Description | PrimaryKey | MappedDimensionTable | DimensionTableField |
Bi_FactGiftCards_s3 | CenterID | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 | centerID | |
Bi_FactGiftCards_s3 | ClosedDate | TIMESTAMP | The date when the status of the invoice is marked as 'closed' | |||
Bi_FactGiftCards_s3 | Discount | FLOAT | Discount applied during sale of the gift card or prepaid card. | |||
Bi_FactGiftCards_s3 | ExpiryDate | DATE | Expiry date of the gift card or prepaid card sold. | |||
Bi_FactGiftCards_s3 | FactGiftCardID | DECIMAL(19,0) | A unique identifier for each record generated in the fact table. | Yes | ||
Bi_FactGiftCards_s3 | FactorToPrice | FLOAT | The ratio between sale price and giftcard value. | |||
Bi_FactGiftCards_s3 | GiftCardUserID | VARCHAR(36) | 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_s3 | GiftCardUserId | |
Bi_FactGiftCards_s3 | GiftCardValue | FLOAT | The value assigned to the gift card or prepaid card at the time of purchase. | |||
Bi_FactGiftCards_s3 | InvoiceID | VARCHAR(36) | A unique identifier, within the organization, for the corresponding invoice. | |||
Bi_FactGiftCards_s3 | InvoiceItemID | VARCHAR(36) | The unique identifier for each line item within the invoice. | |||
Bi_FactGiftCards_s3 | ItemID | VARCHAR(36) | A unique identifier for the Item(Bi_DimItems). | Bi_DimItems_S3 | itemid | |
Bi_FactGiftCards_s3 | ItemType | INT | A unique identifier for the Item Type(Bi_DimItemType). | Bi_DimItemType_S3 | itemtypeid | |
Bi_FactGiftCards_s3 | OrganizationID | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 | OrganizationId | |
Bi_FactGiftCards_s3 | PaymentDate | TIMESTAMP | The date of redemption of items using the gift card or prepaid card. | |||
Bi_FactGiftCards_s3 | PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
Bi_FactGiftCards_s3 | RecordTypeID | INT | Indicates whether the transaction was a sale, refund, or redemption. | |||
Bi_FactGiftCards_s3 | RedemAmount | FLOAT | The value redeemed from the gift card or prepaid card . | |||
Bi_FactGiftCards_s3 | RedemptionCenterID | VARCHAR(36) | A unique identifier for the center at which giftcard or pre paid card is redeemed.(Bi_DimCenter) | Bi_DimCenter_s3 | centerID | |
Bi_FactGiftCards_s3 | RedemptionItemID | VARCHAR(36) | The unique identifier of the item redeemed using the gift card or prepaid card.(Bi_DimItems) | Bi_DimItems_S3 | itemid | |
Bi_FactGiftCards_s3 | RedemptionUserID | VARCHAR(36) | A unique identifier for the guest who redeemed the gift card or prepaid card.(Bi_Dimuser) | Bi_Dimuser_s3 | userid | |
Bi_FactGiftCards_s3 | SaleDate | TIMESTAMP | The date on which the corresponding invoice was created. | |||
Bi_FactGiftCards_s3 | SalePrice | FLOAT | Sale price of the gift card or prepaid card. | |||
Bi_FactGiftCards_s3 | Tax | FLOAT | Tax applied during sale of the gift card or prepaid card. | |||
Bi_FactGiftCards_s3 | UserID | VARCHAR(36) | A unique identifier for the guest, generated in User dimension(Bi_DimUser). | Bi_Dimuser_s3 | userid | |
Bi_FactGiftCards_s3 | void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
Bi_FactGiftCards_s3 | groupid | BIGINT | Internal to Zenoti. Used for data processing. | |||
Bi_FactGiftCards_s3 | ActivationDate | TIMESTAMP | Date on which Giftcard is activated in center time. | |||
Bi_FactGiftCards_s3 | InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. |