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.