Tableau Connector for Sage Business Cloud Accounting

Build 22.0.8342

SalesQuoteLineItem

Query SalesEstimatesQuoteLineItem in Sage Business Cloud Accounting.

Table Specific Information

Query the available SalesQuoteLineItem

Select

The driver uses the Sage Accounting API to process search criteria that refer to ContactId,Search,StatusId,FromDate,ToDate,UpdatedOrCreatedSince,HasAttachments columns. The driver processes other filters client-side within the driver.

  • ContactId supports the '=' operator.
  • Search 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 SalesQuoteLineItem WHERE ContactId='abc'
SELECT * FROM SalesQuoteLineItem WHERE Search='abc'
SELECT * FROM SalesQuoteLineItem WHERE StatusId='abc'
SELECT * FROM SalesQuoteLineItem WHERE FromDate='2018-12-15'
SELECT * FROM SalesQuoteLineItem WHERE ToDate='2018-12-15'
SELECT * FROM SalesQuoteLineItem WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM SalesQuoteLineItem WHERE HasAttachments='abc'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
QuoteStatusId String Parent ID
TaxRateId String

TaxRates.Id

The unique identifier for the item
ProductId String

Products.Id

The unique identifier for the item
EuGoodsServicesTypeId String The unique identifier for the item

使用できる値は次のとおりです。GOODS, SERVICES

NetAmount String The net amount for the quote line
BaseCurrencyTaxAmount String The tax amount for the quote line in base currency
BaseCurrencyTotalAmount String The total amount for the quote line in base currency
DiscountPercentage String The discount percentage for the quote line
Quantity String The quantity for the quote line
TotalAmount String The total amount for the quote line
BaseCurrencyDiscountAmount String The discount amount for the quote line in base currency
LedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
BaseCurrencyTaxBreakdownAggregate String The tax breakdown for the quote line in base currency
TaxBreakdownAggregate String The tax breakdown for the quote line
UnitPrice String The unit price for the quote line
BaseCurrencyUnitPrice String The unit price for the quote line in base currency
DiscountAmount String The discount amount for the quote line
BaseCurrencyNetAmount String The net amount for the quote line in base currency
DisplayedAs String The name of the resource
Description String The description for the quote line
TaxAmount String The tax amount for the quote line
LegacyId Int The legacy ID for the item
TradeOfAsset Bool Whether the line item is marked as trade of asset.
EuSalesDescriptionId String

EuSalesDescriptions.Id

The unique identifier for the item
UnitPriceIncludesTax Bool Defines whether the unit price includes tax
ServiceId String

Services.Id

The unique identifier for the item
ContactId String
Search String
StatusId String
FromDate Datetime
ToDate Datetime
HasAttachments String

Query SalesQuoteLineItem in Sage Business Cloud Accounting.

Table Specific Information

Query the available SalesQuoteLineItem

Select

The driver uses the Sage Accounting API to process search criteria that refer to ContactId,Search,StatusId,FromDate,ToDate,UpdatedOrCreatedSince,HasAttachments columns. The driver processes other filters client-side within the driver.

  • ContactId supports the '=' operator.
  • Search 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 SalesQuoteLineItem WHERE ContactId='abc'
SELECT * FROM SalesQuoteLineItem WHERE Search='abc'
SELECT * FROM SalesQuoteLineItem WHERE StatusId='abc'
SELECT * FROM SalesQuoteLineItem WHERE FromDate='2018-12-15'
SELECT * FROM SalesQuoteLineItem WHERE ToDate='2018-12-15'
SELECT * FROM SalesQuoteLineItem WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM SalesQuoteLineItem WHERE HasAttachments='abc'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
QuoteStatusId String Parent ID
TaxRateId String

TaxRates.Id

The unique identifier for the item
ProductId String

Products.Id

The unique identifier for the item
EuGoodsServicesTypeId String The unique identifier for the item

使用できる値は次のとおりです。GOODS, SERVICES

NetAmount String The net amount for the quote line
BaseCurrencyTaxAmount String The tax amount for the quote line in base currency
BaseCurrencyTotalAmount String The total amount for the quote line in base currency
DiscountPercentage String The discount percentage for the quote line
Quantity String The quantity for the quote line
TotalAmount String The total amount for the quote line
BaseCurrencyDiscountAmount String The discount amount for the quote line in base currency
LedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
BaseCurrencyTaxBreakdownAggregate String The tax breakdown for the quote line in base currency
TaxBreakdownAggregate String The tax breakdown for the quote line
UnitPrice String The unit price for the quote line
BaseCurrencyUnitPrice String The unit price for the quote line in base currency
DiscountAmount String The discount amount for the quote line
BaseCurrencyNetAmount String The net amount for the quote line in base currency
DisplayedAs String The name of the resource
Description String The description for the quote line
TaxAmount String The tax amount for the quote line
LegacyId Int The legacy ID for the item
TradeOfAsset Bool Whether the line item is marked as trade of asset.
EuSalesDescriptionId String

EuSalesDescriptions.Id

The unique identifier for the item
UnitPriceIncludesTax Bool Defines whether the unit price includes tax
ServiceId String

Services.Id

The unique identifier for the item
ContactId String

Contacts.Id

Search String
StatusId String
FromDate Datetime
ToDate Datetime
HasAttachments String

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