JDBC Driver for Xero WorkflowMax

Build 22.0.8462

QuotesCost

Return a list of quotes related to costs.

Select

The driver will process all filters client side except QuoteID.

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