ODBC Driver for Sage 200

Build 20.0.7587

SalesTradingPeriods

This resource returns the details of all sales trading periods for all financial years held for the company. A company can have the trading periods set to be the same as the accounting periods or as different periods. (Sage 200c Professional and Sage 200 Extra Online Only, Sage 200c Standard defaults to financial year periods)

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 SalesTradingPeriods WHERE Id=1
SELECT * FROM SalesTradingPeriods WHERE PeriodNumber='1'
SELECT * FROM SalesTradingPeriods WHERE StartDate='2018-01-01T01:00:00.000+01:00'
SELECT * FROM SalesTradingPeriods WHERE EndDate='2018-01-31T01:00:00.000+01:00'
SELECT * FROM SalesTradingPeriods WHERE DateTimeUpdated='2018-02-28T15:23:45.667+01:00'

Columns

Name Type References Description
Id [KEY] Long An unique Id specific to each sales trading period.
PeriodNumber String The period number.
StartDate Date Date the trading period starts. The returned string includes the time but this will always be 00:00:00.
EndDate Date Date the trading period ends. The returned string includes the time but this will always be 00:00:00.
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