Power BI Connector for Sage Business Cloud Accounting

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060