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). |