Mediusflow: Handlde errands where integration status not in sync

gistfile1

DECLARE @intErrandId integer 
DECLARE @intPaymenttransferred integer 
DECLARE @strVerificationIdentity nvarchar (20)

SET @intErrandId = [[Errand Id]]
SET @strVerificationIdentity = '[[Verification Identity]]' 

-- Get payment transsferred status based on statusId

SELECT @intPaymenttransferred = CASE (e.statusid)
                                    WHEN 57 THEN 15
                                    WHEN 9 THEN 2
                                    ELSE 1
                                END
FROM ERRAND e
WHERE ID = @intErrandId

UPDATE INVOICE_HEAD
    SET VerificationIdentity = @strVerificationIdentity,
        PaymentTransferred = @intPaymenttransferred WHERE ID IN
        (SELECT invoiceid
         FROM ERRAND
         WHERE id = @intErrandId)
    UPDATE ERRAND

SET VISIBLE = -1 WHERE id = @intErrandId