Package Value Fact Table
ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide
Stores detailed package sale, payment, redemption, and revenue recognition data including item-level pricing, refunds, category breakdowns, and apportionment factors.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| Factsegmentwid | BIGINT IDENTITY | NOT NULL | Surrogate key for the package value record. |
| FactSegmentId | BIGINT | YES | Source system identifier for the package value segment. |
| CenterWID | BIGINT | YES | Foreign key to the center dimension (Bi_DimCenter.centerwid). |
| UserWId | BIGINT | YES | Foreign key to the guest/user dimension (Bi_DimUser.userwid). |
| SaleByWId | BIGINT | YES | Foreign key to the employee who made the sale (Bi_DimUser.userwid). |
| CloseBywid | BIGINT | YES | Foreign key to the employee who closed the invoice (Bi_DimUser.userwid). |
| CreatedByWID | BIGINT | YES | Foreign key to the user who created the record (Bi_DimUser.userwid). |
| ItemTypeWID | BIGINT | YES | Foreign key to the item type dimension. |
| Itemwid | BIGINT | YES | Foreign key to the item dimension. |
| UnitItemType | INT | YES | Unit item type code. |
| ProductWId | BIGINT | YES | Foreign key to the product dimension. |
| ServiceWId | BIGINT | YES | Foreign key to the service dimension. |
| PackageRecordType | INT | YES | Record type for the package transaction. |
| PackageVersionWId | BIGINT | YES | Foreign key to the package version dimension. |
| packageuserwid | BIGINT | YES | Foreign key to the package owner/user (Bi_DimUser.userwid). |
| PackageStartDate | TIMESTAMP | YES | Start date of the package. |
| PackageEndDate | TIMESTAMP | YES | End date of the package. |
| GracePeriod | TIMESTAMP | YES | Grace period end timestamp for the package. |
| Quantity | INT | YES | Quantity of items in the package. |
| QuantityRedeemed | INT | YES | Quantity of items already redeemed. |
| SalePrice | FLOAT | YES | Sale price of the package. |
| Discount | FLOAT | YES | Discount applied to the package. |
| Tax | FLOAT | YES | Tax amount on the package. |
| FinalSalePrice | FLOAT | YES | Final sale price after discounts and tax. |
| SaleLiability | FLOAT | YES | Sale liability amount. |
| PackageIRR | FLOAT | YES | Internal rate of return for the package. |
| PackagePaymentAmount | FLOAT | YES | Payment amount at the package level. |
| ItemPaymentAmount | FLOAT | YES | Payment amount at the item level. |
| PackagePaymentAmountTax | FLOAT | YES | Tax on the package payment amount. |
| ItemPaymentAmountTax | FLOAT | YES | Tax on the item payment amount. |
| AdjustedPaymentAmount | FLOAT | YES | Adjusted payment amount at the package level. |
| AdjustedItemPaymentAmount | FLOAT | YES | Adjusted payment amount at the item level. |
| AdjustedPaymentAmountTax | FLOAT | YES | Tax on the adjusted package payment amount. |
| AdjustedItemPaymentAmountTax | FLOAT | YES | Tax on the adjusted item payment amount. |
| Suspense | FLOAT | YES | Suspense (deferred revenue) amount. |
| PaymentModeNumber | VARCHAR(200) | YES | Payment mode reference number. |
| PaymentDateTimeInCenter | TIMESTAMP | YES | Payment date/time in center local time. |
| PaymentDateInCenter | DATE | YES | Payment date in center local time. |
| SaleDateTimeInCenter | TIMESTAMP | YES | Sale date/time in center local time. |
| SaleDateInCenter | DATE | YES | Sale date in center local time. |
| ClosedDateTimeInCenter | TIMESTAMP | YES | Invoice closed date/time in center local time. |
| ClosedDateInCenter | DATE | YES | Invoice closed date in center local time. |
| CreatedDateTimeInCenter | TIMESTAMP | YES | Record creation date/time in center local time. |
| CreatedDateInCenter | DATE | YES | Record creation date in center local time. |
| ItemSalePrice | FLOAT | YES | Sale price at the item level. |
| ItemFinalSalePrice | FLOAT | YES | Final sale price at the item level. |
| InvoiceId | VARCHAR(36) | YES | GUID of the associated invoice. |
| InvoiceItemId | VARCHAR(36) | YES | GUID of the associated invoice item. |
| InvoiceStatus | INT | YES | Status code of the invoice. |
| TransactionId | VARCHAR(36) | YES | GUID of the payment transaction. |
| PaymentOptionType | VARCHAR(200) | YES | Type of payment option used. |
| PackagePaymentType | VARCHAR(200) | YES | Type of package payment. |
| Invoice_No | NVARCHAR(320) | YES | Human-readable invoice number. |
| RedemptionDate | TIMESTAMP | YES | Date/time of the redemption. |
| RedeemedInvoiceItemId | VARCHAR(36) | YES | GUID of the redeemed invoice item. |
| ItemSaleByWId | BIGINT | YES | Foreign key to the employee who sold the item (Bi_DimUser.userwid). |
| ItemDiscount | FLOAT | YES | Discount applied at the item level. |
| UnitItemDiscount | NVARCHAR(256) | YES | Description of unit item discount. |
| ItemListPrice | FLOAT | YES | List price of the item. |
| ApprovalNumber | NVARCHAR(512) | YES | Approval number for the transaction. |
| CreditCardLastFourDigits | NVARCHAR(128) | YES | Last four digits of the credit card used. |
| PaymentCollectionCenterWID | BIGINT | YES | Foreign key to the center where payment was collected (Bi_DimCenter.centerwid). |
| ItemRedemptionCenterWID | BIGINT | YES | Foreign key to the center where item was redeemed (Bi_DimCenter.centerwid). |
| RefundInvoiceID | VARCHAR(36) | YES | GUID of the refund invoice. |
| RefundInvoiceItemID | VARCHAR(36) | YES | GUID of the refund invoice item. |
| TotalRefundValue | FLOAT | YES | Total value of the refund. |
| ProductCategoryName | NVARCHAR(2048) | YES | Name of the product category. |
| ProductCategoryCode | NVARCHAR(256) | YES | Code of the product category. |
| ProductParentCategoryName | NVARCHAR(2048) | YES | Name of the parent product category. |
| ProductParentCategoryCode | NVARCHAR(256) | YES | Code of the parent product category. |
| ProductTagName | NVARCHAR(2048) | YES | Tag name for the product. |
| ServiceCategoryName | NVARCHAR(2048) | YES | Name of the service category. |
| ServiceCategoryCode | NVARCHAR(256) | YES | Code of the service category. |
| ServiceParentCategoryName | NVARCHAR(2048) | YES | Name of the parent service category. |
| ServiceParentCategoryCode | NVARCHAR(256) | YES | Code of the parent service category. |
| ServiceTagname | NVARCHAR(2048) | YES | Tag name for the service. |
| IsRevenueRecognized | BOOLEAN | YES | Whether revenue has been recognized for this record. |
| IsFirstPaymentOnPackage | BOOLEAN | YES | Whether this is the first payment on the package. |
| ItemLevelApportionFactor | FLOAT | YES | Apportionment factor at the item level. |
| ClassWId | BIGINT | YES | Foreign key to the class dimension. |
| ClassCategoryName | NVARCHAR(2048) | YES | Name of the class category. |
| ClassCategoryCode | NVARCHAR(256) | YES | Code of the class category. |
| ClassParentCategoryName | NVARCHAR(2048) | YES | Name of the parent class category. |
| ClassParentCategoryCode | NVARCHAR(256) | YES | Code of the parent class category. |
| ClassTagname | NVARCHAR(2048) | YES | Tag name for the class. |
| BenefitRefundQty | INT | YES | Quantity of benefit refunds. |
| void | BOOLEAN | YES | Soft-delete flag indicating the record is logically deleted. |
| LPRedemption | FLOAT | YES | Loyalty point redemption amount. |
| SaleLiabilityExclLPRedemption | FLOAT | YES | Sale liability excluding loyalty point redemptions. |
| SuspenseExclLPRedemption | FLOAT | YES | Suspense amount excluding loyalty point redemptions. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
Factsegmentwid
Foreign Keys
| Column | References |
|---|---|
| CenterWID | Bi_DimCenter.centerwid |
| PaymentCollectionCenterWID | Bi_DimCenter.centerwid |
| ItemRedemptionCenterWID | Bi_DimCenter.centerwid |
| UserWId | Bi_DimUser.userwid |
| SaleByWId | Bi_DimUser.userwid |
| CloseBywid | Bi_DimUser.userwid |
| CreatedByWID | Bi_DimUser.userwid |
| packageuserwid | Bi_DimUser.userwid |
| ItemSaleByWId | Bi_DimUser.userwid |
| ClosedDateInCenter | Bi_DimDate.datewid |
| CreatedDateInCenter | Bi_DimDate.datewid |
| PaymentDateInCenter | Bi_DimDate.datewid |
| SaleDateInCenter | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| UnitItemType | 0 = Service 2 = Product 11 = Class |
| PackageRecordType | 0 = Not Applicable 1 = Purchase 2 = Redemption 3 = Refund |
| InvoiceStatus | 0 = Open 1 = Open 2 = Open 3 = Open 4 = Closed |
| IsRevenueRecognized | TRUE if revenue is recognized; FALSE otherwise. |
| IsFirstPaymentOnPackage | TRUE if this is the first payment; FALSE otherwise. |
| void | TRUE if the record is soft-deleted; FALSE otherwise. |
Was this article helpful?
Your feedback helps us improve our documentation.