INSERT INTO cheques
      (SELECT "Import"."ExternalId" as "id", "device"."clientId" as "client_id", "Import"."Content" as "content",
      "Import"."ReceivedAt" as "created_at","Import"."ReceivedAt" as "updated_at", "Import"."DeviceSN" as "deviceSN",
      "Import"."DeviceRN" as "deviceRN", "deviceGroup"."Name" as "deviceGroup",
      "Import"."FSNumber" as "fsNumber", "Import"."OFDName" as "ofdName", "Import"."OFDWebsite" as "ofdWebsite",
      "Import"."OFDINN" as "ofdinn", "Import"."FNSWebsite" as "fnsWebsite", "Import"."DocumentNumber" as "documentNumber",
      "Import"."ShiftNumber" as "shiftNumber", "Import"."DocumentIndex" as "documentIndex", "Import"."Change" as "change",
      "Import"."FP" as "fp", "Import"."Type" as "type", "Import"."ProcessedAt" as "processedAt",
      0 as "amount", FALSE as "fromLk", 'processed' as "status"
      FROM import_cheques as "Import" LEFT OUTER JOIN "Devices" as "device" ON "Import"."DeviceSN"=device."serialNumber"
      LEFT OUTER JOIN import_device_groups as "deviceGroup" ON "Import"."DeviceGroupId"="deviceGroup"."Id" WHERE device."clientId" IS NOT NULL
      )
ON CONFLICT ("id") DO UPDATE SET
      client_id=EXCLUDED.client_id,content=EXCLUDED.content,created_at=EXCLUDED.created_at,updated_at=EXCLUDED.updated_at,
      "deviceSN"=EXCLUDED."deviceSN","deviceRN"=EXCLUDED."deviceRN","deviceGroup"=EXCLUDED."deviceGroup","fsNumber"=EXCLUDED."fsNumber",
      "ofdName"=EXCLUDED."ofdName",ofdinn=EXCLUDED.ofdinn,"ofdWebsite"=EXCLUDED."ofdWebsite","fnsWebsite"=EXCLUDED."fnsWebsite",
      "documentNumber"=EXCLUDED."documentNumber","documentIndex"=EXCLUDED."documentIndex","shiftNumber"=EXCLUDED."shiftNumber",
      change=EXCLUDED.change,fp=EXCLUDED.fp,type=EXCLUDED.type,"processedAt"=EXCLUDED."processedAt",amount=0,"fromLk"=FALSE,status='processed'