invantive documentation
Invantive SupportforenAnmelden / Eintragen

HrmDivisionClassifications: Exact Online HRM Division Classifications

read only per partition REST

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

Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.

Es können nur Daten abgerufen werden.

API-Quelle

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

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 5
Anzahl der Vollscan-Zeilen pro Minute 7,200
Anzahl der Query-Zeilen pro Minute 300
Zeilen pro Minute schreiben 300

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Tabellenspalten

Die Spalten der Tabelle HrmDivisionClassifications sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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 Ersteller vollständiger Name writable, CreatorFullName Name of creator.
Description varchar2 Description writable, Description
DescriptionTermID int32 Beschreibung Begriffs-ID writable, DescriptionTermID
DvnBlockingStatus int32 Status Blockierung 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 Ersteller vollständiger 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 Kunde-Code writable, ::ancestor.CustomerCode
DvnCustomerName varchar2 Name des Kunden writable, ::ancestor.CustomerName
DvnDescription varchar2 Description writable, ::ancestor.Description
DvnHID int64 Personen-ID writable, ::ancestor.HID
DvnMain char Main writable, ::ancestor.Main
DvnModified datetime Modified writable, ::ancestor.Modified
DvnModifier guid Modified writable, ::ancestor.Modifier
DvnModifierFullName varchar2 Geänderter vollständiger Name writable, ::ancestor.ModifierFullName
DvnSiretNumber varchar2 SIRET Nummer writable, ::ancestor.SiretNumber
DvnStartDate datetime Anfangsdatum writable, ::ancestor.StartDate
DvnStatus int16 Status writable, ::ancestor.Status
DvnTaxOfficeNumber varchar2 Finanzamt Nummer writable, ::ancestor.TaxOfficeNumber
DvnTaxReferenceNumber varchar2 itgen_eol_dvntaxreferencenumber writable, ::ancestor.TaxReferenceNumber
DvnVATNumber varchar2 Umsatzsteuer-Nummer 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 Geänderter vollständiger Name writable, ModifierFullName Name of modifier.
SequenceNr int32 Sequenznummer writable, SequenceNr

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: