Třídová akce

Popis:

Vrátí seznam neoceněných pohybů pro skladovou uzávěrku.

Kód:

17

Tělo:

SELECT
  A.ID, 
  A.LocalTAmount, 
  CASE 
    WHEN (A.FlowType IN ('24', '37')) THEN 
      A.ProvideRow_ID 
    ELSE 
      A.RDocumentRow_ID 
  END AS RDocumentRow_ID, 
  A.Quantity, 
  A.Store_ID, 
  A.StoreCard_ID, 
  A.Parent_ID,
  A.CompletePrices, 
  PMS.SystemState AS PMSystemState,
  A.ProductionTask_ID, 
  A.FlowType AS DocumentType,
  A.FlowSign, 
  A.PriceTransformationCoefficient,
  A.TAmount, 
  A.TotalPrice,
  A.Valuated,
  A.EtalonRate 
FROM StoreDocuments2 A
JOIN PMStates PMS ON A.PMState_ID = PMS.ID 
JOIN StoreDocuments SD ON SD.ID = A.Parent_ID
WHERE
  A.ClosingOrder = 0 AND
  A.RowType = 3 AND
  SD.DocDate$DATE < :DateTo AND
  EXISTS (SELECT 1 FROM SelDat WHERE SelDat.Sel_ID = :StoreSel_ID AND SelDat.Obj_ID = A.Store_ID AND (SelDat.Tag = ' ' or SelDat.Tag = A.StoreCard_ID))  
ORDER BY
  SD.DocDate$DATE, A.OrderFlow

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