SQL Command – Which Envelope ID Uses Which Map

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:

SQL command

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:

SQL command Select Name


Leave a Reply

Your email address will not be published. Required fields are marked *