Create a Field Mapping Custom Object

You create the Field Mapping custom object in the Sales application. Use a new sandbox to create the Field mapping custom object.

Note: You must validate and publish the sandbox before generating import and export artifacts for the Field Mapping object. The procedure on generating artifacts appears later in this topic.

Creating the Field Mapping Custom Object

Enter the parameters listed in the following table for the Field Mapping custom object, using the Creating Custom Objects procedure.

Parameter	Value
Display Label	Field Mapping
Plural Label	Field Mappings
Record Name Label	Field Mapping ID
Record Name Data Type	Select Automatically Generated Sequence from the drop down menu.
Sequence Format	{000000000000000} (15 zeroes inside braces)
Object Name	O_INT_FieldMapping
Description	Leave blank.

Creating Fields for the Field Mapping Custom Object

Create the fields listed in the following table for the Field Mapping custom object using the Creating Custom Objects procedure.

Parameter	FusionFieldNameField	FusionFieldValue Field	RemoteFieldID Field	RemoteFieldName Field	RemoteField Value Field	RemoteSystemID Field
Field Type	Text	Text	Text	Text	Text	Text
Display Label	Local Field Name	Local Field Value	Remote Field ID	Remote Field Name	Remote Field Value	Remote System Name
Name	FusionFieldName	LocalFieldValue	RemoteFieldID	RemoteFieldName	RemoteFieldValue	RemoteSystemID
Display Width	20	20	20	20	20	20
Display Type	Simple Text Box	Simple Text Box	Simple Text Box	Simple Text Box	Simple Text Box	Simple Text Box
Constraints	Required, Updatable, Searchable, Indexed	Required, Updatable, Searchable, Indexed	Updatable, Searchable	Required, Updatable, Searchable, Indexed	Required, Updatable, Searchable, Indexed	Required, Updatable, Searchable, Indexed
Maximum Length	100	100	100	100	100	80

Creating Pages for the Field Mapping Custom Object

Create the pages listed in the following tables for the Field Mapping custom object using the Creating Custom Objects procedure.

Creating the Object Validation Rule for the Field Mapping Custom Object

Create the object validation rule from the UniqueKey.groovy file, using the Creating Validation Rules procedure.

Creating the Global Function for the Field Mapping Custom Object

Create a global function from the O_INT_GetMappedField.groovy file using the Creating Global Functions procedure.

Note: This global function depends on the Field Mapping custom object being created, so it was not created previously in the Creating Global Functions procedure.

Validating and Publishing the Sandbox

Validate and publish the sandbox for the Integration Configuration custom object, using the Publish Unified Sandboxes topic.

Generating Artifacts for Import and Export

To support the import and export of a custom object, such as Field Mapping, you must first generate the object artifacts required for both import and export.

Note: Before performing this step, validate the current sandbox and publish it. Generating import and export artifacts in sandboxes is not supported.

To generate artifacts for import and export do the following:

1. Exit the sandbox, click Navigator, and select Application Composer.

2. In the Generate Import and Export Artifacts area, click Generate.

3. Refresh the page if necessary.

4. In the Details window, make sure that the statuses for the Field Mapping custom object are the following:

   • Overall Status: Completed

   • Import Status: Success

   • Export Status: Success