---
title: "Table 1237 Transformation Rule, extension points 29"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/table/1237-transformation-rule/points/
object: https://jonas-paprotka.de/ref/table/1237-transformation-rule/
app: "Base Application"
major: 29
source: https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/
checked: 2026-11-20
changed: 2026-10-05
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Table 1237 Transformation Rule, extension points 29

JOP-AL, https://jonas-paprotka.de/ref/table/1237-transformation-rule/points/

29 procedures and triggers with a step in src/Layers/W1/BaseApp/System/DataExchange/TransformationRule.Table.al, in source order, read from the text, not from a run.

## Transformation Type.OnValidate

[Line 32](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L32), trigger.

- [43](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L43) calls `IsDataFormatUpdateAllowed`

## Find Value.OnValidate

[Line 53](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L53), trigger.

- [56](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L56) calls `ValidateTransformationRuleField`

## Replace Value.OnValidate

[Line 63](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L63), trigger.

- [66](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L66) calls `ValidateTransformationRuleField`

## Starting Text.OnValidate

[Line 73](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L73), trigger.

- [76](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L76) calls `ValidateTransformationRuleField`

## Ending Text.OnValidate

[Line 83](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L83), trigger.

- [86](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L86) calls `ValidateTransformationRuleField`

## Start Position.OnValidate

[Line 94](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L94), trigger.

- [97](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L97) calls `ValidateTransformationRuleField`

## Length.OnValidate

[Line 106](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L106), trigger.

- [111](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L111) raises `OnValidateLengthOnBeforeTestTransformationType`, IsHandled
- [115](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L115) calls `ValidateTransformationRuleField`

## Data Format.OnValidate

[Line 122](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L122), trigger.

- [124](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L124) calls `IsDataFormatUpdateAllowed`
- [128](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L128) calls `ValidateTransformationRuleField`

## Data Formatting Culture.OnValidate

[Line 135](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L135), trigger.

- [137](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L137) calls `IsDataFormatUpdateAllowed`
- [141](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L141) calls `ValidateTransformationRuleField`

## Table ID.OnLookup

[Line 153](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L153), trigger.

- [157](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L157) calls [Codeunit 8617 Config. Validate Management](https://jonas-paprotka.de/ref/codeunit/8617-config-validate-management/) `LookupTable`
- [159](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L159) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Table ID`

## Table ID.OnValidate

[Line 162](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L162), trigger.

- [166](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L166) calls `ValidateTransformationRuleField`

## Source Field ID.OnValidate

[Line 182](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L182), trigger.

- [189](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L189) calls `ValidateTransformationRuleField`

## Target Field ID.OnValidate

[Line 205](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L205), trigger.

- [212](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L212) calls `ValidateTransformationRuleField`

## Field Lookup Rule.OnValidate

[Line 228](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L228), trigger.

- [230](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L230) calls `ValidateTransformationRuleField`

## Precision.OnValidate

[Line 239](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L239), trigger.

- [242](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L242) calls `ValidateTransformationRuleField`

## Direction.OnValidate

[Line 249](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L249), trigger.

- [252](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L252) calls `ValidateTransformationRuleField`

## Extract From Date Type.OnValidate

[Line 259](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L259), trigger.

- [261](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L261) calls `ValidateTransformationRuleField`

## OnInsert

[Line 278](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L278), trigger.

- [280](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L280) calls `CheckMandatoryFields`

## OnModify

[Line 283](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L283), trigger.

- [285](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L285) calls `CheckMandatoryFields`

## CreateDefaultTransformations

[Line 320](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L320).

- [322](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L322) calls `InsertRec`
- [323](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L323) calls `InsertRec`
- [324](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L324) calls `InsertRec`
- [325](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L325) calls `InsertRec`
- [326](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L326) calls `InsertRec`
- [327](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L327) calls `InsertRec`
- [328](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L328) calls `InsertRec`
- [329](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L329) calls `InsertRec`
- [330](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L330) calls `InsertRec`
- [331](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L331) calls `InsertRec`
- [332](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L332) calls `InsertRec`
- [333](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L333) calls `InsertRec`
- [334](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L334) raises `OnCreateTransformationRules`
- [335](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L335) calls `InsertFindAndReplaceRule`

## IsDataFormatUpdateAllowed

[Line 348](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L348).

- [355](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L355) raises `OnBeforeIsDataFormatUpdateAllowed`, IsHandled

## InsertRec

[Line 363](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L363).

- [370](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L370) calls [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `CreateRule`

## CreateRule

[Line 374](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L374).

- [377](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L377) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Code`
- [378](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L378) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Description`
- [379](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L379) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Transformation Type`
- [380](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L380) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Start Position`
- [381](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L381) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Length`
- [382](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L382) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Data Format`
- [383](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L383) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Data Formatting Culture`
- [384](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L384) writes [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) Insert(true)

## InsertFindAndReplaceRule

[Line 387](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L387).

- [394](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L394) calls [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `ReplaceRule`

## ReplaceRule

[Line 397](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L397).

- [400](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L400) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Code`
- [401](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L401) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Description`
- [402](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L402) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Transformation Type`
- [403](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L403) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Find Value`
- [404](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L404) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Replace Value`
- [405](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L405) writes [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) Insert(true)

## ReplaceRule

[Line 408](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L408).

- [411](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L411) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Code`
- [412](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L412) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Description`
- [413](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L413) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Transformation Type`
- [414](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L414) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Find Value`
- [415](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L415) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Replace Value`
- [416](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L416) validates [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `Next Transformation Rule`
- [417](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L417) writes [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) Insert(true)

## TransformText

[Line 420](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L420).

- [432](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L432) calls [Table 1237 Transformation Rule](https://jonas-paprotka.de/ref/table/1237-transformation-rule/) `TransformText`
- [434](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L434) raises `OnAfterTransformText`

## EditNextTransformationRule

[Line 506](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L506).

- [514](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L514) runs [Page 1238 Transformation Rule Card](https://jonas-paprotka.de/ref/page/1238-transformation-rule-card/)

## InsertAppendSpaceTransformation

[Line 527](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L527).

- [529](https://jonas-paprotka.de/ref/table/1237-transformation-rule/source/#L529) calls `InsertFindAndReplaceRule`

## Source

AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
