ZenotiHelp

Membership Dunning Consolidated

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Consolidated table storing membership recurring collection (dunning) records, tracking payment cycles, collection statuses, and guest membership details.

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.
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 time zone VARCHAR(128) YES Time zone of the center. Sourced from DimCenter.center_time_zone.
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.
center company name VARCHAR(200) YES Company name associated with the center. Sourced from DimCenter.center_company_name.
operating center BOOLEAN YES Indicates whether the center is an operating center. Sourced from DimCenter.operating_center.
center wid BIGINT YES Warehouse ID of the center. Sourced from DimCenter.center_wid.
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(160) 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(128) 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(256) 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 home phone VARCHAR(64) YES Home phone number of the guest. Sourced from DimUser.homephone.
guest phone code INTEGER YES Phone country code of the guest. Sourced from DimUser.phonecode.
guest code VARCHAR(128) YES Code assigned to the guest. Sourced from DimUser.usercode.
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.
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(1600) YES Referral source of the guest. Sourced from DimUser.guestreferralsource.
membership name VARCHAR(512) YES Name of the membership. Sourced from DimMembership.membership_name.
membership category VARCHAR(200) YES Category of the membership. Sourced from DimMembership.membership_category.
membership credit amount DOUBLE PRECISION YES Credit amount associated with the membership. Sourced from DimMembership.membership_credit_amount.
membership recurring VARCHAR(5) YES Indicates whether the membership is recurring (Yes/No). Sourced from DimMembership.membership_recurring.
membership type VARCHAR(16) YES Type of the membership. Sourced from DimMembership.membership_type.
membership tags VARCHAR(65535) YES Tags associated with the membership. Sourced from DimMembership.membership_tags.
membership start date TIMESTAMP WITHOUT TIME ZONE YES Start date of the membership.
membership end date TIMESTAMP WITHOUT TIME ZONE YES End date of the membership.
next collection date TIMESTAMP WITHOUT TIME ZONE YES Next scheduled collection date for the membership.
expected collection date in freeze period TIMESTAMP WITHOUT TIME ZONE YES Expected collection date during a freeze period.
last tried on TIMESTAMP WITHOUT TIME ZONE YES Date and time of the last collection attempt.
next try at TIMESTAMP WITHOUT TIME ZONE YES Date and time of the next collection attempt.
collection status VARCHAR(200) YES Current status of the collection cycle.
invoice id VARCHAR(36) YES Unique identifier of the associated invoice.
invoice item id VARCHAR(36) YES Unique identifier of the associated invoice item.
sale price DOUBLE PRECISION YES Sale price of the membership.
final sale price DOUBLE PRECISION YES Final sale price after adjustments.
discount DOUBLE PRECISION YES Discount applied to the membership.
tax DOUBLE PRECISION YES Tax amount on the membership.
collected date TIMESTAMP WITHOUT TIME ZONE YES Date and time when the amount was collected.
cycle number INTEGER YES Current cycle number in the recurring collection.
duration INTEGER YES Duration of the membership period.
duration type VARCHAR(200) YES Unit of duration (e.g., Days, Months, Years).
recurring collection pk BIGINT YES Primary key for the recurring collection record.
user membership id VARCHAR(36) YES Unique identifier of the user's membership.
record type VARCHAR(400) YES Type of dunning record.
group invoice id VARCHAR(36) YES Group invoice identifier for bundled memberships.
Center Code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.center_code.
invoice no VARCHAR(160) YES Invoice number associated with the dunning record.
collection initiated date TIMESTAMP YES Date and time when the collection was initiated.
no of tries INTEGER YES Number of collection attempts made.
collection mode VARCHAR(400) YES Mode of collection (e.g., Auto, Manual).

Primary Key

recurring collection pk (BIGINT)

Foreign Keys

  • user wid / user id references DimUser (guest)
  • center wid references DimCenter
  • invoice id / invoice item id references FactInvoice / FactInvoiceItem
  • Membership columns reference DimMembership
  • user membership id references user membership records

Enumerator Values

Column Name Known Values
collection status Collected, Pending, Failed, Cancelled
duration type Days, Months, Years
membership recurring Yes, No
membership type Membership type values
guest gender Male, Female, Other
record type Record type values
collection mode Auto, Manual

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.