ZenotiHelp

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 name references DimCenter
  • zone name references DimZone
  • organization account name references 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.