Hi Bjørn,

Unfortunately there is not a column in the database which would indicate a signature has been obtained.  I am sure you are aware that signatures are uploaded as an attachment against the order so just clicking on the attachment icon should indicate whether a signature was obtained.

But a specific field/column indicating the status of a signature does not exist.  Sorry.

Thanks Phil, that was I reconed. Thanks for confirming.

Quick followup - we record the reason why a signature was not available. Is that stored anywhere?

In response to your follow up question, yes there is a field that is updated when the customer was not able to sign the work order.  This information is stored in the order_changes_log (a part of the v15 & higher transaction logs) and can be retrieved with a query like the following:

SELECT unique_id, 
       order_id, 
       bpart_id, 
       comment_text, 
       creation_datetime, 
       created_by
FROM order_changes_log with(nolock)
WHERE order_id = 'SV2202060001@@1'
      AND bpart_id = 'signature_unavailable';

The comment_text would contain what the field engineer inserted as the reason.

I should also clarify a little more for the original question, as you know the signature is upload as an attachment.  There is NOT a dedicated field for indicating the presence of the signature but if you were looking to capture a query to see if there was an attachment, this is possible.  

SELECT ap_attachment_id, 
       ap_table_key, 
       ap_user_login, 
       ap_creation_time, 
       ap_description, 
       ap_file_name
FROM ap_attachments WITH(NOLOCK)
WHERE ap_table_key = 'SV2202060002@@1'
      AND ap_description LIKE 'Signed by:%';

However, there is nothing in the UI itself to indicate the presence of the signature other than the attachment.