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 idreferences DimCashRegistercenter name,center wid,Center Codereferences DimCenteremployee first name,employee - codereferences 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.