Data Exch. Field Mapping #1225

Other table in Microsoft Dynamics 365 Business Central. 21 fields, 247 records in Cronus demo.

Fields

247

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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.

All fields (21)

Data Exch. Field Mapping — FIELDS

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

Related tables (8)

Tables referenced by fields on the Data Exch. Field Mapping table through TableRelation properties.

Data Exch. Def

#1222 · Other · via Data Exch. Def Code

Data Exch. Mapping

#1224 · Other · via Table ID

Data Exch. Column Def

#1223 · Other · via Column No.

Data Exch. Line Def

#1227 · Other · via Data Exch. Line Def Code

Transformation Rule

#1237 · Other · via Transformation Rule