Excel Add-In for Sage Business Cloud Accounting

Build 22.0.8479

SalesInvoiceLineItem

Query SalesInvoiceLineItem in Sage Business Cloud Accounting.

Table Specific Information

Query the available SalesInvoiceLineItem

Select

The driver uses the Sage Accounting API to process search criteria that refer to ContactId,StatusId,FromDate,ToDate,UpdatedOrCreatedSince,DeletedSince,HasAttachments,ShowPaymentsAllocations,Search 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.
  • DeletedSince supports the '=' operator.
  • HasAttachments supports the '=' operator.
  • ShowPaymentsAllocations supports the '=' operator.
  • Search supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM SalesInvoiceLineItem WHERE ContactId='abc'
SELECT * FROM SalesInvoiceLineItem WHERE StatusId='abc'
SELECT * FROM SalesInvoiceLineItem WHERE FromDate='2018-12-15'
SELECT * FROM SalesInvoiceLineItem WHERE ToDate='2018-12-15'
SELECT * FROM SalesInvoiceLineItem WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM SalesInvoiceLineItem WHERE DeletedSince='2018-12-15'
SELECT * FROM SalesInvoiceLineItem WHERE HasAttachments='abc'
SELECT * FROM SalesInvoiceLineItem WHERE ShowPaymentsAllocations='abc'
SELECT * FROM SalesInvoiceLineItem WHERE Search='abc'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
SalesInvoicesId 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 Double The net amount for the invoice line
SalesInvoicesCurrencyTaxAmount Double The tax amount for the invoice line in base currency
SalesInvoicesCurrencyTotalAmount Double The total amount for the invoice line in base currency
DiscountPercentage String The discount percentage for the invoice line
Quantity Double The quantity for the invoice line
TotalAmount Double The total amount for the invoice line
SalesInvoicesCurrencyDiscountAmount Double The discount amount for the invoice line in base currency
LedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
BaseCurrencyTaxBreakdownAggregate String The tax breakdown for the invoice line in base currency
TaxBreakdownAggregate String The tax breakdown for the invoice line
UnitPrice Double The unit price for the invoice line
SalesInvoicesCurrencyUnitPrice Double The unit price for the invoice line in base currency
DiscountAmount String The discount amount for the invoice line
SalesInvoicesCurrencyNetAmount Double The net amount for the invoice line in base currency
DisplayedAs String The name of the resource
Description String The description for the invoice line
TaxAmount Double The tax amount for the invoice 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.
LegacyId Int The legacy ID for the item
TradeOfAsset Bool Whether the line item is marked as trade of asset.
EuSalesDescriptionDisplayedAs String The name of the resource
EuSalesDescriptionLegacyId Int The legacy ID for the item
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

StatusId String
FromDate Datetime
ToDate Datetime
DeletedSince Datetime
HasAttachments String
ShowPaymentsAllocations String
Search String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479