ContactEmployees
Return, update, create and delete an employee contact for an AccountRight company file.
Table Specific Information
Select
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 | CurrentBalance | FirstName | LastName | CompanyName |
IsActive | IsIndividual | LastModified | Notes | DisplayID |
EmployeePaymentDetailsID | EmployeePayrollDetailsID | EmployeeStandardPayID | TimeBillingDetailsCostPerHour | TimeBillingDetailsEmployeeBillingRateExcludingTax |
SELECT * FROM ContactEmployees SELECT * FROM ContactEmployees WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM ContactEmployees WHERE FirstName = "James" OR FirstName = "John"
Insert
The following attributes are required when performing an insert: CompanyName (if IsIndividual = false), FirstName, LastName, IsIndividual.
INSERT INTO ContactEmployees (FirstName, LastName, IsIndividual) VALUES ("James", "Bond", true)
Update
To update an existing ContactEmployee, along with the addresses, we can either pass a JSON string to the aggregate input value or use a temporary table like below.
INSERT INTO ContactAddressItems#TEMP (City, Country) VALUES ("Paris", "France") UPDATE ContactEmployees SET FirstName = "James", Addresses = "ContactAddressItems#TEMP" WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9"
Delete
You must specify the Id of the ContactEmployee to delete it.
DELETE FROM ContactEmployees WHERE Id = '5a3e152b-4910-4cbe-ad27-32a57392ae23'
Columns
Name | Type | ReadOnly | Description |
ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. |
CurrentBalance | Decimal | True |
Contact balance. |
FirstName | String | False |
Contact first name. |
LastName | String | False |
Contact last name. |
CompanyName | String | False |
Contact company name. |
IsActive | Boolean | False |
True indicates the employee contact is active. False indicates the employee contact is inactive. |
IsIndividual | Boolean | False |
True indicates the employee contact represents an individual. False indicates the employee contact represents a company. |
LastModified | Datetime | True |
Extracts the last modification date for the contact resource. |
Notes | String | False |
Notes for the contact. |
URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
PhotoURI | String | False |
Uniform resource identifier associated with a photo image. |
DisplayID | String | False |
Display ID for the contact card. |
EmployeePaymentDetailsID | Uuid | True |
Unique identifier in the form of a guid. |
EmployeePaymentDetailsURI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
EmployeePayrollDetailsID | Uuid | True |
Unique identifier in the form of a guid. |
EmployeePayrollDetailsURI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
EmployeeStandardPayID | Uuid | True |
Unique identifier in the form of a guid. |
EmployeeStandardPayURI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
TimeBillingDetailsCostPerHour | Double | True |
Hourly cost of employee to business. |
TimeBillingDetailsEmployeeBillingRateExcludingTax | Double | True |
Hourly billing rate for services provided by employee |
Identifiers | String | True |
Contact Identifiers Details. |
CustomField1Label | String | True |
Custom Field 1 label. |
CustomField1Value | String | True |
Custom Field 1 value. |
CustomField2Label | String | True |
Custom Field 2 label. |
CustomField2Value | String | True |
Custom Field 2 value. |
CustomField3Label | String | True |
Custom Field 3 label. |
CustomField3Value | String | True |
Custom Field 3 value. |
CustomList1Label | String | True |
Custom List 1 label. |
CustomList1Value | String | True |
Custom List 1 value. |
CustomList2Label | String | True |
Custom List 2 label. |
CustomList2Value | String | True |
Custom List 2 value. |
CustomList3Label | String | True |
Custom List 3 label. |
CustomList3Value | String | True |
Custom List 3 value. |
Addresses | String | False |
The following set of information pulls through details for a contact address. |
RowVersion | String | False |
Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. |
CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |