Package Liability data model

"organization name"

VARCHAR(512)

Displays the name of the organization.

"organization account name"

VARCHAR(256)

Displays the account name of the organization. Example: If you use the following URL to log in to Zenoti: https://demo.managemyspa.com, then "demo" is your account name.

"Package Sale center name"

VARCHAR(128)

Displays the name of the center where a package was sold to a guest.

"Package Sale center company name"

VARCHAR(128)

Displays center's company name where a package was sold to a guest. Businesses, especially in a franchisee model, may register each center as a different company - such details are tracked in the Centers > General tab.

"Payment Center Name"

VARCHAR(128)

Displays the name of the center where guest made a payment/transaction for a package.

"Item Sale Center Name"

VARCHAR(32)

Displays the name of the center where a package item was redeemed.

"Package Redemption Center"

VARCHAR(4096)

Displays the name of the center where a package item was redeemed by a user.

"Package Sale center Zone name"

VARCHAR(512)

Displays the name of the zone where a package was sold to a guest.

"Payment Center Zone Name"

VARCHAR(512)

Displays the name of the zone where guest made a payment/transaction for a package.

"Item Sale Center Zone Name"

VARCHAR(512)

Displays the name of the zone where a package item was redeemed.

"user id"

VARCHAR(36)

Guest GUID (of the guest who purchased a package). This value is unique for each guest.

"guest first name"

VARCHAR(160)

Displays the first name of the guest who purchased a package.

"guest last name"

VARCHAR(256)

Displays the last name of the guest who purchased a package.

"guest middle name"

VARCHAR(128)

Displays the middle name of the guest who purchased a package.

"guest Address 1"

NVARCHAR(512)

Displays the adress details of the guest who purchased a package.

"guest Address 2"

NVARCHAR(512)

Displays the adress details of the guest who purchased a package.

"guest city"

VARCHAR(128)

Displays the adress details (city name) of the guest who purchased a package.

"guest zipcode"

VARCHAR(128)

Displays the adress details (zip code) of the guest who purchased a package.

"guest type name"

VARCHAR(128)

Guest, Employee

Displays whether the user of the package is a guest or an employee.

"guest email"

VARCHAR(256)

Displays guest email.

"guest mobile phone"

VARCHAR(64)

Displays contact details of the guest.

"guest home phone"

VARCHAR(64)

Displays contact details of the guest.

"guest phone code"

INTEGER

Displays contact details of the guest.

"guest code"

VARCHAR(128)

Displays the unique code assigned to each user.

"guest gender"

VARCHAR(14)

"Male", "Female" In case the field is blank (no value is recorded) then, Zenoti uses the value "Not Applicable".

Displays the gender of the guest.

"guest state"

VARCHAR(4096)

Displays the name of the state to which the guest belongs.

"guest country name"

VARCHAR(4096)

Displays the name of the country to which the guest belongs.

"is guest inactive"

BOOLEAN

"False", "True"

Displays whether the guest is active in the system or not.

"guest tags"

VARCHAR(65535)

Displays the tags associated with the guest. You can use tags to record any information that the front desk may use while trying to build a relationship with the guest for the growth of the business. Examples: Guest likes our Ayurvedic Massage for 30 mins, Guest missed our previous promo, Guest loves our Lavender Massage Oil.

"employee first name"

VARCHAR(160)

Displays the first name of the employee who provided a service from a package to a guest.

"employee last name"

VARCHAR(256)

Displays the last name of the employee who provided a service from a package to a guest.

"employee middle name"

VARCHAR(128)

Displays the middle name of the employee who provided a service from a package to a guest.

"employee mobile phone"

VARCHAR(64)

Displays the contact details of the employee who provided a service from a package to a guest.

"employee code"

VARCHAR(128)

Displays the unique code assigned to each user in the employee's guests profile. This is the employee who provided a service from a package to a guest. When an employee profile is created, Zenoti automatically creates a guest profile for the same user. Ideally the code should be the same as employee code set up in the profile unless someone manually changed it in the employee's guest profile. This code can be different from employee code in the employee profile.

"employee - code"

VARCHAR(128)

Displays the unique code assigned to each employee in the employee profile. This is the employee who provided a service from a package to a guest.

"employee gender"

VARCHAR(14)

"Male", "Female", "Not Applicable"

Displays the gender of the employee who provided a service from a package to a guest.

"employee job name"

VARCHAR(1020)

Displays the name of the employee's job (who provided a service from a package to a guest).

"employee job code"

VARCHAR(1020)

Displays the code of the employee's job (who provided a service from a package to a guest).

"is employee inactive"

BOOLEAN

"False" "True"

Displays whether the employee who is earning a commission on this invoice is currently active or not. This is the employee who provided a service from a package to a guest.

"service name"

VARCHAR(512)

Displays the name of the service. Example: Mens Body- Brazilian - Modified

"service length"

INTEGER

Displays the length of the service in minutes.

"service category"

VARCHAR(256)

Displays the category to which the service belongs. Example: Modified Brazilian

"service parent category"

VARCHAR(256)

Displays the parent category to which the service belongs.

"service has variant"

VARCHAR(14)

Possible values : "1","0", where 1 means that the service has a variant.

Displays if the service has a variant

"service is variant"

VARCHAR(14)

Possible values : "1","0", where 1 means that the service has a variant.

Displays if the service is a variant.

"service businessunit"

VARCHAR(200)

Displays the business unit name to which the service belongs.

"is service inactive"

BOOLEAN

Displays if the service is still active or not.

"service tags"

VARCHAR(65535)

Displays the service tags.

"product name"

VARCHAR(256)

Displays the name of the product. Example: Pink Mini Gloss Purse Set

"product category"

VARCHAR(256)

Displays the category to which the product belongs. Example: Lipstick

"product parent category"

VARCHAR(256)

Displays the parent category to which the product belongs. Example:Cosmetics

"product business unit"

VARCHAR(200)

Displays the business unit name to which the product belongs.

"product has variant"

BOOLEAN

"False" "True" "Not Applicable"

Displays if the product has a variant.

"is product inactive"

BOOLEAN

"False" "True"

Displays if the product is still available or not.

"product tags"

VARCHAR(65535)

Displays the product tags for products that are part of the package.

"package name"

VARCHAR(512)

Displays the name of the package.

"package type"

VARCHAR(14)

"Day package" "Series package" "Promo package" "Not Available"

Displays the type of package.

"package category"

VARCHAR(200)

Displays the category name of the package.

"package businessunit"

VARCHAR(200)

Displays the name of the business unit to which the package belongs.

"is package inactive"

BOOLEAN

"False" "True"

Displays if the package is still active or not

"package tags"

VARCHAR(65535)

Displays the package tags.

"package id"

VARCHAR(36)

Displays the unique GUID of the package.

"BundlePackageID"

VARCHAR(36)

Displays the unique GUID of the bundle package.

"BundlePackageNo"

ÏNTEGER

Helps you identify the number of bundle packages in a invoice.

"package version id"

VARCHAR(36)

Displays the version to which the package belongs.

"package code"

NVARCHAR(128)

Displays the code of the package.

"item type code"

VARCHAR(100)

Product Service

Displays if product or service is associated to thr package.

"Unit item type code"

INTEGER

1 - Category/Parent Category 2 - Product/Service 3 - Tag

Displays if it is a Product, Product Category, or Product Tag. Or, whether it is a Service, Service Category, or a Service Tag. This will help you to understand the product/service dimension attributes of a package.

"package start date"

TIMESTAMP

Displays the start date of the package.

"package end date"

TIMESTAMP

Displays the end date of the package.

"template package versionid"

VARCHAR(70)

Displays the package version unique ID.

quantity

INTEGER

Displays the total quantity of items (Product/Service) provided with a package.

"quantity redeemed"

INTEGER

Displays the total quantity of items (Product/Service) redeemed from a package.

"payment option type"

VARCHAR(250)

Displays payment method used. Example: For a card used for payment, it will tell if card used is Master or VISA.

"transactionid"

VARCHAR(36)

Displays unique GUID for a transaction.

"payment type"

VARCHAR(100)

Displays type of payment used. Example: Credit Card, Gift Card, Cash.

"amount paid for package"

FLOAT

Displays the total payment made for a package.

"package final sale price"

FLOAT

Displays the final sale price of a package.

"package sale price"

FLOAT

Displays the sale price of a package.

"package item price"

FLOAT

Displays the final sale price of an item in package (can be service or product). In case of Category or Tag association, the package item price is the average value of Item Final Sale Price of all the Products/Services under that Category or Tag.

"sale price of item"

FLOAT

Displays sale price of package items. Sale price of package is prorated based on "package item price" field. This is done to get the contribution of an item at the package level.

"final sale price of item"

FLOAT

Displays final sale price of package items. Final sale price of package is prorated based on "package item price" field. This is done to get the contribution of an item at the package level.

"prorated amount paid for item"

FLOAT

Displays amount paid for package at item level based on Final Sale price of an item.

"package sale date and time"

TIMESTAMP

Displays date and time at which package was sold to a guest.

"package sale date"

DATE

Displays date on which a package was sold to a guest.

"payment date"

DATE

Displays date on which payment is triggered for the purchase of a package.

"payment date and time"

TIMESTAMP

Displays the date and time at which payment is triggered for the purchase of a package.

"package invoice no"

VARCHAR(80)

Displays the invoice number associated to sale, refund, or redemption transaction.

"package invoice id"

VARCHAR(36)

Displays the invoice id associated to sale, refund, or redemption transaction.

"package invoice item id"

VARCHAR(36)

Displays invoice item id associated to sale, refund, or redemption transaction.

"invoice status"

VARCHAR(14)

"Open" "Closed"

Displays the status of invoice whether it is open or closed.

"min redemption date"

DATE

Displays the first time when any item of the package was redeemed.

"max redemption date"

DATE

Displays the last time when any item of this package was redeemed.

"business unit"

VARCHAR(200)

Displays the business unit associated to a package.

"redemption date"

TIMESTAMP

Displays the date on which package item was redeemed.

"record type"

VARCHAR(20)

Displays record type whether it is related to Sale, Refund, or Redemption.

"benefitrefundqty"

INTEGER

Indicates the quantity (#) of package refunded.

"redemption amount"

FLOAT

Displays the total amount redeemed for a package item of total quantity redeemed.

"Package item discount"

FLOAT

Displays the discount of item based on package level discount. Discount of package is prorated based on "package item price" field. This it done to get the contribution of item at package level.

"unit item discount"

FLOAT

Displays discount of item (Service/ Product). Note: This field is populated only for Custom packages.

"package sale by employee first name"

VARCHAR(160)

Displays the first name of the employee name who sold the package to the guest.

"package sale by employee last name"

VARCHAR(256)

Displays the first name of the employee name who sold the package to the guest.

"package sale by employee code"

VARCHAR(128)

Displays the unique code assigned to each user in the employee's guests profile. This is the employee code of the employee who sold the package to the guest. When an employee profile is created, Zenoti automatically creates a guest profile for the same user. Ideally the code should be the same as employee code set up in the profile unless someone manually changed it in the employee's guest profile. This code can be different from employee code in the employee profile.

"package sale by employee - code"

VARCHAR(128)

Displays the unique code assigned to each employee in the employee profile. This is the code of the employee who sold the package.

"package sale by employee job name"

VARCHAR(1020)

Displays the name of the employee's job who sold the package to a guest.

"package sale by employee job code"

VARCHAR(1020)

Displays the code of the employee's job who sold the package to a guest.

"refund invoice item id"

VARCHAR(36)

Displays Invoice item id associated with refund transaction.

"resource name"

VARCHAR(1020)

Displays the name of the resource. Example: Room Name.

"resource code"

VARCHAR(1020)

Displays the unique code of the resource.

"Item List Price"

FLOAT

For Custom Packages - Displays the final sale price of an item in the package. This can be a service or product. Does not include invoice level discount. For Series Packages - Displays the sale price of an item at the center level. This can be a service or product. Does not include invoice level discount. Note: In the case of category or tag, this field displays the average price of the corresponding category or tag.

"Approval Number"

NVARCHAR(256)

Displays the Approval number associated to a payment.

"Credit Card Last Four Digits"

NVARCHAR(32)

Displays the last four digits of the credit card used for a payment.

"is center franchise"

BOOLEAN

Displays whether the center is a franchise.

"center cstn number"

NVARCHAR(80)

Displays the Central Sales Tax (CST) number for the center.

"center tin number"

NVARCHAR(80)

Displays the Taxpayer’s Identification Number (TIN) number for the center.

"center tot number"

NVARCHAR(80)

Displays the Transient occupancy tax (TOT) number for the center.

"center service tax number"

NVARCHAR(80)

Displays the service tax number for the center.

"center vat number"

NVARCHAR(80)

Displays the value added tax identification number (VAT) for the center.

"center luxury tax number"

NVARCHAR(80)

Displays the luxury tax number (VAT) for the center.

"employee additional field 1"

NVARCHAR(8000)

Displays the additional fields of the employee who provided a service attached with a package to a guest.

"employee additional field 2"

NVARCHAR(8000)

Displays the additional fields of the employee who provided a service attached with a package to a guest.

"Package sale by employee additional field 1"

NVARCHAR(8000)

Displays the additional fields of the employee who sold a a package to a guest.

"Package sale by employee additional field 2"

NVARCHAR(8000)

Displays the additional fields of the employee who sold a a package to a guest.