Třídová akce

Kód:

38

Tělo:

select
  Max(A.Store_Id) as Store_ID,
  Max(PD.DocDate$Date) as DocDate,
  Max(PD.BusOrder_Id) as BusOrder_Id,
  Max(BO.Code) as BO_Code,
  Max(BO.Name) as BO_Name,
  Max(PD.BusTransaction_Id) as BusTransaction_Id,
  Max(BT.Code) as BT_Code,
  Max(BT.Name) as BT_Name,
  Max(PD.BusProject_Id) as BusProject_Id,
  Max(BP.Code) as BP_Code,
  Max(BP.Name) as BP_Name
from
  POSDocuments2  A
  left join POSDocuments PD on PD.id = A.parent_id
  left join BusOrders BO on BO.id = PD.BusOrder_id
  left join BusTransactions BT on BT.id = PD.BusTransaction_ID
  left join BusProjects BP on BP.id = PD.BusProject_ID
where
  A.Id like :SiteMask and
  A.OrderFinished = 'N' and
  ((A.OrderKind = 2) or
   (A.OrderWasteQuantity>0))  and
  PD.Opened='N'
group by
  A.Store_Id,
  PD.DocDate$Date,  
  PD.BusOrder_Id,
  PD.BusTransaction_Id,
  PD.BusProject_Id
  

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