ZenotiHelp

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.