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.

Dataset ID: e449c0b3-b172-4f7b-b8c0-f2f1de7bc925

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 NameDefinitionExample Output
shift_dateopenDate–Time Shift Opened2021-04-04T15:30:54
shift_dateclosedDate–Time Shift Closed2021-04-04T21:13:50
is_closedIs the shift currently open or closed? True or Falsetrue
account_nameCash Drawer NameRegister1
currency_typeCurrency or payment type used for the transactionCASH
expectedExpected totals from from each shift2705.14
actualActual totals calculated after shift is closed2696.40
storeidID of Store420
BATCH_IDInternal Field358.0
BATCH_LAST_RUNInternal Field2021-12-08T11:02:03
last_retrieved_datethe DateTime we last retrieved data from SellTreez2021-12-08T00:00:00