---
id: object/table/1225
type: object
title: Table 1225 "Data Exch. Field Mapping"
summary: Table 1225 "Data Exch. Field Mapping" in Base Application (System.IO). 16 fields, 5 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 83c60cd69a1dc4a59e7ba9c3d683df4675f84efb26d59948f68dc5a9acdb15d3
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/System/DataExchange/DataExchFieldMapping.Table.al
    title: src/Layers/W1/BaseApp/System/DataExchange/DataExchFieldMapping.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/general-business-functionality/exchange-data-electronically/exchange-data
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 1225
name: Data Exch. Field Mapping
namespace: System.IO
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "26"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 16
  procedures: 7
  events: 1
  subscribers: 0
relations:
  out: 5
  referenced_by: 0
  pages: 2
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 1225 "Data Exch. Field Mapping"

> Table 1225 "Data Exch. Field Mapping" in Base Application (System.IO). 16 fields, 5 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28.

Base Application · System.IO · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/System/DataExchange/DataExchFieldMapping.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md) (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"](../table/1222.md) ("Data Exch. Def".Code); NotBlank |
| 2 | Table ID | Integer | — | TableRelation [Table 1224 "Data Exch. Mapping"](../table/1224.md) ("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. <small>via [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md)</small> | TableRelation [Table 1223 "Data Exch. Column Def"](../table/1223.md) ("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. <small>via [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md)</small> | 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... <small>via [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md)</small> |  |
| 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"](../table/1227.md) ("Data Exch. Line Def".Code where("Data Exch. Def Code" = field("Data Exch. Def Code"))); NotBlank |
| 9 | Multiplier | 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. <small>via [Page 1218 "Generic Data Exch Fld Mapping"](../page/1218.md)</small> | 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. <small>via [Page 1218 "Generic Data Exch Fld Mapping"](../page/1218.md)</small> | TableRelation Field."No." where(TableNo = field("Target Table ID")) |
| 12 | Target Table Caption | 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. <small>via [Page 1218 "Generic Data Exch Fld Mapping"](../page/1218.md)</small> | FlowField: lookup("Table Metadata".Caption where(ID = field("Target Table ID"))) |
| 14 | Target Table Field Caption | 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. <small>via [Page 1218 "Generic Data Exch Fld Mapping"](../page/1218.md)</small> | 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. <small>via [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md)</small> | TableRelation [Table 1237 "Transformation Rule"](../table/1237.md) (Transformation Rule) |
| 21 | Overwrite Value | Boolean | Specifies that the current value will be overwritten by a new value. <small>via [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md)</small> |  |
| 30 | Priority | Integer | Specifies the order that the field mappings must be processed. The field mapping with the highest number will be processed first. <small>via [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md)</small> |  |

## 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"](../table/1222.md)
- Column No.: TableRelation [Table 1223 "Data Exch. Column Def"](../table/1223.md)
- Table ID: TableRelation [Table 1224 "Data Exch. Mapping"](../table/1224.md)
- Data Exch. Line Def Code: TableRelation [Table 1227 "Data Exch. Line Def"](../table/1227.md)
- Transformation Rule: TableRelation [Table 1237 "Transformation Rule"](../table/1237.md)

## Pages and codeunits on this table

- [Page 1217 "Data Exch Field Mapping Part"](../page/1217.md) (source table)
- [Page 1218 "Generic Data Exch Fld Mapping"](../page/1218.md) (source table)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26, BC28

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