# GLClassificationsBulk: Exact Online General Ledger Classifications - Catalog: `ExactOnlineREST` - Schema: `Financial` - Primary Keys: `ID` - Label: General Ledger Classifications The data in this table is partitioned per value of the `Division` column. This is a read-only table. 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. ## Table Columns The columns of the table `GLClassificationsBulk` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Abstract` | `char` | Abstract | ☐ | Abstract elements are only used in presentation linkbases to group other elements. They are not supposed to be used in instance documents. | | `Balance` | `varchar2` | Balance | ☐ | Only used for amount concepts: in that case either 'debit' or 'credit'. | | `Code` | `varchar2` | Code | ☐ | The Code is unique. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | Name of creator. | | `Description` | `varchar2` | Description | ☐ | Description of the element. Note that this description is only used for division-specific taxonomies (or reporting schemes). | | `Division` | `int32` | Division ID | ☑ | Unique number of the Exact Online division. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `ID` | `guid` | ID | ☑ | Primary key. | | `IsTupleSubElement` | `char` | Is Tuple Sub-element | ☐ | Obsolete. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | Name of modifier. | | `Name` | `varchar2` | Name | ☐ | The Name is unique in the namespace. | | `Nillable` | `char` | Nillable | ☐ | Determines whether usage of the element is mandatory in an instance document. | | `Parent` | `guid` | Parent | ☐ | Parent element for reporting schemes. In a reporting scheme, an element can have only one parent. This column is only used for reporting schemes. Note that in a real taxonomy, elements can have multiple parents. | | `PeriodType` | `varchar2` | Period Type | ☐ | Only used for item concepts: either 'instant' or 'duration'. 'instant' is used for balance types of concepts, 'duration' is used for P&L types of concepts. | | `SubstitutionGroup` | `varchar2` | Substitution Group | ☐ | Mostly import sutstitutiongroup is xbrli:tuple, which makes the element a tuple concept. The default substitutiongroup for item concepts is xbrli:item. | | `TaxonomyNamespace` | `guid` | Tax Component Namespace | ☐ | Namespace of the element. | | `TaxonomyNamespaceDescription` | `varchar2` | | ☐ | Description of TaxonomyNamespace. | | `Type` | `guid` | Type | ☐ | Type of the element. |