Table "Integration Table Mapping"

ID 5335
Namespace: Microsoft.Integration.SyncEngine

Properties

Name Value
Caption Integration Table Mapping
DrillDownPageID Page Microsoft.Integration.SyncEngine."Integration Table Mapping List"
LookupPageID Page Microsoft.Integration.SyncEngine."Integration Table Mapping List"
DataClassification CustomerContent

Fields

Name Type Description
Name Code[20]

Specifies the name of the integration table mapping entry.
"Table ID" Integer
"Integration Table ID" Integer
"Synch. Codeunit ID" Integer
"Integration Table UID Fld. No." Integer
"Int. Tbl. Modified On Fld. No." Integer
"Int. Table UID Field Type" Integer
"Table Config Template Code" Code[10]
"Int. Tbl. Config Template Code" Code[10]
Direction Option

Specifies the synchronization direction.
"Int. Tbl. Caption Prefix" Text[30]

Specifies text that appears before the caption of the integration table wherever the caption is used.
"Synch. Int. Tbl. Mod. On Fltr." DateTime

Specifies a date/time filter that uses the date on which records were modified to determine which records to synchronize to the integration system. The filter is based on the SystemModifiedAt field on the Business Central table records.
"Synch. Modified On Filter" DateTime

Specifies a date/time filter that uses the date on which records were modified to determine which records to synchronize from the system you are integrating with. The filter is based on the Modified On field on the integration table records.
"Table Filter" Blob
"Integration Table Filter" Blob
"Synch. Only Coupled Records" Boolean

Specifies if the synchronization engine will process only currently coupled records or couple the newly created records as well.
"Parent Name" Code[20]
"Graph Delta Token" Text[250]
"Int. Tbl. Delta Token Fld. No." Integer
"Int. Tbl. ChangeKey Fld. No." Integer
"Int. Tbl. State Fld. No." Integer
"Delete After Synchronization" Boolean
"BC Rec Page Id" Integer
"CDS Rec Page Id" Integer
"Deletion-Conflict Resolution" Enum Microsoft.Integration.SyncEngine."Integration Deletion Conflict Resolution"

Specifies the action to take when a coupled record is deleted in one of the connected applications.
"Update-Conflict Resolution" Enum Microsoft.Integration.SyncEngine."Integration Update Conflict Resolution"

Specifies the action to take when a coupled record is updated in both of the connected applications.
"Uncouple Codeunit ID" Integer
"Coupling Codeunit ID" Integer
"Synch. After Bulk Coupling" Boolean
"Dependency Filter" Text[250]
"Create New in Case of No Match" Boolean
Type Enum Microsoft.Integration.SyncEngine."Integration Table Mapping Type"
"Disable Event Job Resch." Boolean

Specifies if event-based rescheduling of synchronization jobs should be turned off for this table mapping.
"Multi Company Synch. Enabled" Boolean

Specifies if the multi-company synchronization is enabled for this mapping.
"Table Caption" Text[250]
"No. of Errors" Integer

Specifies the number of errors for this mapping.
"No. of Skipped" Integer

Specifies the number of records that are excluded from the synchronization because of repetitive errors.
"Full Sync is Running" Boolean
"Full Sync Session ID" Integer
"Last Full Sync Start DateTime" DateTime
"User Defined" Boolean

Specifies if the field is generated manually through the integration table mapping wizard.
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

FindFilteredRec

procedure FindFilteredRec(RecordRef: RecordRef; var OutOfMapFilter: Boolean): Boolean

Parameters

Name Type Description
RecordRef RecordRef
OutOfMapFilter Boolean

Returns

Type Description
Boolean

FindMapping

[Scope(Cloud)]
procedure FindMapping(TableNo: Integer; IntegrationTableNo: Integer): Boolean

Parameters

Name Type Description
TableNo Integer
IntegrationTableNo Integer

Returns

Type Description
Boolean

FindMappingForTable

procedure FindMappingForTable(TableId: Integer): Boolean

Parameters

Name Type Description
TableId Integer

Returns

Type Description
Boolean

DoesExistForTable

procedure DoesExistForTable(TableId: Integer): Boolean

Parameters

Name Type Description
TableId Integer

Returns

Type Description
Boolean

IsFullSynch

procedure IsFullSynch(): Boolean

Returns

Type Description
Boolean

GetName

procedure GetName(): Code[20]

Returns

Type Description
Code[20]

GetDirection

procedure GetDirection(): Integer

Returns

Type Description
Integer

GetJobLogEntryNo

procedure GetJobLogEntryNo(): Integer

Returns

Type Description
Integer

GetTempDescription

procedure GetTempDescription(): Text

Returns

Type Description
Text

GetExtendedIntegrationTableCaption

procedure GetExtendedIntegrationTableCaption(): Text

Returns

Type Description
Text

GetUserFriendlyMappingName

procedure GetUserFriendlyMappingName(): Text

Returns

Type Description
Text

SetTableFilter

procedure SetTableFilter(Filter: Text)

Parameters

Name Type Description
Filter Text

GetTableFilter

procedure GetTableFilter(): Text

Returns

Type Description
Text

SetIntegrationTableFilter

procedure SetIntegrationTableFilter(IntTableFilter: Text)

Parameters

Name Type Description
IntTableFilter Text

GetIntegrationTableFilter

procedure GetIntegrationTableFilter(): Text

Returns

Type Description
Text

SetIntTableModifiedOn

procedure SetIntTableModifiedOn(ModifiedOn: DateTime)

Parameters

Name Type Description
ModifiedOn DateTime

SetTableModifiedOn

procedure SetTableModifiedOn(ModifiedOn: DateTime)

Parameters

Name Type Description
ModifiedOn DateTime

SetJobLogEntryNo

procedure SetJobLogEntryNo(NewJobLogEntryNo: Integer)

Parameters

Name Type Description
NewJobLogEntryNo Integer

ShowLog

procedure ShowLog(JobIDFilter: Text)

Parameters

Name Type Description
JobIDFilter Text

ShowSynchronizationLog

procedure ShowSynchronizationLog(var IntegrationTableMapping: Record "Integration Table Mapping")

Parameters

Name Type Description
IntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"

ShowUncouplingLog

procedure ShowUncouplingLog(var IntegrationTableMapping: Record "Integration Table Mapping")

Parameters

Name Type Description
IntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"

ShowCouplingLog

procedure ShowCouplingLog(var IntegrationTableMapping: Record "Integration Table Mapping")

Parameters

Name Type Description
IntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"

SetOriginalJobQueueEntryOnHold

procedure SetOriginalJobQueueEntryOnHold(var JobQueueEntry: Record "Job Queue Entry"; var PrevStatus: Option)

Parameters

Name Type Description
JobQueueEntry Table System.Threading."Job Queue Entry"
PrevStatus Option

SetOriginalJobQueueEntryStatus

procedure SetOriginalJobQueueEntryStatus(var JobQueueEntry: Record "Job Queue Entry"; Status: Option)

Parameters

Name Type Description
JobQueueEntry Table System.Threading."Job Queue Entry"
Status Option

UpdateTableMappingModifiedOn

procedure UpdateTableMappingModifiedOn(LatestModifiedOn: array[2] of DateTime)

Parameters

Name Type Description
LatestModifiedOn array[2] of DateTime

SynchronizeNow

procedure SynchronizeNow(ResetLastSynchModifiedOnDateTime: Boolean)

Parameters

Name Type Description
ResetLastSynchModifiedOnDateTime Boolean

SynchronizeNow

procedure SynchronizeNow(ResetLastSynchModifiedOnDateTime: Boolean; ResetSynchonizationTimestampOnRecords: Boolean)

Parameters

Name Type Description
ResetLastSynchModifiedOnDateTime Boolean
ResetSynchonizationTimestampOnRecords Boolean

GetRecordRef

procedure GetRecordRef(ID: Variant; var IntegrationRecordRef: RecordRef): Boolean

Parameters

Name Type Description
ID Variant
IntegrationRecordRef RecordRef

Returns

Type Description
Boolean

SetIntRecordRefFilter

procedure SetIntRecordRefFilter(var IntRecordRef: RecordRef)

Parameters

Name Type Description
IntRecordRef RecordRef

SetIntRecordRefFilter

procedure SetIntRecordRefFilter(var IntRecordRef: RecordRef; TableFilter: Text)

Parameters

Name Type Description
IntRecordRef RecordRef
TableFilter Text

SetRecordRefFilter

procedure SetRecordRefFilter(var RecordRef: RecordRef)

Parameters

Name Type Description
RecordRef RecordRef

CopyModifiedOnFilters

procedure CopyModifiedOnFilters(FromIntegrationTableMapping: Record "Integration Table Mapping")

Parameters

Name Type Description
FromIntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"

CreateRecord

[Scope(Cloud)]
procedure CreateRecord(MappingName: Code[20]; TableNo: Integer; IntegrationTableNo: Integer; IntegrationTableUIDFieldNo: Integer; IntegrationTableModifiedFieldNo: Integer; TableConfigTemplateCode: Code[10]; IntegrationTableConfigTemplateCode: Code[10]; SynchOnlyCoupledRecords: Boolean; DirectionArg: Option; Prefix: Text[30])

Parameters

Name Type Description
MappingName Code[20]
TableNo Integer
IntegrationTableNo Integer
IntegrationTableUIDFieldNo Integer
IntegrationTableModifiedFieldNo Integer
TableConfigTemplateCode Code[10]
IntegrationTableConfigTemplateCode Code[10]
SynchOnlyCoupledRecords Boolean
DirectionArg Option
Prefix Text[30]

CreateRecord

[Scope(Cloud)]
procedure CreateRecord(MappingName: Code[20]; TableNo: Integer; IntegrationTableNo: Integer; IntegrationTableUIDFieldNo: Integer; IntegrationTableModifiedFieldNo: Integer; TableConfigTemplateCode: Code[10]; IntegrationTableConfigTemplateCode: Code[10]; SynchOnlyCoupledRecords: Boolean; DirectionArg: Option; Prefix: Text[30]; SynchCodeunitId: Integer; UncoupleCodeunitId: Integer)

Parameters

Name Type Description
MappingName Code[20]
TableNo Integer
IntegrationTableNo Integer
IntegrationTableUIDFieldNo Integer
IntegrationTableModifiedFieldNo Integer
TableConfigTemplateCode Code[10]
IntegrationTableConfigTemplateCode Code[10]
SynchOnlyCoupledRecords Boolean
DirectionArg Option
Prefix Text[30]
SynchCodeunitId Integer
UncoupleCodeunitId Integer

CreateRecord

[Scope(Cloud)]
procedure CreateRecord(MappingName: Code[20]; TableNo: Integer; IntegrationTableNo: Integer; IntegrationTableUIDFieldNo: Integer; IntegrationTableModifiedFieldNo: Integer; TableConfigTemplateCode: Code[10]; IntegrationTableConfigTemplateCode: Code[10]; SynchOnlyCoupledRecords: Boolean; DirectionArg: Option; Prefix: Text[30]; SynchCodeunitId: Integer; UncoupleCodeunitId: Integer; CouplingCodeunitId: Integer)

Parameters

Name Type Description
MappingName Code[20]
TableNo Integer
IntegrationTableNo Integer
IntegrationTableUIDFieldNo Integer
IntegrationTableModifiedFieldNo Integer
TableConfigTemplateCode Code[10]
IntegrationTableConfigTemplateCode Code[10]
SynchOnlyCoupledRecords Boolean
DirectionArg Option
Prefix Text[30]
SynchCodeunitId Integer
UncoupleCodeunitId Integer
CouplingCodeunitId Integer

SetFullSyncStartAndCommit

procedure SetFullSyncStartAndCommit()

SetFullSyncEndAndCommit

procedure SetFullSyncEndAndCommit()

IsFullSyncAllowed

procedure IsFullSyncAllowed(): Boolean

Returns

Type Description
Boolean

IsMappingEnabled

procedure IsMappingEnabled(RequestedDirection: Option): Boolean

Parameters

Name Type Description
RequestedDirection Option

Returns

Type Description
Boolean

IsFieldMappingEnabled

procedure IsFieldMappingEnabled(FieldNo: Integer; IntegrationTableFieldNo: Integer; RequestedDirection: Option): Boolean

Parameters

Name Type Description
FieldNo Integer
IntegrationTableFieldNo Integer
RequestedDirection Option

Returns

Type Description
Boolean

GetTableConfigTemplates

procedure GetTableConfigTemplates(IntegrationTableMappingName: Code[20]): Text

Parameters

Name Type Description
IntegrationTableMappingName Code[20]

Returns

Type Description
Text

GetIntTableConfigTemplates

procedure GetIntTableConfigTemplates(IntegrationTableMappingName: Code[20]): Text

Parameters

Name Type Description
IntegrationTableMappingName Code[20]

Returns

Type Description
Text

Events

OnIsCreateNewInCaseOfNoMatchControlVisible

[IntegrationEvent(False,False)]
internal procedure OnIsCreateNewInCaseOfNoMatchControlVisible(var IntegrationTableMapping: Record "Integration Table Mapping"; var CreateNewInCaseOfNoMatchControlVisible: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
IntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"
CreateNewInCaseOfNoMatchControlVisible Boolean
IsHandled Boolean

OnSynchronizeNow

[IntegrationEvent(False,False)]
local procedure OnSynchronizeNow(var IntegrationTableMapping: Record "Integration Table Mapping"; ResetLastSynchModifiedOnDateTime: Boolean; ResetSynchonizationTimestampOnRecords: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
IntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"
ResetLastSynchModifiedOnDateTime Boolean
ResetSynchonizationTimestampOnRecords Boolean
IsHandled Boolean

OnEnableMultiCompanySynchronization

[IntegrationEvent(False,False)]
internal procedure OnEnableMultiCompanySynchronization(var IntegrationTableMapping: Record "Integration Table Mapping"; var IsHandled: Boolean)

Parameters

Name Type Description
IntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"
IsHandled Boolean

OnDisableMultiCompanySynchronization

[IntegrationEvent(False,False)]
internal procedure OnDisableMultiCompanySynchronization(var IntegrationTableMapping: Record "Integration Table Mapping"; var IsHandled: Boolean)

Parameters

Name Type Description
IntegrationTableMapping Table Microsoft.Integration.SyncEngine."Integration Table Mapping"
IsHandled Boolean

OnBeforeIsMappingEnabled

[IntegrationEvent(False,False)]
local procedure OnBeforeIsMappingEnabled(RequestedDirection: Option; var Result: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
RequestedDirection Option
Result Boolean
IsHandled Boolean

OnBeforeIsFieldMappingEnabled

[IntegrationEvent(False,False)]
local procedure OnBeforeIsFieldMappingEnabled(FieldNo: Integer; IntegrationTableFieldNo: Integer; RequestedDirection: Option; var Result: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
FieldNo Integer
IntegrationTableFieldNo Integer
RequestedDirection Option
Result Boolean
IsHandled Boolean

See also