Power BI Connector for Sage Business Cloud Accounting

Build 22.0.8342

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 String The net amount for the invoice line
SalesInvoicesCurrencyTaxAmount String The tax amount for the invoice line in base currency
SalesInvoicesCurrencyTotalAmount String The total amount for the invoice line in base currency
DiscountPercentage String The discount percentage for the invoice line
Quantity String The quantity for the invoice line
TotalAmount String The total amount for the invoice line
SalesInvoicesCurrencyDiscountAmount String 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 String The unit price for the invoice line
SalesInvoicesCurrencyUnitPrice String The unit price for the invoice line in base currency
DiscountAmount String The discount amount for the invoice line
SalesInvoicesCurrencyNetAmount String 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 String The tax amount for the invoice line
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) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8342