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 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 |
BATCH_ID | Internal Field | 358.0 |
BATCH_LAST_RUN | Internal Field | 2021-12-08T11:02:03 |
last_retrieved_date | the DateTime we last retrieved data from SellTreez | 2021-12-08T00:00:00 |
Updated 22 days ago