Table 1224 "Data Exch. Mapping"

Base Application · System.IO · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 1214 “Data Exch Mapping Card” (1 Learn page).

Properties

Property	Value
Caption	Data Exch. Mapping
DataClassification	CustomerContent

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	Data Exch. Def Code	Code[20]	—	TableRelation Table 1222 “Data Exch. Def” (Data Exch. Def); NotBlank
2	Table ID	Integer	Specifies the table that holds the fields to or from which data is exchanged according to the mapping. via Page 1214 “Data Exch Mapping Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Table)); NotBlank
3	Name	Text[250]	Specifies the name of the data exchange mapping setup. via Page 1214 “Data Exch Mapping Card”
4	Mapping Codeunit	Integer	Specifies the codeunit that is used to map the specified columns or XML data elements to fields in Microsoft Dynamics 365. via Page 1214 “Data Exch Mapping Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
6	Data Exch. No. Field ID	Integer	Specifies the ID. This field is intended only for internal use. via Page 1214 “Data Exch Mapping Card”	TableRelation Field.“No.” where(TableNo = field(“Table ID”))
7	Data Exch. Line Field ID	Integer	Specifies the ID. This field is intended only for internal use. via Page 1214 “Data Exch Mapping Card”	TableRelation Field.“No.” where(TableNo = field(“Table ID”))
8	Data Exch. Line Def Code	Code[20]	—	TableRelation Table 1227 “Data Exch. Line Def” (“Data Exch. Line Def”.Code where(“Data Exch. Def Code” = field(“Data Exch. Def Code”))); NotBlank
9	Pre-Mapping Codeunit	Integer	Specifies the codeunit that prepares the mapping between fields in Dynamics 365 and external data. via Page 1214 “Data Exch Mapping Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
10	Post-Mapping Codeunit	Integer	Specifies the codeunit that completes the mapping between fields in Dynamics 365 and the external data file or service. via Page 1214 “Data Exch Mapping Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
20	Use as Intermediate Table	Boolean	Specifies that the table that you select in the Table ID field is an intermediate table where the imported data is stored before it is mapped to the target table. via Page 1214 “Data Exch Mapping Card”
21	Key Index	Integer	Specifies the key index to sort the source records before exporting. via Page 1214 “Data Exch Mapping Card”	TableRelation Key.“No.” where(TableNo = field(“Table ID”))
22	Key	Text[250]	Specifies the key to sort the source records before exporting. via Page 1214 “Data Exch Mapping Card”	FlowField: lookup(Key.Key where(TableNo = field(“Table ID”), “No.” = field(“Key Index”))); not editable

Keys

Key1: Data Exch. Def Code, Data Exch. Line Def Code, Table ID (clustered)

Events published

OnBeforeOnDelete(var DataExchMapping: Record "Data Exch. Mapping"; var IsHandled: Boolean) (integration)

Procedures

InsertRec(DataExchDefCode: Code[20]; DataExchLineDefCode: Code[20]; TableId: Integer; NewName: Text[250]; MappingCodeunit: Integer; DataExchNoFieldId: Integer; DataExchLineFieldId: Integer)
InsertRecForExport(DataExchDefCode: Code[20]; DataExchLineDefCode: Code[20]; TableId: Integer; NewName: Text[250]; ProcessingCodeunit: Integer)
InsertRecForImport(DataExchDefCode: Code[20]; DataExchLineDefCode: Code[20]; TableId: Integer; NewName: Text[250]; DataExchNoFieldId: Integer; DataExchLineFieldId: Integer)
CreateDataExchMapping(TableID: Integer; CodeunitID: Integer; DataExchNoFieldID: Integer; DataExchLineFieldID: Integer)
PositivePayUpdateCodeunits(): Boolean

Plus 2 local procedures.

Triggers

OnDelete, OnRename

Relations

Data Exch. Def Code: TableRelation Table 1222 “Data Exch. Def”
Data Exch. Line Def Code: TableRelation Table 1227 “Data Exch. Line Def”

Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 1225 “Data Exch. Field Mapping”: Table ID
Table 1238 “Data Exch. Field Grouping”: Table ID

Pages and codeunits on this table

Page 1214 “Data Exch Mapping Card” (source table)
Page 1219 “Data Exch Mapping Part” (source table)
Codeunit 1268 “Export Launcher” (codeunit runs on it)

Countries that replace it

CA, MX, US

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: "Data Exch. Mapping"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.