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: Incremental > Tables

AddressesIncremental: Exact Online Addresses (Incremental)

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Incremental

Primary Keys: ID

Label: Addresses (Incremental)

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.

Field Selection Method: NotRequired

View Columns

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

Name

Data Type

Label

Required

Documentation

Account

guid

Account

 

AccountIsSupplier

boolean

Account Is Supplier

 

AddressLine1

string

Address Line 1

 

AddressLine2

string

Address Line 2

 

AddressLine3

string

Address Line 3

 

City

string

City

 

Contact

guid

Contact

 

Country

string

Country

 

Created

datetime

Created

 

Creator

guid

Creator

 

Division

int32

Division

 

Fax

string

Fax

 

FreeBoolField_01

boolean

Free Boolean Field #1

 

FreeBoolField_02

boolean

Free Boolean Field #2

 

FreeBoolField_03

boolean

Free Boolean Field #3

 

FreeBoolField_04

boolean

Free Boolean Field #4

 

FreeBoolField_05

boolean

Free Boolean Field #5

 

FreeDateField_01

datetime

Free Date Field #1

 

FreeDateField_02

datetime

Free Date Field #2

 

FreeDateField_03

datetime

Free Date Field #3

 

FreeDateField_04

datetime

Free Date Field #4

 

FreeDateField_05

datetime

Free Date Field #5

 

FreeNumberField_01

double

Free Number Field #1

 

FreeNumberField_02

double

Free Number Field #2

 

FreeNumberField_03

double

Free Number Field #3

 

FreeNumberField_04

double

Free Number Field #4

 

FreeNumberField_05

double

Free Number Field #5

 

FreeTextField_01

string

Free Text Field #1

 

FreeTextField_02

string

Free Text Field #2

 

FreeTextField_03

string

Free Text Field #3

 

FreeTextField_04

string

Free Text Field #4

 

FreeTextField_05

string

Free Text Field #5

 

ID

guid

ID

Primary key.

Mailbox

string

Mailbox

 

Main

boolean

Main

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

NicNumber

string

NIC Number

 

Notes

string

Notes

 

Phone

string

Phone

 

PhoneExtension

string

Phone Extension

 

Postcode

string

Postal Code

 

State

string

State

 

Timestamp

int64

Timestamp

 

Type

int16

Type

 

Warehouse

guid

Warehouse

 

 

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