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