ZenotiHelp

Cashregiser Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Consolidated fact table capturing cash register closure events including cash balances, credit card totals, adjustments, deposits, and associated employee and center details.

Columns

Column Name Data Type Nullable Description
cash register id VARCHAR(36) Yes Unique identifier (UUID) of the cash register.
cash register code VARCHAR(128) Yes Code assigned to the cash register.
cash register name VARCHAR(1024) Yes Name of the cash register.
cash register description VARCHAR(4096) Yes Description of the cash register.
is cash register active BOOLEAN Yes Indicates whether the cash register is active.
is cash register void BOOLEAN Yes Indicates whether the cash register is 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 Zone name of the center. 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 Timezone of the center. Sourced from DimCenter.time_zone.
center city VARCHAR(128) Yes City of the center. Sourced from DimCenter.city.
center zip VARCHAR(32) Yes Zip code of the center. Sourced from DimCenter.zip.
center state name VARCHAR(4096) Yes State of the center. Sourced from DimCenter.state_name.
country name VARCHAR(4096) Yes Country of the center. Sourced from DimCenter.country_name.
operating center BOOLEAN Yes Indicates whether the center is operating. 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 of 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 (UUID) of the closure event.
closure date TIMESTAMP Yes Date and time of the cash register closure.
cash in register NUMERIC(19,4) Yes Cash amount in the register at closure.
cc NUMERIC(19,4) Yes Credit card total amount.
checks NUMERIC(19,4) Yes Checks total amount.
adjustments NUMERIC(19,4) Yes Cash adjustments amount.
adjustments notes VARCHAR(8000) Yes Notes for cash adjustments.
deposit NUMERIC(19,4) Yes Deposit amount.
cc adjustments NUMERIC(19,4) Yes Credit card adjustments amount.
cc adjustment notes VARCHAR(8000) Yes Notes for credit card adjustments.
bank name VARCHAR(200) Yes Name of the bank for the deposit.
closure type CHAR(4) Yes Type of closure (e.g., EOD, Mid-day).
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 Cash added to the register.
cash paid NUMERIC(19,4) Yes Cash paid out from the register.
cash transferred NUMERIC(19,4) Yes Cash transferred between registers.
cashback amount NUMERIC(19,4) Yes Cashback amount given to customers.
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 performed the closure. Sourced from DimEmployee.first_name.
employee last name VARCHAR(256) Yes Last name of the employee. Sourced from DimEmployee.last_name.
employee middle name VARCHAR(256) Yes Middle name of the employee. Sourced from DimEmployee.middle_name.
employee mobile phone VARCHAR(64) Yes Mobile phone of the employee. Sourced from DimEmployee.mobile_phone.
employee - code VARCHAR(128) Yes Code of the employee. Sourced from DimEmployee.employee_code.
employee gender VARCHAR(14) Yes Gender of the employee. Sourced from DimEmployee.gender.
employee job name VARCHAR(1020) Yes Job title of the employee. Sourced from DimEmployee.job_name.
employee job code VARCHAR(8000) Yes Job code of the employee. Sourced from DimEmployee.job_code.
is employee inactive BOOLEAN Yes Indicates whether the employee is inactive. Sourced from DimEmployee.is_inactive.
employee tags VARCHAR(65535) Yes Tags associated with the employee. Sourced from DimEmployee.tags.
employee start date TIMESTAMP Yes Start date of the employee. Sourced from DimEmployee.start_date.
employee last date TIMESTAMP Yes Last active date of the employee. Sourced from DimEmployee.last_date.
minutes to add INTEGER Yes Timezone offset in minutes for the center.
custom FLOAT Yes Custom payment type amount.
factcashregisterwid BIGINT Yes Warehouse identifier for the cash register fact record.
factcashregisterid INTEGER Yes Cash register fact record identifier.
Center Code VARCHAR(40) Yes Code of the center. Sourced from DimCenter.center_code.

Primary Key

No explicit primary key is defined. closure id serves as the logical key. factcashregisterwid is used as the distribution key, and fact cash register pk / factcashregisterid serve as surrogate identifiers.

Foreign Keys

  • cash register id references DimCashRegister
  • center name, center wid, Center Code references DimCenter
  • employee first name, employee - code references DimEmployee (closure employee)

Enumerator Values

Column Name Known Values
closure type EOD (End of Day), MID (Mid-day), etc.
is cash register active true, false
is cash register void true, false
employee gender Male, Female, etc.

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.