Monthly Finance Summery Consolidated
ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide
Consolidated summary table storing monthly financial metrics per center including ticket counts, sales figures, discounts, refunds, and appointment statistics.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| center name | VARCHAR(256) | YES | Name of the center. Sourced from DimCenter.center_name. |
| zone name | VARCHAR(256) | YES | Name of the zone. Sourced from DimZone.zone_name. |
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| dt | DATE | YES | Reporting date for the financial summary. |
| invoicece source | VARCHAR(256) | YES | Source of the invoice (e.g., Center, Online). |
| employee hours | FLOAT | YES | Total employee hours worked. |
| male tickets | INTEGER | YES | Number of tickets for male guests. |
| female tickets | INTEGER | YES | Number of tickets for female guests. |
| unkonwn tickets | INTEGER | YES | Number of tickets for guests with unknown gender. |
| total tickets | INTEGER | YES | Total number of tickets across all genders. |
| total guest visits | INTEGER | YES | Total number of guest visits. |
| new guest tickets | INTEGER | YES | Number of tickets for new guests. |
| new guest visits | INTEGER | YES | Number of visits by new guests. |
| service sales | FLOAT | YES | Total service sales revenue. |
| service discount | FLOAT | YES | Total discount applied to services. |
| service refund value | FLOAT | YES | Total refund value for services. |
| product sales | FLOAT | YES | Total product sales revenue. |
| product discount | FLOAT | YES | Total discount applied to products. |
| product refund value | FLOAT | YES | Total refund value for products. |
| gift card sales | FLOAT | YES | Total gift card sales revenue. |
| gift card discount | FLOAT | YES | Total discount applied to gift cards. |
| gift card refund value | FLOAT | YES | Total refund value for gift cards. |
| day package sales | FLOAT | YES | Total day package sales revenue. |
| day package discount | FLOAT | YES | Total discount applied to day packages. |
| day package refund value | FLOAT | YES | Total refund value for day packages. |
| membership sales | FLOAT | YES | Total membership sales revenue. |
| membership discount | FLOAT | YES | Total discount applied to memberships. |
| membership refund value | FLOAT | YES | Total refund value for memberships. |
| package sales | FLOAT | YES | Total package sales revenue. |
| package discount | FLOAT | YES | Total discount applied to packages. |
| package refund value | FLOAT | YES | Total refund value for packages. |
| total sales | FLOAT | YES | Grand total of all sales. |
| total tax | FLOAT | YES | Total tax collected. |
| total discount | FLOAT | YES | Grand total of all discounts applied. |
| delete app count | INTEGER | YES | Count of deleted appointments. |
| redo app count | INTEGER | YES | Count of redo appointments. |
| look and walk app count | INTEGER | YES | Count of look-and-walk (walk-in) appointments. |
| cuts app count | INTEGER | YES | Count of cuts appointments. |
| cash added | FLOAT | YES | Total cash added to registers. |
| cash paid | FLOAT | YES | Total cash paid out from registers. |
| Production Hours | FLOAT | YES | Total production hours recorded. |
| male tickets excluding cn | INTEGER | YES | Male ticket count excluding credit notes. |
| female tickets excluding cn | INTEGER | YES | Female ticket count excluding credit notes. |
| unknown tickets excluding cn | INTEGER | YES | Unknown gender ticket count excluding credit notes. |
| new guest tickets excluding cn | INTEGER | YES | New guest ticket count excluding credit notes. |
| new guest visit excluding cn | INTEGER | YES | New guest visit count excluding credit notes. |
| total tickets excluding cn | INTEGER | YES | Total ticket count excluding credit notes. |
| total guest visits excluding cn | INTEGER | YES | Total guest visit count excluding credit notes. |
| redo source app count | INTEGER | YES | Count of redo source appointments. |
| service sales excluding cn | FLOAT | YES | Service sales excluding credit notes. |
| service discount excluding cn | FLOAT | YES | Service discount excluding credit notes. |
| total sales excluding cn | FLOAT | YES | Total sales excluding credit notes. |
| total tax excluding cn | FLOAT | YES | Total tax excluding credit notes. |
| total discount excluding cn | FLOAT | YES | Total discount excluding credit notes. |
| giftcard value | FLOAT | YES | Total gift card redemption value. |
| loyalty point redemption amount | FLOAT | YES | Total loyalty point redemption amount. |
| loyalty point redemption amount CN | FLOAT | YES | Loyalty point redemption amount on credit notes. |
Primary Key
No explicit primary key defined. Composite of dt, center name, and invoicece source uniquely identifies a record.
Foreign Keys
center namereferences DimCenterzone namereferences DimZoneorganization account namereferences DimOrganization
Enumerator Values
| Column Name | Known Values |
|---|---|
| invoicece source | Invoice source values (e.g., Center, Online) |
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.