Activities
Return, update, create and delete a list of time billing activities 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, Description, DisplayID, IsActive, Name, Status, Type, UnitOfMeasurement, IncomeAccountID, IncomeAccountDisplayID, IncomeAccountName, ChargeableRate, UseDescriptionOnSales, TaxCodeID, TaxCodeCode. All the other columns and operators are processed client side.
SELECT * FROM Activities WHERE ID = REPLACE SELECT * FROM Activities WHERE Description = "criteria" SELECT * FROM Activities WHERE DisplayID = "criteria"
Insert
The following attributes are required when performing an insert: DisplayID, IncomeAccountID, TaxCodeID, Type, Status.
INSERT INTO Activities(DisplayID, IncomeAccountID, TaxCodeID, Type, Status) values("test", "0b9b6098-1a9e-499d-bf41-b863a6daad9c", "2619bed9-3750-45b5-b353-18f5651beb01", "Hourly", "Chargeable"
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. |
| Description | String | False |
Description of the object. |
| DisplayID | String | False |
Display ID for the object. |
| IsActive | Boolean | False |
True or false. |
| Name | String | False |
Name of the object. |
| Status | String | False |
Can consist of the following: Chargeable used to include on time billing invoices. NonChargeable used when not charging customers but still wanting to include on activity slip. |
| Type | String | False |
Hourly or NonHourly. |
| UnitOfMeasurement | String | False |
Hourly - If Type = Hourly then UnitOfMeasurement = Hour. NonHourly - specify the type of measurement |
| IncomeAccountID | Uuid | False |
Unique identifier for the account in the form of a guid. |
| IncomeAccountDisplayID | String | True |
Account code. Format includes separator ie 4-1100 |
| IncomeAccountName | String | True |
Name of the account. |
| IncomeAccountURI | String | True |
Uniform resource identifier associated with the account object. |
| ChargeableRate | String | True |
Rate which can consit of the following: EmployeeBillingRate - sourced from the employee contact card. CustomerBillingRate - sourced from the customer contact card. ActivityRate - entered on activity and is exclusive of tax. |
| UseDescriptionOnSales | Boolean | True |
True or false. |
| TaxCodeID | Uuid | False |
Unique guid identifier belonging to the assigned tax code. |
| TaxCodeCode | String | True |
3 digit tax code. |
| TaxCodeURI | String | True |
Uniform resource identifier associated with the tax code object. |
| URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
| RowVersion | String | True |
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. |