Power BI Connector for Sage 200

Build 20.0.7587

SalesOrderAdditionalCharges

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

Select

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'

Columns

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

NominalCodes.Id

Nominal code record Id. See nominal_codes
TaxCodeId Long

TaxCodes.Id

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587