Cash Actuals & Expected Table

This dataset provides a summary of all the closed shifts by day, along with each cash drawer’s ‘actuals’ and ‘differences’ by shift.

Unique Composite Key(s): account_name, storeid, shift_dateopen

Datetime Dataset Last Updated: last_retrieved_timestamp

Incremental Load Logic: Use the column shift_dateopen as data appends per new cash movement action completed

Pull Previous Day: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(shift_dateopen) = date(date_add(now(), INTERVAL -1 day)) "}

Pull Previous Successful Update: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(shift_dateopen) >= $stored_last_update_datetime"}
  • stored_last_update_datetime is your stored DateTime for last successful data pull

TIP: As a best practice, we recommend that you save the timestamp for each of your dataset pulls as 'stored_last_update_datetime'. Note that this value is not saved in our datasets, but is a suggestion.

Column Name

Definition

Example Output

shift_dateopen

Date–Time Shift Opened

2021-04-04T15:30:54

shift_dateclosed

Date–Time Shift Closed

2021-04-04T21:13:50

is_closed

Is the shift currently open or closed? True or False

true

account_name

Cash Drawer Name

Register1

currency_type

Currency or payment type used for the transaction

CASH

expected

Expected totals from from each shift

2705.14

actual

Actual totals calculated after shift is closed

2696.40

storeid

ID of Store

420


Did this page help you?