JDBC Driver for Xero WorkflowMax

Build 22.0.8462

QuotesTask

Return a list of quotes related to Tasks.

Select

The driver will process all filters client side except QuoteID.

SELECT * FROM QuotesTask WHERE QuoteID = 'Q000123'
SELECT * FROM QuotesTask WHERE QuoteID IN ('Q000124', 'Q000123')

Columns

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462