Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: System > Tables

SystemDivisionClassifications: Exact Online System Division Classifications

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: System

Label: System Division Classifications

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

This is a read-only view. The Exact Online API may not support changing the data or the Invantive SQL 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.

Select Exact Online API URL: /api/v1/{division}/system/Divisions?$expand=Class_01,Class_02,Class_03,Class_04,Class_05

Insert Exact Online API URL: /api/v1/{division}/system/Divisions?$expand=Class_01,Class_02,Class_03,Class_04,Class_05

Update Exact Online API URL: /api/v1/{division}/system/Divisions?$expand=Class_01,Class_02,Class_03,Class_04,Class_05

Delete Exact Online API URL: /api/v1/{division}/system/Divisions?$expand=Class_01,Class_02,Class_03,Class_04,Class_05

Exact Online API Metadata URL: /api/v1/{division}/system/$metadata

Field Selection Method: NotRequired

Base Path: $.['Class_01','Class_02','Class_03','Class_04','Class_05']

View Columns

The columns of the view SystemDivisionClassifications are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ClassNameCustomer

guid

 

 

ClassNameDescription

string

 

 

ClassNameID

guid

 

 

Code

string

Code

 

Created

datetime

Created

 

Creator

guid

Creator

 

CreatorFullName

string

Creator Full Name

 

Description

string

Description

 

DescriptionTermID

int32

Description Term ID

 

DvnAddressLine1

string

 

 

DvnAddressLine2

string

 

 

DvnAddressLine3

string

 

 

DvnChamberOfCommerceNumber

string

 

 

DvnCity

string

 

 

DvnCode

int32

 

 

DvnCountry

string

 

 

DvnCreated

datetime

 

 

DvnCurrency

string

 

 

DvnCurrent

boolean

 

 

DvnCustomer

guid

 

 

DvnCustomerCode

string

 

 

DvnCustomerName

string

 

 

DvnDescription

string

 

 

DvnEmail

string

 

 

DvnHid

int64

 

 

DvnIsMainDivision

boolean

 

 

DvnModified

datetime

 

 

DvnPhone

string

 

 

DvnPostcode

string

 

 

DvnState

string

 

 

DvnStatus

int32

 

 

DvnVATNumber

string

 

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

ModifierFullName

string

Modified Full Name

 

SequenceNr

int32

 

 

 

07-11-2021 09:07 Version 20.2.94-PROD+3513