Transformation Rule Card – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Pages TTransformation Rule Card

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/page1238

Page Name: Transformation Rule Card
Page Number: 1238
Page Type: Card

Source Table Name: Transformation Rule
Source Table Number: 1237

Show/hide columns in the Transformation Rule Card page

Seq.	Control ID	Control Name	Field No.	Field Name	Enabled	Editable	Visible
0	412791440	Code	1	Code	true	True	true
1	225920675	Description	2	Description	true	True	true
2	751554036	Transformation Type	3	Transformation Type	true	True	true
	Available options are: “Uppercase” “Lowercase” “Title Case” “Trim” “Substring” “Replace” “Regular Expression – Replace” “Remove Non-Alphanumeric Characters” “Date Formatting” “Decimal Formatting” “Regular Expression – Match” “Custom” “Date and Time Formatting” “Field Lookup” “Round” “Extract From Date”
3	380775157	Next Transformation Rule	30	Next Transformation Rule	true	True	true
4	1152060291	Find Value	10	Find Value	true	True	true
5	550253482	Replace Value	11	Replace Value	true	True	true
6	817219196	Start Position	15	Start Position	true	True	true
7	1028448336	Starting Text	12	Starting Text	true	True	true
8	63123121	Length	16	Length	true	True	true
9	1772108359	Ending Text	13	Ending Text	true	True	true
10	1200485466	Data Format	18	Data Format	true	True	true
11	720715014	Data Formatting Culture	20	Data Formatting Culture	true	True	true
12	502624262	Table ID	50	Table ID	true	True	true
13	208859901	Table Caption	51	Table Caption	true	False	true
14	691997225	Source Field ID	52	Source Field ID	true	True	true
15	2094077268	Source Field Caption	53	Source Field Caption	true	False	true
16	1587577275	Target Field ID	54	Target Field ID	true	True	true
17	459706040	Target Field Caption	55	Target Field Caption	true	False	true
18	548416397	Field Lookup Rule	56	Field Lookup Rule	true	True	true
	Available options are: “Target” “Original If Target Is Blank”
19	123716730	Extract From Date Type	70	Extract From Date Type	true	True	true
	Available options are: “Date” “Month” “Year”
20	1241282635	Precision	57	Precision	true	True	true
21	673367792	Direction	58	Direction	true	True	true
22	121478038	TestText			true	true	true
23	1770076415	ResultText			true	false	true
24	896109327	UpdateResultLbl			true	False	true

Dynamics 365 BC Table Reference Pages TTransformation Rule Card

Show/hide columns in the Transformation Rule Card page

Leave a Reply Cancel reply