Excel Add-In for Xero WorkflowMax

Build 21.0.8137

JobCosts

Return a list of all costs of jobs.

Select

Note: Because of Xero WorkflowMax API restrictions the Job ID filters will not work properly while using custom Job numbers which have punctuation in them. This is a known issue that Xero refuses to fix. Please change the Job number so there is no punctuation and try again. In case you are using custom Job numbers with punctuation in them you may encounter 404 Not Found error in Jobs and JobCosts tables.

The {i will use the your data source API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. Specifically, the following are processed server-side:

  • JobID supports the '=' operator.

All filterable columns allow multiple values to be specified by using the IN operator. Response time from the server can be improved by identifying only the rows you want to retrieve.

SELECT * FROM JobCosts WHERE JobID='J000002'
SELECT * FROM JobCosts WHERE JobID IN ('J000001', 'J000002')

Insert

JobID, Date, Description, Quantity, UnitCost, UnitPrice are required to insert. The following query creates a new JobCost:

INSERT INTO JobCosts (JobID, Date, Description, Quantity, UnitCost, UnitPrice) VALUES ('J000002', '2019-07-17T00:00:00', 'Maybach', '123', 30, 50)

Columns

Name Type ReadOnly Description
JobID String False

Job Identifier related to the cost.

UUID [KEY] String True

Cost identifier.

Date Datetime False

The date when the cost was created.

Description String False

The description related to the cost.

Code String False

The code of the unit.

Note String False

The note related to the cost.

Quantity Double False

Product quantity.

UnitCost Float False

Cost per unit.

UnitPrice Float False

Price per unit.

SupplierUUID String False

Determines the supplier identifier.

SupplierName String True

Determines the supplier name.

Billable String True

Determines if the cost is billable or not true(default) | false.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137