ZenotiHelp

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.