"SELECT" +
   "   dj.idStatus       AS [idStatus]," +
   "   st.name           AS [nmState]," +
   "   dj.id             AS [idDoc]," +
    "   dj.idRoute                   AS [idRoute]," +
   "   dj.idPhysicalPerson          AS [idPhysicalPerson], " +
   "   dj.idOperation    AS [idOperation]," +    ----- признак документа -2 накладная, 3-рко (расходник)
   "   dj.idState    AS [StatusDoc]," +
   "   op.shortName                 AS [docName]," +
   "   '№' || dj.PrintDocNum        AS [docNum]," +
   "   DATE(dj.OpDate)              AS [docDate]," +
   "   STRFTIME('%H:%M', dj.OpDate) AS [docTime], " +
   "   dj.idBuyPoint                AS [idBuyPoint]," +   - контрагенты
  "   sum(dj.Amount)                    AS [amount]," +
   "   dj.Comment                   AS [comment] " +
   "FROM docJournal dj  " +
   "LEFT JOIN enOperationTypes   op ON op.id = dj.idOperation" +
   "LEFT JOIN refDocumentStates  st ON st.id = dj.idState" +
   "WHERE   " +
   "   DATE(dj.OpDate) BETWEEN DATE('" + startDate + "') AND DATE('" + endDate + "')" +
  "   AND  dj.idOperation IN (2, 3)" +
     "   AND dj.deleted = 0          " +
    "  AND dj.idStatus = 1       " +
  "group BY              \n" +
"   dj.idBuyPoint, dj.idOperation              --";
  "ORDER BY              \n" +
  "   dj.OpDate ASC, dj.PrintDocNum ASC"
;