Exact Online API Data Model
IncrementalLoadStatuses: Exact Online Incremental Loading Statuses |
Status of incremental loading tables.
Catalog: ExactOnlineDataDictionary
Schema: DataDictionary
Label: Incremental Loading Statuses
The data in this table is partitioned per value of the Division column.
This is a read-only table. 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: Required
Table Columns
The columns of the table IncrementalLoadStatuses are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AlgorithmVersion |
int32 |
|
☑ |
|
CreatedUtc |
datetime |
Created (UTC) |
☑ |
|
DeletedRowsFoundCountLast |
int64 |
|
☑ |
|
DeletedRowsFoundCountTotal |
int64 |
|
☑ |
|
DownloadDurationDeletedRowsLastTicks |
int64 |
|
☑ |
|
DownloadDurationDeletedRowsTotalTicks |
int64 |
|
☑ |
|
DownloadDurationModifiedRowsLastTicks |
int64 |
|
☑ |
|
DownloadDurationModifiedRowsTotalTicks |
int64 |
|
☑ |
|
DownloadDurationPreviousRowsLastTicks |
int64 |
|
☑ |
|
DownloadDurationPreviousRowsTotalTicks |
int64 |
|
☑ |
|
EventLogEntriesCount |
int32 |
|
☑ |
|
MaxSeenTimestampCurrent |
int64 |
|
☑ |
|
MaxSeenTimestampCurrentDateTime |
datetime |
|
☐ |
|
MaxSeenTimestampPrevious |
int64 |
|
☐ |
|
MaxSeenTimestampPreviousDateTime |
datetime |
|
☐ |
|
PartitionCode |
string |
Partition Code |
☐ |
|
PartitionCompanyCity |
string |
Partition Company City |
☐ |
|
PartitionCompanyCountry |
string |
Partition Company Country |
☐ |
|
PartitionCompanyEmailAddress |
string |
Partition Company Email Address |
☐ |
|
PartitionCompanyName |
string |
Partition Company Name |
☐ |
|
PartitionCompanyPhone |
string |
Partition Company Phone |
☐ |
|
PartitionCreatedUtc |
datetime |
|
☐ |
|
PartitionName |
string |
Partition Name |
☐ |
|
PartitionOwnerCompanyName |
string |
|
☐ |
|
RowCount |
int64 |
Rows |
☑ |
|
RowCountPrevious |
int64 |
Previous Row Count |
☐ |
|
ServiceUrlRequested |
string |
|
☐ |
|
StatisticsCount |
int32 |
|
☑ |
|
TableNameRequested |
string |
|
☐ |
|
TimestampEnvironment |
string |
|
☐ |
|
Uid |
guid |
|
☑ |
|
Version |
int32 |
Version |
☑ |
|
15-06-2022 19:32 Version 22.0.232-PROD+3445
