Other table in Microsoft Dynamics 365 Business Central. 27 fields, 13 records in Cronus demo.
The Transformation Rule table (ID 1237) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 27 fields, with a primary key of Code, and includes 3 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Code PK | Code | Normal | |
| 2 | Description | Text | Normal | |
| 3 | Transformation Type | Option | Normal | |
| 10 | Find Value | Text | Normal | |
| 11 | Replace Value | Text | Normal | |
| 12 | Starting Text | Text | Normal | |
| 13 | Ending Text | Text | Normal | |
| 15 | Start Position | Integer | Normal | |
| 16 | Length | Integer | Normal | |
| 18 | Data Format | Text | Normal | |
| 20 | Data Formatting Culture | Text | Normal | |
| 30 | Next Transformation Rule | Code | Normal | → Transformation Rule #1237 |
| 50 | Table ID | Integer | Normal | |
| 51 | Table ID ⚡ FLOW | Text | FlowField | |
| 52 | Source Field ID | Integer | Normal | |
| 53 | Source Field Caption ⚡ FLOW | Text | FlowField | |
| 54 | Target Field ID | Integer | Normal | |
| 55 | Target Field Caption ⚡ FLOW | Text | FlowField | |
| 56 | Field Lookup Rule | Option | Normal | |
| 57 | Precision | Decimal | Normal | |
| 58 | Direction | Text | Normal | |
| 70 | Extract From Date Type | Option | Normal | |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |
Tables referenced by fields on the Transformation Rule table through TableRelation properties.