Table 1225 "Data Exch. Field Mapping"

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

Learn documents this table through its pages: Page 1217 “Data Exch Field Mapping Part” (1 Learn page).

Properties

Property	Value
Caption	Data Exch. Field 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”.Code); NotBlank
2	Table ID	Integer	—	TableRelation Table 1224 “Data Exch. Mapping” (“Data Exch. Mapping”.“Table ID”); NotBlank
3	Column No.	Integer	Specifies the number of the column in the external file that is mapped to the field in the Target Table ID field, when you are using an intermediate table for data import. via Page 1217 “Data Exch Field Mapping Part”	TableRelation Table 1223 “Data Exch. Column Def” (“Data Exch. Column Def”.“Column No.” where(“Data Exch. Def Code” = field(“Data Exch. Def Code”), “Data Exch. Line Def Code” = field(“Data Exch. Line Def Code”))); NotBlank
4	Field ID	Integer	Specifies the number of the field in the external file that is mapped to the field in the Target Table ID field, when you are using an intermediate table for data import. via Page 1217 “Data Exch Field Mapping Part”	TableRelation Field.“No.” where(TableNo = field(“Table ID”))
5	Optional	Boolean	Specifies that the map will be skipped if the field is empty. If you do not select this check box, then an export error will occur if the field is empty. When the Use as Intermediate Table check box is selected, the Validate Only check box specifies that the element-to-field map is not used to conve… via Page 1217 “Data Exch Field Mapping Part”
6	Use Default Value	Boolean	—
7	Default Value	Text[250]	—
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	Multiplier Δ BC28	Decimal	—
10	Target Table ID	Integer	Specifies the table that the value in the Column Caption field is mapped to, when you are using an intermediate table for data import. via Page 1218 “Generic Data Exch Fld Mapping”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Table))
11	Target Field ID	Integer	Specifies the field in the target table that the value in the Column Caption field is mapped to, when you are using an intermediate table for data import. via Page 1218 “Generic Data Exch Fld Mapping”	TableRelation Field.“No.” where(TableNo = field(“Target Table ID”))
12	Target Table Caption Δ BC24	Text[250]	Specifies the name of the table in the Target Table ID field, which is the table that the value in the Column Caption field is mapped to, when you are using an intermediate table for data import. via Page 1218 “Generic Data Exch Fld Mapping”	FlowField: lookup(“Table Metadata”.Caption where(ID = field(“Target Table ID”)))
14	Target Table Field Caption Δ BC24	Text[80]	Specifies the name of the field in the target table that the value in the Column Caption field is mapped to, when you are using an intermediate table for data import. via Page 1218 “Generic Data Exch Fld Mapping”	FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Target Table ID”), “No.” = field(“Target Field ID”)))
20	Transformation Rule	Code[20]	Specifies the rule that transforms imported text to a supported value before it can be mapped to a specified field in Microsoft Dynamics 365. When you choose a value in this field, the same value is entered in the Transformation Rule field in the Data Exch. Field Mapping Buf. table and vice versa. via Page 1217 “Data Exch Field Mapping Part”	TableRelation Table 1237 “Transformation Rule” (Transformation Rule)
21	Overwrite Value	Boolean	Specifies that the current value will be overwritten by a new value. via Page 1217 “Data Exch Field Mapping Part”
30	Priority	Integer	Specifies the order that the field mappings must be processed. The field mapping with the highest number will be processed first. via Page 1217 “Data Exch Field Mapping Part”

Keys

Key1: Data Exch. Def Code, Data Exch. Line Def Code, Table ID, Column No., Field ID (clustered)
Key2: Data Exch. Def Code, Data Exch. Line Def Code, Table ID, Priority

Events published

OnBeforeInsert(var DataExchFieldMapping: Record "Data Exch. Field Mapping"; var IsHandled: Boolean) (integration)

Procedures

InsertRec(DataExchDefCode: Code[20]; DataExchLineDefCode: Code[20]; TableId: Integer; ColumnNo: Integer; FieldId: Integer; NewOptional: Boolean; NewMultiplier: Decimal)
FillSourceRecord(Field: Record "Field")
GetColumnCaption(): Text
GetFieldCaption(): Text
GetPath(): Text

Plus 1 local procedures.

Triggers

OnInsert, OnModify

Relations

Data Exch. Def Code: TableRelation Table 1222 “Data Exch. Def”
Column No.: TableRelation Table 1223 “Data Exch. Column Def”
Table ID: TableRelation Table 1224 “Data Exch. Mapping”
Data Exch. Line Def Code: TableRelation Table 1227 “Data Exch. Line Def”
Transformation Rule: TableRelation Table 1237 “Transformation Rule”

Pages and codeunits on this table

Page 1217 “Data Exch Field Mapping Part” (source table)
Page 1218 “Generic Data Exch Fld Mapping” (source table)

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