FinancialYearPeriods
This resource returns the details of all accounting periods for all financial years held for the company. A company always has five future financial years and can have unlimited previous years, depending on how long the company has been operating. The default sort (orderby) field are by 'financial_year_start_date' and 'period_number' ascending.
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 FinancialYearPeriodViews WHERE FinancialYearId = 1 SELECT * FROM FinancialYearPeriodViews WHERE FinancialYearStartDate = '2018-01-01T01:00:00.000+01:00' SELECT * FROM FinancialYearPeriodViews WHERE FinancialYearEndDate = '2018-12-31T01:00:00.000+01:00' SELECT * FROM FinancialYearPeriodViews WHERE YearRelativeToCurrentYear = 0 SELECT * FROM FinancialYearPeriodViews WHERE NumberOfPeriodsInYear = 12 SELECT * FROM FinancialYearPeriodViews WHERE AccountingPeriodId = 1 SELECT * FROM FinancialYearPeriodViews WHERE PeriodNumber = 1 SELECT * FROM FinancialYearPeriodViews WHERE PeriodStartDate = '2018-01-01T01:00:00.000+01:00' SELECT * FROM FinancialYearPeriodViews WHERE PeriodEndDate = '2018-01-31T01:00:00.000+01:00'
Columns
Name | Type | References | Description |
FinancialYearId [KEY] | Long | An Id specific to each financial year. | |
FinancialYearStartDate | Date | Date the financial year starts. The returned string includes the time but this will always be 00:00:00. | |
FinancialYearEndDate | Date | Date the financial year ends. The returned string includes the time but this will always be 00:00:00. | |
YearRelativeToCurrentYear | Int | Value to represent the year relative to the current financial year. The current financial year is 0. The first previous year is -1. The first future year is 1. | |
NumberOfPeriodsInYear | Int | The number of periods in the financial year. | |
AccountingPeriodId | Long | An Id specific to each accounting period. | |
PeriodNumber | Int | Value to show the period in relation to the associated year. For example, for a year that starts in January, January will be period 1, February period 2 etc. | |
PeriodStartDate | Date | Date the period starts. The returned string includes the time but this will always be 00:00:00. | |
PeriodEndDate | Date | Date the period finished. The returned string includes the time but this will always be 00:00:00. |