Cash Register Fact Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Stores cash register closure records including cash amounts, credit card totals, adjustments, deposits, petty cash, and bank deposit details for each closure event.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factcashregisterwid | BIGINT IDENTITY | No | Surrogate primary key (auto-generated) |
| factcashregisterid | INTEGER | Yes | Source system identifier for the cash register fact |
| closureno | INTEGER | Yes | Closure sequence number |
| closureid | VARCHAR(36) | Yes | Unique identifier (GUID) of the closure |
| cashregisterwid | BIGINT | Yes | Foreign key to the cash register dimension |
| centerwid | BIGINT | Yes | Foreign key to the center dimension |
| closuredate | TIMESTAMP | Yes | Date and time of the register closure |
| cashinregister | NUMERIC(19,4) | Yes | Cash amount in the register at closure |
| cc | NUMERIC(19,4) | Yes | Credit card total at closure |
| checks | NUMERIC(19,4) | Yes | Checks total at closure |
| adjustments | NUMERIC(19,4) | Yes | Cash adjustment amount |
| adjustmentnotes | VARCHAR(8000) | Yes | Notes explaining the adjustments |
| deposit | NUMERIC(19,4) | Yes | Deposit amount |
| userwid | BIGINT | Yes | Foreign key to the user who performed the closure |
| ccadjustments | NUMERIC(19,4) | Yes | Credit card adjustment amount |
| ccadjustmentsnotes | VARCHAR(8000) | Yes | Notes explaining the credit card adjustments |
| bankname | VARCHAR(200) | Yes | Name of the bank for the deposit |
| closuretype | CHAR(4) | Yes | Type of closure |
| topettycash | NUMERIC(19,4) | Yes | Amount allocated to petty cash |
| notes | VARCHAR(32000) | Yes | General notes on the closure |
| cashadded | NUMERIC(19,4) | Yes | Cash added to the register |
| cashpaid | NUMERIC(19,4) | Yes | Cash paid out from the register |
| cashtransferred | NUMERIC(19,4) | Yes | Cash transferred between registers |
| cashbackamount | NUMERIC(19,4) | Yes | Cashback amount given |
| cashinprevregisterclosure | NUMERIC(19,4) | Yes | Cash remaining from the previous register closure |
| podid | INTEGER | Yes | Pod identifier for multi-tenant partitioning |
| void | BOOLEAN | Yes | Indicates if the record is voided |
| custom | FLOAT | Yes | Custom payment amount at closure |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factcashregisterwid
Foreign Keys
| Column | References |
|---|---|
| cashregisterwid | Bi_DimCashRegister.cashregisterwid |
| centerwid | Bi_DimCenter.centerwid |
| userwid | Bi_DimUser.userwid |
Enumerator Values
| Column | Values |
|---|---|
| void | true = Voided, false = Active |
| closuretype | S = Standard P = Partial F = Final |
Was this article helpful?
Your feedback helps us improve our documentation.