Power BI Connector for Sage 200

Build 20.0.7587

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.

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