Cash register dimension table
bi_dimcashregister
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | Flag that indicates whether the cash register is active. - True: Cash register is active - False: Cash register is inactive | boolean | |
cashregisterid | A unique identifier for the cash register associated with the petty cash transaction. This is generated in Analytics, it does not exist in the core system. | varchar ( 36 ) | |
cashregisterpk | unique identifier for the row in core data base | numeric | |
cashregisterwid | unique identifier for the row | bigint | |
centerid | unique identifer for the center. | varchar ( 36 ) | |
code | Unique code associated with the cash register. This is created while adding the cash register. | varchar ( 128 ) | |
description | Brief description about the cash register. This is a non-mandatory field that is filled up while adding the cash register. | varchar ( 4096 ) | |
enableinvoicemirroring | integer | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
lastupdated | last updated time of cash register | timestamp without time zone | |
name | Name of the cash register associated with the register closure. | varchar ( 1024 ) | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
updatedby | userid of employee who updated the cash register | varchar ( 36 ) | |
void | Flag that indicates whether the cash register is valid. - True: Cash register is void - False: Cash register is valid | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |