PurchaseInvoiceLineItem
Query PurchaseInvoiceLineItem in Sage Business Cloud Accounting.
Table Specific Information
Query the available PurchaseInvoiceLineItem
Select
The driver uses the Sage Accounting API to process search criteria that refer to ShowPaymentsAllocations,HasAttachments,FromDate,ContactId,StatusId,ShowCorrections,DeletedSince,Search,ToDate columns. The driver processes other filters client-side within the driver.
- ShowPaymentsAllocations supports the '=' operator.
- HasAttachments supports the '=' operator.
- FromDate supports the '=' operator.
- ContactId supports the '=' operator.
- StatusId supports the '=' operator.
- ShowCorrections supports the '=' operator.
- DeletedSince supports the '=' operator.
- Search supports the '=' operator.
- ToDate supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM PurchaseInvoiceLineItem WHERE ShowPaymentsAllocations = 'abc' SELECT * FROM PurchaseInvoiceLineItem WHERE HasAttachments = 'abc' SELECT * FROM PurchaseInvoiceLineItem WHERE FromDate = '2018-12-15' SELECT * FROM PurchaseInvoiceLineItem WHERE ContactId = 'abc' SELECT * FROM PurchaseInvoiceLineItem WHERE StatusId = 'abc' SELECT * FROM PurchaseInvoiceLineItem WHERE ShowCorrections = 'abc' SELECT * FROM PurchaseInvoiceLineItem WHERE DeletedSince = '2018-12-15' SELECT * FROM PurchaseInvoiceLineItem WHERE Search = 'abc' SELECT * FROM PurchaseInvoiceLineItem WHERE ToDate = '2018-12-15'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the item | |
| PurchaseInvoicesId | String | Parent ID | |
| TaxRateDisplayedAs | String | The name of the resource | |
| TaxRateLegacyId | Int | The legacy ID for the item | |
| TaxRateId | String | 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 | String | The net amount for the invoice line | |
| PurchaseInvoicesCurrencyTaxAmount | String | The tax amount for the invoice line in PurchaseInvoices currency | |
| PurchaseInvoicesCurrencyTotalAmount | String | The total amount for the invoice line in PurchaseInvoices currency | |
| Quantity | String | The quantity for the invoice line | |
| TotalAmount | String | The total amount for the invoice line | |
| LedgerAccountId | String | The unique identifier for the item | |
| IsPurchaseForResale | Bool | Identifies whether the line item is for resale. (Ireland Only) | |
| PurchaseInvoicesCurrencyTaxBreakdownAggregate | String | The tax breakdown for the invoice line in PurchaseInvoices currency | |
| TaxBreakdownAggregate | String | The tax breakdown for the invoice line | |
| UnitPrice | String | The unit price for the invoice line | |
| PurchaseInvoicesCurrencyUnitPrice | String | The unit price for the invoice line in PurchaseInvoices currency | |
| GstAmount | String | The gst or hst tax amount for the invoice line | |
| PurchaseInvoicesCurrencyNetAmount | String | The net amount for the invoice line in PurchaseInvoices 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. 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. | |
| PstAmount | String | The pst or qst 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. | |
| UnitPriceIncludesTax | Bool | Defines whether the unit price includes tax | |
| ServiceId | String |
Services.Id | The unique identifier for the item |
| ShowPaymentsAllocations | String | ||
| HasAttachments | String | ||
| FromDate | Datetime | ||
| ContactId | String | ||
| StatusId | String | ||
| ShowCorrections | String | ||
| DeletedSince | Datetime | ||
| Search | String | ||
| ToDate | Datetime |