Other table in Microsoft Dynamics 365 Business Central. 21 fields, 247 records in Cronus demo.
The Data Exch. Field Mapping table (ID 1225) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 21 fields, with a primary key of Data Exch. Def Code, Table ID, Column No., Field ID, Data Exch. Line Def Code, and includes 2 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Data Exch. Def Code, Table ID, Column No., Field ID, Data Exch. Line Def Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Data Exch. Def Code PK | Code | Normal | → Data Exch. Def #1222 |
| 2 | Table ID PK | Integer | Normal | → Data Exch. Mapping #1224 |
| 3 | Column No. PK | Integer | Normal | → Data Exch. Column Def #1223 |
| 4 | Field ID PK | Integer | Normal | |
| 5 | Optional | Boolean | Normal | |
| 6 | Use Default Value | Boolean | Normal | |
| 7 | Default Value | Text | Normal | |
| 8 | Data Exch. Line Def Code PK | Code | Normal | → Data Exch. Line Def #1227 |
| 9 | Multiplier | Decimal | Normal | |
| 10 | Target Table ID | Integer | Normal | |
| 11 | Target Field ID | Integer | Normal | |
| 12 | Target Table Caption ⚡ FLOW | Text | FlowField | |
| 14 | Target Field Caption ⚡ FLOW | Text | FlowField | |
| 20 | Transformation Rule | Code | Normal | → Transformation Rule #1237 |
| 21 | Overwrite Value | Boolean | Normal | |
| 30 | Priority | Integer | Normal | |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |
Tables referenced by fields on the Data Exch. Field Mapping table through TableRelation properties.