JDBC Driver for Xero WorkflowMax

Build 22.0.8462

InvoicesJobTask

Return a list of invoices related to Tasks.

Select

The driver will process all filters client side except InvoiceID.

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462