MuleSoft Connector for Sage Business Cloud Accounting

Build 21.0.8011

PurchaseCreditNoteLineItem

Query PurchaseCreditNoteLineItem in Sage Business Cloud Accounting.

Table Specific Information

Query the available PurchaseCreditNoteLineItem

Select

The driver uses the Sage Accounting API to process search criteria that refer to ShowPaymentsAllocations,Search,ContactId,StatusId,FromDate,ToDate,UpdatedOrCreatedSince,DeletedSince,HasAttachments,ShowPaymentsAllocations columns. The driver processes other filters client-side within the driver.

  • ShowPaymentsAllocations supports the '=' operator.
  • Search supports the '=' operator.
  • 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.

For example, the following queries are processed server side:

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

Columns

Name Type References Description
Id [KEY] String The unique identifier for the item
PurchaseCreditNotesId 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 String The net amount for the credit note line
BaseCurrencyTaxAmount String The tax amount for the credit note line in base currency
BaseCurrencyTotalAmount String The total amount for the credit note line in base currency
Quantity String The quantity for the credit note line
TotalAmount String The total amount for the credit note line
LedgerAccountId String

LedgerAccounts.Id

The unique identifier for the item
IsPurchaseForResale Bool Identifies whether the line item is for resale. (Ireland Only)
BaseCurrencyTaxBreakdownAggregate String The tax breakdown for the credit note line in base currency
TaxBreakdownAggregate String The tax breakdown for the credit note line
UnitPrice String The unit price for the credit note line
BaseCurrencyUnitPrice String The unit price for the credit note line in base currency
GstAmount String The gst or hst tax amount for the credit note line
BaseCurrencyNetAmount String The net amount for the credit note line in base currency
DisplayedAs String The name of the resource
Description String The description for the credit note line
TaxAmount String The tax amount for the credit note line
PstAmount String The pst or qst tax amount for the credit note 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
Search String
ContactId String
StatusId String
FromDate Datetime
ToDate Datetime
DeletedSince Datetime
HasAttachments String
ShowPaymentsAllocations String

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.8011