Mapping M3 BE fields to Mobility Core columns

All default values are preconfigured.
  1. Select Data import > Integration MetaData.
  2. Right-click the M3 BE table and select Output Parameters.
    If you have not logged in yet, the Provide BE Credentials is displayed. Specify the M3 BE user name and password.
  3. In the Output Parameters section, select an M3 BE field that is paired with an M3 Mobility Core column, then click the right arrow.
  4. In the M3 CLM fields section, select the M3 BE field that you have moved earlier.
  5. Specify this information:
    CLM table
    Select the M3 Mobility Core table where the M3 Mobility Core column is found. The M3 Mobility Core tables relevant to the M3 BE table that you have selected earlier are listed. Most of the time, only one M3 Mobility Core table is listed.
    CLM column
    Select the M3 Mobility Core column that is paired with M3 BE field.
    Default value
    Specify a default value if this column should be filled with a default value instead of the value from M3.
    If new record (Use Today or Default Value)
    Select if the default field value set is used. If it is a date field, the value is the Current date for the new record.
    Use Today or Default Value
    Select if the default field value set is used. If it is a date field, the value is the Current date for the changes made on the record.
    Is Person
    This field should be specified into the Contact table. It only applies to the import and update of Account records (OCUSMA in M3).
    Is Address
    The M3 address has four fields. This field should be added to one field where each line is separated by a carriage return and line feed unicode characters.
    Is Account type selection
    Placeholder for the field that should be compared to the selected Account Types in Specifying selection settings.
    Create for all Languages
    If this option is selected, a record is created for each language that exists in the Language table. This applies to the Description tables, such as CodeDescription, ProductDescription and others.
    Skip for Update
    The field that is marked with this property is not updated if the record already exists. You can only specify the value if it is a Create or Insert operation.
    Must exist
    The value, usually a foreign key, must exist. The foreign key is not part of the key values from M3, but it must exist in a table or the record to be imported cannot be imported to M3 Mobility Core.
    Combine Date+Time
    Select this option when you have a date field that must contain the time portion. For example, the field Activity.StartDate should contain both date and time because you can plan the activity to be performed today at three in the afternoon. Usually, the dates display the time in the database, but it is only the date part that is used. When you look at the database, keep in mind that it is in UTC format.
    Is Unique
    The value of the field with this property can only exist once. This is usually a key-field in M3.
    Is Combined Unique
    The values of the fields marked with this property can exist together only once. Together, they are the unique key in M3.
    Is Self Refering
    The field marked with this property contains a value from the same table, such as the Payer field in Account. That field could contain another AccountID.
    Get Owner/Org Unit from start page
    The field marked with this property should contain the CRMUserID for the User set as the owner on this transaction. If you need to specify the Organisation unit, it should be retrieved from this user.
    Is Account status selection
    Placeholder for the field that should be compared to the selected Account status from- and to- values in Specifying selection settings.
    Match Code Group selection
    This field (CTSTCO) from the Event from CSYTAB (this only applies to Codes), should only be specified in M3 CLM if it matches the CodeGroups specified in Specifying code group settings.
    Match with default value
    If the field value is the same value that is specified as the default value, then this record is added to the M3 Mobility Core database.
    Combine to Parent PK
    Select this option when mapping the Header and Lines. You need to know which fields are unique keys in M3 for the header record so that you can use these fields to check in the header table for that record. For Sales quotes that are the QuoteNumber in the Header record, and the QuoteNumber, Line number and Line suffix for the Line record.
    Is Foreign Key
    The value of this field must exist in another table. That table and the field to search is specified in the drop-down boxes displayed when the check box is selected.
  6. Click Save at the right of the M3 CLM table field.
  7. Click Save at the right of the M3 CLM fields section.
    Note: For the change to be applied after the mapping, you need to restart the M3 Mobility Core node in the Grid Management Pages using the LifeCycle Manager.