<?php $variable_name = get_post_meta($post->ID, 'Custom_Field_Name', true); ?>
<?php if ($variable_name): ?>
<?php echo wp_get_attachment_url($variable_name); ?>
<?php endif; ?>
Just replace variable_name with whatever you wish to call it and Custom_Field_Name with whatever you named the field in the plugin.