invantive documentation
Invantive Support ForumsLog In / Sign Up

FinancialYearsExtended: Exact Online Financial Years (Extended)

read only

  • Catalog: ExactOnlineREST
  • Schema: Views
  • Label: Financial Years (Extended)

Financial years defined for the company.

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 432
Full scan rows per minute 50,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table FinancialYearsExtended are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
DATEEND datetime DATEEND
DATESTART datetime DATESTART
DIVISION_CODE varchar2 Administration ID Internal unique number of the Exact Online administration.
DIVISION_HID int64 Administration Number of the Exact Online administration. Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administration Name Name of the Exact Online administration. Not guaranteed to be unique.
FINANCIALYEAR number Financial Year Number FINANCIALYEAR
PERIODS number PERIODS

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: