ZenotiHelp

Cashregiserv2 Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 4 min readGuide

Consolidated fact table storing cash register closure details including cash balances, payment adjustments, deposits, and associated employee and center information.

Columns

Column Name Data Type Nullable Description
cash register id VARCHAR(36) YES Unique identifier for the cash register.
cash register code VARCHAR(128) YES Code assigned to the cash register.
cash register name VARCHAR(1024) YES Display name of the cash register.
cash register description VARCHAR(4096) YES Detailed description of the cash register.
is cash register active BOOLEAN YES Indicates whether the cash register is currently active.
is cash register void BOOLEAN YES Indicates whether the cash register has been voided.
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 geographic zone. Sourced from DimCenter.zone name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center name.
center time zone VARCHAR(4096) 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 name of the center. Sourced from DimCenter.center state name.
country name VARCHAR(4096) YES Country name of the center. Sourced from DimCenter.country name.
operating center BOOLEAN YES Indicates whether the center is an operating center. Sourced from DimCenter.operating center.
center wid BIGINT YES Warehouse identifier for the center. Sourced from DimCenter.center wid.
fact cash register pk INTEGER YES Primary key for the cash register fact record.
cash register closure no INTEGER YES Sequential closure number for the cash register.
closure id VARCHAR(36) YES Unique identifier for the closure event.
closure date TIMESTAMP WITHOUT TIME ZONE YES Date and time when the cash register was closed.
cash in register NUMERIC(19,4) YES Amount of cash in the register at closure.
cc NUMERIC(19,4) YES Credit card total amount at closure.
checks NUMERIC(19,4) YES Total checks amount at closure.
adjustments NUMERIC(19,4) YES Cash adjustments amount.
adjustments notes VARCHAR(8000) YES Notes describing the cash adjustments.
deposit NUMERIC(19,4) YES Deposit amount at closure.
cc adjustments NUMERIC(19,4) YES Credit card adjustments amount.
cc adjustment notes VARCHAR(8000) YES Notes describing the credit card adjustments.
bank name VARCHAR(200) YES Name of the bank associated with the deposit.
closure type CHAR(4) YES Type of closure (e.g., day closure, shift closure).
to petty cash NUMERIC(19,4) YES Amount transferred to petty cash.
notes VARCHAR(32000) YES General notes for the closure.
cash added NUMERIC(19,4) YES Amount of cash added to the register.
cash paid NUMERIC(19,4) YES Amount of cash paid out from the register.
cash transferred NUMERIC(19,4) YES Amount of cash transferred between registers.
cashback amount NUMERIC(19,4) YES Cashback amount given at the register.
cash in previous register closure after adjustments NUMERIC(19,4) YES Cash balance from the previous closure after adjustments.
employee first name VARCHAR(256) YES First name of the employee who closed the register. Sourced from DimEmployee.employee first name.
employee last name VARCHAR(256) YES Last name of the employee. Sourced from DimEmployee.employee last name.
employee middle name VARCHAR(256) YES Middle name of the employee. Sourced from DimEmployee.employee middle name.
employee mobile phone VARCHAR(64) YES Mobile phone number of the employee. Sourced from DimEmployee.employee mobile phone.
employee - code VARCHAR(128) YES Employee code identifier. Sourced from DimEmployee.employee - code.
employee gender VARCHAR(14) YES Gender of the employee. Sourced from DimEmployee.employee gender.
employee job name VARCHAR(1020) YES Job title of the employee. Sourced from DimEmployee.employee job name.
employee job code VARCHAR(8000) YES Job code of the employee. Sourced from DimEmployee.employee job code.
is employee inactive BOOLEAN YES Indicates whether the employee is inactive. Sourced from DimEmployee.is employee inactive.
employee tags VARCHAR(65535) YES Tags associated with the employee. Sourced from DimEmployee.employee tags.
employee start date TIMESTAMP WITHOUT TIME ZONE YES Start date of the employee. Sourced from DimEmployee.employee start date.
employee last date TIMESTAMP WITHOUT TIME ZONE YES Last working date of the employee. Sourced from DimEmployee.employee last date.
minutes to add INTEGER YES Minute offset to convert UTC to center local time.
custom FLOAT YES Custom numeric field for additional data.
payment type id VARCHAR(36) YES Unique identifier for the payment type.
Actual NUMERIC(19,4) YES Actual cash amount recorded.
Day Closure CCAdjustments NUMERIC(19,4) YES Day closure credit card adjustments amount.
Center Code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.Center Code.

Primary Key

fact cash register pk -- Integer surrogate key uniquely identifying each cash register fact record.

Foreign Keys

  • center wid references DimCenter
  • payment type id references DimPaymentType
  • groupid references the tenant/data group

Enumerator Values

Column Name Known Values
closure type CHAR(4)

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.