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 | 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. This attribute is required in v3.1, unless the tax rate is of a 'zero', 'exempt' or 'no_tax' type. Then the tax_amount is infered as 0.0. In v3, this attribute is optional, but you should still set, as it defaults to 0.0 in any case. | |
LegacyId | Int | The legacy ID for the item | |
TradeOfAsset | Bool | Whether the line item is marked as trade of asset. | |
EuSalesDescriptionId | String | 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 | 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. This attribute is required in v3.1, unless the tax rate is of a 'zero', 'exempt' or 'no_tax' type. Then the tax_amount is infered as 0.0. In v3, this attribute is optional, but you should still set, as it defaults to 0.0 in any case. | |
LegacyId | Int | The legacy ID for the item | |
TradeOfAsset | Bool | Whether the line item is marked as trade of asset. | |
EuSalesDescriptionId | String | 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 |