Share via

Table "Transformation Rule"

ID 1237
Namespace: System.IO

Properties

Name Value
Caption Transformation Rule
DataCaptionFields 1,2
LookupPageID Page System.IO."Transformation Rules"
DataClassification CustomerContent

Fields

Name Type Description
Code Code[20]
Description Text[100]
"Transformation Type" Enum System.IO."Transformation Rule Type"
"Find Value" Text[250]
"Replace Value" Text[250]
"Starting Text" Text[250]
"Ending Text" Text[250]
"Start Position" Integer
Length Integer
"Data Format" Text[100]
"Data Formatting Culture" Text[10]
"Next Transformation Rule" Code[20]
"Table ID" Integer
"Table Caption" Text[250]
"Source Field ID" Integer
"Source Field Caption" Text[250]
"Target Field ID" Integer
"Target Field Caption" Text[250]
"Field Lookup Rule" Option
Precision Decimal
Direction Text[1]
"Extract From Date Type" Enum System.IO."Extract From Date Type"
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

CreateDefaultTransformations

procedure CreateDefaultTransformations()

ValidateTransformationRuleField

procedure ValidateTransformationRuleField(FieldNo: Integer)

Parameters

Name Type Description
FieldNo Integer

IsDataFormatUpdateAllowed

procedure IsDataFormatUpdateAllowed(): Boolean

Returns

Type Description
Boolean

InsertRec

procedure InsertRec(NewCode: Code[20], NewDescription: Text[100], NewTransformationType: Enum "Transformation Rule Type", NewStartPosition: Integer, NewLength: Integer, NewDataFormat: Text[100], NewDataFormattingCulture: Text[10])

Parameters

Name Type Description
NewCode Code[20]
NewDescription Text[100]
NewTransformationType Enum System.IO."Transformation Rule Type"
NewStartPosition Integer
NewLength Integer
NewDataFormat Text[100]
NewDataFormattingCulture Text[10]

CreateRule

procedure CreateRule(NewCode: Code[20], NewDescription: Text[100], NewTransformationType: Enum "Transformation Rule Type", NewStartPosition: Integer, NewLength: Integer, NewDataFormat: Text[100], NewDataFormattingCulture: Text[10])

Parameters

Name Type Description
NewCode Code[20]
NewDescription Text[100]
NewTransformationType Enum System.IO."Transformation Rule Type"
NewStartPosition Integer
NewLength Integer
NewDataFormat Text[100]
NewDataFormattingCulture Text[10]

InsertFindAndReplaceRule

procedure InsertFindAndReplaceRule(NewCode: Code[20], NewDescription: Text[100], NewTransformationType: Enum "Transformation Rule Type", NewFindValue: Text[250], NewReplaceValue: Text[250], NextTransformationRule: Code[20])

Parameters

Name Type Description
NewCode Code[20]
NewDescription Text[100]
NewTransformationType Enum System.IO."Transformation Rule Type"
NewFindValue Text[250]
NewReplaceValue Text[250]
NextTransformationRule Code[20]

ReplaceRule

procedure ReplaceRule(NewCode: Code[20], NewDescription: Text[100], NewTransformationType: Enum "Transformation Rule Type", NewFindValue: Text[250], NewReplaceValue: Text[250])

Parameters

Name Type Description
NewCode Code[20]
NewDescription Text[100]
NewTransformationType Enum System.IO."Transformation Rule Type"
NewFindValue Text[250]
NewReplaceValue Text[250]

ReplaceRule

procedure ReplaceRule(NewCode: Code[20], NewDescription: Text[100], NewTransformationType: Enum "Transformation Rule Type", NewFindValue: Text[250], NewReplaceValue: Text[250], NextTransformationRule: Code[20])

Parameters

Name Type Description
NewCode Code[20]
NewDescription Text[100]
NewTransformationType Enum System.IO."Transformation Rule Type"
NewFindValue Text[250]
NewReplaceValue Text[250]
NextTransformationRule Code[20]

TransformText

procedure TransformText(OldValue: Text): Text

Parameters

Name Type Description
OldValue Text

Returns

Type Description
Text

GetFourthToSixthSubstringCode

procedure GetFourthToSixthSubstringCode(): Code[20]

Returns

Type Description
Code[20]

GetUSDateFormatCode

procedure GetUSDateFormatCode(): Code[20]

Returns

Type Description
Code[20]

GetUSDateTimeFormatCode

procedure GetUSDateTimeFormatCode(): Code[20]

Returns

Type Description
Code[20]

GetUppercaseCode

procedure GetUppercaseCode(): Code[20]

Returns

Type Description
Code[20]

GetLowercaseCode

procedure GetLowercaseCode(): Code[20]

Returns

Type Description
Code[20]

GetTitlecaseCode

procedure GetTitlecaseCode(): Code[20]

Returns

Type Description
Code[20]

GetTrimCode

procedure GetTrimCode(): Code[20]

Returns

Type Description
Code[20]

GetAlphanumericCode

procedure GetAlphanumericCode(): Code[20]

Returns

Type Description
Code[20]

GetDanishDecimalFormatCode

procedure GetDanishDecimalFormatCode(): Code[20]

Returns

Type Description
Code[20]

GetYYYYMMDDCode

procedure GetYYYYMMDDCode(): Code[20]

Returns

Type Description
Code[20]

GetYYYYMMDDHHMMSSCode

procedure GetYYYYMMDDHHMMSSCode(): Code[20]

Returns

Type Description
Code[20]

GetDeleteNOTPROVIDEDCode

procedure GetDeleteNOTPROVIDEDCode(): Code[20]

Returns

Type Description
Code[20]

EditNextTransformationRule

procedure EditNextTransformationRule()

Events

OnTransformation

[IntegrationEvent(False,False)]
procedure OnTransformation(TransformationCode: Code[20], InputText: Text, var OutputText: Text)

Parameters

Name Type Description
TransformationCode Code[20]
InputText Text
OutputText Text

OnCreateTransformationRules

[IntegrationEvent(False,False)]
procedure OnCreateTransformationRules()

OnBeforeIsDataFormatUpdateAllowed

[IntegrationEvent(True,False)]
local procedure OnBeforeIsDataFormatUpdateAllowed(FieldNumber: Integer, var DataFormatUpdateAllowed: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
FieldNumber Integer
DataFormatUpdateAllowed Boolean
IsHandled Boolean

OnValidateLengthOnBeforeTestTransformationType

[IntegrationEvent(False,False)]
procedure OnValidateLengthOnBeforeTestTransformationType(var TransformationRule: Record "Transformation Rule", xTransformationRule: Record "Transformation Rule", var IsHandled: Boolean)

Parameters

Name Type Description
TransformationRule Table System.IO."Transformation Rule"
xTransformationRule Table System.IO."Transformation Rule"
IsHandled Boolean

See also