Integration Table Mapping

DynamicsDocs.comIntegration Table Mapping«Table 5335»Integration Table MappingName [PK]Table IDIntegration Table IDSynch. Codeunit IDIntegration Table UID Fld. No.Int. Tbl. Modified On Fld. No.Int. Table UID Field TypeTable Config Template CodeInt. Tbl. Config Template CodeDirection; [Bidirectional,ToIntegratio...Int. Tbl. Caption PrefixSynch. Int. Tbl. Mod. On Fltr.Synch. Modified On FilterTable FilterIntegration Table FilterSynch. Only Coupled RecordsParent NameGraph Delta TokenInt. Tbl. Delta Token Fld. No.Int. Tbl. ChangeKey Fld. No.Int. Tbl. State Fld. No.Delete After SynchronizationDependency FilterFull Sync is RunningFull Sync Session IDLast Full Sync Start DateTime«Table 5336»Integration Field MappingNo. [PK]Integration Table Mapping NameField No.Integration Table Field No.Direction; [Bidirectional,ToIntegratio...Constant ValueValidate FieldValidate Integration Table FldClear Value on Failed Sync«Table 5337»Temp Integration Field MappingNo. [PK]Integration Table Mapping NameSource Field No.Destination Field No.Validate Destination FieldConstant Value«Table 5338»Integration Synch. JobID [PK]Start Date/TimeFinish Date/TimeMessageIntegration Table Mapping NameInsertedModifiedDeletedUnchangedSkippedFailedSynch. Direction; [Bidirectional,ToInt...Job Queue Log Entry No.«Table 8618»Config. Template HeaderCode [PK,NN]DescriptionTable IDTable NameTable CaptionUsed In HierarchyEnabled<Table Config Template Code><Int. Tbl. Config Template Code><Integration Table Mapping Name><Integration Table Mapping Name><Integration Table Mapping Name>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback


# Name Type
1 Name Code20
2 Table ID Integer
3 Integration Table ID Integer
4 Synch. Codeunit ID Integer
5 Integration Table UID Fld. No. Integer
6 Int. Tbl. Modified On Fld. No. Integer
7 Int. Table UID Field Type Integer Editable: No
8 Table Config Template Code Code10
9 Int. Tbl. Config Template Code Code10
10 Direction Option
11 Int. Tbl. Caption Prefix Text30
12 Synch. Int. Tbl. Mod. On Fltr. DateTime
13 Synch. Modified On Filter DateTime
14 Table Filter BLOB
15 Integration Table Filter BLOB
16 Synch. Only Coupled Records Boolean
17 Parent Name Code20
18 Graph Delta Token Text250
19 Int. Tbl. Delta Token Fld. No. Integer
20 Int. Tbl. ChangeKey Fld. No. Integer
21 Int. Tbl. State Fld. No. Integer
22 Delete After Synchronization Boolean
30 Dependency Filter Text250
100 Full Sync is Running Boolean
101 Full Sync Session ID Integer
102 Last Full Sync Start DateTime DateTime


# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Int. Tbl. Config Template Code Config. Template Header Code 1..n
Synch. Codeunit ID Table Metadata ID 1..n

Table Relations From Other Tables

From Table From Field
Integration Field Mapping Integration Table Mapping Name 1..n
Integration Synch. Job Integration Table Mapping Name 1..n
Temp Integration Field Mapping Integration Table Mapping Name 1..n