Excel Add-In for Xero WorkflowMax

Build 21.0.8137

InvoicesJobTask

Return a list of invoices related to Tasks.

Select

The {i will process all filters client side except InvoiceID.

SELECT * FROM InvoicesJobTask
Select * from InvoicesJobTask where InvoiceID = 'I000123'
Select * from InvoicesJobTask where InvoiceID IN ('I000124', 'I000123')

Columns

Name Type Description
InvoiceID [KEY] String The identifier of the invoice
Name String The Name of the task related to the invoice.
Description String The Description of the task related to the invoice.
Minutes Int The Minutes of the task related to the invoice.
BillableRate Double The BillableRate of the task related to the invoice.
Billable String The Billable of the task related to the invoice.
Amount Double The Amount of the task related to the invoice.
AmountTax Double The AmountTax of the task related to the invoice.
AmountIncludingTax Double The AmountIncludingTax of the task related to the invoice.

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