Skip to main content

Cash register fact table v2

Bi_FactCashRegisterv2_s3

Field

Description

Field type

Primary key

Mapped Dimension table

Mapped Dimension field

FactCashRegisterId

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

INT

Y

ClosureNo

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

INT

ClosureId

Unique identifier associated with the cash register closure number.

VARCHAR(36)

CashRegisterId

A unique identifier generated for the Cash Register.

VARCHAR(36)

CenterId

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

VARCHAR(36)

ClosureDate

Date and time at which the register is closed.

TIMESTAMP

CashInRegister

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.

DECIMAL(19,4)

CC

Total invoice amount collected via card payments.

DECIMAL(19,4)

Checks

Total invoice amount collected by check payments.

DECIMAL(19,4)

Adjustments

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

DECIMAL(19,4)

AdjustmentNotes

Notes entered by the employee corresponding to the adjustments field

NVARCHAR(8000)

Deposit

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

DECIMAL(19,4)

userid

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

VARCHAR(36)

CCAdjustments

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

DECIMAL(19,4)

CCAdjustmentsNotes

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

NVARCHAR(8000)

BankName

Name of the bank in which the amount is deposited.

NVARCHAR(200)

ClosureType

Displays a static value: S.

CHAR(4)

ToPettyCash

Cash converted from business cash to petty cash. Petty cash is typically used for expenses such as buying coffee or lunch for a guest.

DECIMAL(19,4)

Notes

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

NVARCHAR(65535)

CashAdded

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

DECIMAL(19,4)

CashPaid

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

DECIMAL(19,4)

CashTransferred

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

DECIMAL(19,4)

CashBackAmount

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.

DECIMAL(19,4)

CashInPrevRegisterClosure

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.

DECIMAL(19,4)

PodName

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

VARCHAR(20)

etlCreatedDate

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

TIMESTAMP

Void

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

BOOLEAN

OrganizationId

A code that uniquely identifies an Organization

VARCHAR(36)

custom

Amount collected through custom payments

FLOAT

groupid

Internal to Zenoti. Used for data processing.

BIGINT

PaymentTypeID

unique identifier for paymentype

VARCHAR(36)

bi_dimorgpaymentoption_s3 orgpaymentoptionid

Actual

Actual CC amount collected for the payment type

DECIMAL(19,4)

DayClosureCCAdjustments

Adjusted amount for CC collections for a payment type

DECIMAL(19,4)