SalesQuotes
Query SalesQuotes in Sage Business Cloud Accounting.
Table Specific Information
Query the available SalesQuotes
Select
The driver uses the Sage Accounting API to process search criteria that refer to ContactId,StatusId,FromDate,ToDate,UpdatedOrCreatedSince,HasAttachments columns. The driver processes other filters client-side within the driver.
- ContactId supports the '=' operator.
- StatusId supports the '=' operator.
- FromDate supports the '=' operator.
- ToDate supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
- HasAttachments supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM SalesQuotes WHERE ContactId = 'abc' SELECT * FROM SalesQuotes WHERE StatusId = 'abc' SELECT * FROM SalesQuotes WHERE FromDate = '2018-12-15' SELECT * FROM SalesQuotes WHERE ToDate = '2018-12-15' SELECT * FROM SalesQuotes WHERE UpdatedOrCreatedSince = '2018-12-15' SELECT * FROM SalesQuotes WHERE HasAttachments = 'abc'
Update
Updates are performed based on Id.
UPDATE SalesQuotes SET Reference = 'abc' WHERE Id = '123'
Delete
You must specify the Id of the SalesQuotes to delete it.
DELETE FROM SalesQuotes WHERE id = '123'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The unique identifier for the item | |
DisplayedAs | String | False |
The name of the resource | |
Reference | String | False |
The reference for the quote | |
BaseCurrencyTotalAmount | String | False |
The total amount of the quote in base currency | |
MainAddressId | String | False |
Addresses.Id |
The unique identifier for the item |
BaseCurrencyNetAmount | String | False |
The net amount of the quote in base currency | |
BaseCurrencyShippingTaxBreakdownAggregate | String | False |
The shipping tax breakdown for the quote in base currency | |
ProfitAnalysisTotalProfit | String | False |
The profit amount | |
ProfitAnalysisTotalDescription | String | False |
The description | |
ProfitAnalysisTotalTotalSale | String | False |
The total sale | |
ProfitAnalysisTotalTotalCost | String | False |
The total cost | |
ProfitAnalysisTotalProfitPercentage | String | False |
The profit percentage | |
LineBreakdownAggregate | String | False |
The breakdown of profit per line | |
ContactName | String | False |
The name of the contact when the quote was created | |
SentByEmail | Bool | False |
Indicates whether the quote has been emailed | |
ShippingTaxBreakdownAggregate | String | False |
The shipping tax breakdown for the quote | |
TotalDiscountAmount | String | False |
The discount amount on the quote | |
TaxAmount | String | False |
The tax amount of the quote | |
PaymentsAllocationsTotalDiscount | String | False |
The total discount of all payments and allocations | |
WithholdingTaxRate | String | False |
IRPF withheld Tax Rate (Spain only) | |
TotalAmount | String | False |
The total amount of the quote | |
ExchangeRate | String | False |
The exchange rate for the quote | |
ContactId | String | False |
Contacts.Id |
The unique identifier for the item |
NetAmount | String | False |
The net amount of the quote | |
ContactReference | String | False |
The reference of the contact when the quote was created | |
TaxCalculationMethod | String | False |
The tax calculation method, if applicable, for this sales invoice, returns invoice, cash or retailer. | |
TermsAndConditions | String | False |
Quote terms and conditions | |
ShippingTaxRateId | String | False |
TaxRates.Id |
The unique identifier for the item |
Sent | Bool | False |
Indicates whether the quote has been sent | |
DeliveryAddressFreeForm | String | False |
The free-form delivery address of the quote | |
BaseCurrencyWithholdingTaxAmount | String | False |
IRPF withheld Tax Amount (Spain only) in the base currency | |
DeliveryAddressId | String | False |
Addresses.Id |
The unique identifier for the item |
WithholdingTaxAmount | String | False |
IRPF withheld Tax Amount (Spain only) | |
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
LegacyId | Int | False |
The legacy ID for the item | |
TaxAnalysisAggregate | String | False |
The quote tax analysis | |
QuoteNumberPrefix | String | False |
The quote number prefix | |
BaseCurrencyShippingTotalAmount | String | False |
The total shipping amount in base currency | |
QuoteNumber | String | False |
The generated quote number | |
InverseExchangeRate | String | False |
The inverse exchange rate for the quote | |
TotalQuantity | String | False |
The total quantity of the quote | |
StatusDisplayedAs | String | False |
The quote status name | |
StatusId | String | False |
The quote status id | |
DetailedTaxAnalysisBaseCurrencyTotalGoodsAmount | String | False |
The total base currency amount relating to goods for all tax rates | |
DetailedTaxAnalysisBaseCurrencyTotalTax | String | False |
The base currency total tax amount for all tax rates | |
DetailedTaxAnalysisTotalRetailerTax | String | False |
The total retailer tax amount for all tax rates | |
DetailedTaxAnalysisBaseCurrencyTotal | String | False |
The total base currency amount for all tax rates | |
DetailedTaxAnalysisTotalGoodsAmount | String | False |
The total amount relating to goods for all tax rates | |
DetailedTaxAnalysisTotalNet | String | False |
The total net amount for all tax rates | |
DetailedTaxAnalysisBaseCurrencyTotalServicesAmount | String | False |
The total base currency amount relating to services for all tax rates | |
DetailedTaxAnalysisBaseCurrencyTotalNet | String | False |
The base currency total net amount for all tax rates | |
DetailedTaxAnalysisTotalServicesAmount | String | False |
The total amount relating to services for all tax rates | |
DetailedTaxAnalysisTotal | String | False |
The total amount for all tax rates | |
DetailedTaxAnalysisTotalTax | String | False |
The total tax amount for all tax rates | |
ExpiryDate | String | False |
The expiry date of the quote | |
BaseCurrencyShippingTaxAmount | String | False |
The tax shipping amount in base currency | |
ShippingTaxAmount | String | False |
The tax shipping amount. NOTE: This is not required for POST/PUT requests as the shipping tax is calculated based on the shipping_net_amount and the shipping_tax_rate. | |
CreatedAt | Datetime | True |
The datetime when the item was created | |
PaymentsAllocationsTotalAmount | String | False |
The total amount of all payments and allocations | |
TaxReconciled | Bool | False |
Indicates if the quote/estimate is tax reconciled or not. | |
Editable | Bool | False |
Indicates whether artefact can be edited | |
ShippingTotalAmount | String | False |
The total shipping amount | |
InvoiceDisplayedAs | String | False |
The name of the resource | |
InvoiceLegacyId | Int | False |
The legacy ID for the item | |
InvoiceId | String | False |
The unique identifier for the item | |
BaseCurrencyShippingNetAmount | String | False |
The net shipping amount in base currency | |
ShippingNetAmount | String | False |
The net shipping amount | |
CurrencyId | String | False |
Currencies.Id |
The unique identifier for the item |
Notes | String | False |
Quote notes | |
MainAddressFreeForm | String | False |
The free-form main address of the quote | |
TotalPaid | String | False |
The total paid amount of the quote including any payments, allocations and discounts | |
Date | Datetime | False |
The date of the quote | |
BaseCurrencyTaxAmount | String | False |
The tax amount of the quote in base currency | |
SalesQuoteLineItemAggregate | String | False |
The quote lines of the quote | |
BaseCurrencyTotalDiscountAmount | String | False |
The discount amount on the quote in base currency | |
FromDate | Datetime | False | ||
ToDate | Datetime | False | ||
HasAttachments | String | False |