Exact Online API Data Model
IncrementalLoadEventLogEntries: Exact Online Incremental Loading Event Log Entries |
Event log entries of incremental loading tables.
Catalog: ExactOnlineDataDictionary
Schema: DataDictionary
Label: Incremental Loading Event Log Entries
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 IncrementalLoadEventLogEntries are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CategoryCode |
string |
Category Code |
☐ |
|
CreatedUtc |
datetime |
Created (UTC) |
☑ |
|
DataContainerId |
string |
Data Container ID |
☐ |
|
FreeField1 |
string |
Free Field 1 |
☐ |
|
FreeField2 |
string |
Free Field 2 |
☐ |
|
FreeField3 |
string |
Free Field 3 |
☐ |
|
FreeField4 |
string |
Free Field 4 |
☐ |
|
FreeField5 |
string |
Free Field 5 |
☐ |
|
IncrementVersion |
int32 |
Increment Version |
☐ |
|
PartitionCode |
string |
Partition Code |
☐ |
|
Source |
string |
Source |
☐ |
|
StatusAlgorithmVersion |
int32 |
Status Algorithm Version |
☑ |
|
StatusCreatedUtc |
datetime |
Status Created (UTC) |
☑ |
|
StatusDeletedRowsFoundCountLast |
int64 |
|
☑ |
|
StatusDeletedRowsFoundCountTotal |
int64 |
|
☑ |
|
StatusDownloadDurationDeletedRowsLastTicks |
int64 |
|
☑ |
|
StatusDownloadDurationDeletedRowsTotalTicks |
int64 |
|
☑ |
|
StatusDownloadDurationModifiedRowsLastTicks |
int64 |
|
☑ |
|
StatusDownloadDurationModifiedRowsTotalTicks |
int64 |
|
☑ |
|
StatusDownloadDurationPreviousRowsLastTicks |
int64 |
|
☑ |
|
StatusDownloadDurationPreviousRowsTotalTicks |
int64 |
|
☑ |
|
StatusEventLogEntriesCount |
int32 |
|
☑ |
|
StatusMaxSeenTimestampCurrent |
int64 |
|
☑ |
|
StatusMaxSeenTimestampCurrentDateTime |
datetime |
|
☐ |
|
StatusMaxSeenTimestampPrevious |
int64 |
|
☐ |
|
StatusMaxSeenTimestampPreviousDateTime |
datetime |
|
☐ |
|
StatusPartitionCode |
string |
|
☐ |
|
StatusPartitionCompanyCity |
string |
|
☐ |
|
StatusPartitionCompanyCountry |
string |
|
☐ |
|
StatusPartitionCompanyEmailAddress |
string |
|
☐ |
|
StatusPartitionCompanyName |
string |
|
☐ |
|
StatusPartitionCompanyPhone |
string |
|
☐ |
|
StatusPartitionCreatedUtc |
datetime |
|
☐ |
|
StatusPartitionName |
string |
|
☐ |
|
StatusPartitionOwnerCompanyName |
string |
|
☐ |
|
StatusRowCount |
int64 |
|
☑ |
|
StatusRowCountPrevious |
int64 |
|
☐ |
|
StatusServiceUrlRequested |
string |
Status Service URL Requested |
☐ |
|
StatusStatisticsCount |
int32 |
|
☑ |
|
StatusTableNameRequested |
string |
Status Table Name Requested |
☐ |
|
StatusTimestampEnvironment |
string |
Status Timestamp Environment |
☐ |
|
StatusUid |
guid |
Status UID |
☑ |
|
StatusVersion |
int32 |
Status Version |
☑ |
|
TableFullQualifiedName |
string |
Full Qualified Table Name |
☐ |
|
Text |
string |
Text |
☐ |
|
Uid |
guid |
|
☑ |
|
15-06-2022 19:32 Version 22.0.232-PROD+3445
