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 使用できる値は次のとおりです。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. 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 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

SSIS Components for Sage Business Cloud Accounting

PurchaseCreditNoteLineItem

Table Specific Information

Select

Columns