ServiceNow transform maps handle the format of data being shared into a ServiceNow instance. The common documents use transform maps to allow data to be properly shared out of one application and then be mapped correctly to the relevant fields in ServiceNow.
Understand the process of transform maps with Common Documents with the following steps:
Coalesced Field Mappings
Field mappings with the coalesced box checked will be processed first to identify if this is a new record or an update.
On Before Transform Scripts
All on before scripts are processed.
All Non-Coalesced Field Mappings
Field mappings where the coalesced checkbox is not ticked.
On Foreign Insert Scripts
All on foreign scripts are processed.
Script Box
This is the script field on the main transform map.
The Common Documents will have a script in this field that will ensure proper dates and times are reflected on records.
On After Scripts
Once the record is written to the database, these scripts are run.