select
s.Code as DisplayName,
a.Name as Description,
a.CREATED$DATE as Date$Date,
a.ID as ID,
'0000000000' as FirmID
from PLMPieceLists a, StoreCards s
where a.Storecard_ID=s.id and
a.BusProject_ID=:ID
and (a.CREATED$DATE >= :DateFrom) and (a.CREATED$DATE < :DateTo + 1) AND Revided_ID IS NULLGenerated by ABRA Software a.s. 27.10.2021 16:34:49