Power BI Connector for Xero WorkflowMax

Build 21.0.8137

QuotesCost

Return a list of quotes related to costs.

Select

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

Select * from QuotesCost
Select * from QuotesCost where QuoteID = 'Q000123'
Select * from QuotesCost where QuoteID IN ('Q000124', 'Q000123')

Columns

Name Type Description
QuoteID [KEY] String The identifier of the Quote.
Description String The Description of the task related to the costs.
Note String The Note of the task related to the costs.
Code String The Code of the task related to the costs.
Billable String The Billable of the task related to the costs.
Quantity Int The Quantity of the task related to the costs.
UnitCost Double The UnitCost of the task related to the costs.
UnitPrice Double The UnitPrice of the task related to the costs.
Amount Double The Amount of the task related to the costs.
AmountTax Double The AmountTax of the task related to the costs.
AmountIncludingTax Double The AmountIncludingTax of the task related to the costs.

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