invantive documentation
Invantive Support ForumsLog In / Sign Up

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_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.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: