PurchaseCorrectiveInvoice
Query PurchaseCorrectiveInvoice in Sage Business Cloud Accounting.
Table Specific Information
Query the available PurchaseCorrectiveInvoice
Select
The driver uses the Sage Accounting API to process search criteria that refer to ShowPaymentsAllocations,ShowCorrections,Search,ContactId,StatusId,FromDate,ToDate,UpdatedOrCreatedSince,DeletedSince,HasAttachments columns. The driver processes other filters client-side within the driver.
- ShowPaymentsAllocations supports the '=' operator.
- ShowCorrections 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.
For example, the following queries are processed server side:
SELECT * FROM PurchaseCorrectiveInvoice WHERE ShowPaymentsAllocations='abc' SELECT * FROM PurchaseCorrectiveInvoice WHERE ShowCorrections='abc' SELECT * FROM PurchaseCorrectiveInvoice WHERE Search='abc' SELECT * FROM PurchaseCorrectiveInvoice WHERE ContactId='abc' SELECT * FROM PurchaseCorrectiveInvoice WHERE StatusId='abc' SELECT * FROM PurchaseCorrectiveInvoice WHERE FromDate='2018-12-15' SELECT * FROM PurchaseCorrectiveInvoice WHERE ToDate='2018-12-15' SELECT * FROM PurchaseCorrectiveInvoice WHERE UpdatedOrCreatedSince='2018-12-15' SELECT * FROM PurchaseCorrectiveInvoice WHERE DeletedSince='2018-12-15' SELECT * FROM PurchaseCorrectiveInvoice WHERE HasAttachments='abc'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the item | |
| BaseId | String | Parent ID | |
| DisplayedAs | String | The name of the resource | |
| Reference | String | The reference for the invoice | |
| BaseCurrencyTotalAmount | String | The total amount of the invoice in base currency | |
| BaseCurrencyNetAmount | String | The net amount of the invoice in base currency | |
| ContactName | String | The name of the contact when the invoice was created | |
| DueDate | String | The due date of the invoice | |
| OriginalInvoiceDisplayedAs | String | The name of the resource | |
| OriginalInvoiceLegacyId | Int | The legacy ID for the item | |
| OriginalInvoiceId | String | The unique identifier for the item | |
| TaxAmount | String | The tax amount of the invoice | |
| LastPaid | String | The date of the last payment | |
| PaymentsAllocationsTotalDiscount | String | The total discount of all payments and allocations | |
| OriginalInvoiceDate | String | The Invoice date relating to the original invoice (Spain only) | |
| WithholdingTaxRate | String | IRPF withheld Tax Rate (Spain only) | |
| TotalAmount | String | The total amount of the invoice | |
| ExchangeRate | String | The exchange rate for the invoice | |
| OutstandingAmount | String | The outstanding amount of the invoice | |
| ContactDisplayedAs | String | The name of the resource | |
| ContactId | String |
Contacts.Id | The unique identifier for the item |
| NetAmount | String | The net amount of the invoice | |
| ContactReference | String | The reference of the contact when the invoice was created | |
| PaymentsAllocationsAggregate | String | The associated payments and allocations | |
| BaseCurrencyWithholdingTaxAmount | String | IRPF withheld Tax Amount (Spain only) in the base currency | |
| WithholdingTaxAmount | String | IRPF withheld Tax Amount (Spain only) | |
| UpdatedAt | Datetime | The datetime when the item was last updated | |
| LegacyId | Int | The legacy ID for the item | |
| TaxanalysisAggregate | String | The invoice tax analysis (Optional for Spain, restricted for all other regions) | |
| OriginalInvoiceNumber | String | The number relating to the original invoice (Spain only) | |
| InverseExchangeRate | String | The inverse exchange rate for the credit note | |
| TotalQuantity | String | The total quantity of the invoice | |
| TransactionId | String |
Transactions.Id | The unique identifier for the item |
| StatusDisplayedAs | String | The name of the resource | |
| StatusLegacyId | Int | The legacy ID for the item | |
| StatusId | String | The unique identifier for the item | |
| BaseCurrencyTotalGoodsAmount | String | The total base currency amount relating to goods for all tax rates | |
| BaseCurrencyTotalTax | String | The base currency total tax amount for all tax rates | |
| TotalRetailerTax | String | The total retailer tax amount for all tax rates | |
| BaseCurrencyTotal | String | The total base currency amount for all tax rates | |
| TotalGoodsAmount | String | The total amount relating to goods for all tax rates | |
| TaxRatesBreakdownServicesAmount | String | The total amount for the tax rate relating to services | |
| TaxRatesBreakdownBaseCurrencyNetAmount | String | The base currency net amount for the tax rate | |
| TaxRatesBreakdownName | String | The tax rate name | |
| TaxRatesBreakdownBaseCurrencyServicesAmount | String | The total base currency amount for the tax rate relating to services | |
| TaxRatesBreakdownBaseCurrencyTaxAmount | String | The base currency tax amount for the tax rate | |
| TaxRatesBreakdownBaseCurrencyTotalAmount | String | The base currency total amount for the tax rate | |
| TaxRatesBreakdownGoodsAmount | String | The total amount for the tax rate relating to goods | |
| TaxRatesBreakdownRetailTaxAmount | String | The retailer tax amount for the tax rate | |
| TaxRatesBreakdownBaseCurrencyGoodsAmount | String | The total base currency amount for the tax rate relating to goods | |
| TaxRatesBreakdownTaxRateCreatedAt | Datetime | The datetime when the item was created | |
| TaxRatesBreakdownTaxRateIsCombinedRate | Bool | Indicates whether the tax rate is made up of component tax rates | |
| TaxRatesBreakdownTaxRateDisplayedAs | String | The name of the resource | |
| TaxRatesBreakdownTaxRateName | String | The name of the tax rate | |
| TaxRatePercentageAggregate | String | The tax rate percentage and date ranges they apply to | |
| TransactionTypeId | String |
TaxRates.Id | The unique identifier for the item |
| CreatedAt | Datetime | The datetime when the item was created | |
| PaymentsAllocationsTotalAmount | String | The total amount of all payments and allocations | |
| VoidReason | String | The reason the invoice was voided | |
| TaxReconciled | Bool | Indicates if the artefact is tax reconciled or not. | |
| Editable | Bool | Indicates whether artefact can be edited | |
| VendorReference | String | The vendor reference for the invoice | |
| CurrencyId | String |
Currencies.Id | The unique identifier for the item |
| PurchaseInvoiceLineItemAggregate | String | The invoice lines of the invoice | |
| Notes | String | Invoice notes | |
| TotalPaid | String | The total paid amount of the invoice including any payments, allocations and discounts | |
| DeletedAt | Datetime | The datetime when the item was deleted | |
| BaseCurrencyTaxAmount | String | The tax amount of the invoice in base currency | |
| Date | String | The date of the invoice | |
| BaseCurrencyOutstandingAmount | String | The outstanding amount of the invoice in base currency | |
| ShowPaymentsAllocations | String | ||
| ShowCorrections | String | ||
| Search | String | ||
| ContactId | String | ||
| StatusId | String | ||
| FromDate | Datetime | ||
| ToDate | Datetime | ||
| DeletedSince | Datetime | ||
| HasAttachments | String |