Objects/Tables/Table 1237 Transformation Rule
Table 1237 Transformation Rule in 23
Jonas Paprotka, Base Application 23.5.16502.31399, checked
- App
- Base Application
- Namespace
- System.IO
Fields, 22Keys, 1Procedures, 21Events, 4
Versions171819202122232425262728latest
Source29
Fields, 22
| Id | Name | Type | Obsolete |
|---|
| 1 | Code | Code[20] | - |
| 2 | Description | Text[100] | - |
| 3 | Transformation Type | Enum Transformation Rule Type | - |
| 10 | Find Value | Text[250] | - |
| 11 | Replace Value | Text[250] | - |
| 12 | Starting Text | Text[250] | - |
| 13 | Ending Text | Text[250] | - |
| 15 | Start Position | Integer | - |
| 16 | Length | Integer | - |
| 18 | Data Format | Text[100] | - |
| 20 | Data Formatting Culture | Text[10] | - |
| 30 | Next Transformation Rule | Code[20] | - |
| 50 | Table ID | Integer | - |
| 51 | Table Caption | Text[250] | - |
| 52 | Source Field ID | Integer | - |
| 53 | Source Field Caption | Text[250] | - |
| 54 | Target Field ID | Integer | - |
| 55 | Target Field Caption | Text[250] | - |
| 56 | Field Lookup Rule | Option | - |
| 57 | Precision | Decimal | - |
| 58 | Direction | Text[1] | - |
| 70 | Extract From Date Type | Enum Extract From Date Type | - |
Keys, 1
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Code | - |
Procedures, 21
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CreateDefaultTransformations | () | | public | - |
| IsDataFormatUpdateAllowed | () | Boolean | public | - |
| InsertRec | (Code[20], Text[100], Option, Integer, Integer, Text[100], Text[10]) | | public | - |
| TransformText | (Text) | Text | public | - |
| GetFourthToSixthSubstringCode | () | Code[20] | public | - |
| GetUSDateFormatCode | () | Code[20] | public | - |
| GetUSDateTimeFormatCode | () | Code[20] | public | - |
| GetUppercaseCode | () | Code[20] | public | - |
| GetLowercaseCode | () | Code[20] | public | - |
| GetTitlecaseCode | () | Code[20] | public | - |
| GetTrimCode | () | Code[20] | public | - |
| GetAlphanumericCode | () | Code[20] | public | - |
| GetDanishDecimalFormatCode | () | Code[20] | public | - |
| GetYYYYMMDDCode | () | Code[20] | public | - |
| GetYYYYMMDDHHMMSSCode | () | Code[20] | public | - |
| GetDeleteNOTPROVIDEDCode | () | Code[20] | public | - |
| EditNextTransformationRule | () | | public | - |
| CreateRule | (Code[20], Text[100], Option, Integer, Integer, Text[100], Text[10]) | | public | - |
| ReplaceRule | (Code[20], Text[100], Option, Text[250], Text[250]) | | public | - |
| InsertFindAndReplaceRule | (Code[20], Text[100], Option, Text[250], Text[250], Code[20]) | | public | - |
| ReplaceRule | (Code[20], Text[100], Option, Text[250], Text[250], Code[20]) | | public | - |
Events, 4
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnTransformation | (Code[20], Text, var Text) | - |
| Integration event | OnCreateTransformationRules | () | - |
| Integration event | OnBeforeIsDataFormatUpdateAllowed | (Integer, var Boolean, var Boolean) | - |
| Integration event | OnValidateLengthOnBeforeTestTransformationType | (var Record Transformation Rule, Record Transformation Rule, var Boolean) | - |