SELECT Example of invoice including doc outbound and printing queue
i.documentno as "Invoice_No",
pq.C_Printing_Queue_id as "Printing Queue ID",
pq.processed as "printed",
c_doc_outbound_log_id as "Doc Outbound ID"
FROM c_doc_outbound_log dol
LEFT JOIN c_invoice i ON dol.ad_table_id = 318 AND dol.record_id = i.c_invoice_id
LEFT JOIN AD_Archive ar ON ar.AD_Table_ID = 318 AND ar.record_id = i.c_invoice_id
LEFT JOIN C_Printing_Queue pq ON ar.AD_Archive_ID = pq.AD_Archive_ID
JOIN ad_org o ON i.ad_org_id = o.ad_org_id
AND dol.created >= '2018-01-05'
View source file on GitHub.com