Table 1237 "Transformation Rule"

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

Properties

Property	Value
Caption	Transformation Rule
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	Code	Code[20]	Specifies rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Business Central. via Page 1238 “Transformation Rule Card”	NotBlank
2	Description	Text[100]	Specifies rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Business Central. via Page 1238 “Transformation Rule Card”
3	Transformation Type	Enum “Transformation Rule Type”	Specifies rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Business Central. via Page 1238 “Transformation Rule Card”	enum Enum 1237 “Transformation Rule Type”
10	Find Value	Text[250]	Specifies in the Transformation Rule table the rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Microsoft Dynamics 365. via Page 1238 “Transformation Rule Card”
11	Replace Value	Text[250]	Specifies rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Dynamics 365. via Page 1238 “Transformation Rule Card”
12	Starting Text	Text[250]	Specifies the first part of text that was imported from an external file to be transformed to a supported value by mapping to the specified field in Dynamics 365. via Page 1238 “Transformation Rule Card”
13	Ending Text	Text[250]	Specifies the last part of text that was imported from an external file to be transformed to a supported value by mapping to the specified field in Dynamics 365. via Page 1238 “Transformation Rule Card”
15	Start Position	Integer	Specifies rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Dynamics 365. via Page 1238 “Transformation Rule Card”
16	Length	Integer	Specifies the length of one item unit when measured in the specified unit of measure. via Page 1238 “Transformation Rule Card”
18	Data Format	Text[100]	Specifies in the Transformation Rule table the rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Microsoft Dynamics 365. via Page 1238 “Transformation Rule Card”
20	Data Formatting Culture	Text[10]	Specifies in the Transformation Rule table the rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Microsoft Dynamics 365. via Page 1238 “Transformation Rule Card”
30	Next Transformation Rule	Code[20]	Specifies the transformation rule that takes the result of this rule and transforms the value. via Page 1238 “Transformation Rule Card”	TableRelation Table 1237 “Transformation Rule” (“Transformation Rule”.Code)
50	Table ID	Integer	Specifies the ID of the table to get the record for the field lookup. via Page 1238 “Transformation Rule Card”
51	Table Caption Δ BC24	Text[250]	Specifies the caption of the table to get the record for the field lookup. via Page 1238 “Transformation Rule Card”	FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Table), “Object ID” = field(“Table ID”))); not editable
52	Source Field ID	Integer	Specifies the ID of the field to find the record for the field lookup. via Page 1238 “Transformation Rule Card”	TableRelation Field.“No.” where(TableNo = field(“Table ID”))
53	Source Field Caption Δ BC24	Text[250]	Specifies the caption of the field to find the record for the field lookup. via Page 1238 “Transformation Rule Card”	FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Table ID”), “No.” = field(“Source Field ID”))); not editable
54	Target Field ID	Integer	Specifies the ID of the field to get the value for the field lookup. via Page 1238 “Transformation Rule Card”	TableRelation Field.“No.” where(TableNo = field(“Table ID”))
55	Target Field Caption Δ BC24	Text[250]	Specifies the caption of the field to get the value for the field lookup. via Page 1238 “Transformation Rule Card”	FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Table ID”), “No.” = field(“Target Field ID”))); not editable
56	Field Lookup Rule	Option	Specifies the type of the field lookup. In case of Target the value from the Target Field ID will be taken as is, even if it is blank. In case of Original If Target Is Blank the original value will be taken if target one is blank. via Page 1238 “Transformation Rule Card”
57	Precision Δ BC28	Decimal	Specifies rounding precision. via Page 1238 “Transformation Rule Card”
58	Direction	Text[1]	Specifies rounding direction. via Page 1238 “Transformation Rule Card”
70	Extract From Date Type	Enum “Extract From Date Type”	Specifies what should be extracted from the date. via Page 1238 “Transformation Rule Card”	enum Enum 1238 “Extract From Date Type”

Keys

Key1: Code (clustered)

Events published

OnTransformation(TransformationCode: Code[20]; InputText: Text; var OutputText: Text) (integration)
OnCreateTransformationRules() (integration)
OnBeforeIsDataFormatUpdateAllowed(FieldNumber: Integer; var DataFormatUpdateAllowed: Boolean; var IsHandled: Boolean) (integration)
OnValidateLengthOnBeforeTestTransformationType(var TransformationRule: Record "Transformation Rule"; xTransformationRule: Record "Transformation Rule"; var IsHandled: Boolean) (integration)
OnAfterTransformText(var TransformationRule: Record "Transformation Rule"; OldValue: Text; var NewValue: Text) + BC29 (integration)

Trigger event subscribers

OnBeforeDeleteEvent: Codeunit 5397 “CDS Transformation Rule Mgt.” OnDeleteTransformationRule

Procedures

CreateDefaultTransformations()
ValidateTransformationRuleField(FieldNo: Integer) + BC25
IsDataFormatUpdateAllowed(): Boolean
InsertRec(NewCode: Code[20]; NewDescription: Text[100]; NewTransformationType: Enum "Transformation Rule Type"; NewStartPosition: Integer; NewLength: Integer; NewDataFormat: Text[100]; NewDataFormattingCulture: Text[10]) + BC25 − BC25
CreateRule(NewCode: Code[20]; NewDescription: Text[100]; NewTransformationType: Enum "Transformation Rule Type"; NewStartPosition: Integer; NewLength: Integer; NewDataFormat: Text[100]; NewDataFormattingCulture: Text[10]) + BC25 − BC25
InsertFindAndReplaceRule(NewCode: Code[20]; NewDescription: Text[100]; NewTransformationType: Enum "Transformation Rule Type"; NewFindValue: Text[250]; NewReplaceValue: Text[250]; NextTransformationRule: Code[20]) + BC25 − BC25
ReplaceRule(NewCode: Code[20]; NewDescription: Text[100]; NewTransformationType: Enum "Transformation Rule Type"; NewFindValue: Text[250]; NewReplaceValue: Text[250]) + BC25 + BC25 − BC25 − BC25
ReplaceRule(NewCode: Code[20]; NewDescription: Text[100]; NewTransformationType: Enum "Transformation Rule Type"; NewFindValue: Text[250]; NewReplaceValue: Text[250]; NextTransformationRule: Code[20]) + BC25 + BC25 − BC25 − BC25
TransformText(OldValue: Text): Text
GetFourthToSixthSubstringCode(): Code[20]
GetUSDateFormatCode(): Code[20]
GetUSDateTimeFormatCode(): Code[20]
GetUppercaseCode(): Code[20]
GetLowercaseCode(): Code[20]
GetTitlecaseCode(): Code[20]
GetTrimCode(): Code[20]
GetAlphanumericCode(): Code[20]
GetDanishDecimalFormatCode(): Code[20]
GetYYYYMMDDCode(): Code[20]
GetYYYYMMDDHHMMSSCode(): Code[20]
GetDeleteNOTPROVIDEDCode(): Code[20]
GetAppendSpaceCode(): Code[20] + BC28 (obsolete 28.0: This is an unused procedure.)
EditNextTransformationRule()
InsertAppendSpaceTransformation() + BC28 (obsolete 28.0: This is an unused procedure.)

Plus 1 local procedures.

Triggers

OnInsert, OnModify

Relations

lookup page Page 1237 “Transformation Rules”
Next Transformation Rule: TableRelation Table 1237 “Transformation Rule”

Referenced by

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

Table 1225 “Data Exch. Field Mapping”: Transformation Rule
Table 1237 “Transformation Rule”: Next Transformation Rule
Table 1265 “Data Exch. Field Mapping Buf.”: Transformation Rule
Table 5336 “Integration Field Mapping”: Transformation Rule
Table 5384 “Man. Int. Field Mapping”: Transformation Rule
Table 6118 “E-Doc. Mapping”: Transformation Rule

Pages and codeunits on this table

Page 1237 “Transformation Rules” (source table)
Page 1238 “Transformation Rule Card” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Page 1238 “Transformation Rule Card” (1 call: EditNextTransformationRule → (object))

Implemented by

Deprecations

procedure GetAppendSpaceCode: Pending 28.0 (#if not CLEAN28), “This is an unused procedure.”
procedure InsertAppendSpaceTransformation: Pending 28.0 (#if not CLEAN28), “This is an unused procedure.”

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). The call sections above are our own, per object, from the BC29 call graph. 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: "Transformation Rule"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.