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 idreferences DimUser (guest)center widreferences DimCenterinvoice id/invoice item idreferences FactInvoice / FactInvoiceItem- Membership columns reference DimMembership
user membership idreferences 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.