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 widreferences DimCenterpayment type idreferences DimPaymentTypegroupidreferences 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.