dim_cash_register


Description

A physical or virtual point-of-sale register, used to process sales and issue receipts.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
cash_register_id int8 19 null
fct_pos_saleposition.cash_register_id fct_pos_saleposition_cash_register_id_fkey R

The primary key of this table.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id dim_cash_register_organization_unit_id_fkey R

The gym location this cash register belongs to.
name varchar 256 √ null

Human-readable name of the cash register. Unique per location.
description varchar 256 √ null

Optional description of the cash register.
status varchar 256 √ null

Current lifecycle status: CREATED, VALIDATION, OPEN, DEACTIVATED, or DEACTIVATED_BY_SYSTEM.
external_register_id varchar 256 √ null

Machine-readable identifier of the register, used for fiscal compliance.
is_regulated bool 1 √ null

Whether the register is subject to fiscal regulation.
created_date timestamptz 35 √ null

Timestamp when the cash register was created.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation