2025-10-04 13:48:28 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:28 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:28 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:48:28 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:28 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:48:28 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:48:28 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-04 13:48:29 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:48:29 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-04 13:48:29 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-04 13:48:29 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:48:29 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-04 13:48:29 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:48:29 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-04 13:48:31 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:48:32 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:48:32 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-04 13:48:33 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='Rx6mbdYBJ8Gb/3I1nd/LWXVFPgVTf1heUh+CX9il0Ok=',"Details"='',"ExDetails"='np+8EjyDNtjEyTBNkIgaEw==',"Max"=2,"OlusturmaTarihi"='23.09.2025 15:03:23',"Durum"=1  WHERE "ID"=1
2025-10-04 13:48:33 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',1,'ORCA','4.10.2025 13:48:33','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"Rx6mbdYBJ8Gb/3I1nd/LWXVFPgVTf1heUh+CX9il0Ok=","Details":"","ExDetails":"np+8EjyDNtjEyTBNkIgaEw==","Max":2,"_sonTarih":"2025-10-04T00:00:00","ID":1,"OlusturmaTarihi":"2025-09-23T15:03:23.888654","Durum":1}') ;
2025-10-04 13:48:33 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 1 )
2025-10-04 13:48:34 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:48:34 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:48:34 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:48:34 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:48:34 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:34' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:48:34 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:34' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:48:34 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:34' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:48:37 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:37' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:48:37 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('4.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('4.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:48:37 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-04 13:48:37 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:48:37 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:48:37 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:48:37 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:48:37 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:37' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:48:37 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:37' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:48:37 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:37' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:48:38 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:48:38' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:48:38 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('4.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('4.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:48:38 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-04 13:48:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:48:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:48:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:48:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:48:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:48:39 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-04 13:48:40 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:40 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:40 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:48:40 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:40 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:48:40 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-04 13:48:40 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:48:40 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-04 13:48:40 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-04 13:48:40 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:48:40 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-04 13:48:40 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:48:40 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-04 13:48:42 - Hata (Slayt indirirken): https://lisans.orcayazilim.net/Slayt/1.jpg - The process cannot access the file 'D:\Yazilim\Dilara\OrcaALFA_NET8\OrcaERP\bin\Release\net8.0-windows\Gorseller\Slayt\1.jpg' because it is being used by another process.
2025-10-04 13:48:42 - Hata (Slayt indirirken): https://lisans.orcayazilim.net/Slayt/2.jpg - The process cannot access the file 'D:\Yazilim\Dilara\OrcaALFA_NET8\OrcaERP\bin\Release\net8.0-windows\Gorseller\Slayt\2.jpg' because it is being used by another process.
2025-10-04 13:48:43 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:48:43 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankahareketleri' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarthareketleri' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarttanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankaposhareketleri' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankapostanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankatanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'barkodlar' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'birimtanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihareketler' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihesaplar' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ceksenethareketleri' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dizaynlar' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dokumanlar' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'donemtanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumalias' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusummukellefler' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumtanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fatura' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'faturahareketleri' 
2025-10-04 13:48:44 - ALTER TABLE "FaturaHareketleri" ADD COLUMN "SNo" INTEGER  
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatipleri' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fiyattanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'gridgorunumler' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasahareketleri' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasatanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kdvdepartman' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kullanicilar' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'lisanstanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'notlar' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odeme' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odemehareket' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'logtanim' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklif' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklifhareketleri' 
2025-10-04 13:48:44 - ALTER TABLE "SiparisTeklifHareketleri" ADD COLUMN "SNo" INTEGER  
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'terazikodtanim' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ozelkodtanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'parametreler' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'posterazitanim' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'projekodtanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklet' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklethareketleri' 
2025-10-04 13:48:44 - ALTER TABLE "SatisBekletHareketleri" ADD COLUMN "SNo" INTEGER  
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayim' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayimdetaylari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'serinotanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokfiyatlari' 
2025-10-04 13:48:44 - CREATE TABLE "StokFiyatlari" (
  "StokID" INTEGER,
  "FirmaID" INTEGER,
  "FiyatTanimID" INTEGER,
  "FiyatTanim" TEXT,
  "SatisFiyati" DECIMAL,
  "EskiSatisFiyati" DECIMAL,
  "DegistirmeTarihi" TIMESTAMP,
  "ID" INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NOT NULL,
  "OlusturmaTarihi" TIMESTAMP,
  "Durum" INTEGER
);

2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokgruplari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokhareketleri' 
2025-10-04 13:48:44 - ALTER TABLE "StokHareketleri" ADD COLUMN "NetFiyat" DECIMAL  
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokkartlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'subetanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'urunfiyattablosu' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'uygulamaversiyon' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarthareketleri' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarttanimlari' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ilceler' 
2025-10-04 13:48:44 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'iller' 
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "FirmaTanimlari"  
2025-10-04 13:48:44 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "KdvDepartman"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "CariKodu" = '99.99.99.00099' ) 
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "StokGruplari"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "BankaTanimlari"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "BankaPosTanimlari"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "BankaKartTanimlari"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "YemekKartTanimlari"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "Kullanicilar"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "iLler"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "iLceler"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "FirmaTipleri"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "BirimTanimlari"  
2025-10-04 13:48:44 - SELECT COUNT(1) FROM "TeraziKodTanim"  
2025-10-04 13:48:44 - UPDATE "Fatura" SET "AcikMi"=false, "EDurum"=0 
2025-10-04 13:48:44 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:44 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 13:48:46 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:48:55 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:48:55 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:48:55 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = '99.99.99.00099' )   LIMIT 1 offset 0
2025-10-04 13:48:55 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:48:55 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:48:55 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'POS' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:48:55 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 4, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 3) = 'POS'
                AND "FaturaNumarasi" SIMILAR TO 'POS[0-9]{9}%'
2025-10-04 13:48:55 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "BelgeTuru" = 'POS' ) AND ( "Tarih" = '4.10.2025 00:00:00' )) 
2025-10-04 13:48:55 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-04 13:48:55 - SELECT "Departman","Oran","Sira","FirmaID","ID","OlusturmaTarihi","Durum" FROM "KdvDepartman"  
2025-10-04 13:48:55 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmHizliSatis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:48:55 - SELECT "FirmaID","FirmalarOrtakGrup","GrupAdi","PostaGorunur","ID","OlusturmaTarihi","Durum" FROM "StokGruplari"  WHERE ( "PostaGorunur" = True )ORDER BY "GrupAdi" ASC 
2025-10-04 13:48:55 - SELECT "DocID","Dokuman" FROM "Dokumanlar"  WHERE (("DocID" IN (1)) AND( "Aciklama" = 'STOKGRUP' )) 
2025-10-04 13:48:57 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (((( "FirmaID" = 1 ) OR ( "FirmalarOrtakStok" = 1 )) AND ( "Durum" = 1 )) AND ( "StokGrubu" = 'VARSAYILAN' ))  AND ( "SatisFiyati" > 0 )  ORDER BY "StokAdi" ASC LIMIT 100 offset 0
2025-10-04 13:48:58 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (((( "FirmaID" = 1 ) OR ( "FirmalarOrtakStok" = 1 )) AND ( "Durum" = 1 )) AND ( "StokGrubu" = 'VARSAYILAN' ))  AND ( "SatisFiyati" > 0 )  ORDER BY "StokAdi" ASC LIMIT 100 offset 0
2025-10-04 13:48:58 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (((( "FirmaID" = 1 ) OR ( "FirmalarOrtakStok" = 1 )) AND ( "Durum" = 1 )) AND ( "StokGrubu" = 'VARSAYILAN' ))  AND ( "SatisFiyati" > 0 )  ORDER BY "StokAdi" ASC LIMIT 100 offset 0
2025-10-04 13:49:36 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:49:36 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-10-04 13:49:36 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:49:39 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:49:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:49:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListesSiparis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:49:39 - SELECT *,sum("Borc" - "Alacak") OVER (PARTITION BY "CariKod" ORDER BY "Tarih","Saat","FaturaNumarasi", "ID" ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "Bakiye" FROM "CariHareketler"  WHERE (( "CariID" = 93 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-10-04 13:49:39 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 93 )) 
2025-10-04 13:49:43 - SELECT "FirmaID","SubeID","Marka","Tanim","IpAdres","SeriNo","PortNo","KasaId","SubeAdi","KasaAdi","ID","OlusturmaTarihi","Durum" FROM "PosTeraziTanim"  
2025-10-04 13:49:43 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari" ORDER BY "FirmaAdi" ASC 
2025-10-04 13:49:43 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmKasaPosTanimlari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:49:44 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE ( "FirmaID" = CAST(1 AS INT4))ORDER BY "SubeAdi" ASC 
2025-10-04 13:49:47 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = CAST(1 AS INT4))) 
2025-10-04 13:50:20 - INSERT INTO "PosTeraziTanim"  
           ("FirmaID","SubeID","Marka","Tanim","IpAdres","SeriNo","PortNo","KasaId","SubeAdi","KasaAdi","OlusturmaTarihi","Durum")
     VALUES
           (1,1,'HUGIN','kasa','192.168.1.251','FT40046096','4444',NULL,'MERKEZ','MERKEZ','4.10.2025 10:50:20',1) returning "ID"
2025-10-04 13:50:20 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('PosTeraziTanim','Ekle',1,'ORCA','4.10.2025 13:50:20','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:50:21 - SELECT "FirmaID","SubeID","Marka","Tanim","IpAdres","SeriNo","PortNo","KasaId","SubeAdi","KasaAdi","ID","OlusturmaTarihi","Durum" FROM "PosTeraziTanim"  
2025-10-04 13:50:22 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:22 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = '99.99.99.00099' )   LIMIT 1 offset 0
2025-10-04 13:50:22 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:50:22 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:50:22 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'POS' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:50:22 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 4, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 3) = 'POS'
                AND "FaturaNumarasi" SIMILAR TO 'POS[0-9]{9}%'
2025-10-04 13:50:22 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "BelgeTuru" = 'POS' ) AND ( "Tarih" = '4.10.2025 00:00:00' )) 
2025-10-04 13:50:22 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-04 13:50:22 - SELECT "Departman","Oran","Sira","FirmaID","ID","OlusturmaTarihi","Durum" FROM "KdvDepartman"  
2025-10-04 13:50:22 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmHizliSatis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:50:22 - SELECT "FirmaID","FirmalarOrtakGrup","GrupAdi","PostaGorunur","ID","OlusturmaTarihi","Durum" FROM "StokGruplari"  WHERE ( "PostaGorunur" = True )ORDER BY "GrupAdi" ASC 
2025-10-04 13:50:22 - SELECT "DocID","Dokuman" FROM "Dokumanlar"  WHERE (("DocID" IN (1)) AND( "Aciklama" = 'STOKGRUP' )) 
2025-10-04 13:50:24 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:24 - SELECT "FirmaID","SubeID","Marka","Tanim","IpAdres","SeriNo","PortNo","KasaId","SubeAdi","KasaAdi","ID","OlusturmaTarihi","Durum" FROM "PosTeraziTanim"  WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) 
2025-10-04 13:50:24 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:27 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:27 - INSERT INTO `PosAyarlar`  
           (`ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol`)
     VALUES
           (@ID,@ButonBoyutu,@TasarimBoyutu,@YaziciAdi,@YazarkasaModel,@Decimal0,@Cekmece,@ResimGoster,@CekmeceYol) ;
2025-10-04 13:50:27 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:27 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:50:27 - SELECT MAX("ID") FROM "Fatura"  WHERE ( "BelgeTuru" = 'POS' ) 
2025-10-04 13:50:28 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"   WHERE ( "ID" = 1 )   LIMIT 1 offset 0
2025-10-04 13:50:28 - SELECT "FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","ID","OlusturmaTarihi","Durum" FROM "FaturaHareketleri"  WHERE ( "BelgeID" = 1 ) 
2025-10-04 13:50:28 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmPosRaporFisDetay' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeFisler' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:50:40 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:40 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:50:40 - SELECT "FirmaID","SubeID","Marka","Tanim","IpAdres","SeriNo","PortNo","KasaId","SubeAdi","KasaAdi","ID","OlusturmaTarihi","Durum" FROM "PosTeraziTanim"  WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) 
2025-10-04 13:50:40 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:46 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:46 - UPDATE `PosAyarlar`  SET
           `ID`=@ID,`ButonBoyutu`=@ButonBoyutu,`TasarimBoyutu`=@TasarimBoyutu,`YaziciAdi`=@YaziciAdi,`YazarkasaModel`=@YazarkasaModel,`FisLimiti`=@Decimal0,`Cekmece`=@Cekmece,`ResimGoster`=@ResimGoster,`CekmeceYol`=@CekmeceYol  WHERE ( `ID` = @ID0 )
2025-10-04 13:50:46 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:49 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:50:49 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:50:49 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = '99.99.99.00099' )   LIMIT 1 offset 0
2025-10-04 13:50:49 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:50:49 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:50:49 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'POS' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:50:49 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 4, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 3) = 'POS'
                AND "FaturaNumarasi" SIMILAR TO 'POS[0-9]{9}%'
2025-10-04 13:50:49 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "BelgeTuru" = 'POS' ) AND ( "Tarih" = '4.10.2025 00:00:00' )) 
2025-10-04 13:50:50 - SELECT "FirmaID","SubeID","Marka","Tanim","IpAdres","SeriNo","PortNo","KasaId","SubeAdi","KasaAdi","ID","OlusturmaTarihi","Durum" FROM "PosTeraziTanim"   WHERE (((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "KasaAdi" = 'MERKEZ' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:50:50 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-04 13:50:50 - SELECT "Departman","Oran","Sira","FirmaID","ID","OlusturmaTarihi","Durum" FROM "KdvDepartman"  
2025-10-04 13:50:50 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmHizliSatis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:50:57 - SELECT "FirmaID","FirmalarOrtakGrup","GrupAdi","PostaGorunur","ID","OlusturmaTarihi","Durum" FROM "StokGruplari"  WHERE ( "PostaGorunur" = True )ORDER BY "GrupAdi" ASC 
2025-10-04 13:50:57 - SELECT "DocID","Dokuman" FROM "Dokumanlar"  WHERE (("DocID" IN (1)) AND( "Aciklama" = 'STOKGRUP' )) 
2025-10-04 13:50:58 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (((( "FirmaID" = 1 ) OR ( "FirmalarOrtakStok" = 1 )) AND ( "Durum" = 1 )) AND ( "StokGrubu" = 'VARSAYILAN' ))  AND ( "SatisFiyati" > 0 )  ORDER BY "StokAdi" ASC LIMIT 100 offset 0
2025-10-04 13:51:00 - SELECT "ST".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" "ST" Left JOIN "StokHareketleri" "SH" ON (( "ST"."ID" = "SH"."StokID" ) AND ( "SH"."FirmaID" = 1 ))  Left JOIN "Barkodlar" "B" ON ( "ST"."ID" = "B"."StokID" )   WHERE ((( "ST"."FirmaID" = 1 ) OR ( "ST"."FirmalarOrtakStok" = 1 )) AND ( "ST"."Durum" = 1 ))  AND ((( (LOWER("ST"."StokKodu"))  ilike concat('%','a','%')) OR ( (LOWER("ST"."StokAdi"))  ilike concat('%','a','%')) ) OR  ( (LOWER("B"."Barkod"))  ilike concat('%','a','%')) )GROUP BY "ST"."ID"  
2025-10-04 13:51:00 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmStokArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myGridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:51:10 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:51:10 - INSERT INTO "Fatura"  
           ("FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","OlusturmaTarihi","Durum")
     VALUES
           (1,1,1,1,1,'MERKEZ','MERKEZ',NULL,'99.99.99.00099','PEŞİN SATIŞ','1.01.1900 00:00:00','4.10.2025 00:00:00','13:51:05','POS000000002','TL',1,608,19693969396939693969396939,0,608,19693969396939693969396939,105,70306030603060306030603061,713,90,'POS',NULL,NULL,NULL,NULL,NULL,False,False,NULL,False,'49f959dd-8ac6-4d8a-8a62-0075c80a520a',0,NULL,'4.10.2025 10:50:49',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Fatura','Ekle',5,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "CariHareketler"  
           ("CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","OlusturmaTarihi","Durum")
     VALUES
           ('99.99.99.00099','PEŞİN SATIŞ','4.10.2025 00:00:00','13:51:05','POS000000002',713,90,0,NULL,'TL',1,'POS',NULL,1,1,1,1,5,0,'MERKEZ','MERKEZ',False,'4.10.2025 10:50:49',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('CariHareketler','Ekle',117,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',3,'7610196003544','COLGATE ZİGZAG FIRÇA TEKLİ','ADET','7610196003544',39,945454545454545454545454545,43,940000000000000000000000000,43,940000000000000000000000000,571,35217723453017570664629487,0,0,0,0,0,0,43,9400000000000000000000000000,43,9400000000000000000000000001,43,9400000000000000000000000002,43,9400000000000000000000000003,43,9400000000000000000000000004,43,9400000000000000000000000005,43,9400000000000000000000000006,43,9400000000000000000000000007,'TL',43,9400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',6,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',4,'8682013114015','N.BS LİMON SIKACAĞI','ADET','8682013114015',30,0,36,00,36,00,60,0,0,0,0,0,0,0,36,000,36,001,36,002,36,003,36,004,36,005,36,006,36,007,'TL',36,008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',7,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',6,'8690572408247','VİTAL OKSİDAN LOSYON %9','ADET','8690572408247',10,25,12,300,12,300,294,23076923076923076923076923,0,0,0,0,0,0,12,3000,12,3001,12,3002,12,3003,12,3004,12,3005,12,3006,12,3007,'TL',12,3008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',8,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',7,'8690572408230','VİTAL OKSİDAN LOSYON %6','ADET','8690572408230',10,25,12,300,12,300,46,428571428571428571428571430,0,0,0,0,0,0,12,3000,12,3001,12,3002,12,3003,12,3004,12,3005,12,3006,12,3007,'TL',12,3008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',9,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',8,'8690000120000','Ö.ÜÇEV OVAL MASA 70*120','ADET','8690000120000',395,0,474,00,474,00,49,281934996220710506424792140,0,0,0,0,0,0,474,000,474,001,474,002,474,003,474,004,474,005,474,006,474,007,'TL',474,008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',10,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',9,'8693495054645','HACI ŞAKİR LAVANTA 150GR','ADET','8693495054645',59,9,71,88,71,88,247,61918579345965238081420654,0,0,0,0,0,0,71,880,71,881,71,882,71,883,71,884,71,885,71,886,71,887,'TL',71,888,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',11,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',10,'8690576029257','NUHUN ANKARA MANTI 500 GR.','ADET','8690576029257',18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,39,199605179301673253435862980,0,0,0,0,0,0,19,1400000000000000000000000000,19,1400000000000000000000000001,19,1400000000000000000000000002,19,1400000000000000000000000003,19,1400000000000000000000000004,19,1400000000000000000000000005,19,1400000000000000000000000006,19,1400000000000000000000000007,'TL',19,1400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',12,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',11,'8690526028040','ETİ KARAM BİTTER %70 KAKAO 60G','ADET','8690526028040',24,95049504950495049504950495,25,200000000000000000000000000,25,200000000000000000000000000,36,776497108316890301667077540,0,0,0,0,0,0,25,2000000000000000000000000000,25,2000000000000000000000000001,25,2000000000000000000000000002,25,2000000000000000000000000003,25,2000000000000000000000000004,25,2000000000000000000000000005,25,2000000000000000000000000006,25,2000000000000000000000000007,'TL',25,2000000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',13,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,'4.10.2025 00:00:00','13:51:05',12,'8690576029813','NUHUN ANKARA TEL SEHRİYE 500 G','ADET','8690576029813',18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,39,199605179301673253435862980,0,0,0,0,0,0,19,1400000000000000000000000000,19,1400000000000000000000000001,19,1400000000000000000000000002,19,1400000000000000000000000003,19,1400000000000000000000000004,19,1400000000000000000000000005,19,1400000000000000000000000006,19,1400000000000000000000000007,'TL',19,1400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,5,1,'4.10.2025 10:51:04',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',14,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE ( "BelgeID" = 5 ) 
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,6,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',3,'PEŞİN SATIŞ','7610196003544','COLGATE ZİGZAG FIRÇA TEKLİ','ADET','7610196003544',39,945454545454545454545454545,43,940000000000000000000000000,1,0,10,3,994545454545454545454545455,39,945454545454545454545454545,43,940000000000000000000000000,43,940000000000000000000000000,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4827,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,7,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',4,'PEŞİN SATIŞ','8682013114015','N.BS LİMON SIKACAĞI','ADET','8682013114015',30,0,36,00,1,0,20,6,00,30,0,36,00,36,00,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4828,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,8,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',6,'PEŞİN SATIŞ','8690572408247','VİTAL OKSİDAN LOSYON %9','ADET','8690572408247',10,25,12,300,1,0,20,2,050,10,25,12,300,12,300,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4829,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,9,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',7,'PEŞİN SATIŞ','8690572408230','VİTAL OKSİDAN LOSYON %6','ADET','8690572408230',10,25,12,300,1,0,20,2,050,10,25,12,300,12,300,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4830,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,10,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',8,'PEŞİN SATIŞ','8690000120000','Ö.ÜÇEV OVAL MASA 70*120','ADET','8690000120000',395,0,474,00,1,0,20,79,00,395,0,474,00,474,00,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4831,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,11,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',9,'PEŞİN SATIŞ','8693495054645','HACI ŞAKİR LAVANTA 150GR','ADET','8693495054645',59,9,71,88,1,0,20,11,98,59,9,71,88,71,88,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4832,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,12,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',10,'PEŞİN SATIŞ','8690576029257','NUHUN ANKARA MANTI 500 GR.','ADET','8690576029257',18,95049504950495049504950495,19,140000000000000000000000000,1,0,1,0,189504950495049504950495050,18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4833,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,13,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',11,'PEŞİN SATIŞ','8690526028040','ETİ KARAM BİTTER %70 KAKAO 60G','ADET','8690526028040',24,95049504950495049504950495,25,200000000000000000000000000,1,0,1,0,249504950495049504950495050,24,95049504950495049504950495,25,200000000000000000000000000,25,200000000000000000000000000,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4834,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (5,1,1,1,1,1,14,'POS','POS000000002','4.10.2025 00:00:00','13:51:05',12,'PEŞİN SATIŞ','8690576029813','NUHUN ANKARA TEL SEHRİYE 500 G','ADET','8690576029813',18,95049504950495049504950495,19,140000000000000000000000000,1,0,1,0,189504950495049504950495050,18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,'TL',1,'','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4835,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "Odeme"  
           ("FirmaID","SubeID","CariID","KullaniciID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","GenelToplam","BelgeTuru","Islem","IptalSebebi","OdemeKod1","OdemeKod2","OdemeKod3","ProjeKodu","OlusturmaTarihi","Durum")
     VALUES
           (1,1,1,1,'MERKEZ','MERKEZ',NULL,'99.99.99.00099','PEŞİN SATIŞ','1.01.1900 00:00:00','4.10.2025 00:00:00','13:51:05','POS000000002','TL',1,713,90,'POS','POS TAHSİLAT',NULL,NULL,NULL,NULL,NULL,'4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Odeme','Ekle',113,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "CariHareketler"  
           ("CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","OlusturmaTarihi","Durum")
     VALUES
           ('99.99.99.00099','PEŞİN SATIŞ','4.10.2025 00:00:00','13:51:05','POS000000002',0,713,90,NULL,'TL',1,'POS','POS TAHSİLAT',1,1,1,1,5,0,'MERKEZ','MERKEZ',False,'4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('CariHareketler','Ekle',118,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "OdemeHareket"  
           ("FaturaNumarasi","FirmaID","SubeID","KullaniciID","CariID","OdemeID","BankaID","CekSenetID","BankaAdi","Tarih","Vade","Saat","Cikan","Giren","Aciklama","BelgeTuru","Islem","OdemeTuru","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000002',1,1,1,1,113,0,0,NULL,'4.10.2025 00:00:00','1.01.1900 00:00:00','13:51:05',0,713,90,NULL,'POS','POS TAHSİLAT','NAKİT','4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('OdemeHareket','Ekle',113,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - INSERT INTO "KasaHareketleri"  
           ("Tarih","Saat","CariKod","Sube","Kasa","Cikan","Giren","FaturaNo","Aciklama","IslemTuru","BelgeTuru","DovizBirimi","DovizKuru","CariAdi","FirmaID","CariID","BelgeID","HareketID","KullaniciID","OlusturmaTarihi","Durum")
     VALUES
           ('4.10.2025 00:00:00','13:51:05','99.99.99.00099','MERKEZ','MERKEZ',0,713,90,'POS000000002',NULL,'POS TAHSİLAT','POS','TL',1,'PEŞİN SATIŞ',1,1,5,113,1,'4.10.2025 10:51:10',1) returning "ID"
2025-10-04 13:51:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('KasaHareketleri','Ekle',2,'ORCA','4.10.2025 13:51:10','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:10 - UPDATE "Fatura"  SET
            "Yazdirildi" = True   WHERE ( "ID" = 5 )
2025-10-04 13:51:13 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = '99.99.99.00099' )   LIMIT 1 offset 0
2025-10-04 13:51:13 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:51:13 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:51:13 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'POS' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:51:13 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 4, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 3) = 'POS'
                AND "FaturaNumarasi" SIMILAR TO 'POS[0-9]{9}%'
2025-10-04 13:51:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "BelgeTuru" = 'POS' ) AND ( "Tarih" = '4.10.2025 00:00:00' )) 
2025-10-04 13:51:14 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:51:14 - SELECT "FirmaID","SubeID","Marka","Tanim","IpAdres","SeriNo","PortNo","KasaId","SubeAdi","KasaAdi","ID","OlusturmaTarihi","Durum" FROM "PosTeraziTanim"  WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) 
2025-10-04 13:51:14 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:51:16 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:51:16 - UPDATE `PosAyarlar`  SET
           `ID`=@ID,`ButonBoyutu`=@ButonBoyutu,`TasarimBoyutu`=@TasarimBoyutu,`YaziciAdi`=@YaziciAdi,`YazarkasaModel`=@YazarkasaModel,`FisLimiti`=@Decimal0,`Cekmece`=@Cekmece,`ResimGoster`=@ResimGoster,`CekmeceYol`=@CekmeceYol  WHERE ( `ID` = @ID0 )
2025-10-04 13:51:16 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 13:51:17 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:51:17 - SELECT "ST".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" "ST" Left JOIN "StokHareketleri" "SH" ON (( "ST"."ID" = "SH"."StokID" ) AND ( "SH"."FirmaID" = 1 ))  Left JOIN "Barkodlar" "B" ON ( "ST"."ID" = "B"."StokID" )   WHERE ((( "ST"."FirmaID" = 1 ) OR ( "ST"."FirmalarOrtakStok" = 1 )) AND ( "ST"."Durum" = 1 ))  AND ((( (LOWER("ST"."StokKodu"))  ilike concat('%','a','%')) OR ( (LOWER("ST"."StokAdi"))  ilike concat('%','a','%')) ) OR  ( (LOWER("B"."Barkod"))  ilike concat('%','a','%')) )GROUP BY "ST"."ID"  
2025-10-04 13:51:18 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmStokArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myGridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:51:34 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:51:34 - INSERT INTO "Fatura"  
           ("FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","OlusturmaTarihi","Durum")
     VALUES
           (1,1,1,1,1,'MERKEZ','MERKEZ',NULL,'99.99.99.00099','PEŞİN SATIŞ','1.01.1900 00:00:00','4.10.2025 00:00:00','13:51:28','POS000000003','TL',1,715,72080108010801080108010800,0,715,72080108010801080108010800,122,90929891989198919891989200,838,63,'POS',NULL,NULL,NULL,NULL,NULL,False,False,NULL,False,'bbe6997d-41e1-416e-af63-51865c940f03',0,NULL,'4.10.2025 10:51:13',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Fatura','Ekle',6,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "CariHareketler"  
           ("CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","OlusturmaTarihi","Durum")
     VALUES
           ('99.99.99.00099','PEŞİN SATIŞ','4.10.2025 00:00:00','13:51:28','POS000000003',838,63,0,NULL,'TL',1,'POS',NULL,1,1,1,1,6,0,'MERKEZ','MERKEZ',False,'4.10.2025 10:51:13',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('CariHareketler','Ekle',119,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',3,'7610196003544','COLGATE ZİGZAG FIRÇA TEKLİ','ADET','7610196003544',39,945454545454545454545454545,43,940000000000000000000000000,43,940000000000000000000000000,571,35217723453017570664629487,0,0,0,0,0,0,43,9400000000000000000000000000,43,9400000000000000000000000001,43,9400000000000000000000000002,43,9400000000000000000000000003,43,9400000000000000000000000004,43,9400000000000000000000000005,43,9400000000000000000000000006,43,9400000000000000000000000007,'TL',43,9400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:20',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',15,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',4,'8682013114015','N.BS LİMON SIKACAĞI','ADET','8682013114015',30,0,36,00,36,00,60,0,0,0,0,0,0,0,36,000,36,001,36,002,36,003,36,004,36,005,36,006,36,007,'TL',36,008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:20',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',16,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',6,'8690572408247','VİTAL OKSİDAN LOSYON %9','ADET','8690572408247',10,25,12,300,12,300,294,23076923076923076923076923,0,0,0,0,0,0,12,3000,12,3001,12,3002,12,3003,12,3004,12,3005,12,3006,12,3007,'TL',12,3008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:20',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',17,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',7,'8690572408230','VİTAL OKSİDAN LOSYON %6','ADET','8690572408230',10,25,12,300,12,300,46,428571428571428571428571430,0,0,0,0,0,0,12,3000,12,3001,12,3002,12,3003,12,3004,12,3005,12,3006,12,3007,'TL',12,3008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:20',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',18,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',8,'8690000120000','Ö.ÜÇEV OVAL MASA 70*120','ADET','8690000120000',395,0,474,00,474,00,49,281934996220710506424792140,0,0,0,0,0,0,474,000,474,001,474,002,474,003,474,004,474,005,474,006,474,007,'TL',474,008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:20',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',19,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',9,'8693495054645','HACI ŞAKİR LAVANTA 150GR','ADET','8693495054645',59,9,71,88,71,88,247,61918579345965238081420654,0,0,0,0,0,0,71,880,71,881,71,882,71,883,71,884,71,885,71,886,71,887,'TL',71,888,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:21',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',20,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',10,'8690576029257','NUHUN ANKARA MANTI 500 GR.','ADET','8690576029257',18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,39,199605179301673253435862980,0,0,0,0,0,0,19,1400000000000000000000000000,19,1400000000000000000000000001,19,1400000000000000000000000002,19,1400000000000000000000000003,19,1400000000000000000000000004,19,1400000000000000000000000005,19,1400000000000000000000000006,19,1400000000000000000000000007,'TL',19,1400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:21',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',21,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',11,'8690526028040','ETİ KARAM BİTTER %70 KAKAO 60G','ADET','8690526028040',24,95049504950495049504950495,25,200000000000000000000000000,25,200000000000000000000000000,36,776497108316890301667077540,0,0,0,0,0,0,25,2000000000000000000000000000,25,2000000000000000000000000001,25,2000000000000000000000000002,25,2000000000000000000000000003,25,2000000000000000000000000004,25,2000000000000000000000000005,25,2000000000000000000000000006,25,2000000000000000000000000007,'TL',25,2000000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:21',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',22,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',12,'8690576029813','NUHUN ANKARA TEL SEHRİYE 500 G','ADET','8690576029813',18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,39,199605179301673253435862980,0,0,0,0,0,0,19,1400000000000000000000000000,19,1400000000000000000000000001,19,1400000000000000000000000002,19,1400000000000000000000000003,19,1400000000000000000000000004,19,1400000000000000000000000005,19,1400000000000000000000000006,19,1400000000000000000000000007,'TL',19,1400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:21',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',23,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',13,'8685703461727','Ö.BİMODA HOSPİTAL BLOCK','ADET','8685703461727',70,0,84,00,84,00,54,935812306330234617087206730,0,0,0,0,0,0,84,000,84,001,84,002,84,003,84,004,84,005,84,006,84,007,'TL',84,008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:21',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',24,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',14,'4100000001277','D.MUM TENEKE KAP İÇİ','ADET','4100000001277',14,9,17,88,17,88,148,33333333333333333333333333,0,0,0,0,0,0,17,880,17,881,17,882,17,883,17,884,17,885,17,886,17,887,'TL',17,888,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:21',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',25,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,'4.10.2025 00:00:00','13:51:28',17,'86907538','KNORR BULYON TAV SUYU 2X10GR','ADET','86907538',6,9504950495049504950495049505,7,0200000000000000000000000000,7,0200000000000000000000000000,49,621024013108677294732530040,0,0,0,0,0,0,7,02000000000000000000000000000,7,02000000000000000000000000001,7,02000000000000000000000000002,7,02000000000000000000000000003,7,02000000000000000000000000004,7,02000000000000000000000000005,7,02000000000000000000000000006,7,02000000000000000000000000007,'TL',7,02000000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,6,1,'4.10.2025 10:51:21',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',26,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE ( "BelgeID" = 6 ) 
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,15,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',3,'PEŞİN SATIŞ','7610196003544','COLGATE ZİGZAG FIRÇA TEKLİ','ADET','7610196003544',39,945454545454545454545454545,43,940000000000000000000000000,1,0,10,3,994545454545454545454545455,39,945454545454545454545454545,43,940000000000000000000000000,43,940000000000000000000000000,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4836,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,16,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',4,'PEŞİN SATIŞ','8682013114015','N.BS LİMON SIKACAĞI','ADET','8682013114015',30,0,36,00,1,0,20,6,00,30,0,36,00,36,00,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4837,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,17,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',6,'PEŞİN SATIŞ','8690572408247','VİTAL OKSİDAN LOSYON %9','ADET','8690572408247',10,25,12,300,1,0,20,2,050,10,25,12,300,12,300,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4838,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,18,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',7,'PEŞİN SATIŞ','8690572408230','VİTAL OKSİDAN LOSYON %6','ADET','8690572408230',10,25,12,300,1,0,20,2,050,10,25,12,300,12,300,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4839,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,19,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',8,'PEŞİN SATIŞ','8690000120000','Ö.ÜÇEV OVAL MASA 70*120','ADET','8690000120000',395,0,474,00,1,0,20,79,00,395,0,474,00,474,00,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4840,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,20,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',9,'PEŞİN SATIŞ','8693495054645','HACI ŞAKİR LAVANTA 150GR','ADET','8693495054645',59,9,71,88,1,0,20,11,98,59,9,71,88,71,88,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4841,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,21,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',10,'PEŞİN SATIŞ','8690576029257','NUHUN ANKARA MANTI 500 GR.','ADET','8690576029257',18,95049504950495049504950495,19,140000000000000000000000000,1,0,1,0,189504950495049504950495050,18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4842,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,22,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',11,'PEŞİN SATIŞ','8690526028040','ETİ KARAM BİTTER %70 KAKAO 60G','ADET','8690526028040',24,95049504950495049504950495,25,200000000000000000000000000,1,0,1,0,249504950495049504950495050,24,95049504950495049504950495,25,200000000000000000000000000,25,200000000000000000000000000,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4843,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,23,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',12,'PEŞİN SATIŞ','8690576029813','NUHUN ANKARA TEL SEHRİYE 500 G','ADET','8690576029813',18,95049504950495049504950495,19,140000000000000000000000000,1,0,1,0,189504950495049504950495050,18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4844,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,24,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',13,'PEŞİN SATIŞ','8685703461727','Ö.BİMODA HOSPİTAL BLOCK','ADET','8685703461727',70,0,84,00,1,0,20,14,00,70,0,84,00,84,00,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4845,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,25,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',14,'PEŞİN SATIŞ','4100000001277','D.MUM TENEKE KAP İÇİ','ADET','4100000001277',14,9,17,88,1,0,20,2,98,14,9,17,88,17,88,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4846,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,1,26,'POS','POS000000003','4.10.2025 00:00:00','13:51:28',17,'PEŞİN SATIŞ','86907538','KNORR BULYON TAV SUYU 2X10GR','ADET','86907538',6,9504950495049504950495049505,7,0200000000000000000000000000,3,255,0,1,0,226238613861386138613861386,22,623861386138613861386138614,22,850100000000000000000000000,7,0200000000000000000000000000,'TL',1,'','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4847,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "Odeme"  
           ("FirmaID","SubeID","CariID","KullaniciID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","GenelToplam","BelgeTuru","Islem","IptalSebebi","OdemeKod1","OdemeKod2","OdemeKod3","ProjeKodu","OlusturmaTarihi","Durum")
     VALUES
           (1,1,1,1,'MERKEZ','MERKEZ',NULL,'99.99.99.00099','PEŞİN SATIŞ','1.01.1900 00:00:00','4.10.2025 00:00:00','13:51:28','POS000000003','TL',1,838,63,'POS','POS TAHSİLAT',NULL,NULL,NULL,NULL,NULL,'4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Odeme','Ekle',114,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "CariHareketler"  
           ("CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","OlusturmaTarihi","Durum")
     VALUES
           ('99.99.99.00099','PEŞİN SATIŞ','4.10.2025 00:00:00','13:51:28','POS000000003',0,838,63,NULL,'TL',1,'POS','POS TAHSİLAT',1,1,1,1,6,0,'MERKEZ','MERKEZ',False,'4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('CariHareketler','Ekle',120,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "OdemeHareket"  
           ("FaturaNumarasi","FirmaID","SubeID","KullaniciID","CariID","OdemeID","BankaID","CekSenetID","BankaAdi","Tarih","Vade","Saat","Cikan","Giren","Aciklama","BelgeTuru","Islem","OdemeTuru","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000003',1,1,1,1,114,0,0,NULL,'4.10.2025 00:00:00','1.01.1900 00:00:00','13:51:28',0,838,63,NULL,'POS','POS TAHSİLAT','NAKİT','4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('OdemeHareket','Ekle',114,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - INSERT INTO "KasaHareketleri"  
           ("Tarih","Saat","CariKod","Sube","Kasa","Cikan","Giren","FaturaNo","Aciklama","IslemTuru","BelgeTuru","DovizBirimi","DovizKuru","CariAdi","FirmaID","CariID","BelgeID","HareketID","KullaniciID","OlusturmaTarihi","Durum")
     VALUES
           ('4.10.2025 00:00:00','13:51:28','99.99.99.00099','MERKEZ','MERKEZ',0,838,63,'POS000000003',NULL,'POS TAHSİLAT','POS','TL',1,'PEŞİN SATIŞ',1,1,6,114,1,'4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:51:34 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('KasaHareketleri','Ekle',3,'ORCA','4.10.2025 13:51:34','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:51:34 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = '99.99.99.00099' )   LIMIT 1 offset 0
2025-10-04 13:51:34 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:51:34 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:51:34 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'POS' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:51:34 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 4, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 3) = 'POS'
                AND "FaturaNumarasi" SIMILAR TO 'POS[0-9]{9}%'
2025-10-04 13:51:34 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "BelgeTuru" = 'POS' ) AND ( "Tarih" = '4.10.2025 00:00:00' )) 
2025-10-04 13:51:45 - SELECT "ST".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" "ST" Left JOIN "StokHareketleri" "SH" ON (( "ST"."ID" = "SH"."StokID" ) AND ( "SH"."FirmaID" = 1 ))  Left JOIN "Barkodlar" "B" ON ( "ST"."ID" = "B"."StokID" )   WHERE ((( "ST"."FirmaID" = 1 ) OR ( "ST"."FirmalarOrtakStok" = 1 )) AND ( "ST"."Durum" = 1 ))  AND ((( (LOWER("ST"."StokKodu"))  ilike concat('%','a','%')) OR ( (LOWER("ST"."StokAdi"))  ilike concat('%','a','%')) ) OR  ( (LOWER("B"."Barkod"))  ilike concat('%','a','%')) )GROUP BY "ST"."ID"  
2025-10-04 13:51:45 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmStokArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myGridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:52:05 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:52:05 - INSERT INTO "Fatura"  
           ("FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","OlusturmaTarihi","Durum")
     VALUES
           (1,1,1,1,1,'MERKEZ','MERKEZ',NULL,'99.99.99.00099','PEŞİN SATIŞ','1.01.1900 00:00:00','4.10.2025 00:00:00','13:51:58','POS000000004','TL',1,608,19693969396939693969396939,13,90,594,29693969396939693969396939,105,70306030603060306030603061,700,00,'POS',NULL,NULL,NULL,NULL,NULL,False,False,NULL,False,'e9a1b3ab-7f36-4ff6-a95c-e308cda49374',0,NULL,'4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Fatura','Ekle',7,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "CariHareketler"  
           ("CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","OlusturmaTarihi","Durum")
     VALUES
           ('99.99.99.00099','PEŞİN SATIŞ','4.10.2025 00:00:00','13:51:58','POS000000004',700,00,0,NULL,'TL',1,'POS',NULL,1,1,1,1,7,0,'MERKEZ','MERKEZ',False,'4.10.2025 10:51:34',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('CariHareketler','Ekle',121,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',3,'7610196003544','COLGATE ZİGZAG FIRÇA TEKLİ','ADET','7610196003544',39,945454545454545454545454545,43,940000000000000000000000000,43,940000000000000000000000000,571,35217723453017570664629487,0,0,0,0,0,0,43,9400000000000000000000000000,43,9400000000000000000000000001,43,9400000000000000000000000002,43,9400000000000000000000000003,43,9400000000000000000000000004,43,9400000000000000000000000005,43,9400000000000000000000000006,43,9400000000000000000000000007,'TL',43,9400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',27,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',4,'8682013114015','N.BS LİMON SIKACAĞI','ADET','8682013114015',30,0,36,00,36,00,60,0,0,0,0,0,0,0,36,000,36,001,36,002,36,003,36,004,36,005,36,006,36,007,'TL',36,008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',28,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',6,'8690572408247','VİTAL OKSİDAN LOSYON %9','ADET','8690572408247',10,25,12,300,12,300,294,23076923076923076923076923,0,0,0,0,0,0,12,3000,12,3001,12,3002,12,3003,12,3004,12,3005,12,3006,12,3007,'TL',12,3008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',29,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',7,'8690572408230','VİTAL OKSİDAN LOSYON %6','ADET','8690572408230',10,25,12,300,12,300,46,428571428571428571428571430,0,0,0,0,0,0,12,3000,12,3001,12,3002,12,3003,12,3004,12,3005,12,3006,12,3007,'TL',12,3008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',30,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',8,'8690000120000','Ö.ÜÇEV OVAL MASA 70*120','ADET','8690000120000',395,0,474,00,474,00,49,281934996220710506424792140,0,0,0,0,0,0,474,000,474,001,474,002,474,003,474,004,474,005,474,006,474,007,'TL',474,008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',31,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',9,'8693495054645','HACI ŞAKİR LAVANTA 150GR','ADET','8693495054645',59,9,71,88,71,88,247,61918579345965238081420654,0,0,0,0,0,0,71,880,71,881,71,882,71,883,71,884,71,885,71,886,71,887,'TL',71,888,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',32,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',10,'8690576029257','NUHUN ANKARA MANTI 500 GR.','ADET','8690576029257',18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,39,199605179301673253435862980,0,0,0,0,0,0,19,1400000000000000000000000000,19,1400000000000000000000000001,19,1400000000000000000000000002,19,1400000000000000000000000003,19,1400000000000000000000000004,19,1400000000000000000000000005,19,1400000000000000000000000006,19,1400000000000000000000000007,'TL',19,1400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',33,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',11,'8690526028040','ETİ KARAM BİTTER %70 KAKAO 60G','ADET','8690526028040',24,95049504950495049504950495,25,200000000000000000000000000,25,200000000000000000000000000,36,776497108316890301667077540,0,0,0,0,0,0,25,2000000000000000000000000000,25,2000000000000000000000000001,25,2000000000000000000000000002,25,2000000000000000000000000003,25,2000000000000000000000000004,25,2000000000000000000000000005,25,2000000000000000000000000006,25,2000000000000000000000000007,'TL',25,2000000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',34,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,'4.10.2025 00:00:00','13:51:58',12,'8690576029813','NUHUN ANKARA TEL SEHRİYE 500 G','ADET','8690576029813',18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,39,199605179301673253435862980,0,0,0,0,0,0,19,1400000000000000000000000000,19,1400000000000000000000000001,19,1400000000000000000000000002,19,1400000000000000000000000003,19,1400000000000000000000000004,19,1400000000000000000000000005,19,1400000000000000000000000006,19,1400000000000000000000000007,'TL',19,1400000000000000000000000008,'SATIS','1.01.1900 00:00:00','','99.99.99.00099','PEŞİN SATIŞ','POS',1,7,1,'4.10.2025 10:51:47',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',35,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE ( "BelgeID" = 7 ) 
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,27,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',3,'PEŞİN SATIŞ','7610196003544','COLGATE ZİGZAG FIRÇA TEKLİ','ADET','7610196003544',39,945454545454545454545454545,43,940000000000000000000000000,1,0,10,3,994545454545454545454545455,39,945454545454545454545454545,43,940000000000000000000000000,43,940000000000000000000000000,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4848,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,28,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',4,'PEŞİN SATIŞ','8682013114015','N.BS LİMON SIKACAĞI','ADET','8682013114015',30,0,36,00,1,0,20,6,00,30,0,36,00,36,00,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4849,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,29,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',6,'PEŞİN SATIŞ','8690572408247','VİTAL OKSİDAN LOSYON %9','ADET','8690572408247',10,25,12,300,1,0,20,2,050,10,25,12,300,12,300,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4850,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,30,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',7,'PEŞİN SATIŞ','8690572408230','VİTAL OKSİDAN LOSYON %6','ADET','8690572408230',10,25,12,300,1,0,20,2,050,10,25,12,300,12,300,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4851,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,31,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',8,'PEŞİN SATIŞ','8690000120000','Ö.ÜÇEV OVAL MASA 70*120','ADET','8690000120000',395,0,474,00,1,0,20,79,00,395,0,474,00,474,00,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4852,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,32,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',9,'PEŞİN SATIŞ','8693495054645','HACI ŞAKİR LAVANTA 150GR','ADET','8693495054645',59,9,71,88,1,0,20,11,98,59,9,71,88,71,88,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4853,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,33,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',10,'PEŞİN SATIŞ','8690576029257','NUHUN ANKARA MANTI 500 GR.','ADET','8690576029257',18,95049504950495049504950495,19,140000000000000000000000000,1,0,1,0,189504950495049504950495050,18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4854,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,34,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',11,'PEŞİN SATIŞ','8690526028040','ETİ KARAM BİTTER %70 KAKAO 60G','ADET','8690526028040',24,95049504950495049504950495,25,200000000000000000000000000,1,0,1,0,249504950495049504950495050,24,95049504950495049504950495,25,200000000000000000000000000,25,200000000000000000000000000,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4855,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (7,1,1,1,1,1,35,'POS','POS000000004','4.10.2025 00:00:00','13:51:58',12,'PEŞİN SATIŞ','8690576029813','NUHUN ANKARA TEL SEHRİYE 500 G','ADET','8690576029813',18,95049504950495049504950495,19,140000000000000000000000000,1,0,1,0,189504950495049504950495050,18,95049504950495049504950495,19,140000000000000000000000000,19,140000000000000000000000000,'TL',1,'','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',4856,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "Odeme"  
           ("FirmaID","SubeID","CariID","KullaniciID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","GenelToplam","BelgeTuru","Islem","IptalSebebi","OdemeKod1","OdemeKod2","OdemeKod3","ProjeKodu","OlusturmaTarihi","Durum")
     VALUES
           (1,1,1,1,'MERKEZ','MERKEZ',NULL,'99.99.99.00099','PEŞİN SATIŞ','1.01.1900 00:00:00','4.10.2025 00:00:00','13:51:58','POS000000004','TL',1,700,00,'POS','POS TAHSİLAT',NULL,NULL,NULL,NULL,NULL,'4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Odeme','Ekle',115,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "CariHareketler"  
           ("CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","OlusturmaTarihi","Durum")
     VALUES
           ('99.99.99.00099','PEŞİN SATIŞ','4.10.2025 00:00:00','13:51:58','POS000000004',0,700,00,NULL,'TL',1,'POS','POS TAHSİLAT',1,1,1,1,7,0,'MERKEZ','MERKEZ',False,'4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('CariHareketler','Ekle',122,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "OdemeHareket"  
           ("FaturaNumarasi","FirmaID","SubeID","KullaniciID","CariID","OdemeID","BankaID","CekSenetID","BankaAdi","Tarih","Vade","Saat","Cikan","Giren","Aciklama","BelgeTuru","Islem","OdemeTuru","OlusturmaTarihi","Durum")
     VALUES
           ('POS000000004',1,1,1,1,115,0,0,NULL,'4.10.2025 00:00:00','1.01.1900 00:00:00','13:51:58',0,700,00,NULL,'POS','POS TAHSİLAT','NAKİT','4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('OdemeHareket','Ekle',115,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - INSERT INTO "KasaHareketleri"  
           ("Tarih","Saat","CariKod","Sube","Kasa","Cikan","Giren","FaturaNo","Aciklama","IslemTuru","BelgeTuru","DovizBirimi","DovizKuru","CariAdi","FirmaID","CariID","BelgeID","HareketID","KullaniciID","OlusturmaTarihi","Durum")
     VALUES
           ('4.10.2025 00:00:00','13:51:58','99.99.99.00099','MERKEZ','MERKEZ',0,700,00,'POS000000004',NULL,'POS TAHSİLAT','POS','TL',1,'PEŞİN SATIŞ',1,1,7,115,1,'4.10.2025 10:52:05',1) returning "ID"
2025-10-04 13:52:05 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('KasaHareketleri','Ekle',4,'ORCA','4.10.2025 13:52:05','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-04 13:52:05 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = '99.99.99.00099' )   LIMIT 1 offset 0
2025-10-04 13:52:05 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:52:05 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:52:05 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'POS' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-04 13:52:05 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 4, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 3) = 'POS'
                AND "FaturaNumarasi" SIMILAR TO 'POS[0-9]{9}%'
2025-10-04 13:52:05 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "BelgeTuru" = 'POS' ) AND ( "Tarih" = '4.10.2025 00:00:00' )) 
2025-10-04 13:52:28 - SELECT "Departman","Oran","Sira","FirmaID","ID","OlusturmaTarihi","Durum" FROM "KdvDepartman"  
2025-10-04 13:52:28 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-04 13:52:28 - SELECT distinct "TeraziGrubu" FROM "StokKartlari"  WHERE ((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND NOT( "TeraziGrubu" IS NULL   OR "TeraziGrubu"='')) 
2025-10-04 13:52:28 - SELECT distinct "Mensei" FROM "StokKartlari"  WHERE ((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND NOT( "Mensei" IS NULL   OR "Mensei"='')) 
2025-10-04 13:52:30 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (( "StokKodu" = (LOWER('')) ) OR ( "StokKodu" = (UPPER('')) ))   LIMIT 1 offset 0
2025-10-04 13:52:30 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (( "StokKodu" = (LOWER('')) ) OR ( "StokKodu" = (UPPER('')) ))   LIMIT 1 offset 0
2025-10-04 13:52:32 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:52:32 - SELECT "Departman","Oran","Sira","FirmaID","ID","OlusturmaTarihi","Durum" FROM "KdvDepartman"  
2025-10-04 13:52:32 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-04 13:52:32 - SELECT distinct "TeraziGrubu" FROM "StokKartlari"  WHERE ((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND NOT( "TeraziGrubu" IS NULL   OR "TeraziGrubu"='')) 
2025-10-04 13:52:32 - SELECT distinct "Mensei" FROM "StokKartlari"  WHERE ((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND NOT( "Mensei" IS NULL   OR "Mensei"='')) 
2025-10-04 13:52:33 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (( "StokKodu" = (LOWER('')) ) OR ( "StokKodu" = (UPPER('')) ))   LIMIT 1 offset 0
2025-10-04 13:52:33 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim3","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE (( "StokKodu" = (LOWER('')) ) OR ( "StokKodu" = (UPPER('')) ))   LIMIT 1 offset 0
2025-10-04 13:52:37 - SELECT "FirmaID","FirmalarOrtakGrup","GrupAdi","PostaGorunur","ID","OlusturmaTarihi","Durum" FROM "StokGruplari" ORDER BY "GrupAdi" ASC 
2025-10-04 13:52:37 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmStokGruplari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:52:44 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:52:44 - SELECT "BirimAdi","UBL","ID","OlusturmaTarihi","Durum" FROM "BirimTanimlari" ORDER BY "BirimAdi" ASC 
2025-10-04 13:52:44 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmBirimTanim' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 13:52:54 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:52:54 - SELECT *,sum("Borc" - "Alacak") OVER (PARTITION BY "CariKod" ORDER BY "Tarih","Saat","FaturaNumarasi", "ID" ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "Bakiye" FROM "CariHareketler"  WHERE (( "CariID" = 93 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-10-04 13:52:54 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 93 )) 
2025-10-04 13:52:55 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:52:55 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:52:55 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('4.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('4.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:52:55 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 13:52:55 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:52:55 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 13:52:55' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 13:52:55 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('4.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('4.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 13:52:55 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-04 14:39:39 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 14:39:39 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 14:39:39 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 14:39:39 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-04 14:39:39 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 14:39:39 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 14:39:39 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-04 14:39:40 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-04 14:39:40 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-04 14:39:40 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-04 14:39:40 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 14:39:40 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-04 14:39:40 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 14:39:40 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-04 14:39:44 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-04 14:39:45 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-04 14:39:45 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-04 14:39:46 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='Rx6mbdYBJ8Gb/3I1nd/LWXVFPgVTf1heUh+CX9il0Ok=',"Details"='',"ExDetails"='np+8EjyDNtjEyTBNkIgaEw==',"Max"=1,"OlusturmaTarihi"='23.09.2025 15:03:23',"Durum"=1  WHERE "ID"=1
2025-10-04 14:39:46 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',1,'ORCA','4.10.2025 14:39:46','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"Rx6mbdYBJ8Gb/3I1nd/LWXVFPgVTf1heUh+CX9il0Ok=","Details":"","ExDetails":"np+8EjyDNtjEyTBNkIgaEw==","Max":1,"_sonTarih":"2025-10-04T00:00:00","ID":1,"OlusturmaTarihi":"2025-09-23T15:03:23.888654","Durum":1}') ;
2025-10-04 14:39:46 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 1 )
2025-10-04 14:39:47 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 14:39:47 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 14:39:47 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 14:39:47 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 14:39:47 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:47' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 14:39:47 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:47' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 14:39:47 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:47' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 14:39:47 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:47' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 14:39:47 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('4.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('4.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 14:39:47 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-04 14:39:48 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 14:39:48 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-04 14:39:48 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 14:39:48 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 14:39:48 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:48' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-04 14:39:48 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:48' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-04 14:39:48 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:48' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 14:39:48 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('4.10.2025 14:39:48' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-04 14:39:48 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('4.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('4.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-04 14:39:48 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-04 14:39:48 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 14:39:48 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 14:39:48 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 14:39:48 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 14:39:48 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-04 14:39:48 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
