Custom field mapping

Zilliant CPQ supports mapping between C4C and the CPQ custom Business Data Attribute (BDA) field with a range of string, Boolean and decimal. CPQ uses a lookup table to maintain this mapping.

Supported graph and subject types

Supported data types

Use the following supported data types to define the range property of a custom BDA:

• String—Syntax for defining range: <rdfs:range rdf:resource="&xsd;string"/>
• Boolean—Syntax for defining range: <rdfs:range rdf:resource="&xsd;boolean"/>
• Decimal— Syntax for defining range: <rdfs:range rdf:resource="&xsd;decimal"/>v

The following table lists supported data type mappings between CPQ and C4C.

Use the following procedures to configure custom field mapping:

1. Define custom fields in CPQ and add a custom BDA
2. Map the fields

Define custom fields in CPQ

Define custom fields in CPQ in the application-schema-ext.owl file:

1. Download the application-schema-ext.owl file. See General property and ontology files to learn how to access this file.

2. Add the new custom BDA for the supported domain with the following properties:

   • Type—Specify a functional property.
   • Domain—Define within the supported domain/subject types URI.
   • subProperty—Specify an assertion.
   • Range—Specify a string, decimal or Boolean value.

3. Upload the application-schema-ext.owl file to the system.

4. Restart to refresh the newly added custom fields to the system.

The following samples show a supported custom BDA definition for the account business type:

<!-- http://www.inmindcloud.com/application/application-schema-ext.owl#zAccountTextField -->

    <owl:DatatypeProperty rdf:about=" http://www.inmindcloud.com/application/application-schema-ext.owl#zAccountTextField">

<rdf:type rdf:resource="&owl;FunctionalProperty"/>

             <rdfs:domain rdf:resource="&as;Account"/>

             <rdfs:subPropertyOf rdf:resource="&as;assertion"/>

             <rdfs:range rdf:resource="&xsd;string"/>

    </owl:DatatypeProperty>

<!-- http://www.inmindcloud.com/application/application-schema-ext.owl#zAccountBooleanField -->

    <owl:DatatypeProperty rdf:about="&ase;zAccountBooleanField">

<rdf:type rdf:resource="&owl;FunctionalProperty"/>

             <rdfs:domain rdf:resource="&as;Account"/>

             <rdfs:subPropertyOf rdf:resource="&as;assertion"/>

             <rdfs:range rdf:resource="&xsd;boolean"/>

    </owl:DatatypeProperty>

<!-- http://www.inmindcloud.com/application/application-schema-ext.owl#zAccountDecimalField -->

    <owl:DatatypeProperty rdf:about="&ase;zAccountDecimalField">

<rdf:type rdf:resource="&owl;FunctionalProperty"/>

             <rdfs:domain rdf:resource="&as;Account"/>

             <rdfs:subPropertyOf rdf:resource="&as;assertion"/>

             <rdfs:range rdf:resource="&xsd;decimal "/>

    </owl:DatatypeProperty>

Map the CPQ custom BDA to C4C custom fields

After you define the supported custom BDA, map the BDA to the custom field created in C4C. Use the CUSTOM_CFC_FIELDS pre-delivered lookup table.

The lookup table includes the following fields:

• MX GRAPH TYPE URI—Supported PRIMRY Business Type URI. It must be the full URI of supported Graph Types available in CPQ.

• MX SUBJECT TYPE URI—Supported Subject Type URI. It must be the full URI of supported Subject Types available in CPQ.

• MX FIELD URI*—The custom BDA URI with the domain of the supported SUBJECT TYPE URI and supported data type (such as String, Boolean, Decimal).

• CFC FIELD NAME—Custom field name defined in C4C.

• CFC FIELD NAMESPAC—Name space of the field name generated by C4C when creating the custom field. Example: a00:zAccountHeaderText1.

• CFC XPATH—XPath expression at the root level for the SUBJECT_TYPE.

  Note

  The XPath definition for each supported SUBJECT TYPE is fixed and must exactly match the syntax.

To access the CUSTOM_CFC_FIELDS lookup table in CPQ:

1. Sign in to CPQ with administrator credentials.
2. In the left navigation area, select Lookup.
3. Use the search bar at the top to find CUSTOM_CFC_FIELDS.

Define the custom fields mapping in Excel:

1. Download the CUSTOM_CFC_FIELDS table to define the custom field mapping.
2. Define the mapping record.
3. Upload the Excel file to the application.