INSERT_MONEY
Inserts or updates a system generated timesheet entry (e.g. for meal penalty); handles updating, deleting. No hours component is included
Example Usage
INSERT_MONEY("2022-03-21", "MEAL", 17.50, "REIM-MEAL") -> records $17.50 to earnings code "MEAL"
INSERT_MONEY("2022-03-21", "TRAV", 42.37, "REIM-TRAVEL") -> records $42.37 to earnings code "TRAV"
Overview
Function signature
INSERT_MONEY(paydate, hourtype, amount, reference, exception)
Category
Database
Return data type
bool
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
paydate | date | The paydate for which the entry is being made | |
hourtype | lookup | The earnings code to use for the monetary amount | |
amount | float | The amount to add as money | |
reference | string | This is a unique reference which will allow multiple monetary items to be added to a given day (e.g. "MEAL" and "TRAVEL" for separate reimbursable items) | |
exception | string | Optional: set an exception abbreviation on the punch |