Data Types - trillium_quality - Latest

Trillium Quality for Dynamics Installation and Developer Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Version
Latest
Language
English
Product name
Trillium Quality
Title
Trillium Quality for Dynamics Installation and Developer Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:21:24.697372

You can add up to two string fields, two numeric fields, and one date field to your match criteria. For matching purposes, field values are handled as follows. (Value modifications are internal; visual field values are not modified.)

  • String fields: All spaces are removed and the value is left-justified. For example, “  abc def ” will be matched as “abcdef”. A maximum of 100 characters per field are used in the match criteria.

  • Numeric fields: All non-numeric characters are removed and the value is left-justified. For example, “ 99-999-(99)” will be matched as “9999999”. A maximum of 100 characters per field are used in the match criteria.

  • Date and time fields: Date formats are supported regardless of the order of subcomponents (year, month, day). The time portion of the value is not included in the match value. A maximum of 20 characters are used in the match criteria.

The data type of the Trillium field determines how the data is evaluated. For example, the sample web resource XML file illustrates assigning the CRM field accountnumber, which is a string field, to trillium_dr_num_1, which is a numeric field. The data will be matched as a numeric field, which excludes non-numeric characters, allowing “123-456” to match “123--456”.