Table 1237 Transformation Rule
22 fields
| Id | Name | Type | Versions |
|---|---|---|---|
| 1 | Code | Code[20] | 17-29 |
| 2 | Description | Text[100] | 17-29 |
| 3 | Transformation Type | Enum "Transformation Rule Type" | 17-29changed in 21 |
| 10 | Find Value | Text[250] | 17-29 |
| 11 | Replace Value | Text[250] | 17-29 |
| 12 | Starting Text | Text[250] | 17-29 |
| 13 | Ending Text | Text[250] | 17-29 |
| 15 | Start Position | Integer | 17-29 |
| 16 | Length | Integer | 17-29 |
| 18 | Data Format | Text[100] | 17-29 |
| 20 | Data Formatting Culture | Text[10] | 17-29 |
| 30 | Next Transformation Rule | Code[20] | 17-29 |
| 50 | Table ID | Integer | new in 21 |
| 51 | Table Caption | Text[250] | new in 21 |
| 52 | Source Field ID | Integer | new in 21 |
| 53 | Source Field Caption | Text[250] | new in 21 |
| 54 | Target Field ID | Integer | new in 21 |
| 55 | Target Field Caption | Text[250] | new in 21 |
| 56 | Field Lookup Rule | Option | new in 21 |
| 57 | Precision | Decimal | new in 21 |
| 58 | Direction | Text[1] | new in 21 |
| 70 | Extract From Date Type | Enum "Extract From Date Type" | new in 21 |