Managing Schema

Use the Manage Schema window to compare the database schema in Infor CRM with your integration schema to ensure data integrity. You can compare data for various resources to determine if differences in string lengths exist between systems.

More information about how Infor CRM manages schema differences:

MaxLength - If data is synchronized to Infor CRM that exceeds the MaxLength of a field, the entire row will be rejected.

FractionalDigits - If data is synchronized to Infor CRM that exceeds the number of decimal points, the value will be rounded to the maximum digits allowed after the decimal point. For example, if a currency field is defined as 17.4, then a value of 123.12348 is saved as 123.1235 and a value of 123.12343 is saved as 123.1234.

You can perform these tasks related to schema:

• Click (Manage Schema) on the Integration Detail view Resources tab to open the Manage Schema dialog box.
• Compare schema for resources