Power BI Connector for Sage Business Cloud Accounting

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060