Register Summery Consolidated
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Consolidated summary table storing daily cash register balances and payment method totals per center, including cash, credit card, check, tips, and adjustments.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| 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. |
| ct date | DATE | YES | Reporting date for the register summary. |
| cash resgister name | VARCHAR(1024) | YES | Name of the cash register. |
| cash | FLOAT | YES | Total cash amount collected. |
| cc | FLOAT | YES | Total credit card amount collected. |
| check | FLOAT | YES | Total check amount collected. |
| opening balance | FLOAT | YES | Opening balance of the register for the day. |
| closing balance | FLOAT | YES | Closing balance of the register for the day. |
| deposit amount | FLOAT | YES | Total deposit amount. |
| tip amount | FLOAT | YES | Total tip amount collected. |
| custom | FLOAT | YES | Total amount from custom payment methods. |
| cashback amount | FLOAT | YES | Total cashback amount given. |
| cash adjustments | FLOAT | YES | Total cash adjustments made. |
| cc adjustments | FLOAT | YES | Total credit card adjustments made. |
Primary Key
No explicit primary key defined. Composite of ct date, center name, and cash resgister name uniquely identifies a record.
Foreign Keys
center namereferences DimCenterzone namereferences DimZoneorganization account namereferences DimOrganization
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.