This SQL command is useful for finding out which envelope_id’s use a particular Sterling Integrator map.
select envelope_id from envelope_parms where Value = ‘KEU_ORDGB01’
Example results shown below:
Once you have the result of the SQL command, you will need to make another command to find the name of the envelope.
select Name from envelope where envelope_id = ‘fiber:1833955:115dcaef8ee:-67b6’
The result should be the STX (or UNB) envelope: