ZenotiHelp

Scheduled Collections Consolidated

ZTZenoti Docs Team Updated April 10, 2026 5 min readGuide

Consolidated table storing scheduled payment collection records including collection status, amounts, guest details, and sale-by employee information.

Columns

Column Name Data Type Nullable Description
scheduled collection wid BIGINT YES Warehouse ID for the scheduled collection record.
scheduled payment type VARCHAR(200) YES Type of scheduled payment (e.g., Membership, Package).
payment option type VARCHAR(200) YES Payment option used for the collection.
collection amount DOUBLE PRECISION YES Expected collection amount.
collection date in center DATE YES Scheduled date for the collection in center local time.
collected amount DOUBLE PRECISION YES Actual amount collected.
collected date time in ccenter TIMESTAMP WITHOUT TIME ZONE YES Date and time when the amount was collected in center local time.
collected date in center DATE YES Date when the amount was collected in center local time.
invoice id VARCHAR(36) YES Unique identifier of the associated invoice.
last tried on DATE YES Date of the last collection attempt.
next try at DATE YES Date of the next scheduled collection attempt.
created date time in center TIMESTAMP WITHOUT TIME ZONE YES Date and time when the record was created in center local time.
created date in center DATE YES Date when the record was created in center local time.
collections status VARCHAR(200) YES Current status of the collection (e.g., Collected, Pending, Failed).
collection source VARCHAR(200) YES Source or channel of the collection.
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.
zone name VARCHAR(800) YES Name of the zone. Sourced from DimZone.zone_name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center_name.
center city VARCHAR(128) YES City where the center is located. Sourced from DimCenter.center_city.
center zip VARCHAR(32) YES ZIP/postal code of the center. Sourced from DimCenter.center_zip.
center state name VARCHAR(4096) YES State where the center is located. Sourced from DimCenter.center_state_name.
country name VARCHAR(4096) YES Country where the center is located. Sourced from DimCenter.country_name.
operating center BOOLEAN YES Indicates whether the center is an operating center. Sourced from DimCenter.operating_center.
user wid BIGINT YES Warehouse ID of the guest. Sourced from DimUser.userwid.
user id VARCHAR(36) YES Unique identifier of the guest. Sourced from DimUser.userid.
guest first name VARCHAR(256) YES First name of the guest. Sourced from DimUser.firstname.
guest last name VARCHAR(256) YES Last name of the guest. Sourced from DimUser.lastname.
guest middle name VARCHAR(256) YES Middle name of the guest. Sourced from DimUser.middlename.
guest city VARCHAR(128) YES City of the guest. Sourced from DimUser.city.
guest zipcode VARCHAR(128) YES ZIP/postal code of the guest. Sourced from DimUser.zipcode.
guest type name VARCHAR(128) YES Type classification of the guest. Sourced from DimUser.usertypename.
guest email VARCHAR(512) YES Email address of the guest. Sourced from DimUser.email.
guest mobile phone VARCHAR(64) YES Mobile phone number of the guest. Sourced from DimUser.mobilephone.
guest phone code INTEGER YES Phone country code of the guest. Sourced from DimUser.phonecode.
guest gender VARCHAR(14) YES Gender of the guest. Sourced from DimUser.gender.
guest dob TIMESTAMP WITHOUT TIME ZONE YES Date of birth of the guest. Sourced from DimUser.dob.
referred by guestid VARCHAR(36) YES ID of the guest who referred this guest. Sourced from DimUser.referredby.
guest anniversary date TIMESTAMP WITHOUT TIME ZONE YES Anniversary date of the guest. Sourced from DimUser.anniversarydate.
guest state VARCHAR(4096) YES State of the guest. Sourced from DimUser.statedispname.
guest country name VARCHAR(4096) YES Country of the guest. Sourced from DimUser.countrydname.
is guest inactive BOOLEAN YES Indicates whether the guest is inactive. Sourced from DimUser.void.
guest tags VARCHAR(65535) YES Tags associated with the guest. Sourced from DimUser.usertags.
guest referral source VARCHAR(3200) YES Referral source of the guest. Sourced from DimUser.guestreferralsource.
invoice_no VARCHAR(40) YES Invoice number associated with the collection.
salebywid BIGINT YES Warehouse ID of the sale-by employee.
business unit VARCHAR(65535) YES Business unit associated with the collection.
invoice status VARCHAR(14) YES Status of the associated invoice (e.g., Closed, Open).
custompaymentname VARCHAR(800) YES Name of the custom payment method used.
considerinfinancials BOOLEAN YES Indicates whether this collection is considered in financial reporting.
minutes to add INTEGER YES Time zone offset in minutes to convert to center local time.
sale by employee wid BIGINT YES Warehouse ID of the sale-by employee. Sourced from DimEmployee.employee_wid.
sale by employee id VARCHAR(36) YES Unique identifier of the sale-by employee. Sourced from DimEmployee.employee_id.
sale by employee first name VARCHAR(256) YES First name of the sale-by employee. Sourced from DimEmployee.employee_first_name.
sale by employee last name VARCHAR(256) YES Last name of the sale-by employee. Sourced from DimEmployee.employee_last_name.
sale by employee middle name VARCHAR(256) YES Middle name of the sale-by employee. Sourced from DimEmployee.employee_middle_name.
sale by employee city VARCHAR(128) YES City of the sale-by employee. Sourced from DimEmployee.city.
sale by employee zipcode VARCHAR(128) YES ZIP/postal code of the sale-by employee. Sourced from DimEmployee.zipcode.
sale by employee type name VARCHAR(128) YES Type classification of the sale-by employee. Sourced from DimEmployee.usertypename.
sale by employee email VARCHAR(512) YES Email address of the sale-by employee. Sourced from DimEmployee.email.
sale by employee mobile phone VARCHAR(64) YES Mobile phone of the sale-by employee. Sourced from DimEmployee.mobilephone.
sale by employee phone code INTEGER YES Phone country code of the sale-by employee. Sourced from DimEmployee.phonecode.
sale by employee gender VARCHAR(14) YES Gender of the sale-by employee. Sourced from DimEmployee.gender.
sale by employee dob TIMESTAMP WITHOUT TIME ZONE YES Date of birth of the sale-by employee. Sourced from DimEmployee.dob.
sale by employee anniversary date TIMESTAMP WITHOUT TIME ZONE YES Anniversary date of the sale-by employee. Sourced from DimEmployee.anniversarydate.
sale by employee state VARCHAR(4096) YES State of the sale-by employee. Sourced from DimEmployee.statedispname.
sale by employee country name VARCHAR(4096) YES Country of the sale-by employee. Sourced from DimEmployee.countrydname.
is sale by employee inactive BOOLEAN YES Indicates whether the sale-by employee is inactive. Sourced from DimEmployee.void.
sale by employee tags VARCHAR(65535) YES Tags associated with the sale-by employee. Sourced from DimEmployee.usertags.
sale by employee job code VARCHAR(8000) YES Job code of the sale-by employee. Sourced from DimEmployee.jobcode.
sale by employee job name VARCHAR(1020) YES Job name of the sale-by employee. Sourced from DimEmployee.jobname.
Center Code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.center_code.

Primary Key

scheduled collection wid (BIGINT)

Foreign Keys

  • user wid / user id references DimUser (guest)
  • sale by employee wid / sale by employee id references DimEmployee
  • invoice id references FactInvoice

Enumerator Values

Column Name Known Values
scheduled payment type Membership, Package, and other scheduled payment types
collections status Collected, Pending, Failed, Cancelled
collection source Source channel values
invoice status Closed, Open
guest gender Male, Female, Other
sale by employee gender Male, Female, Other

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.