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 idreferences DimUser (guest)sale by employee wid/sale by employee idreferences DimEmployeeinvoice idreferences 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.