Please enable JavaScript to view this site.

Navigation: Catalog: ExactOnlineXML > Schemas > Schema: XML > Tables

BalanceLinesPerPeriod: Exact Online Balance Lines per Period

Catalog: ExactOnlineXML

Schema: XML

Label: Balance Lines per Period

Documentation:

The current balance (debit versus credit) per combination of Exact Online company (division), financial year, financial period and for every GL account on balance and Profit and Loss.

 

Additional where-clause columns supported:

- division

- year

- prevyears (2 )

- period_from

- period_to

- afterentry (1 )

- showperiods (1 )

The data in this table is partitioned per value of the Division column.

Retrieve: true

Insert: true

Update: true

Delete: false

Exact Online API URL: Balances

Topic: Balances

Base XPath: /eExact/Balances/Balance

XPath: /Years/Year/Periods/Period

Named Complex Type: Balances

Filters on API Server: division- year- prevyears (2 )- period_from- period_to- afterentry (1 )- showperiods (1 )

View Columns

The columns of the view BalanceLinesPerPeriod 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 or update.

Name

Data Type

Label

Required

Documentation

BALANCE

decimal

Balance

 

COSTANALYSIS

string

Cost Analysis

 

 

CREDIT

decimal

Credit

 

 

DEBIT

decimal

Debit

 

 

DIVISION_CODE

string

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

string(240)

Administration Name

Name of the Exact Online administration. Not guaranteed to be unique.

INTERFACE_URL

string(4000)

Interface URL

URL used to interface this row with Exact Online.

PERIODS_YEAR_CLOSE

decimal

Year Close

 

 

PERIODS_YEAR_COSTANALYSIS

string

Year Cost Analysis

 

 

PERIODS_YEAR_CREDIT

decimal

Year Credit

 

 

PERIODS_YEAR_DEBIT

decimal

Year Debit

 

 

PERIODS_YEAR_OPEN

decimal

Year Open

 

 

PERIODS_YEAR_REPORTINGYEAR_ATTR

int64

Year Reporting Year

 

 

PERIODS_YEAR_YEARS_BALANCE_ADDRESS

string

Balance Address

 

 

PERIODS_YEAR_YEARS_BALANCE_BALANCETYPE_ATTR

string

Balance Balance Type

 

 

PERIODS_YEAR_YEARS_BALANCE_CHAMBEROFCOMMERCE

string

Balance Chamber of Commerce

 

 

PERIODS_YEAR_YEARS_BALANCE_CITY

string

Balance City

 

 

PERIODS_YEAR_YEARS_BALANCE_CODE_ATTR

string

Balance Code

 

 

PERIODS_YEAR_YEARS_BALANCE_COMPANYNAME

string

Balance Company Name

 

 

PERIODS_YEAR_YEARS_BALANCE_COUNTRY_CODE_ATTR

string

Country Code

 

 

PERIODS_YEAR_YEARS_BALANCE_COUNTRY_DESCRIPTION_TERMID_ATTR

int64

Balance Country Term ID

 

 

PERIODS_YEAR_YEARS_BALANCE_COUNTRY_DESCRIPTION

string(255)

Country Description

 

 

PERIODS_YEAR_YEARS_BALANCE_DESCRIPTION_TERMID_ATTR

int64

 

 

 

PERIODS_YEAR_YEARS_BALANCE_DESCRIPTION

string(255)

Balance Description

 

 

PERIODS_YEAR_YEARS_BALANCE_LEADCODE

string

Balance Lead Code

 

 

PERIODS_YEAR_YEARS_BALANCE_POSTALCODE

string

Balance Postal Code

 

 

PREVYEARS

int32

Previous Years Included

 

REPORTINGPERIOD_ATTR

int64

Reporting Period

 

 

ROWNUM

int32

Row Number

Number of the row within the results, starting at 1.

 

15-06-2022 19:32 Version 22.0.232-PROD+3445