ODBC Driver for Sage 200

Build 23.0.8839


Additional charges can be added to sales orders to account for items such as carriage and insurance. Within the Sage 200 application, users can setup and maintain the list of additional charges that can be referenced when creating a sales order. This API resource can be used to determine what each additional charge is for.

Table Specific Information


The driver uses the Sage 200c Standard Online API to process all search criteria.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM SalesOrderAdditionalCharges WHERE Id = 42101
SELECT * FROM SalesOrderAdditionalCharges WHERE Code = '0000000001'
SELECT * FROM SalesOrderAdditionalCharges WHERE Name = 'Sample'


Name Type References Description
Id [KEY] Long Sop additional charge record Id.
Code String Sop additional charge code.
Name String Sop additional charge name.
ChargeValue Decimal Sop additional charge value.
NotionalCostValue Decimal Sop additional charge notional cost value.
NominalCodeId Long


Nominal code record Id. See nominal_codes
TaxCodeId Long


Tax code record Id. See tax_codes
DateTimeUpdated Datetime The date and time this entity was last updated (UTC).

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