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.

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 Name

Definition

Example Output

ID

Unique ID of row

1533908e-d528-4a25-87a1-077bd36e09ff

date

Date–Time of account activity

2021-01-30T21:02:46

user

ID of user making the account activity

30013

amount

Amount of account activity

1869.66

from_account

Account that activity is coming from

Main Vault

to_account

Account that activity is going to

Register 1

to_account_type

Type of Account

INCOMING_SALES

transaction_type

Transaction Type

CASH TO VAULT

transaction_currency_type

Transaction Currency type

CASH

transaction_notes

Optional - notes related to account activity

Transfer end of shift cash from CD02

storeid

ID of Store

420

last_retrieved_timestamp

the Date–Time we last retrieved data from SellTreez

2021-06-09T14:18:30


Did this page help you?