invantive documentation
Invantive Support ForumsLog In / Sign Up

BalanceLinesPerPeriodAll: Exact Online Balance Lines per Period (All Years)

read only

  • Catalog: ExactOnlineREST
  • Schema: Balances
  • Label: Balance Lines per Period (All Years)

Complete historical balance sheet for per period. Compared to BalanceLinesPerPeriodEx, this view retrieves all years instead of only at most 5 years.

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 BalanceLinesPerPeriodAll 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
BALANCE decimal Balance balance
CREDIT number Credit
DEBIT number Debit
DIVISION_CODE int32 Division DIVISION_CODE Division code.
DIVISION_HID int64 Division Short Name writable, DIVISION_HID Short name of the Exact Online division.
DIVISION_NAME varchar2(50) Administration Name writable, DIVISION_NAME Name of the Exact Online division.
PERIODS_YEAR_CLOSE number Year Close
PERIODS_YEAR_CREDIT number Year Credit
PERIODS_YEAR_DEBIT number Year Debit
PERIODS_YEAR_OPEN number Year Open
PERIODS_YEAR_REPORTINGYEAR_ATTR number Year Reporting Year
PERIODS_YEAR_YEARS_BALANCE_BALANCETYPE_ATTR varchar2 Balance Balance Type
PERIODS_YEAR_YEARS_BALANCE_CODE_ATTR varchar2 Balance Code
PERIODS_YEAR_YEARS_BALANCE_DESCRIPTION varchar2(255) Balance Description
PERIODS_YEAR_YEARS_BALANCE_LEADCODE varchar2 Balance Lead Code
REPORTINGPERIOD_ATTR number Reporting Period

Release Notes

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