Копирование чеков из магазина в ЦО : Супермаг Плюс (Супермаг 2000)

Connected to Oracle Database 11g Release 11.2.0.1.0 
Connected as supermag@//192.168.1.201/DBOFFICE

SQL> 
SQL> select locid, count(1)
  2    from SUPERMAG.SMCASHZ E
  3   WHERE E.CLOSEDATE between to_date('3.10.2019', 'dd.mm.yyyy')
  4                         and to_date('3.12.2019', 'dd.mm.yyyy')
  5   group by locid;

      LOCID   COUNT(1)
----------- ----------
          6         61
         44          1
          4        183
          5        122
          3        123
         36          1

6 rows selected


SQL> 
SQL> select  locid, znum, closedate
  2    from SUPERMAG.SMCASHZ E
  3   WHERE E.CLOSEDATE > to_date('01.01.2019', 'dd.mm.yyyy')
  4     and locid not in (3, 4, 5, 6)
  5   order by closedate;

      LOCID   ZNUM CLOSEDATE
----------- ------ -----------
         44   2361 16.04.2019
         44   2494 25.08.2019
         44   2552 22.10.2019
         36    862 21.11.2019