ZenotiHelp

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.