SyncEngine meta information
This table contains meta information for handling the synchronisation to Master Data Management through the SyncEngine.
The table is automatically updated by Business NXT when data is edited, created or deleted in the specific accounting tables corresponding to each data type. The updates are then picked up by the SyncEngine service and synchronized with Master Data Management.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | SEMtInf | The table name in the database. |
| API identifier | syncEngineMetaInformation | The API identifier used in GraphQL. |
| Table no. | 392 | The table number in the data model. |
The following fields exist in this table:
Foreign Key Integer
An integer value serving as a foreign key for tables with integer primary key values (like Associate, General ledger account and Organisational unit 1-Organisational unit 6).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FkInt32 | The database field name. |
| API identifier | foreignKeyInteger | The API identifier used in GraphQL. |
| Number | 17635 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | AssociateBusiness |
| ||
| Associate | AssociateContact |
| ||
| General ledger account | GeneralLedgerAccount |
| ||
| Company information | CompanyInformation |
| ||
| Organisational unit 1 | OrgUnit1 |
| ||
| Organisational unit 2 | OrgUnit2 |
| ||
| Organisational unit 3 | OrgUnit3 |
| ||
| Organisational unit 4 | OrgUnit4 |
| ||
| Organisational unit 5 | OrgUnit5 |
| ||
| Organisational unit 6 | OrgUnit6 |
| ||
| VAT code | TaxCode |
|
Foreign Key String of length 10
A string value serving as a foreign key for tables with string (10) primary key values (Organisational unit 8-Organisational unit 12).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 10 | Text (10) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FkStr10 | The database field name. |
| API identifier | foreignKeyString10 | The API identifier used in GraphQL. |
| Number | 17739 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
| ||
| Organisational unit 9 | OrgUnit9 |
| ||
| Organisational unit 10 | OrgUnit10 |
| ||
| Organisational unit 11 | OrgUnit11 |
| ||
| Organisational unit 12 | OrgUnit12 |
|
Foreign Key String of length 40
A string value serving as a foreign key for tables with string (40) primary key values (Organisational unit 7).
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | String of length 40 | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | FkStr40 | The database field name. |
| API identifier | foreignKeyString40 | The API identifier used in GraphQL. |
| Number | 17740 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
MDM data type
A value indicating the type of Master Data Type.
- 1 - Business
- 2 - Contact
- 3 - General ledger account
- 4 - Cost unit type
- 5 - Cost unit
- 6 - Tax code
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | MDM data type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MdmDataTp | The database field name. |
| API identifier | mdmDataType | The API identifier used in GraphQL. |
| Number | 17634 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| SyncEngine control information | SyncEngineControlInformation |
|
MDM Deleted version no.
A value indicating the MDM version in which the data was deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | MDM version no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MdmDelVer | The database field name. |
| API identifier | mdmDeletedVersion | The API identifier used in GraphQL. |
| Number | 17638 |
MDM public id
The primary key of this table. A GUID assigned when creating the record, and sent to MDM as the public ID. May be equal to External ID.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | GUID | Text (40) |
| Primary key | Yes | MDM public id |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MdmPubId | The database field name. |
| API identifier | mdmPublicId | The API identifier used in GraphQL. |
| Number | 17633 |
MDM status
A flag field controlling the sync processing in Visma Business Services Host for SyncEngine.
- Synchronisation is pending
- Pending synchronisation is deleted
- Synchronisation is in progress
- Synchronisation failed
- Synchronisation of deletion is in progress
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | MDM status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MdmPrc | The database field name. |
| API identifier | mdmStatus | The API identifier used in GraphQL. |
| Number | 17639 |
MDM Sync version no.
The version of the master data that is synced with the data owner - i.e. this is the version of data that Business NXT has.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | MDM version no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MdmSyncVer | The database field name. |
| API identifier | mdmSyncVersion | The API identifier used in GraphQL. |
| Number | 17637 |
MDM version no.
The version of the master data as known by the local application. Since Business NXT is data owner, MDM version no. and MDM Sync version no. will be the same.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | MDM version no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | MdmVer | The database field name. |
| API identifier | mdmVersion | The API identifier used in GraphQL. |
| Number | 17636 |
MDM operation id
A value linking the record to a Visma.SyncEngine sync operation. When the sync request is issued, an operation ID is returned and stored in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | GUID | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OpId | The database field name. |
| API identifier | operationId | The API identifier used in GraphQL. |
| Number | 17868 |
Organisational Unit
A value used with organisational units to identify the organisational unit type.
- 1 - Organisational unit class 1
- 2 - Organisational unit class 2
- 3 - Organisational unit class 3
- 4 - Organisational unit class 4
- 5 - Organisational unit class 5
- 6 - Organisational unit class 6
- 7 - Organisational unit class 7
- 8 - Organisational unit class 8
- 9 - Organisational unit class 9
- 10 - Organisational unit class 10
- 11 - Organisational unit class 11
- 12 - Organisational unit class 12
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Org. unit class no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrgUnitTp | The database field name. |
| API identifier | orgUnitType | The API identifier used in GraphQL. |
| Number | 17741 |
Sync. attempt counter
A counter for number of sync attempts. Used by Visma Business Services Host for SyncEngine to determine when to fail the sync attempts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SyncAttCnt | The database field name. |
| API identifier | syncAttemptCount | The API identifier used in GraphQL. |
| Number | 17869 |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |