Power BI Connector for Xero WorkflowMax

Build 21.0.8137

QuotesTask

Return a list of quotes related to Tasks.

Select

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

Select * from QuotesTask
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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137