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
The allowed values are 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 | 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 |