---
title: "Table 1237 Transformation Rule"
author: "Jonas Paprotka"
url: https://jonas-paprotka.de/ref/table/1237-transformation-rule/
type: table
id: 1237
name: "Transformation Rule"
app: "Base Application"
namespace: System.IO
versions: "17-28"
build: 28.5.54151.54365
source: "https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/29/"
checked: 2026-09-20
subject: "Microsoft Dynamics 365 Business Central"
license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link."
---

# Table 1237 Transformation Rule

Jonas Paprotka, https://jonas-paprotka.de/ref/table/1237-transformation-rule/

| | |
| --- | --- |
| App | Base Application |
| Namespace | System.IO |
| Versions | 17-28 |
| Source file | System/DataExchange/TransformationRule.Table.al |

## Fields

| Id | Name | Type | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| 1 | Code | Code[20] | 17-28 | - | - |
| 2 | Description | Text[100] | 17-28 | - | - |
| 3 | Transformation Type | Enum Transformation Rule Type | 17-28 | - | - |
| 10 | Find Value | Text[250] | 17-28 | - | - |
| 11 | Replace Value | Text[250] | 17-28 | - | - |
| 12 | Starting Text | Text[250] | 17-28 | - | - |
| 13 | Ending Text | Text[250] | 17-28 | - | - |
| 15 | Start Position | Integer | 17-28 | - | - |
| 16 | Length | Integer | 17-28 | - | - |
| 18 | Data Format | Text[100] | 17-28 | - | - |
| 20 | Data Formatting Culture | Text[10] | 17-28 | - | - |
| 30 | Next Transformation Rule | Code[20] | 17-28 | - | - |
| 50 | Table ID | Integer | 21-28 | - | - |
| 51 | Table Caption | Text[250] | 21-28 | - | - |
| 52 | Source Field ID | Integer | 21-28 | - | - |
| 53 | Source Field Caption | Text[250] | 21-28 | - | - |
| 54 | Target Field ID | Integer | 21-28 | - | - |
| 55 | Target Field Caption | Text[250] | 21-28 | - | - |
| 56 | Field Lookup Rule | Option | 21-28 | - | - |
| 57 | Precision | Decimal | 21-28 | - | - |
| 58 | Direction | Text[1] | 21-28 | - | - |
| 70 | Extract From Date Type | Enum Extract From Date Type | 21-28 | - | - |

## Keys

| Name | Fields | Versions |
| --- | --- | --- |
| Key1, clustered | Code | 17-28 |

## Procedures

| Name | Parameters | Returns | Access | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- | --- |
| CreateDefaultTransformations | () | - | public | 17-28 | - | - |
| IsDataFormatUpdateAllowed | () | Boolean | public | 17-28 | - | - |
| InsertRec | (Code[20], Text[100], Option, Integer, Integer, Text[100], Text[10]) | - | public | 17-24 | - | - |
| TransformText | (Text) | Text | public | 17-28 | - | - |
| GetFourthToSixthSubstringCode | () | Code[20] | public | 17-28 | - | - |
| GetUSDateFormatCode | () | Code[20] | public | 17-28 | - | - |
| GetUSDateTimeFormatCode | () | Code[20] | public | 17-28 | - | - |
| GetUppercaseCode | () | Code[20] | public | 17-28 | - | - |
| GetLowercaseCode | () | Code[20] | public | 17-28 | - | - |
| GetTitlecaseCode | () | Code[20] | public | 17-28 | - | - |
| GetTrimCode | () | Code[20] | public | 17-28 | - | - |
| GetAlphanumericCode | () | Code[20] | public | 17-28 | - | - |
| GetDanishDecimalFormatCode | () | Code[20] | public | 17-28 | - | - |
| GetYYYYMMDDCode | () | Code[20] | public | 17-28 | - | - |
| GetYYYYMMDDHHMMSSCode | () | Code[20] | public | 17-28 | - | - |
| GetDeleteNOTPROVIDEDCode | () | Code[20] | public | 17-28 | - | - |
| EditNextTransformationRule | () | - | public | 17-28 | - | - |
| CreateRule | (Code[20], Text[100], Option, Integer, Integer, Text[100], Text[10]) | - | public | 18-24 | - | - |
| ReplaceRule | (Code[20], Text[100], Option, Text[250], Text[250]) | - | public | 18-24 | - | - |
| InsertFindAndReplaceRule | (Code[20], Text[100], Option, Text[250], Text[250], Code[20]) | - | public | 19-24 | - | - |
| ReplaceRule | (Code[20], Text[100], Option, Text[250], Text[250], Code[20]) | - | public | 19-24 | - | - |
| ValidateTransformationRuleField | (Integer) | - | public | 25-28 | - | - |
| InsertRec | (Code[20], Text[100], Enum Transformation Rule Type, Integer, Integer, Text[100], Text[10]) | - | public | 25-28 | - | - |
| CreateRule | (Code[20], Text[100], Enum Transformation Rule Type, Integer, Integer, Text[100], Text[10]) | - | public | 25-28 | - | - |
| InsertFindAndReplaceRule | (Code[20], Text[100], Enum Transformation Rule Type, Text[250], Text[250], Code[20]) | - | public | 25-28 | - | - |
| ReplaceRule | (Code[20], Text[100], Enum Transformation Rule Type, Text[250], Text[250]) | - | public | 25-28 | - | - |
| ReplaceRule | (Code[20], Text[100], Enum Transformation Rule Type, Text[250], Text[250], Code[20]) | - | public | 25-28 | - | - |
| GetAppendSpaceCode | () | Code[20] | public | 28 | Pending 28.0 | This is an unused procedure. |
| InsertAppendSpaceTransformation | () | - | public | 28 | Pending 28.0 | This is an unused procedure. |

## Events

| Kind | Name | Parameters | Versions | Obsolete | Reason |
| --- | --- | --- | --- | --- | --- |
| Integration event | OnTransformation | (Code[20], Text, var Text) | 17-28 | - | - |
| Integration event | OnCreateTransformationRules | () | 17-28 | - | - |
| Integration event | OnBeforeIsDataFormatUpdateAllowed | (Integer, var Boolean, var Boolean) | 17-28 | - | - |
| Integration event | OnValidateLengthOnBeforeTestTransformationType | (var Record Transformation Rule, Record Transformation Rule, var Boolean) | 22-28 | - | - |

## Source

Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20.
AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153.

Jonas Paprotka, 2026-09-20.