Return and update employee payment details on employee contact cards for an AccountRight company file.
Table Specific Information
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: ID, BankStatementText, PaymentMethod, EmployeeID, EmployeeDisplayID, EmployeeName. All the other columns and operators are processed client side.
SELECT * FROM EmployeePaymentDetails WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM EmployeePaymentDetails WHERE EmployeeID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9"
To update an existing employee payment detail, along with its BankAccounts, we can either pass a JSON string to the BankAccounts value or use a temporary table like below.
Note: this will replace all the current BankAccounts with the ones below.
INSERT INTO EmployeeBankAccountItems#TEMP(BSBNumber, BankAccountName, BankAccountNumber, Unit, Value) VALUES ("341-241", "123412341", "Mr A Long", 100, "Percent") UPDATE EmployeePaymentDetails SET BankAccounts = "EmployeeBankAccountItems#TEMP" WHERE ID = "992163e5-f46d-4b45-9296-965aa89a2a71"
Unique identifier in the form of a guid.
Text to appear on employee's bank statement where PaymentMethod = Electronic.
Payment method can consist of the following Enum values: Cash, Cheque, Electronic.
Unique guid identifier belonging to the assigned employee contact.
Customer contact Card ID, can also be used as a unique employee contact identifier.
Name of the employee contact.
Uniform resource identifier associated with the employee contact object.
Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
An array of employee bank account information where PaymentMethod = Electronic.
The ID of the company file. Takes precedence over the CompanyFileId connection property.