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