Cash register fact table v2
Table | Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|---|
bi_factcashregisterv2 | factcashregisterwid | A unique identifier for each record generated in the fact table. | BIGINT | Y | |
bi_factcashregisterv2 | factcashregisterid | A unique identifier for each record generated in the fact table. | INTEGER | ||
bi_factcashregisterv2 | closureno | Unique value that is generated every time a cash register is closed. | INTEGER | ||
bi_factcashregisterv2 | closureid | Unique identifier associated with the cash register closure number. | VARCHAR(36) | ||
bi_factcashregisterv2 | cashregisterwid | A unique identifier generated for the Cash Register. | BIGINT | ||
bi_factcashregisterv2 | centerwid | A unique identifier for the center, generated in Centre dimension(Bi_DimCenter) | BIGINT | ||
bi_factcashregisterv2 | closuredate | Date and time at which the register is closed. | TIMESTAMP | ||
bi_factcashregisterv2 | 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. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | cc | Total invoice amount collected via card payments. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | checks | Total invoice amount collected by check payments. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | adjustments | Difference between the expected cash collection calculated by Zenoti and the actual cash collection entered by the employee. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | adjustmentnotes | Notes entered by the employee corresponding to the adjustments field | VARCHAR(8000) | ||
bi_factcashregisterv2 | deposit | Amount deposited in the bank at the end of the day. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | userwid | A unique identifier for the guest, generated in User dimension(Bi_DimUser) | BIGINT | ||
bi_factcashregisterv2 | ccadjustments | Difference in the credit card collection calculated by Zenoti and the actual credit card collection entered by the employee. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | ccadjustmentsnotes | Notes entered by the employee corresponding to the cc adjustments field. | VARCHAR(8000) | ||
bi_factcashregisterv2 | bankname | Name of the bank in which the amount is deposited. | VARCHAR(200) | ||
bi_factcashregisterv2 | closuretype | Displays a static value: S. | CHAR(4) | ||
bi_factcashregisterv2 | 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. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | notes | Comments entered by the employee on the Close Payment screen while closing the register. | VARCHAR(32000) | ||
bi_factcashregisterv2 | cashadded | Cash added to the corresponding cash register after previous register closure by using the Manage Cash window in Core. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | cashpaid | Cash paid out to employees from the corresponding cash register by using the Manage Cash window in Core. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | cashtransferred | Cash transferred from the corresponding cash register to another register by using the Manage Cash window in Core. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | 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. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | 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. | NUMERIC(19,4) | ||
bi_factcashregisterv2 | podname | Internal to the ETL, says from which POD data is being synced the table | VARCHAR(20) | ||
bi_factcashregisterv2 | etlcreateddate | Latest timestamp at which the corresponding record was either inserted or updated in this table. | TIMESTAMP | ||
bi_factcashregisterv2 | void | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | BOOLEAN | ||
bi_factcashregisterv2 | custom | Amount collected through custom payments | FLOAT | ||
bi_factcashregisterv2 | groupid | Internal to Zenoti. Used for data processing. | BIGINT | ||
bi_factcashregisterv2 | PaymentTypeID | unique identifier for paymentype | VARCHAR(36) | bi_dimorgpaymentoption_s3 orgpaymentoptionid | |
bi_factcashregisterv2 | Actual | Actual CC amount collected for the payment type | NUMERIC(19,4) | ||
bi_factcashregisterv2 | DayClosureCCAdjustments | Adjusted amount for CC collections for a payment type | NUMERIC(19,4) | ||
bi_factcashregisterv2 | organizationid | A code that uniquely identifies an Organization | VARCHAR(36) |