Table 1222 "Data Exch. Def"

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

Learn documents this table through its pages: Page 1210 “Data Exch Def Card” (1 Learn page), Page 1211 “Data Exch Def List” (1).

Properties

Property	Value
Caption	Data Exch. Def
DataClassification	CustomerContent
LookupPageId	Data Exch Def List
DrillDownPageId	Data Exch Def List

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	Code	Code[20]	Specifies a code that identifies the data exchange setup. via Page 1210 “Data Exch Def Card”	NotBlank
2	Name	Text[100]	Specifies the name of the data exchange definition. via Page 1210 “Data Exch Def Card”
3	Type	Enum “Data Exchange Definition Type”	Specifies what type of exchange the data exchange definition is used for. via Page 1210 “Data Exch Def Card”	enum Enum 1222 “Data Exchange Definition Type”
4	Reading/Writing XMLport	Integer	Specifies the XMLport through which an imported data file or service enters prior to mapping and through which exported data exits when it is written to a data file or service after mapping. via Page 1210 “Data Exch Def Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(XMLport))
5	Header Lines	Integer	Specifies how many header lines exist in the file. This ensures that the header data is not imported. This field is only relevant for import. via Page 1210 “Data Exch Def Card”
8	Header Tag	Text[250]	Specifies the text of the first column on the header line. via Page 1210 “Data Exch Def Card”
9	Footer Tag	Text[250]	Specifies the text of the first column on the footer line. If a footer line exists in several places in the file, enter the text of the first column on the footer line to ensure that the footer data is not imported. This field is only relevant for import. via Page 1210 “Data Exch Def Card”
10	Column Separator	Option	Specifies how columns in the file are separated if the file is of type Variable Text. via Page 1210 “Data Exch Def Card”	OptionCaption: ,Tab,Semicolon,Comma,Space,Custom
11	File Encoding	Option	Specifies the encoding of the file to be imported. This field is only relevant for import. via Page 1210 “Data Exch Def Card”	OptionCaption: MS-DOS,UTF-8,UTF-16,WINDOWS
13	File Type	Option	Specifies what type of file the data exchange definition is used for. You can select between three file types. via Page 1210 “Data Exch Def Card”	OptionCaption: Xml,Variable Text,Fixed Text,Json
14	Ext. Data Handling Codeunit	Integer	Specifies the codeunit that transfers external data in and out of the Data Exchange Framework. via Page 1210 “Data Exch Def Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
15	Reading/Writing Codeunit	Integer	Specifies the codeunit that processes imported data prior to mapping and exported data after mapping. via Page 1210 “Data Exch Def Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
16	Validation Codeunit	Integer	Specifies the codeunit that is used to validate data against pre-defined business rules. via Page 1210 “Data Exch Def Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
17	Data Handling Codeunit	Integer	Specifies the codeunit that transfers data in and out of tables in Microsoft Dynamics 365. via Page 1210 “Data Exch Def Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
18	User Feedback Codeunit	Integer	Specifies the codeunit that does various clean-up after mapping, such as marks the lines as exported and deletes temporary records. via Page 1210 “Data Exch Def Card”	TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Codeunit))
19	Custom Column Separator	Text[10]	Specifies how columns in the file are separated if the file is of a custom type. via Page 1210 “Data Exch Def Card”
20	Line Separator	Option	Specifies how lines in the file are separated if the file is of type Variable Text. via Page 1210 “Data Exch Def Card”	OptionCaption: CRLF,CR,LF

Keys

Key1: Code (clustered)
Key2: Type

Procedures

InsertRec(NewCode: Code[20]; NewName: Text[100]; NewType: Enum "Data Exchange Definition Type"; ProcessingXMLport: Integer; HeaderCount: Integer; HeaderTag: Text[250]; FooterTag: Text[250])
InsertRecForExport(NewCode: Code[20]; NewName: Text[100]; NewType: Option; ProcessingXMLport: Integer; FileType: Option)
ColumnSeparatorChar(): Text
CheckEnableDisableIsNonXMLFileType(): Boolean
CheckEnableDisableIsImportType(): Boolean
CheckEnableDisableIsBankStatementImportType(): Boolean
CheckEnableDisableDelimitedFileType(): Boolean
PositivePayUpdateCodeunits(): Boolean
ProcessDataExchange(var DataExch: Record "Data Exch.")

Triggers

OnDelete, OnInsert

Relations

drill-down page Page 1211 “Data Exch Def List”
lookup page Page 1211 “Data Exch Def List”

Referenced by

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

Table 4810 “Intrastat Report Setup”: Data Exch. Def. Name, Data Exch. Def. Name - Receipt, Data Exch. Def. Name - Shpt., Data Exch. Def. Code, Data Exch. Def. Code - Receipt, Data Exch. Def. Code - Shpt.
Table 6139 “E-Doc. Service Data Exch. Def.”: Expt. Data Exchange Def. Name, Impt. Data Exchange Def. Name, Expt. Data Exchange Def. Code, Impt. Data Exchange Def. Code
Table 1200 “Bank Export/Import Setup”: Data Exch. Def. Name, Data Exch. Def. Code
Table 1213 “Data Exchange Type”: Data Exch. Def. Code
Table 1220 “Data Exch.”: Data Exch. Def Code
Table 1223 “Data Exch. Column Def”: Data Exch. Def Code
Table 1224 “Data Exch. Mapping”: Data Exch. Def Code
Table 1225 “Data Exch. Field Mapping”: Data Exch. Def Code
Table 1227 “Data Exch. Line Def”: Data Exch. Def Code
Table 1238 “Data Exch. Field Grouping”: Data Exch. Def Code
Table 1650 “Curr. Exch. Rate Update Setup”: Data Exch. Def Code
Table 5010 “Service Declaration Setup”: Data Exch. Def. Code
Table 6121 “E-Document”: Data Exch. Def. Code
Table 8017 “Generic Import Settings”: Data Exchange Definition
Table 98 “General Ledger Setup”: Payroll Trans. Import Format

Pages and codeunits on this table

Page 1210 “Data Exch Def Card” (source table)
Page 1211 “Data Exch Def List” (source table)

Countries that replace it

CA, MX, RU, 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. Def"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.