invantive documentation
Invantive Support ForumsLog In / Sign Up

SystemDivisionClassifications: Exact Online System Division Classifications

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: System
  • Label: System 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}/system/Divisions?$expand=Class_01,Class_02,Class_03,Class_04,Class_05
  • Metadata: /api/v1/{division}/system/$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 SystemDivisionClassifications 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
ClassNameDescription varchar2 itgen_eol_classnamedescription writable, ClassNameDescription
ClassNameID guid itgen_eol_classnameid writable, ClassNameID
Code varchar2 Code writable, Code
Created datetime Created writable, Created
Creator guid Creator writable, Creator
CreatorFullName varchar2 Creator Full Name writable, CreatorFullName
Description varchar2 Description writable, Description
DescriptionTermID int32 Description Term ID writable, DescriptionTermID
DvnAddressLine1 varchar2 Address Line 1 writable, ::ancestor.AddressLine1
DvnAddressLine2 varchar2 Address Line 2 writable, ::ancestor.AddressLine2
DvnAddressLine3 varchar2 Address Line 3 writable, ::ancestor.AddressLine3
DvnChamberOfCommerceNumber varchar2 itgen_eol_dvnchamberofcommercenumber writable, ::ancestor.ChamberOfCommerceNumber
DvnCity varchar2 City writable, ::ancestor.City
DvnCode int32 Code writable, ::ancestor.Code
DvnCountry varchar2 Country writable, ::ancestor.Country
DvnCreated datetime Created writable, ::ancestor.Created
DvnCurrency varchar2 Currency writable, ::ancestor.Currency
DvnCurrent char Current writable, ::ancestor.Current
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
DvnEmail varchar2 Email writable, ::ancestor.Email
DvnHid int64 Human ID writable, ::ancestor.Hid
DvnIsMainDivision char Is Main Division writable, ::ancestor.IsMainDivision
DvnModified datetime Modified writable, ::ancestor.Modified
DvnPhone varchar2 Phone writable, ::ancestor.Phone
DvnPostcode varchar2 Postcode writable, ::ancestor.Postcode
DvnState varchar2 State writable, ::ancestor.State
DvnStatus int32 Status writable, ::ancestor.Status
DvnVATNumber varchar2 VAT Number writable, ::ancestor.VATNumber
Modified datetime Modified writable, Modified
Modifier guid Modifier writable, Modifier
ModifierFullName varchar2 Modified Full Name writable, ModifierFullName
SequenceNr int32 Sequence Number writable, SequenceNr

Release Notes

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