invantive documentation
Invantive Support ForumsLog In / Sign Up

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_CODE_ATTR varchar2 Child Code Child classification.
CHILD_DEPTH number Child Depth Child depth.
CLASSIFICATION_DEPTH number Depth Depth.
CODE_ATTR varchar2 Code Code of the classification.
DEPTH_DISTANCE number Depth Distance Distance in levels.
DIRECT_CHILD char Direct Child Is classification a direct child of master 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.
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.

Release Notes

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