Other table in Microsoft Dynamics 365 Business Central. 27 fields, 13 records in Cronus demo.
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.