GLAccountClassificationRelations: Exact Online GL Account Classification Relations
read only per partition XML
- Catalog:
ExactOnlineXML - Schema:
XML - Label: GL Account Classification Relations
GL Account Classification Relations
The data in this table is partitioned per value of the Division column.
Can only retrieve data.
Summary
Relationships between GL Account Classifications.
Additional where-clause columns supported:
- division
- glschemecode (1 )
Example
The classification '113' is a member of '11'.
API Source
- XML topic:
GLAccountClassificationRelations
Performance Characteristics
| Characteristic | Value |
|---|---|
| Estimated rows | 500 |
| Estimated size (bytes) | 0 |
The result can be cached on the client.
Table Columns
The columns of the table GLAccountClassificationRelations 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 |
|---|---|---|---|---|---|
CLASSIFICATION_ |
number |
Depth | Depth. | ||
CODE_ |
varchar2 |
Code | Code of the classification. | ||
DESCRIPTION |
varchar2 |
Description | Description of the classification. | ||
DIVISION_ |
varchar2 |
Administration ID | Internal unique number of the Exact Online administration. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration. Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Administration Name | Name of the Exact Online administration. Not guaranteed to be unique. | ||
GLSCHEMECODE |
varchar2 |
Scheme Code | |||
INTERFACE_ |
varchar2 |
Interface URL | URL used to interface this row with Exact Online. | ||
PARENT_ |
varchar2 |
Parent Code | Code of the parent classification. | ||
PARENT_ |
varchar2 |
Parent Description | Description of the parent classification. | ||
ROWNUM |
int64 |
Row Number | Number of the row within the results, starting at 1. | ||
SCHEME_ |
varchar2 |
Scheme Code | Code of the reporting scheme. | ||
SCHEME_ |
varchar2 |
Scheme Description | Description of the reporting scheme. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: