Objects/Tables/Table 1237 Transformation Rule
Table 1237 Transformation Rule in 17
Jonas Paprotka, Base Application 17.5.22499.32099, checked
- App
- Base Application
Fields, 12Keys, 1Procedures, 17Events, 3
Versions171819202122232425262728latest
Source29
Fields, 12
| Id | Name | Type | Obsolete |
|---|
| 1 | Code | Code[20] | - |
| 2 | Description | Text[100] | - |
| 3 | Transformation Type | Option | - |
| 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] | - |
Keys, 1
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Code | - |
Procedures, 17
| 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 | - |
Events, 3
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnTransformation | (Code[20], Text, var Text) | - |
| Integration event | OnCreateTransformationRules | () | - |
| Integration event | OnBeforeIsDataFormatUpdateAllowed | (Integer, var Boolean, var Boolean) | - |