ZenotiHelp

Package Liability Data Model

ZTZenoti Docs Team Updated June 28, 2026 21 min readGuide

The package data source maintains the flow of a package through its entire cycle - from the sale of a package to the redemption of its services and products, and also refunds if guests choose to discontinue the package for various reasons.

Known Issue

Class Association to a package is not exposed in this liability data source.

We have also provided a few examples for you to better understand the data.

  • Scenario 1: A guest buys a package but there is no refund or redeemed transaction.
  • Scenario 2: A guest buys a package and completely redeems it.
  • Scenario 3: A guest buys a package and takes a full refund.
  • Scenario 4: A guest buys a package, partially redeems it, and refunds the rest.

For revenue:

Field Value Type Possible Values Description
"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.

Scenario 1: Package is bought but there is no refund or redeemed transaction. Tips:

  • Consider the distinct value among these fields "amount paid for package", "package final sale price", "package sale price" as these will duplicate across item and payment level (populated at Package level).
  • Consider the distinct value among these fields "package item price", "sale price of item", "final sale price of item", and "prorated amount paid for item" as these will duplicate across payment level (populated at package and item level).
"Record Type" "package name" "package version id" "item type code" "Unit item type code" "quantity" "quantity redeemed" "transactionid" "payment type" "payment option type" "amount paid for package" "package final sale price" "package sale price" "package item price" "sale price of item" "final sale price of item" "prorated amount paid for item" "redemption date" "redemption amount" "redemption invoice item id" "refund invoice item id"
sale 1993585 bed12be9-a380-4000-8c81-df7bbb464b4a Service 2 1 0 38fa480b-1d19-410b-b29b-38b84f32662e Credit Memo 3250 3250 6000 0 0 0 0 0
sale 1993585 bed12be9-a380-4000-8c81-df7bbb464b4a Service 2 8 0 38fa480b-1d19-410b-b29b-38b84f32662e Credit Memo 3250 3250 6000 1625 3000 1625 1625 0
sale 1993585 bed12be9-a380-4000-8c81-df7bbb464b4a Service 2 8 0 38fa480b-1d19-410b-b29b-38b84f32662e Credit Memo 3250 3250 6000 1625 3000 1625 1625 0
sale 1993585 bed12be9-a380-4000-8c81-df7bbb464b4a Service 2 1 0 38fa480b-1d19-410b-b29b-38b84f32662e Credit Memo 3250 3250 6000 0 0 0 0 0

Scenario 2 : A guest buys a package and completely redeems it. Tips:

  • Consider the distinct value among these fields "amount paid for package", "package final sale price" ,"package sale price" as these will duplicate across item and payment level (populated at Package level).
  • Consider the distinct value among these fields "package item price", "sale price of item", "final sale price of item", and "prorated amount paid for item" as these will duplicate across payment level (populated at package and item level).
"Record Type" "package name" "package version id" "item type code" "Unit item type code" "quantity" "quantity redeemed" "transactionid" "payment type" "payment option type" "amount paid for package" "package final sale price" "package sale price" "package item price" "sale price of item" "final sale price of item" "prorated amount paid for item" "redemption date" "redemption amount" "redemption invoice item id" "refund invoice item id"
sale 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 0 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 995 1912.71467603 995 995 0
sale 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 0 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 2805 5392.12529274 2805 2805 0
sale 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 0 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 0 0 0 0 0
sale 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 0 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 3230 6209.11397346 3230 3230 0
sale 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 0 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 2975 5718.92076503 2975 2975 0
sale 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 0 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 2805 5392.12529274 2805 2805 0
redemption 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 1 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 2805 5392.12529274 2805 2805 06-11-2011 16:00:00 2805 4aad6f9f-02d2-4f46-9432-32d99549d00e
redemption 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 1 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 2805 5392.12529274 2805 2805 06-11-2011 16:00:00 2805 dd5186bd-8537-4cfc-b9b6-812735e905ab
redemption 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 1 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 0 0 0 0 06-11-2011 16:00:00 0 ef80198b-2f13-44c0-bd0e-c688c2e38e09
redemption 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 1 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 995 1912.71467603 995 995 06-11-2011 16:00:00 995 7cffcdbd-a2fc-408d-926a-ce3cd888a48e
redemption 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 1 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 2975 5718.92076503 2975 2975 27-11-2011 16:00:00 2975 6f68574b-3cd4-4f30-83d5-e263d2058368
redemption 236140 f43f7ffa-6952-4aa3-967b-1ec4aabc5ebf Service 2 1 1 d7e93cad-1462-4e3e-a5ef-a7a04140081c Care Credit 12810 12810 24625 3230 6209.11397346 3230 3230 27-11-2011 16:00:00 3230 9900d68c-9d04-4b8e-87f3-ebe5d384b4ba

Scenario 3: A guest buys a package and takes a full refund. Tips:

  • Consider the distinct value among these fields "amount paid for package", "package final sale price", "package sale price" as these will duplicate across item and payment level (populated at Package level).
  • Consider the distinct value among these fields "package item price", "sale price of item", "final sale price of item", and "prorated amount paid for item" as these will duplicate across payment level (populated at package and item level).
"Record Type" "package name" "package version id" "item type code" "Unit item type code" "quantity" "quantity redeemed" "transactionid" "payment type" "payment option type" "amount paid for package" "package final sale price" "package sale price" "package item price" "sale price of item" "final sale price of item" "prorated amount paid for item" "redemption date" "redemption amount" "redemption invoice item id" "refund invoice item id"
sale 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 1 0 df50bf8c-02c3-4f70-80c1-ba15eb687c7b Visa 1000 7280 7580 0 0 0 0 0
sale 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 1 0 df50bf8c-02c3-4f70-80c1-ba15eb687c7b Visa 1000 7280 7580 1995 2077.21153846 1995 274.038461538 0
sale 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 1 0 df50bf8c-02c3-4f70-80c1-ba15eb687c7b Visa 1000 7280 7580 1295 1348.36538462 1295 177.884615385 0
sale 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 1 0 df50bf8c-02c3-4f70-80c1-ba15eb687c7b Visa 1000 7280 7580 1995 2077.21153846 1995 274.038461538 0
sale 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 1 0 df50bf8c-02c3-4f70-80c1-ba15eb687c7b Visa 1000 7280 7580 1995 2077.21153846 1995 274.038461538 0
sale 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 1 0 df50bf8c-02c3-4f70-80c1-ba15eb687c7b Visa 1000 7280 7580 0 0 0 0 0
refund 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 0 0 69105996-1617-45e6-b18d-eaf3cb8dc27b Visa -1000 -1000 7580 0 0 0 0 0 fa3b2156-3b30-4da9-9de9-b20c409e9e4d
refund 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 0 0 69105996-1617-45e6-b18d-eaf3cb8dc27b Visa -1000 -1000 7580 1995 2077.21153846 -274.038461538 -274.038461538 0 fa3b2156-3b30-4da9-9de9-b20c409e9e4d
refund 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 0 0 69105996-1617-45e6-b18d-eaf3cb8dc27b Visa -1000 -1000 7580 1295 1348.36538462 -177.884615385 -177.884615385 0 fa3b2156-3b30-4da9-9de9-b20c409e9e4d
refund 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 0 0 69105996-1617-45e6-b18d-eaf3cb8dc27b Visa -1000 -1000 7580 1995 2077.21153846 -274.038461538 -274.038461538 0 fa3b2156-3b30-4da9-9de9-b20c409e9e4d
refund 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 0 0 69105996-1617-45e6-b18d-eaf3cb8dc27b Visa -1000 -1000 7580 1995 2077.21153846 -274.038461538 -274.038461538 0 fa3b2156-3b30-4da9-9de9-b20c409e9e4d
refund 4178908 d587d6cc-621e-4cdc-bb87-22edb0753b64 Service 2 0 0 69105996-1617-45e6-b18d-eaf3cb8dc27b Visa -1000 -1000 7580 0 0 0 0 0 fa3b2156-3b30-4da9-9de9-b20c409e9e4d

Scenario 4: A guest buys a package, partially redeems it, and refunds the rest. Tips:

  • Consider the distinct value among these fields "amount paid for package", "package final sale price", "package sale price" as these will duplicate across item and payment level (populated at Package level).
  • Consider the distinct value among these fields "package item price", "sale price of item", "final sale price of item", and "prorated amount paid for item" as these will duplicate across payment level (populated at package and item level).
"Record Type" "package name" "package version id" "item type code" "Unit item type code" "quantity" "quantity redeemed" "transaction id" "payment type" "payment option type" "amount paid for package" "package final sale price" "package sale price" "package item price" "sale price of item" "final sale price of item" "prorated amount paid for item" "redemption date" "redemption amount" "redemption invoice item id" "refund invoice item id"
sale 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 0 e810a4d8-bad9-4b30-888c-f6d5eb660de1 Visa 1150 2500 3000 0 0 0 0 0
sale 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 0 73160afa-ec4a-4760-954d-8f9f8e151a2c Visa 1350 2500 3000 0 0 0 0 0
sale 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 0 e810a4d8-bad9-4b30-888c-f6d5eb660de1 Visa 1150 2500 3000 2500 3000 2500 1150 0
sale 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 0 73160afa-ec4a-4760-954d-8f9f8e151a2c Visa 1350 2500 3000 2500 3000 2500 1350 0
sale 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 0 e810a4d8-bad9-4b30-888c-f6d5eb660de1 Visa 1150 2500 3000 0 0 0 0 0
sale 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 0 73160afa-ec4a-4760-954d-8f9f8e151a2c Visa 1350 2500 3000 0 0 0 0 0
refund 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 0 0 eddb2cfc-d36f-475e-9c8d-4630fee38659 Visa -1150 -1150 3000 0 0 0 0 0 4af4486b-3688-41d5-97f8-dd9c3ab6dd39
refund 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 0 0 eddb2cfc-d36f-475e-9c8d-4630fee38659 Visa -1150 -1150 3000 2500 3000 -1150 -1150 0 4af4486b-3688-41d5-97f8-dd9c3ab6dd39
refund 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 2 eddb2cfc-d36f-475e-9c8d-4630fee38659 Visa -1150 -1150 3000 0 0 0 0 0 4af4486b-3688-41d5-97f8-dd9c3ab6dd39
redemption 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 1 e810a4d8-bad9-4b30-888c-f6d5eb660de1 Visa 1150 2500 3000 0 0 0 0 09-09-2015 20:00:00.00 0 0e5bf5e8-8db4-475b-802b-d15efef724bf
redemption 1496159 896b9e88-5a72-42da-a109-a785f4f3735d Service 2 1 1 73160afa-ec4a-4760-954d-8f9f8e151a2c Visa 1350 2500 3000 0 0 0 0 09-09-2015 20:00:00.00 0 0e5bf5e8-8db4-475b-802b-d15efef724bf

For value:

Field Value Type Primary Key
"organization name" varchar(512) NO
"organization account name" varchar(256) NO
"package sale center name" varchar(128) NO
"package sale center zone name" varchar(512) NO
"package sale center company name" varchar(128) NO
"payment center name" varchar(128) NO
"payment center zone name" varchar(512) NO
"package redemption center" varchar(4096) NO
"package redemption center zone" varchar(4096) NO
"user id" varchar(36) NO
"guest first name" varchar(160) NO
"guest last name" varchar(256) NO
"guest middle name" varchar(160) NO
"guest address 1" varchar(512) NO
"guest address 2" varchar(512) NO
"guest city" varchar(128) NO
"guest zipcode" varchar(128) NO
"guest type name" varchar(128) NO
"guest email" varchar(256) NO
"guest mobile phone" varchar(64) NO
"guest home phone" varchar(64) NO
"guest phone code" varchar(64) NO
"guest code" varchar(128) NO
"guest gender" varchar(128) NO
"guest state" varchar(4096) NO
"guest base center" varchar(4096) NO
"guest country name" varchar(4096) NO
"is guest inactive" boolean NO
"guest tags" varchar(65535) NO
"service name" varchar(512) NO
"service length" integer NO
"service category" varchar(256) NO
"service parent category" varchar(256) NO
"service has variant" varchar(14) NO
"service is variant" varchar(14) NO
"service businessunit" varchar(200) NO
"is service inactive" boolean NO
"service tags" varchar(65535) NO
"product name" varchar(256) NO
"product category" varchar(256) NO
"product parent category" varchar(256) NO
"product business unit" varchar(800) NO
"product has variant" boolean NO
"is product inactive" boolean NO
"product tags" varchar(65535) NO
"class name" varchar(1024) NO
"is workshop" boolean NO
"class length" integer NO
"class category" varchar(256) NO
"class parent category" varchar(256) NO
"class businessunit" varchar(200) NO
"is class inactive" boolean NO
"class tags" varchar(65535) NO
"package name" varchar(1024) NO
"package type" varchar(14) NO
"package category" varchar(200) NO
"package businessunit" varchar(200) NO
"is package inactive" boolean NO
"package tags" varchar(65535) NO
"package id" varchar(36) NO
"package version id" varchar(36) NO
"package code" varchar(128) NO
"item type code" varchar(100) NO
"package start date" timestamp NO
"package end date" timestamp NO
"template package versionid" varchar(36) NO
"business unit" varchar(800) NO
"package sale by employee first name" varchar(160) NO
"package sale by employee last name" varchar(256) NO
"package sale by employee code" varchar(128) NO
"package sale by employee - code" varchar(128) NO
"package sale by employee job name" varchar(1020) NO
"package sale by employee job code" varchar(512) NO
"package sale by employee additional field 1" varchar(8000) NO
"package sale by employee additional field 2" varchar(8000) NO
"item sale by employee first name" varchar(160) NO
"item sale by employee last name" varchar(256) NO
"item sale by employee code" varchar(128) NO
"item sale by employee - code" varchar(128) NO
"item sale by employee job name" varchar(1020) NO
"item sale by employee job code" varchar(512) NO
"item sale by employee additional field 1" varchar(8000) NO
"item sale by employee additional field 2" varchar(8000) NO
"is center franchise" boolean NO
"center cst number" varchar(80) NO
"center tin number" varchar(80) NO
"center tot number" varchar(80) NO
"center service tax number" varchar(80) NO
"center vat number" varchar(80) NO
"center luxary tax number" varchar(80) NO
"is custom package" boolean NO
"minutes to add" integer NO
"brand name" varchar(512) NO
"package sale center code" varchar(40) NO
"payment center code" varchar(40) NO
"package redemption center code" varchar(40) NO
factsegmentwid bigint NO
factsegmentid bigint NO
"unit item type code" integer NO
"record type" integer NO
"package grace period" timestamp NO
quantity integer NO
"quantity redeemed" integer NO
"package sale price" float8 NO
"package discount" float8 NO
"package tax" float8 NO
"package final sale price" float8 NO
"package sale liability" float8 NO
"package irr" float8 NO
"amount paid for package" float8 NO
"amount paid for item" float8 NO
"tax paid for package" float8 NO
"tax paid for item" float8 NO
"adjusted amount paid for package" float8 NO
"adjusted amount paid for item" float8 NO
"adjusted tax paid for package" float8 NO
"adjusted tax paid for item" float8 NO
suspense float8 NO
"payment date time in center" timestamp NO
"payment date in center" date NO
"sale date time in center" timestamp NO
"sale date in center" date NO
"closed date time in center" timestamp NO
"closed date in center" date NO
"created date time in center" timestamp NO
"created date in center" date NO
"package item sale price" float8 NO
"package item final sale price" float8 NO
"package invoice id" varchar(36) NO
"package invoice item id" varchar(36) NO
"invoice status" varchar(100) NO
transactionid varchar(36) NO
"payment option type" varchar(200) NO
"package payment type" varchar(200) NO
"package invoice no" varchar(320) NO
"redemption date" timestamp NO
redeemedinvoiceitemid varchar(36) NO
itemdiscount float8 NO
unititemdiscount varchar(256) NO
itemlistprice float8 NO
approvalnumber varchar(512) NO
creditcardlastfourdigits varchar(256) NO
"refund invoice id" varchar(36) NO
"refund invoice item id" varchar(36) NO
"total refund value" float8 NO
"product category code" varchar(256) NO
"product parent category code" varchar(256) NO
"package benefit product tag" varchar(2048) NO
"service category code" varchar(256) NO
"service parent category code" varchar(256) NO
"package benefit service tag" varchar(2048) NO
isrevenuerecognized boolean NO
isfirstpaymentonpackage boolean NO
itemlevelapportionfactor float8 NO
"class category code" varchar(256) NO
"class parent category code" varchar(256) NO
"package benefit class tag" varchar(2048) NO
"benefit refund quantity" integer NO
etlcreatedby bigint NO
etlcreateddate timestamp NO
podname varchar(200) NO
groupid bigint NO
Was this article helpful?
Your feedback helps us improve our documentation.