# GLAccountClassificationRelations: Exact Online GL Account Classification Relations GL Account Classification Relations ## Documentation: Relationships between GL Account Classifications.chr(13) || chr(10) || chr(13) || chr(10)chr(13) || chr(10) || chr(13) || chr(10)Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- divisionchr(13) || chr(10) || chr(13) || chr(10)- glschemecode (1 ) - Catalog: `ExactOnlineXML` - Schema: `XML` - Alias: `gcn` - Label: GL Account Classification Relations Example: The classification '113' is a member of '11'. The data in this table is partitioned per value of the `Division` column. This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. - Filters on API Server: division - glschemecode (1 ) ## View Columns The columns of the view `GLAccountClassificationRelations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CLASSIFICATION_DEPTH` | `number` | Depth | ☑ | Depth. | | `CODE_ATTR` | `varchar2` | Code | ☑ | Code of the classification. | | `DESCRIPTION` | `varchar2` | Description | ☑ | Description of the classification. | | `DIVISION_CODE` | `varchar2` | 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` | `varchar2`(240) | Administration Name | ☑ | Name of the Exact Online administration. Not guaranteed to be unique. | | `GLSCHEMECODE` | `varchar2` | Scheme Code | ☐ | | | `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. | | `PARENT_CODE_ATTR` | `varchar2` | Parent Code | ☐ | Code of the parent classification. | | `PARENT_DESCRIPTION` | `varchar2` | Parent Description | ☐ | Description of the parent classification. | | `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. | | `SCHEME_CODE_ATTR` | `varchar2` | Scheme Code | ☑ | Code of the reporting scheme. | | `SCHEME_DESCRIPTION` | `varchar2` | Scheme Description | ☑ | Description of the reporting scheme. |