---
id: object/table/1223
type: object
title: Table 1223 "Data Exch. Column Def"
summary: Table 1223 "Data Exch. Column Def" in Base Application (System.IO). 19 fields, 8 public procedures. Present since at least BC23, still in BC30, changed in BC24.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "24"
  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: 343f3696f99cf69e1d61a85d16925d59ae6c97a45aacaee3d8259ef24dccd8ea
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/System/DataExchange/DataExchColumnDef.Table.al
    title: src/Layers/W1/BaseApp/System/DataExchange/DataExchColumnDef.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:
    - localization/ru
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 1223
name: Data Exch. Column Def
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"
source_major: "29"
obsolete: null
countries:
  - ru
ms_search_form_ids: []
counts:
  fields: 19
  procedures: 10
  events: 0
  subscribers: 0
relations:
  out: 2
  referenced_by: 1
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 1223 "Data Exch. Column Def"

> Table 1223 "Data Exch. Column Def" in Base Application (System.IO). 19 fields, 8 public procedures. Present since at least BC23, still in BC30, changed in BC24.

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

Learn documents this table through its pages: [Page 1216 "Data Exch Col Def Part"](../page/1216.md) (1 Learn page).

## Properties

| Property | Value |
|---|---|
| Caption | Data Exch. Column Def |
| 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); NotBlank |
| 2 | Column No. | Integer | Specifies the number that reflects the column's position on the line in the file. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> | NotBlank |
| 3 | Name | Text[250] | Specifies the name of the column. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 4 | Show | Boolean | Specifies that the element is shown in the data exchange definition. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 5 | Data Type | Option | Specifies if the data to be exchanged is of type Text, Date, or Decimal. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> | OptionCaption: Text,Date,Decimal,DateTime,Boolean |
| 6 | Data Format | Text[100] | Specifies the format of the data, if any. For example, MM-DD-YYYY if the data type is Date. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 7 | Data Formatting Culture | Text[10] | Specifies the culture of the data format, if any. For example, en-US if the data type is Decimal to ensure that comma is used as the .000 separator, according to the US format. This field is only relevant for import. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 8 | Description | Text[100] | Specifies a description of the column, for informational purposes. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 10 | 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 |
| 11 | Length | Integer | Specifies the length of the fixed-width line that holds the column if the file is of type Fixed Text. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 12 | Constant | Text[30] | Specifies any data that you want to export in this column, such as extra information about the payment type. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 13 | Path | Text[250] | Specifies the position of the element in the related XML schema. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 14 | Negative-Sign Identifier | Text[30] | Specifies the value that is used in the data file to identify negative amounts, in data files that cannot contain negative signs. This identifier is then used to reverse the identified amounts to negative signs during import. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 15 | Text Padding Required | Boolean | Specifies that the data must include text padding. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 16 | Pad Character | Text[1] | Specifies that text padding. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 17 | Justification | Option | Specifies if the column justification is left or right. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> | OptionCaption: Right,Left |
| 18 | Use Node Name as Value | Boolean | Specifies if the node name should be used as value for file types Xml or Json during import. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 19 | Blank Zero | Boolean | Specifies if the element is epmty if equal to 0. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |
| 20 | Export If Not Blank | Boolean | Specifies if the value of this column must be exported only if it is not blank. <small>via [Page 1216 "Data Exch Col Def Part"](../page/1216.md)</small> |  |

## Keys

- Key1: Data Exch. Def Code, Data Exch. Line Def Code, Column No. (clustered)

## Procedures

- `InsertRec(DataExchDefCode: Code[20]; DataExchLineDefCode: Code[20]; ColumnNo: Integer; NewName: Text[250]; NewShow: Boolean; DataType: Option; DataTypeFormatting: Text[100]; DataFormattingCulture: Text[10]; NewDescription: Text[50])`
- `InsertRecForExport(DataExchDefCode: Code[20]; DataExchLineDefCode: Code[20]; ColumnNo: Integer; NewName: Text[250]; DataType: Option; DataFormat: Text[100]; NewLength: Integer; NewConstant: Text[30])`
- `InsertRecordForImport(DataExchDefCode: Code[20]; DataExchLineDefCode: Code[20]; ColumnNo: Integer; NewName: Text[250]; NewDescription: Text[100]; NewShow: Boolean; DataType: Option; DataFormat: Text[100]; DataFormattingCulture: Text[10])`
- `ValidateRec()`
- `IsDataFormatRequired(): Boolean`
- `IsDataFormattingCultureRequired(): Boolean`
- `SetXMLDataFormattingValues(SimpleDataType: Text)`
- `IsOfDataLine(): Boolean`

Plus 2 local procedures.

## Triggers

OnDelete, OnInsert, OnModify

## Relations

- Data Exch. Def Code: TableRelation [Table 1222 "Data Exch. Def"](../table/1222.md)
- Data Exch. Line Def Code: TableRelation [Table 1227 "Data Exch. Line Def"](../table/1227.md)

## Referenced by

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

- [Table 1225 "Data Exch. Field Mapping"](../table/1225.md): Column No.

## Pages and codeunits on this table

- [Page 1216 "Data Exch Col Def Part"](../page/1216.md) (source table)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24

## Countries that replace it

[RU](../../localizations/ru.md)

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