Exact Online API Data Model
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
