Cash Handling Audit Log Table

The cash handling audit log displays a chronological list of any actions that involve money management within your shop. This includes moving funds between cash drawers and accounts, making deposits and cash drops, reimbursing expenses, and more.

Dataset ID: 6723d00f-05a2-41f9-aa85-ae963c29f8b8

Unique Composite Key(s): id, storeid

Datetime Dataset Last Updated: last_retrieved_timestamp

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

Pull Previous Day: Data-Raw Append Example:

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

Pull Previous Successful Update: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(date) >= $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
IDUnique ID of row1533908e-d528-4a25-87a1-077bd36e09ff
dateDate–Time of account activity2021-01-30T21:02:46
userID of user making the account activity30013
amountAmount of account activity1869.66
from_accountAccount that activity is coming fromMain Vault
to_accountAccount that activity is going toRegister 1
to_account_typeType of AccountINCOMING_SALES
transaction_typeTransaction TypeCASH TO VAULT
transaction_currency_typeTransaction Currency typeCASH
transaction_notesOptional - notes related to account activityTransfer end of shift cash from CD02
storeidID of Store420
last_retrieved_timestampthe Date–Time we last retrieved data from SellTreez2021-06-09T14:18:30