EXT Sync Record
A temporary table that contains data about a record that is logged in External System Change Log. Used when an external system gets changed records.
Object Definition
Object Type | Table |
Object ID | 70314129 |
Object Name | QWESR EXT Sync Record |
Procedures
Fields
Number |
Name |
Type |
Description |
1 |
Entry No. |
BigInteger |
Specifies the unique entry no. for the external system change log entry that this record represents. |
10 |
Subsystem Code |
Code[20] |
Specifies the code of the External Subsystem that this change was logged for. This is blank if the External System doesn't have any subsystems. |
11 |
Change Type |
Enum "QWESR Ext. Sys. Change Type" |
Specifies the type of the change that triggered the logging of this record. |
12 |
Record ID |
RecordId |
Specifies the RecordId of the record that was changed. |
13 |
Table No. |
Integer |
Specifies the Id of the Table that the changed record belongs to. |
14 |
Record SystemId |
Guid |
Specifies the SystemId of the record that was changed. This can be used together with the "Table No." to fetch the changed record. |
15 |
System Code |
Code[20] |
Specifies the System Code of the record that was changed. |
16 |
Fetch ID |
Guid |
Specifies the id of a batch of entries fetched by an external system. |
17 |
Current Row Version |
BigInteger |
Specifies the Last Used RowVersion when the record was changed. This can be used to verify that we get a newer version of the record when performing a synchronization. |
21 |
Date and Time |
DateTime |
Specifies the date and time that the record was changed. |
22 |
Setup Line No. |
Integer |
Specifies the line number of the QWESR Ext. Sys. Sync Stp (Tbl) table that caused the logging of this record. |
100 |
Log SystemId |
Guid |
Specifies the SystemId of the external system change log entry that this record represents. |
This documentation is generated from Spider v27.0