invantive documentation
Invantive Support ForumsLog In / Sign Up

HrmDivisionClassifications: Exact Online HRM Division Classifications

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: HRM
  • Label: HRM Division Classifications

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

API Source

  • Endpoint: /api/v1/{division}/HRM/Divisions?$expand=Class_01,Class_02,Class_03,Class_04,Class_05
  • Metadata: /api/v1/{division}/HRM/$metadata

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 7,200
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Table Columns

The columns of the table HrmDivisionClassifications 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
ClassNameCustomer guid itgen_eol_classnamecustomer writable, ClassNameCustomer Name of class as assigned by Exact Online customer.
ClassNameDescription varchar2 itgen_eol_classnamedescription writable, ClassNameDescription Description of class as assigned by Exact Online customer.
ClassNameID guid itgen_eol_classnameid writable, ClassNameID ID of class as assigned by Exact Online customer.
Code varchar2 Code writable, Code
Created datetime Created writable, Created Creation date.
Creator guid Creator writable, Creator User ID of creator.
CreatorFullName varchar2 Creator Full Name writable, CreatorFullName Name of creator.
Description varchar2 Description writable, Description
DescriptionTermID int32 Description Term ID writable, DescriptionTermID
DvnBlockingStatus int32 Blocking Status writable, ::ancestor.BlockingStatus
DvnCode int32 Code writable, ::ancestor.Code Unique ID of the division.
DvnCountry varchar2 Country writable, ::ancestor.Country Country of the division. Is used for determination of legislation.
DvnCountryDescription varchar2 itgen_eol_dvncountrydescription writable, ::ancestor.CountryDescription Description of the country of the division.
DvnCreated datetime Created writable, ::ancestor.Created Creation date of the division.
DvnCreator guid Creator writable, ::ancestor.Creator User ID of division creator.
DvnCreatorFullName varchar2 Creator Full Name writable, ::ancestor.CreatorFullName Full name of division creator.
DvnCurrency varchar2 Currency writable, ::ancestor.Currency
DvnCurrencyDescription varchar2 itgen_eol_dvncurrencydescription writable, ::ancestor.CurrencyDescription
DvnCustomer guid Customer writable, ::ancestor.Customer
DvnCustomerCode varchar2 Customer Code writable, ::ancestor.CustomerCode
DvnCustomerName varchar2 Customer Name writable, ::ancestor.CustomerName
DvnDescription varchar2 Description writable, ::ancestor.Description
DvnHID int64 Human ID writable, ::ancestor.HID
DvnMain char Main writable, ::ancestor.Main
DvnModified datetime Modified writable, ::ancestor.Modified
DvnModifier guid Modified writable, ::ancestor.Modifier
DvnModifierFullName varchar2 Modified Full Name writable, ::ancestor.ModifierFullName
DvnSiretNumber varchar2 SIRET Number writable, ::ancestor.SiretNumber
DvnStartDate datetime Start Date writable, ::ancestor.StartDate
DvnStatus int16 Status writable, ::ancestor.Status
DvnTaxOfficeNumber varchar2 Tax Office Number writable, ::ancestor.TaxOfficeNumber
DvnTaxReferenceNumber varchar2 itgen_eol_dvntaxreferencenumber writable, ::ancestor.TaxReferenceNumber
DvnVATNumber varchar2 VAT Number writable, ::ancestor.VATNumber
DvnWebsite varchar2 Website writable, ::ancestor.Website
Modified datetime Modified writable, Modified Last modified date.
Modifier guid Modifier writable, Modifier User ID of modifier.
ModifierFullName varchar2 Modified Full Name writable, ModifierFullName Name of modifier.
SequenceNr int32 Sequence Number writable, SequenceNr

Release Notes

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