JDBC Driver for Sage Business Cloud Accounting

Build 22.0.8462

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

LedgerAccounts.Id

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
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

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