Configure transaction-to-quote field mapping
When you use Sales CRM capabilities such as opportunity management, advanced approvals, or PDF document generation, ServiceNow CPQ Microservices sync data to the ServiceNow platform. This sync is set up automatically, but custom transaction fields require you to configure the data mapping.
Before you begin
Role required: admin
Verify that you have the permissions required to add columns on ServiceNow tables.
Activate the Quote Experience plugin (App ID: sn_quote_mgmt_adv).
About this task
Custom transaction fields are mapped to columns on one of two ServiceNow tables:
- Quote — captures header-level quote data.
- Quote Lines — captures individual line data.
To configure the mapping, create a column on the target ServiceNow table, create the corresponding field on the blueprint, map the field to the column, and then deploy the blueprint. Complete the following phases in order.
- Header-level transaction fields can be mapped only to the Quote table.
- Line-level transaction fields can be mapped only to the Quote Lines table.
- The External Field Mapping options are filtered to the column types supported by the current field type.
- Columns that are already mapped to a field aren't displayed.
- If you use a ServiceNow table column that has a list specification, you must add all valid choices for data to sync properly. For example, the choices for the State column on the
Quote table must be updated to match the values of the
txn.stagefield.
Procedure
Result
The custom transaction field is mapped to the selected ServiceNow table column, and data syncs between the transaction and the quote record.