Skip to main content

Cash register fact table

TableName

Field

Field Type

Description

PrimaryKey

MappedDimensionTable

DimensionTableField

Bi_FactCashRegister_s3

FactCashRegisterId

INT

A unique identifier for each record generated in the fact table.

Yes

Bi_FactCashRegister_s3

ClosureNo

INT

Unique value that is generated every time a cash register is closed.

Bi_FactCashRegister_s3

ClosureId

VARCHAR(36)

Unique identifier associated with the cash register closure number.

Bi_FactCashRegister_s3

CashRegisterId

VARCHAR(36)

A unique identifier generated for the Cash Register.(Bi_DimCashRegister)

Bi_DimCashRegister_s3

CashRegisterId

Bi_FactCashRegister_s3

CenterId

VARCHAR(36)

A unique identifier for the center, generated in Centre dimension(Bi_DimCenter).

Bi_DimCenter_s3

centerid

Bi_FactCashRegister_s3

ClosureDate

TIMESTAMP

Date and time at which the register is closed.

Bi_FactCashRegister_s3

CashInRegister

DECIMAL(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.

Bi_FactCashRegister_s3

CC

DECIMAL(19,4)

Total invoice amount collected via card payments.

Bi_FactCashRegister_s3

Checks

DECIMAL(19,4)

Total invoice amount collected by check payments.

Bi_FactCashRegister_s3

Adjustments

DECIMAL(19,4)

Difference between the expected cash collection calculated by Zenoti and the actual cash collection entered by the employee.

Bi_FactCashRegister_s3

AdjustmentNotes

NVARCHAR(8000)

Notes entered by the employee corresponding to the adjustments field.

Bi_FactCashRegister_s3

Deposit

DECIMAL(19,4)

Amount deposited in the bank at the end of the day.

Bi_FactCashRegister_s3

userid

VARCHAR(36)

A unique identifier for the guest, generated in User dimension(Bi_DimUser).

Bi_Dimuser_s3

userid

Bi_FactCashRegister_s3

CCAdjustments

DECIMAL(19,4)

Difference in the credit card collection calculated by Zenoti and the actual credit card collection entered by the employee.

Bi_FactCashRegister_s3

CCAdjustmentsNotes

NVARCHAR(8000)

Notes entered by the employee corresponding to the cc adjustments field.

Bi_FactCashRegister_s3

BankName

NVARCHAR(200)

Name of the bank in which the amount is deposited.

Bi_FactCashRegister_s3

ClosureType

CHAR(4)

Displays a static value: S.

Bi_FactCashRegister_s3

ToPettyCash

DECIMAL(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.

Bi_FactCashRegister_s3

Notes

NVARCHAR(65535)

Comments entered by the employee on the Close Payment screen while closing the register.

Bi_FactCashRegister_s3

CashAdded

DECIMAL(19,4)

Cash added to the corresponding cash register after previous register closure by using the Manage Cash window in Core.

Bi_FactCashRegister_s3

CashPaid

DECIMAL(19,4)

Cash paid out to employees from the corresponding cash register by using the Manage Cash window in Core.

Bi_FactCashRegister_s3

CashTransferred

DECIMAL(19,4)

Cash transferred from the corresponding cash register to another register by using the Manage Cash window in Core.

Bi_FactCashRegister_s3

CashBackAmount

DECIMAL(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.

Bi_FactCashRegister_s3

CashInPrevRegisterClosure

DECIMAL(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.

Bi_FactCashRegister_s3

PodName

VARCHAR(20)

Internal to the ETL, says from which POD data is being synced the table

Bi_FactCashRegister_s3

etlCreatedDate

TIMESTAMP

Latest timestamp at which the corresponding record was either inserted or updated in this table.

Bi_FactCashRegister_s3

Void

BOOLEAN

Indicates if the row should be inserted or deleted. 1- delete, 0-insert

Bi_FactCashRegister_s3

OrganizationId

VARCHAR(36)

A code that uniquely identifies an Organization

Bi_DimCenter_s3

OrganizationId

Bi_FactCashRegister_s3

groupid

BIGINT

Internal to Zenoti. Used for data processing.