Session ID : User iD :
espace client
xx
SELECT
documents.doc_id, documents.doc_number, documents.date_doc,
type_doc.type_doc_descr,
documents.total_pos_ttc,
doc_status.doc_status_descr
FROM activpart.documents
LEFT JOIN doc_status ON documents.doc_status_code=doc_status.doc_status_code
JOIN type_doc ON documents.type_doc_id=type_doc.type_doc_id
AND type_doc.type_doc_ref IN ('DEVISCLI', 'CBLCLI','FACTCLI','AVOIRCLI')
JOIN activpart.thirds ON
WHERE documents.third_id=''
ORDER BY documents.date_doc DESC
xx
| N° de commande | Date | Montant | statut | Actif |
|---|
