GLClassificationMemberClassifications: Exact Online GL Classification Member Classifications
read only per partition XML
- Catalog:
ExactOnlineXML - Schema:
XML - Label: GL Classification Member Classifications
GL Classification Member Classifications
The data in this table is partitioned per value of the Division column.
Can only retrieve data.
Summary
Classifications and the GL accounts contained in them.
Additional where-clause columns supported:
- division
- glschemecode (1 )
Example
The classification '113' contains classifications '1131' and '113b'.
API Source
- XML topic:
GLClassificationMemberClassifications
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 GLClassificationMemberClassifications 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 |
|---|---|---|---|---|---|
CHILD_ |
varchar2 |
Child Code | Child classification. | ||
CHILD_ |
number |
Child Depth | Child depth. | ||
CLASSIFICATION_ |
number |
Depth | Depth. | ||
CODE_ |
varchar2 |
Code | Code of the classification. | ||
DEPTH_ |
number |
Depth Distance | Distance in levels. | ||
DIRECT_ |
char |
Direct Child | Is classification a direct child of master 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. | ||
ROWNUM |
int64 |
Row Number | Number of the row within the results, starting at 1. | ||
SCHEME_ |
varchar2 |
Scheme Code | Code of the reporting scheme. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: