Cash register fact table
Bi_FactCashRegister
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
AdjustmentNotes | VARCHAR(8000) | Notes entered by the employee corresponding to the adjustments field. | |||
Adjustments | numeric(19,4) | Difference between the expected cash collection calculated by Zenoti and the actual cash collection entered by the employee. | |||
BankName | VARCHAR(200) | Name of the bank in which the amount is deposited. | |||
CashAdded | numeric(19,4) | Cash added to the corresponding cash register after previous register closure by using the Manage Cash window in Core. | |||
CashBackAmount | numeric(19,4) | Cash given as cashback for credit card payments by using the Cashback field in POS. Usually, this is the extra amount paid by the guest by using a credit card, so that they can provide a tip to the provider with cash. | |||
CashInPrevRegisterClosure | numeric(19,4) | Day's opening cash balance in the register. This is the closing balance from the previous register closure. Depending on core settings, this field may or may not include the Tips and SSG amounts. | |||
CashInRegister | numeric(19,4) | Expected cash amount in the register at the time of register closure. Depending on core settings, this field may or may not include the Tips and SSG amounts. | |||
CashPaid | numeric(19,4) | Cash paid out to employees from the corresponding cash register by using the Manage Cash window in Core. | |||
CashRegisterwid | bigint | A unique identifier generated for the Cash Register.(Bi_DimCashRegister) | Bi_DimCashRegister CashRegisterwid | ||
CashTransferred | numeric(19,4) | Cash transferred from the corresponding cash register to another register by using the Manage Cash window in Core. | |||
CC | numeric(19,4) | Total invoice amount collected via card payments. | |||
CCAdjustments | numeric(19,4) | Difference in the credit card collection calculated by Zenoti and the actual credit card collection entered by the employee. | |||
CCAdjustmentsNotes | VARCHAR(8000) | Notes entered by the employee corresponding to the cc adjustments field. | |||
Centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCenter). | Bi_DimCenter centerwid | ||
Checks | numeric(19,4) | Total invoice amount collected by check payments. | |||
ClosureDate | TIMESTAMP | Date and time at which the register is closed. | |||
ClosureId | VARCHAR(36) | Unique identifier associated with the cash register closure number. | |||
ClosureNo | INT | Unique value that is generated every time a cash register is closed. | |||
ClosureType | CHAR(4) | Displays a static value: S. | |||
custom | float | Amount collected through custom payments | |||
Deposit | numeric(19,4) | Amount deposited in the bank at the end of the day. | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
FactCashRegisterId | INT | A unique identifier for each record generated in the fact table. | |||
FactCashRegisterwid | bigint | A unique identifier for each record generated in the fact table. Primary key | Yes | ||
Notes | VARCHAR(32000) | Comments entered by the employee on the Close Payment screen while closing the register. | |||
OrganizationId | VARCHAR(36) | A code that uniquely identifies an Organization | Bi_DimCenter OrganizationId | ||
PODID | INT | Internal to the ETL, says from which POD data is being synced the table | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
ToPettyCash | numeric(19,4) | Cash converted from business cash to petty cash. Petty cash is typically used for expenses such as buying coffee or lunch for a guest. | |||
userwid | bigint | A unique identifier for the guest, generated in User dimension(Bi_DimUser). | Bi_Dimuser userwid | ||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||