something like CASE WHEN {transaction.type} = 'Transfer Order' AND {transaction.status} = 'Pending Receipt' THEN {transaction.tranid} ELSE NULL END