select sys.ID from sys$posdocumentsopened sys join posdocuments doc on doc.id=sys.id where ((sys.Opened = 'A') or (sys.IsPayChange = 'A')) and doc.DocQueue_ID = :DocQueue_ID and doc.Shop_ID = :Shop_ID and doc.CreatedBy_ID = :CreatedBy_ID and sys.ID like :SiteMask order by sys.IsPayChange, doc.DocDate$DATE
Generated by ABRA Software a.s. 27.10.2021 16:34:30