Třídová akce

Popis:

Vrátí rezervovanou dispozici po šaržích/sér.č. pro zvolený doklad, kartu, sklad a jednotku.

Kód:

14

Tělo:

SELECT
  SUM(SC.Quantity - SC.QuantityReserved),
  SC.StoreBatch_ID
FROM 
  LogStoreContents SC
  JOIN LogStorePositions SP ON SC.Parent_ID = SP.ID
WHERE
  SP.ReservedForDoc_ID = :ReservedForDocID AND
  SP.ReservedForDocType = :ReservedForDocType AND
  SP.Store_ID = :StoreID AND
  SC.StoreCard_ID = :StoreCardID AND
  SC.QUnit = :QUnit
GROUP BY 
  SC.StoreBatch_ID

Generated by ABRA Software a.s. 27.10.2021 16:35:19