Table 5380 "Man. Integration Table Mapping"
Base Application · Microsoft.Integration.SyncEngine
Across versions
- BC23not present
- BC24added
- BC252 fields changed, 2 procedures added
- BC262 fields changed
- BC27unchanged
- BC283 fields changed
- BC29-30unchanged
Neighbourhood 4 connected objects and pages
Base Application · Microsoft.Integration.SyncEngine · BC24-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| DataClassification | SystemMetadata |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Name Δ BC28 | Code[20] | Specifies the name of the integration table. | NotBlank |
| 2 | Table ID | Integer | — | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Table), “Object Subtype” = const(‘Normal’)) |
| 3 | Integration Table ID | Integer | — | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Table), “Object Subtype” = const(‘CRM’)) |
| 4 | Integration Table UID | Integer | — | TableRelation Field.“No.” where(TableNo = field(“Integration Table ID”)) |
| 5 | Int. Tbl. Modified On Id | Integer | Integration Table Modified On Id caption | TableRelation Field.“No.” where(TableNo = field(“Integration Table ID”)) |
| 6 | Sync Only Coupled Records | Boolean | — | |
| 7 | Direction | Option | Specifies the synchronization direction. via Page 5384 “CDS New Man. Int. Table Wizard” | OptionCaption: Bidirectional,ToIntegrationTable,FromIntegrationTable |
| 8 | Table Config Template Code Δ BC25 Δ BC26 Δ BC28 | Code[10] | — | obsolete Removed 28.0; #if not CLEANSCHEMA28; TableRelation Table 8618 “Config. Template Header” (“Config. Template Header”.Code where(“Table ID” = field(“Table ID”))) |
| 9 | Int. Tbl. Config Template Code Δ BC25 Δ BC26 Δ BC28 | Code[10] | — | obsolete Removed 28.0; #if not CLEANSCHEMA28; TableRelation Table 8618 “Config. Template Header” (“Config. Template Header”.Code where(“Table ID” = field(“Integration Table ID”))) |
| 10 | Table Filter | BLOB | — | |
| 11 | Integration Table Filter | BLOB | — |
Keys
- Key1: Name (clustered)
Procedures
CreateRecord(IntegrationMappingName: Code[20]; IntegrationMappingTableId: Integer; IntegrationMappingIntTableId: Integer; IntegrationTableUID: Integer; IntTblModifiedOnId: Integer; SyncOnlyCoupledRecords: Boolean; lDirection: Option; TableFilter: Text; IntegrationTableFilter: Text)+ BC25 − BC25 (internal)InsertIntegrationTableMapping(var IntegrationTableMapping: Record "Integration Table Mapping"; MappingName: Code[20]; TableNo: Integer; IntegrationTableNo: Integer; IntegrationTableUIDFieldNo: Integer; IntegrationTableModifiedFieldNo: Integer; SynchOnlyCoupledRecords: Boolean; Direction: Option)+ BC25 − BC25 (internal)InsertIntegrationFieldMapping(IntegrationTableMappingName: Code[20]; TableFieldNo: Integer; IntegrationTableFieldNo: Integer; SynchDirection: Option; ConstValue: Text; ValidateField: Boolean; ValidateIntegrationTableField: Boolean; Status: Boolean; TransformationRule: Code[20])(internal)
Plus 2 local procedures.
Triggers
OnDelete
Relations
- Int. Tbl. Config Template Code: TableRelation Table 8618 “Config. Template Header”
- Table Config Template Code: TableRelation Table 8618 “Config. Template Header”
Referenced by
3 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 5381 “Man. Integration Field Mapping”: Integration Table ID, Mapping Name, Table ID
Pages and codeunits on this table
- Page 5382 “Man. Int. Table Mapping List” (source table)
- Page 5384 “CDS New Man. Int. Table Wizard” (source table)
Deprecations
- field Int. Tbl. Config Template Code: Removed 28.0 (#if not CLEANSCHEMA28), “Replaced with Integration Table Config Template table”
- field Table Config Template Code: Removed 28.0 (#if not CLEANSCHEMA28), “Replaced with Table Config Template table”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Man. Integration Table Mapping"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.