ZenotiHelp

Cash Register Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing cash register (point-of-sale terminal) configuration details per center, including activation status and invoice mirroring settings. Populated from the organization's POS (Point of Sale) configuration.

Columns

Column Name Data Type Nullable Description
cashregisterwid BIGINT IDENTITY No Surrogate warehouse key for the cash register dimension
cashregisterpk NUMERIC(19,0) Yes Source system primary key for the cash register
cashregisterid VARCHAR(36) Yes Natural unique identifier of the cash register
code VARCHAR(128) Yes Short code identifying the cash register
name VARCHAR(1024) Yes Display name of the cash register
description VARCHAR(4096) Yes Detailed description of the cash register
active BOOLEAN Yes Flag indicating whether the cash register is currently active
centerid VARCHAR(36) Yes Identifier of the center the cash register belongs to
void BOOLEAN Yes Soft-delete flag; TRUE means the record is logically deleted
lastupdated TIMESTAMP Yes Timestamp of the last update in the source system
updatedby VARCHAR(36) Yes Identifier of the user who last updated the record in the source system
enableinvoicemirroring INTEGER Yes Flag indicating whether invoice mirroring is enabled for this register

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

cashregisterwid

Foreign Keys

Column References
centerid Bi_DimCenter.centerid
updatedby Bi_DimEmployee / Bi_DimUser

Enumerator Values

Column Values
enableinvoicemirroring 0 = Disabled
1 = Enabled
Was this article helpful?
Your feedback helps us improve our documentation.