ODBC Driver for Sage Business Cloud Accounting

Build 26.0.9655

SalesCreditNotes

Query SalesCreditNotes in Sage Business Cloud Accounting.

Table Specific Information

Query the available SalesCreditNotes

Select

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

  • ContactId supports the '=' operator.
  • StatusId supports the '=' operator.
  • ShowPaymentsAllocations supports the '=' operator.
  • MarkAsSent supports the '=' operator.
  • ShowPaymentsAllocations supports the '=' operator.
  • Search 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 SalesCreditNotes WHERE ContactId = 'abc'
SELECT * FROM SalesCreditNotes WHERE StatusId = 'abc'
SELECT * FROM SalesCreditNotes WHERE ShowPaymentsAllocations = 'abc'
SELECT * FROM SalesCreditNotes WHERE MarkAsSent = 'abc'
SELECT * FROM SalesCreditNotes WHERE ShowPaymentsAllocations = 'abc'
SELECT * FROM SalesCreditNotes WHERE Search = 'abc'
SELECT * FROM SalesCreditNotes WHERE FromDate = '2018-12-15'
SELECT * FROM SalesCreditNotes WHERE ToDate = '2018-12-15'
SELECT * FROM SalesCreditNotes WHERE UpdatedOrCreatedSince = '2018-12-15'
SELECT * FROM SalesCreditNotes WHERE DeletedSince = '2018-12-15'
SELECT * FROM SalesCreditNotes WHERE HasAttachments = 'abc'

Insert

Create a simple sales credit note. 

INSERT INTO  [SalesCreditNotes] (ContactName, TotalQuantity, DisplayedAs) VALUES ('test', '1', 'test')

Update

Updates are performed based on Id. 

UPDATE SalesCreditNotes SET Reference = 'abc' WHERE Id = '123'

Delete

You must specify the Id of the SalesCreditNotes to delete it. 

DELETE FROM SalesCreditNotes WHERE id = '123'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the item

DisplayedAs String True

The name of the resource

Reference String False

The reference for the credit note

SalesCreditNoteLineItemAggregate String False

The credit note lines of the credit note

BaseCurrencyTotalAmount String False

The total amount of the credit note in base currency

MainAddressId String True

Addresses.Id

The unique identifier for the item

BaseCurrencyNetAmount String False

The net amount of the credit note in base currency

BaseCurrencyShippingTaxBreakdownAggregate String True

The shipping tax breakdown for the credit note in base currency

ContactName String False

The name of the contact when the credit note was created

SentByEmail Bool True

Indicates whether the credit note has been emailed

ShippingTaxBreakdownAggregate String True

The shipping tax breakdown for the credit note

Migrated Bool True

Indicates if the sales credit note was migrated from another system.

TotalDiscountAmount String False

The discount amount on the credit note

TaxAmount String False

The tax amount of the credit note

LastPaid String True

The date of the last payment

CreditNoteNumber String False

The generated credit note number

PaymentsAllocationsTotalDiscount String True

The total discount of all payments and allocations

TotalAmount String False

The total amount of the credit note

ExchangeRate String False

The exchange rate for the credit note

OutstandingAmount String True

The outstanding amount of the credit note

ContactId String False

Contacts.Id

The unique identifier for the item

NetAmount String False

The net amount of the credit note

ContactReference String False

The reference of the contact when the credit note was created

TaxAddressRegionDisplayedAs String True

The name of the resource

TaxAddressRegionLegacyId Int True

The legacy ID for the item

TaxAddressRegionId String False

The unique identifier for the item

TaxCalculationMethod String True

The tax calculation method, if applicable, for this sales credit note, returns invoice or cash.

TermsAndConditions String False

Credit note terms and conditions

PaymentsAllocationsAggregate String True

The associated payments and allocations

ShippingTaxRateId String False

TaxRates.Id

The unique identifier for the item

Sent Bool False

Indicates whether the credit note has been sent

DeliveryAddressId String True

Addresses.Id

The unique identifier for the item

UpdatedAt Datetime True

The datetime when the item was last updated

LegacyId Int True

The legacy ID for the item

TaxAnalysisAggregate String False

The credit note tax analysis

BaseCurrencyShippingTotalAmount String False

The total shipping amount in base currency

InverseExchangeRate String False

The inverse exchange rate for the credit note

TransactionId String True

Transactions.Id

The unique identifier for the item

TotalQuantity String False

The total quantity of the credit note

StatusDisplayedAs String True

The name of the resource

StatusLegacyId Int True

The legacy ID for the item

StatusId String False

The unique identifier for the item

DetailedTaxAnalysisBaseCurrencyTotalGoodsAmount String True

The total base currency amount relating to goods for all tax rates

DetailedTaxAnalysisBaseCurrencyTotalTax String True

The base currency total tax amount for all tax rates

DetailedTaxAnalysisTotalRetailerTax String True

The total retailer tax amount for all tax rates

DetailedTaxAnalysisBaseCurrencyTotal String True

The total base currency amount for all tax rates

DetailedTaxAnalysisTotalGoodsAmount String True

The total amount relating to goods for all tax rates

DetailedTaxAnalysisTotalNet String True

The total net amount for all tax rates

DetailedTaxAnalysisBaseCurrencyTotalServicesAmount String True

The total base currency amount relating to services for all tax rates

DetailedTaxAnalysisBaseCurrencyTotalNet String True

The base currency total net amount for all tax rates

DetailedTaxAnalysisTotalServicesAmount String True

The total amount relating to services for all tax rates

DetailedTaxAnalysisTotal String True

The total amount for all tax rates

DetailedTaxAnalysisTotalTax String True

The total tax amount for all tax rates

TransactionTypeId String True

TransactionTypes.Id

The unique identifier for the item

BaseCurrencyShippingTaxAmount String False

The tax shipping amount in base currency

ShippingTaxAmount String False

The tax shipping amount. NOTE: This is not required for POST/PUT requests as the shipping tax is calculated based on the shipping_net_amount and the shipping_tax_rate.

CreatedAt Datetime True

The datetime when the item was created

PaymentsAllocationsTotalAmount String True

The total amount of all payments and allocations

CreditNoteNumberPrefix String False

The credit note number prefix

VoidReason String True

The reason the credit note was voided

TaxReconciled Bool True

Indicates if the sales credit note is tax reconciled or not.

Editable Bool True

Indicates whether artefact can be edited

ShippingTotalAmount String False

The total shipping amount

BaseCurrencyShippingNetAmount String False

The net shipping amount in base currency

ShippingNetAmount String False

The net shipping amount

CurrencyDisplayedAs String True

The name of the resource

CurrencyLegacyId Int True

The legacy ID for the item

CurrencyId String False

The unique identifier for the item

Notes String False

credit note notes

MainAddressFreeForm String True

The free-form main address of the credit note

TotalPaid String True

The total paid amount of the credit note including any payments, allocations and discounts

DeletedAt Datetime True

The datetime when the item was deleted

Date String False

The date of the credit note

BaseCurrencyTaxAmount String False

The tax amount of the credit note in base currency

BaseCurrencyOutstandingAmount String True

The outstanding amount of the credit note in base currency

BaseCurrencyTotalDiscountAmount String False

The discount amount on the credit note in base currency

ShowPaymentsAllocations String False

MarkAsSent String False

Search String False

FromDate Datetime True

ToDate Datetime True

DeletedSince Datetime True

HasAttachments String True

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655