Objektová akce

Kód:

4

Tělo:

/* Faktury přijaté */  
 SELECT distinct '04', RI.ID
  FROM receivedinvoices RI
  WHERE
    RI.ID IN (SELECT PO3.pdocument_id
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='04' AND PO3.parent_id=:OBJID)
    
union all
/* JSD */
SELECT distinct '12', CD.ID
  FROM CustomsDeclarations CD
  WHERE
    CD.ID IN (SELECT PO3.pdocument_id
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='12' AND PO3.parent_id=:OBJID)    

union all
/* Výdajový ostatní doklad */
SELECT distinct '02', OE.ID
  FROM otherexpenses OE
  WHERE
    OE.ID IN (SELECT PO3.pdocument_id
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='02' AND PO3.parent_id=:OBJID)

union all
/* Výdajový ostatní doklad */
SELECT distinct '63', VD.ID
  FROM vatissueddcreditnotes VD
  WHERE
    VD.ID IN (SELECT PO3.pdocument_id
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='63' AND PO3.parent_id=:OBJID)

union all
/* Zálohový list přijatý */
SELECT distinct '11', RDI.ID
  FROM receiveddinvoices RDI
  WHERE
    RDI.ID IN (SELECT PO3.pdocument_id
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='11' AND PO3.parent_id=:OBJID)

union all
/* Dobropis VF */
SELECT distinct '60', ICN.ID
  FROM IssuedCreditNotes ICN
  WHERE
    ICN.ID IN (SELECT PO3.pdocument_id
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='60' AND PO3.parent_id=:OBJID)
    
union all
/* Faktury vydané */  
 SELECT distinct '03', II.ID
  FROM IssuedInvoices II
  WHERE
    II.ID IN (SELECT PO3.pdocument_id
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='03' AND PO3.parent_id=:OBJID)

Generated by ABRA Software a.s. 27.10.2021 16:34:10