ZenotiHelp

Package Value Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 10 min readGuide

Consolidated fact table capturing package financial values including sale prices, taxes, discounts, liabilities, payments, suspense, and revenue recognition across package lifecycle events.

Columns

Column Name Data Type Nullable Description
Organization Name VARCHAR(512) Yes Name of the organization. Sourced from DimOrganization.organization_name.
Organization Account Name VARCHAR(256) Yes Account name of the organization. Sourced from DimOrganization.organization_account_name.
Package Sale center name VARCHAR(128) Yes Name of the center where the package was sold. Sourced from DimCenter.center_name.
Package Sale Center Zone Name VARCHAR(512) Yes Zone name of the package sale center. Sourced from DimCenter.zone_name.
Package Sale center company name VARCHAR(128) Yes Company name of the package sale center. Sourced from DimCenter.company_name.
Payment Center Name VARCHAR(128) Yes Name of the center where payment was made. Sourced from DimCenter.center_name.
Payment Center Zone Name VARCHAR(512) Yes Zone name of the payment center. Sourced from DimCenter.zone_name.
Package Redemption Center VARCHAR(4096) Yes Name of the center where the package was redeemed. Sourced from DimCenter.center_name.
Package Redemption Center Zone VARCHAR(4096) Yes Zone name of the package redemption center. Sourced from DimCenter.zone_name.
User Id VARCHAR(36) Yes Unique identifier (UUID) of the guest. Sourced from DimGuest.user_id.
Guest First Name VARCHAR(160) Yes First name of the guest. Sourced from DimGuest.first_name.
Guest Last Name VARCHAR(256) Yes Last name of the guest. Sourced from DimGuest.last_name.
Guest Middle Name VARCHAR(160) Yes Middle name of the guest. Sourced from DimGuest.middle_name.
guest Address 1 VARCHAR(512) Yes Primary address line of the guest. Sourced from DimGuest.address1.
guest Address 2 VARCHAR(512) Yes Secondary address line of the guest. Sourced from DimGuest.address2.
Guest City VARCHAR(128) Yes City of the guest. Sourced from DimGuest.city.
Guest Zipcode VARCHAR(128) Yes Zip code of the guest. Sourced from DimGuest.zipcode.
Guest Type Name VARCHAR(128) Yes Guest type classification name. Sourced from DimGuest.type_name.
Guest Email VARCHAR(256) Yes Email address of the guest. Sourced from DimGuest.email.
Guest Mobile Phone VARCHAR(64) Yes Mobile phone number of the guest. Sourced from DimGuest.mobile_phone.
Guest Home Phone VARCHAR(64) Yes Home phone number of the guest. Sourced from DimGuest.home_phone.
Guest Phone Code VARCHAR(64) Yes Phone country code of the guest. Sourced from DimGuest.phone_code.
Guest Code VARCHAR(128) Yes Unique guest code identifier. Sourced from DimGuest.guest_code.
Guest Gender VARCHAR(128) Yes Gender of the guest. Sourced from DimGuest.gender.
Guest State VARCHAR(4096) Yes State of the guest. Sourced from DimGuest.state.
guest base center VARCHAR(4096) Yes Base center assigned to the guest. Sourced from DimGuest.base_center.
Guest Country Name VARCHAR(4096) Yes Country name of the guest. Sourced from DimGuest.country_name.
Is Guest InActive BOOLEAN Yes Indicates whether the guest is inactive. Sourced from DimGuest.is_inactive.
Guest Tags VARCHAR(65535) Yes Tags associated with the guest. Sourced from DimGuest.tags.
Service Name VARCHAR(512) Yes Name of the service. Sourced from DimService.service_name.
Service Length INTEGER Yes Duration of the service in minutes. Sourced from DimService.service_length.
Service Category VARCHAR(256) Yes Category of the service. Sourced from DimService.category.
Service Parent Category VARCHAR(256) Yes Parent category of the service. Sourced from DimService.parent_category.
Service Has Variant VARCHAR(14) Yes Indicates whether the service has variants. Sourced from DimService.has_variant.
Service Is Variant VARCHAR(14) Yes Indicates whether the service is a variant. Sourced from DimService.is_variant.
Service BusinessUnit VARCHAR(200) Yes Business unit of the service. Sourced from DimService.businessunit.
Is Service InActive BOOLEAN Yes Indicates whether the service is inactive. Sourced from DimService.is_inactive.
Service Tags VARCHAR(65535) Yes Tags associated with the service. Sourced from DimService.tags.
Product Name VARCHAR(256) Yes Name of the product. Sourced from DimProduct.product_name.
Product Category VARCHAR(256) Yes Category of the product. Sourced from DimProduct.category.
Product Parent Category VARCHAR(256) Yes Parent category of the product. Sourced from DimProduct.parent_category.
Product Business Unit VARCHAR(800) Yes Business unit of the product. Sourced from DimProduct.business_unit.
Product Has Variant BOOLEAN Yes Indicates whether the product has variants. Sourced from DimProduct.has_variant.
Is Product InActive BOOLEAN Yes Indicates whether the product is inactive. Sourced from DimProduct.is_inactive.
Product Tags VARCHAR(65535) Yes Tags associated with the product. Sourced from DimProduct.tags.
class name VARCHAR(1024) Yes Name of the class. Sourced from DimClass.class_name.
is workshop BOOLEAN Yes Indicates whether the class is a workshop. Sourced from DimClass.is_workshop.
class length INTEGER Yes Duration of the class in minutes. Sourced from DimClass.class_length.
class category VARCHAR(256) Yes Category of the class. Sourced from DimClass.category.
class parent category VARCHAR(256) Yes Parent category of the class. Sourced from DimClass.parent_category.
class businessunit VARCHAR(200) Yes Business unit of the class. Sourced from DimClass.businessunit.
is class inactive BOOLEAN Yes Indicates whether the class is inactive. Sourced from DimClass.is_inactive.
class tags VARCHAR(65535) Yes Tags associated with the class. Sourced from DimClass.tags.
Package Name VARCHAR(1024) Yes Name of the package. Sourced from DimPackage.package_name.
Package Type VARCHAR(14) Yes Type of the package (e.g., Membership, Series). Sourced from DimPackage.package_type.
Package Category VARCHAR(200) Yes Category of the package. Sourced from DimPackage.category.
Package BusinessUnit VARCHAR(200) Yes Business unit of the package. Sourced from DimPackage.businessunit.
Is Package InActive BOOLEAN Yes Indicates whether the package is inactive. Sourced from DimPackage.is_inactive.
Package Tags VARCHAR(65535) Yes Tags associated with the package. Sourced from DimPackage.tags.
package id VARCHAR(36) Yes Unique identifier (UUID) of the package.
package version id VARCHAR(36) Yes Unique identifier (UUID) of the package version.
package code VARCHAR(128) Yes Code assigned to the package.
Item Type Code VARCHAR(100) Yes Code representing the type of item in the package benefit.
Package Start Date TIMESTAMP Yes Start date and time of the package.
Package End Date TIMESTAMP Yes End date and time of the package.
Template Package versionid VARCHAR(36) Yes Version ID of the template package.
Business Unit VARCHAR(800) Yes Business unit associated with the record.
Package Sale By Employee First Name VARCHAR(160) Yes First name of the employee who sold the package. Sourced from DimEmployee.first_name.
Package Sale By Employee Last Name VARCHAR(256) Yes Last name of the employee who sold the package. Sourced from DimEmployee.last_name.
Package Sale By Employee Code VARCHAR(128) Yes Code of the employee who sold the package. Sourced from DimEmployee.employee_code.
Package Sale By Employee - Code VARCHAR(128) Yes Alternate code of the selling employee. Sourced from DimEmployee.employee_code.
Package Sale By Employee Job Name VARCHAR(1020) Yes Job name of the selling employee. Sourced from DimEmployee.job_name.
Package Sale By Employee Job Code VARCHAR(512) Yes Job code of the selling employee. Sourced from DimEmployee.job_code.
Package sale by employee additional field 1 VARCHAR(8000) Yes Custom additional field 1 for the selling employee. Sourced from DimEmployee.additional_field_1.
Package sale by employee additional field 2 VARCHAR(8000) Yes Custom additional field 2 for the selling employee. Sourced from DimEmployee.additional_field_2.
Item Sale By Employee First Name VARCHAR(160) Yes First name of the employee who sold the item. Sourced from DimEmployee.first_name.
Item Sale By Employee Last Name VARCHAR(256) Yes Last name of the employee who sold the item. Sourced from DimEmployee.last_name.
Item Sale By Employee Code VARCHAR(128) Yes Code of the employee who sold the item. Sourced from DimEmployee.employee_code.
Item Sale By Employee - Code VARCHAR(128) Yes Alternate code of the item selling employee. Sourced from DimEmployee.employee_code.
Item Sale By Employee Job Name VARCHAR(1020) Yes Job name of the item selling employee. Sourced from DimEmployee.job_name.
Item Sale By Employee Job Code VARCHAR(512) Yes Job code of the item selling employee. Sourced from DimEmployee.job_code.
Item sale by employee additional field 1 VARCHAR(8000) Yes Custom additional field 1 for the item selling employee. Sourced from DimEmployee.additional_field_1.
Item sale by employee additional field 2 VARCHAR(8000) Yes Custom additional field 2 for the item selling employee. Sourced from DimEmployee.additional_field_2.
is center franchise BOOLEAN Yes Indicates whether the center is a franchise. Sourced from DimCenter.is_franchise.
center cst number VARCHAR(80) Yes CST number of the center. Sourced from DimCenter.cst_number.
center tin number VARCHAR(80) Yes TIN number of the center. Sourced from DimCenter.tin_number.
center tot number VARCHAR(80) Yes TOT number of the center. Sourced from DimCenter.tot_number.
center service tax number VARCHAR(80) Yes Service tax number of the center. Sourced from DimCenter.service_tax_number.
center vat number VARCHAR(80) Yes VAT number of the center. Sourced from DimCenter.vat_number.
center luxary tax number VARCHAR(80) Yes Luxury tax number of the center. Sourced from DimCenter.luxary_tax_number.
Is Custom Package BOOLEAN Yes Indicates whether the package is a custom package.
Minutes To ADD INTEGER Yes Timezone offset in minutes for the center.
brand name VARCHAR(512) Yes Brand name associated with the record.
Package Sale Center Code VARCHAR(40) Yes Code of the package sale center. Sourced from DimCenter.center_code.
Payment Center Code VARCHAR(40) Yes Code of the payment center. Sourced from DimCenter.center_code.
Package Redemption Center Code VARCHAR(40) Yes Code of the package redemption center. Sourced from DimCenter.center_code.
factsegmentwid BIGINT Yes Fact segment warehouse identifier for ETL partitioning.
Unit Item Type Code INTEGER Yes Numeric code for the unit item type.
record type INTEGER Yes Numeric code representing the record type.
Package grace period TIMESTAMP Yes Grace period end date for the package.
quantity INTEGER Yes Total quantity of the package benefit.
Quantity Redeemed INTEGER Yes Number of units redeemed from the package benefit.
Package Sale Price FLOAT Yes Original sale price of the package.
Package Discount FLOAT Yes Discount amount applied to the package.
Package Tax FLOAT Yes Tax amount applied to the package.
Package Final Sale Price FLOAT Yes Final sale price of the package after discounts and tax.
Package Sale Liability FLOAT Yes Liability amount from the package sale.
Package IRR FLOAT Yes Internal rate of return for the package.
Amount Paid For Package FLOAT Yes Total amount paid for the package.
Amount Paid for Item FLOAT Yes Amount paid attributed to the item.
Tax Paid for Package FLOAT Yes Tax amount paid for the package.
Tax Paid for Item FLOAT Yes Tax amount paid for the item.
Adjusted Amount Paid For Package FLOAT Yes Adjusted amount paid for the package.
Adjusted Amount Paid For Item FLOAT Yes Adjusted amount paid for the item.
Adjusted Tax Paid For Package FLOAT Yes Adjusted tax paid for the package.
Adjusted Tax Paid For Item FLOAT Yes Adjusted tax paid for the item.
suspense FLOAT Yes Suspense amount (unrecognized revenue).
Payment date time in center TIMESTAMP Yes Payment date and time in the center local timezone.
Payment date in center DATE Yes Payment date in the center local timezone.
Sale date time in center TIMESTAMP Yes Sale date and time in the center local timezone.
Sale date in center DATE Yes Sale date in the center local timezone.
Closed date time in center TIMESTAMP Yes Invoice closed date and time in the center local timezone.
Closed date in center DATE Yes Invoice closed date in the center local timezone.
Created date time in center TIMESTAMP Yes Record created date and time in the center local timezone.
Created date in center DATE Yes Record created date in the center local timezone.
Package item sale price FLOAT Yes Sale price of the package item.
Package item final sale price FLOAT Yes Final sale price of the package item after discounts.
Package Invoice Id VARCHAR(36) Yes Unique identifier (UUID) of the package invoice.
Package Invoice Item Id VARCHAR(36) Yes Unique identifier (UUID) of the package invoice item.
Invoice Status VARCHAR(100) Yes Status of the invoice (e.g., Closed, Open).
transactionid VARCHAR(36) Yes Unique identifier (UUID) of the payment transaction.
payment option type VARCHAR(200) Yes Type of payment option used.
Package Payment Type VARCHAR(200) Yes Type of payment for the package.
Package Invoice No VARCHAR(320) Yes Invoice number for the package.
redemption Date TIMESTAMP Yes Date and time when the package benefit was redeemed.
redeemedinvoiceitemid VARCHAR(36) Yes Invoice item ID associated with the redemption.
itemdiscount FLOAT Yes Discount applied to the item.
unititemdiscount VARCHAR(256) Yes Unit item discount description or value.
itemlistprice FLOAT Yes List price of the item before discounts.
approvalnumber VARCHAR(512) Yes Payment approval/authorization number.
creditcardlastfourdigits VARCHAR(256) Yes Last four digits of the credit card used.
refund invoice id VARCHAR(36) Yes Invoice ID associated with a refund.
refund Invoice item id VARCHAR(36) Yes Invoice item ID associated with a refund.
Total refund value FLOAT Yes Total monetary value of the refund.
product category code VARCHAR(256) Yes Code for the product category. Sourced from DimProduct.category_code.
product parent category code VARCHAR(256) Yes Code for the product parent category. Sourced from DimProduct.parent_category_code.
package benefit Product Tag NVARCHAR(2048) Yes Tag identifying the product benefit within the package.
service category code VARCHAR(256) Yes Code for the service category. Sourced from DimService.category_code.
service parent category code VARCHAR(256) Yes Code for the service parent category. Sourced from DimService.parent_category_code.
package benefit Service Tag VARCHAR(2048) Yes Tag identifying the service benefit within the package.
isrevenuerecognized BOOLEAN Yes Indicates whether revenue has been recognized.
isfirstpaymentonpackage BOOLEAN Yes Indicates whether this is the first payment on the package.
itemlevelapportionfactor FLOAT Yes Apportion factor used for item-level revenue allocation.
class category code VARCHAR(256) Yes Code for the class category. Sourced from DimClass.category_code.
class parent category code VARCHAR(256) Yes Code for the class parent category. Sourced from DimClass.parent_category_code.
package benefit Class Tag VARCHAR(2048) Yes Tag identifying the class benefit within the package.
benefit refund quantity INTEGER Yes Quantity of benefits refunded.
etlcreatedby BIGINT Yes Identifier of the ETL process that created the record.
LP Redemption FLOAT Yes Loyalty points redemption amount.
Sale Liability Excl LP Redemption FLOAT Yes Sale liability excluding loyalty points redemption.
Suspense Excl LP Redemption FLOAT Yes Suspense amount excluding loyalty points redemption.

Primary Key

No explicit primary key is defined. The combination of Package Invoice Item Id, record type, and redeemedinvoiceitemid can serve as a logical key.

Foreign Keys

  • User Id references DimGuest
  • Package Sale center name / Package Sale Center Code references DimCenter (sale center)
  • Payment Center Name / Payment Center Code references DimCenter (payment center)
  • Package Redemption Center / Package Redemption Center Code references DimCenter (redemption center)
  • Package Sale By Employee First Name, Package Sale By Employee Code references DimEmployee (selling employee)
  • Item Sale By Employee First Name, Item Sale By Employee Code references DimEmployee (item selling employee)
  • Service Name references DimService
  • Product Name references DimProduct
  • class name references DimClass
  • Package Name, package id references DimPackage

Enumerator Values

Column Name Known Values
Package Type Membership, Series, etc.
Invoice Status Closed, Open, etc.
record type Integer codes representing Sale, Redemption, Refund
Item Type Code Service, Product, Class
Guest Gender Male, Female, etc.

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

Was this article helpful?
Your feedback helps us improve our documentation.