Třídová akce

Kód:

22

Tělo:

SELECT
  A.ID,
  A.store_id as Store_ID,
  ST.code as Store_Code,
  ST.name as Store_Name,
  A.StoreCard_id as StoreCard_ID,
  SC.Code as StoreCard_Code,
  SC.Name as StoreCard_Name,
  SC.MainUnitCode as StoreCard_MainUnitCode,
  A.Qunit as Qunit,
  A.UnitRate as UnitRate,
  A.Quantity as Quantity,
  A.OrderKind as OrderKind,
  A.OrderQuantity as OrderQuantity,
  A.OrderCorrectionQuantity as OrderCorrectionQuantity,
  A.OrderWasteQuantity as OrderWasteQuantity,
  PD.BusOrder_ID,
  BO.code as BO_Code,
  BO.Name as BO_Name,
  PD.BusTransaction_ID,
  BT.code as BT_Code,
  BT.Name as BT_Name,
  PD.BusProject_ID,
  BP.code as BP_Code,
  BP.Name as BP_Name,
  PD.docdate$date as DocDate,
  PD.shop_id as Shop_Id,
  SH.code as Shop_Code,
  SH.name as Shop_Name
FROM
  POSDocuments2  A
  left join POSDocuments PD on PD.id = A.parent_id
  left join stores ST on ST.id = A.store_id
  left join storecards SC on SC.id = A.storecard_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
  left join posshops SH on SH.id = PD.shop_id
WHERE
  A.id like :SiteMask and
  A.orderfinished = 'N' and
  (A.orderkind = 2) and
  PD.opened='N'
order by
  ST.code,
  PD.docdate$date,  
  SC.code,
  A.qunit,
  A.orderkind

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