Cash Register V2 Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Stores cash register closure transaction details including cash, credit card, check amounts, adjustments, and deposit information per closure event.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factcashregisterwid | BIGINT IDENTITY | NOT NULL | Surrogate key for the cash register fact record |
| factcashregisterid | INTEGER | NULL | Business/natural key for the cash register fact |
| closureno | INTEGER | NULL | Sequential closure number |
| closureid | VARCHAR(36) | NULL | Unique identifier (GUID) for the closure |
| cashregisterwid | BIGINT | NULL | Foreign key to the cash register dimension |
| centerwid | BIGINT | NULL | Foreign key to the center dimension |
| closuredate | TIMESTAMP | NULL | Date and time when the register was closed |
| cashinregister | NUMERIC(19,4) | NULL | Total cash amount in the register at closure |
| cc | NUMERIC(19,4) | NULL | Total credit card amount collected |
| checks | NUMERIC(19,4) | NULL | Total check amount collected |
| adjustments | NUMERIC(19,4) | NULL | Cash adjustment amount applied |
| adjustmentnotes | VARCHAR(8000) | NULL | Notes describing cash adjustments |
| deposit | NUMERIC(19,4) | NULL | Deposit amount made to the bank |
| userwid | BIGINT | NULL | Foreign key to the user who performed the closure |
| ccadjustments | NUMERIC(19,4) | NULL | Credit card adjustment amount |
| ccadjustmentsnotes | VARCHAR(8000) | NULL | Notes describing credit card adjustments |
| bankname | VARCHAR(200) | NULL | Name of the bank for the deposit |
| closuretype | CHAR(4) | NULL | Type of closure (e.g., day close, shift close) |
| topettycash | NUMERIC(19,4) | NULL | Amount transferred to petty cash |
| notes | VARCHAR(32000) | NULL | General notes for the closure |
| cashadded | NUMERIC(19,4) | NULL | Cash added to the register |
| cashpaid | NUMERIC(19,4) | NULL | Cash paid out from the register |
| cashtransferred | NUMERIC(19,4) | NULL | Cash transferred between registers |
| cashbackamount | NUMERIC(19,4) | NULL | Cash back amount given to customers |
| cashinprevregisterclosure | NUMERIC(19,4) | NULL | Cash carried over from the previous register closure |
| void | BOOLEAN | NULL | Indicates whether the record has been voided |
| custom | FLOAT | NULL | Custom payment type amount |
| PaymentTypeID | VARCHAR(36) | NULL | Unique identifier (GUID) for the payment type |
| Actual | NUMERIC(19,4) | NULL | Actual counted amount in the register |
| DayClosureCCAdjustments | NUMERIC(19,4) | NULL | Day-level closure credit card adjustments |
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 |
|---|---|
| closuretype | S = Standard P = Partial F = Final |
| void | FALSE = Active, TRUE = Voided |
Was this article helpful?
Your feedback helps us improve our documentation.