-- Dumping structure for table abbad_defaultcompany.dbo_stkfis CREATE TABLE IF NOT EXISTS `dbo_stkfis` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `STKFISTIPI` tinyint(10) DEFAULT NULL COMMENT 'Fiş Tipi', `STKFISHARTIPI` tinyint(3) DEFAULT NULL COMMENT 'Fiş Hareket Tipi', `STKFISCALFLAG` char(1) DEFAULT NULL COMMENT 'Aktif / Pasif', `STKFISSTAFLAG` char(1) DEFAULT NULL COMMENT 'State Flag', `STKFISSTAACKL` varchar(80) DEFAULT NULL COMMENT 'İptal / Kapanış Açıklama', `STKFISKAYNAK` tinyint(3) DEFAULT NULL COMMENT 'Kaynak Program', `STKFISKAYNAKHY` tinyint(3) DEFAULT NULL COMMENT 'Kaynak Hiyerarşi', `STKFISREFNO` int(10) DEFAULT NULL COMMENT 'Referans No', `STKFISKARREFNO` int(10) DEFAULT NULL COMMENT 'Karşı Referans No', `STKFISIDNO` tinyint(3) DEFAULT NULL COMMENT 'Fiş Id No', `STKFISKAYTAR` date DEFAULT NULL COMMENT 'Fiş Kayıt Tarihi', `STKFISHICTAR` date DEFAULT NULL COMMENT 'Hicri Tarih', `STKFISTALTAR` date DEFAULT NULL COMMENT 'Talep Tarihi', `STKFISURTTAR` date DEFAULT NULL COMMENT 'Üretim Tarihi', `STKFISSAAT` time DEFAULT NULL COMMENT 'Fiş Saati', `STKFISSURE` tinyint(3) DEFAULT NULL COMMENT 'Süre', `STKFISSUREACKL` varchar(10) DEFAULT NULL COMMENT 'Süre Açıklama', `STKFISTESTAR` date DEFAULT NULL COMMENT 'Teslim Tarihi', `STKFISNO` varchar(40) DEFAULT NULL COMMENT 'Fiş No', `STKFISEVRAKNO1` varchar(40) DEFAULT NULL COMMENT 'Evrak No 1', `STKFISEVRAKNO2` varchar(40) DEFAULT NULL COMMENT 'Evrak No 2', `STKFISEVRAKNO3` varchar(40) DEFAULT NULL COMMENT 'Evrak No 3', `STKFISCARKOD` varchar(40) DEFAULT NULL COMMENT 'Cari Kod', `STKFISADRESITEM` tinyint(3) DEFAULT NULL COMMENT 'Adres Tip', `STKFISANADEPO` varchar(40) DEFAULT NULL COMMENT 'Ana Depo', `STKFISKARDEPO` varchar(40) DEFAULT NULL COMMENT 'Karşı Depo', `STKFISOZKOD1` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 1', `STKFISOZKOD2` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 2', `STKFISOZKOD3` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 3', `STKFISOZKOD4` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 4', `STKFISOZKOD5` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 5', `STKFISACIKLAMA1` varchar(80) DEFAULT NULL COMMENT 'Açıklama 1', `STKFISACIKLAMA2` varchar(80) DEFAULT NULL COMMENT 'Açıklama 2', `STKFISACIKLAMA3` varchar(80) DEFAULT NULL COMMENT 'Açıklama 3', `STKFISPROJE` varchar(80) DEFAULT NULL COMMENT 'Proje Kod', `STKFISISYERI` varchar(40) DEFAULT NULL COMMENT 'İş Yeri', `STKFISPARTIKOD` varchar(40) DEFAULT NULL COMMENT 'Parti Kodu', `STKFISMASMER` varchar(40) DEFAULT NULL COMMENT 'Masraf Merkezi', `STKFISODEMEACKL` varchar(80) DEFAULT NULL COMMENT 'Ödeme Açıklama', `STKFISODEMEACKL2` varchar(80) DEFAULT NULL COMMENT 'Ödeme Açıklama 2', `STKFISNAKLIYE` varchar(80) DEFAULT NULL COMMENT 'Nakliye', `STKFISOPSIYON` varchar(80) DEFAULT NULL COMMENT 'Opsiyon', `STKFISNOTLAR` varchar(80) DEFAULT NULL COMMENT 'Notlar', `STKFISMASRAF1ACKL` varchar(80) DEFAULT NULL COMMENT 'Masraf 1 Açıklama', `STKFISMASRAF2ACKL` varchar(80) DEFAULT NULL COMMENT 'Masraf 2 Açıklama', `STKFISTUTAR` decimal(17,5) DEFAULT NULL COMMENT 'Tutar', `STKFISISK4ORAN` decimal(17,5) DEFAULT NULL COMMENT 'İsk. 4 %', `STKFISISK4TUTAR` decimal(17,5) DEFAULT NULL COMMENT 'İsk. 4 Tutar', `STKFISISKTOPTUTAR` decimal(17,5) DEFAULT NULL COMMENT 'Toplam İsk. Tutar', `STKFISMASRAF1` decimal(17,5) DEFAULT NULL COMMENT 'Masraf 1', `STKFISMASRAF2` decimal(17,5) DEFAULT NULL COMMENT 'Masraf 2', `STKFISARATOP` decimal(17,5) DEFAULT NULL COMMENT 'Ara Toplam', `STKFISKDVORAN` decimal(17,5) DEFAULT NULL COMMENT 'Kdv %', `STKFISKDVTUTAR` decimal(17,5) DEFAULT NULL COMMENT 'Kdv Tutar', `STKFISGENTOP` decimal(17,5) DEFAULT NULL COMMENT 'Genel Toplam', `STKFISPARABIRIM` varchar(10) DEFAULT NULL COMMENT 'Para Birimi', `STKFISDOVTAR` date DEFAULT NULL COMMENT 'Döviz Tarihi', `STKFISDOVKOD` varchar(10) DEFAULT NULL COMMENT 'Döviz Kodu', `STKFISDOVTUR` varchar(10) DEFAULT NULL COMMENT 'Döviz Piyasası', `STKFISDOVKUR` decimal(7,5) DEFAULT NULL COMMENT 'Döviz Kuru', `STKFISDOVTOP` decimal(17,5) DEFAULT NULL COMMENT 'Döviz Tutar', `STKFISHAZKOD` varchar(40) DEFAULT NULL COMMENT 'Hazırlayan', `STKFISHAZTAR` date DEFAULT NULL COMMENT 'Hazırlanma Tarihi', `STKFISHAZACKL` varchar(80) DEFAULT NULL COMMENT 'Hazırlayan Açıklama', `STKFISKONTFLAG` char(1) DEFAULT NULL COMMENT 'Kontrol Edildi', `STKFISKONTKOD` varchar(40) DEFAULT NULL COMMENT 'Kontrol Eden', `STKFISKONTTAR` date DEFAULT NULL COMMENT 'Kontrol Tarihi', `STKFISKONTACKL` varchar(80) DEFAULT NULL COMMENT 'Kontrol Eden Açıklama', `STKFISONAYFLAG` char(1) DEFAULT NULL COMMENT 'Onaylandı', `STKFISONAYKOD` varchar(40) DEFAULT NULL COMMENT 'Onaylayan', `STKFISONAYTAR` date DEFAULT NULL COMMENT 'Onay Tarihi', `STKFISONAYACKL` varchar(80) DEFAULT NULL COMMENT 'Onaylayan Açıklama', `STKFISTESEDEN` varchar(40) DEFAULT NULL COMMENT 'Teslim Eden', `STKFISTESALAN` varchar(40) DEFAULT NULL COMMENT 'Teslim Alan', `STKFISYAZDIR` char(1) DEFAULT NULL COMMENT 'Yazdırıldı', `STKFISEMAIL` char(1) DEFAULT NULL COMMENT 'Email Gönderildi', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin5 ROW_FORMAT=FIXED; -- Dumping data for table abbad_defaultcompany.dbo_stkfis: ~7 rows (approximately) /*!40000 ALTER TABLE `dbo_stkfis` DISABLE KEYS */; INSERT INTO `dbo_stkfis` (`id`, `STKFISTIPI`, `STKFISHARTIPI`, `STKFISCALFLAG`, `STKFISSTAFLAG`, `STKFISSTAACKL`, `STKFISKAYNAK`, `STKFISKAYNAKHY`, `STKFISREFNO`, `STKFISKARREFNO`, `STKFISIDNO`, `STKFISKAYTAR`, `STKFISHICTAR`, `STKFISTALTAR`, `STKFISURTTAR`, `STKFISSAAT`, `STKFISSURE`, `STKFISSUREACKL`, `STKFISTESTAR`, `STKFISNO`, `STKFISEVRAKNO1`, `STKFISEVRAKNO2`, `STKFISEVRAKNO3`, `STKFISCARKOD`, `STKFISADRESITEM`, `STKFISANADEPO`, `STKFISKARDEPO`, `STKFISOZKOD1`, `STKFISOZKOD2`, `STKFISOZKOD3`, `STKFISOZKOD4`, `STKFISOZKOD5`, `STKFISACIKLAMA1`, `STKFISACIKLAMA2`, `STKFISACIKLAMA3`, `STKFISPROJE`, `STKFISISYERI`, `STKFISPARTIKOD`, `STKFISMASMER`, `STKFISODEMEACKL`, `STKFISODEMEACKL2`, `STKFISNAKLIYE`, `STKFISOPSIYON`, `STKFISNOTLAR`, `STKFISMASRAF1ACKL`, `STKFISMASRAF2ACKL`, `STKFISTUTAR`, `STKFISISK4ORAN`, `STKFISISK4TUTAR`, `STKFISISKTOPTUTAR`, `STKFISMASRAF1`, `STKFISMASRAF2`, `STKFISARATOP`, `STKFISKDVORAN`, `STKFISKDVTUTAR`, `STKFISGENTOP`, `STKFISPARABIRIM`, `STKFISDOVTAR`, `STKFISDOVKOD`, `STKFISDOVTUR`, `STKFISDOVKUR`, `STKFISDOVTOP`, `STKFISHAZKOD`, `STKFISHAZTAR`, `STKFISHAZACKL`, `STKFISKONTFLAG`, `STKFISKONTKOD`, `STKFISKONTTAR`, `STKFISKONTACKL`, `STKFISONAYFLAG`, `STKFISONAYKOD`, `STKFISONAYTAR`, `STKFISONAYACKL`, `STKFISTESEDEN`, `STKFISTESALAN`, `STKFISYAZDIR`, `STKFISEMAIL`) VALUES (1, 14, -1, '1', '1', NULL, 5, 7, 1, NULL, NULL, '2015-07-06', '2015-07-06', NULL, NULL, '12:53:04', 3, 'Hafta', NULL, '1', 'FİŞ-1', NULL, NULL, '1', NULL, 'DEPO-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 75.00000, NULL, 0.00000, NULL, NULL, NULL, 75.00000, 18.00000, 13.50000, 88.50000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, NULL, 'sysadmin', '2015-07-06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2, 14, -1, '1', '1', NULL, 5, 7, 2, NULL, NULL, '2015-07-07', '2015-07-07', NULL, NULL, '14:08:50', 3, 'Hafta', NULL, '2', 'FİŞ-2', NULL, NULL, '1', NULL, 'DEPO-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24.00000, NULL, 0.00000, NULL, NULL, NULL, 24.00000, 18.00000, 4.32000, 28.32000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL, 'sysadmin', '2015-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (3, 14, -1, '1', '1', NULL, 5, 7, 3, NULL, NULL, '2015-07-07', '2015-07-07', NULL, NULL, '14:09:35', 3, 'Hafta', NULL, '3', 'FİŞ-3', NULL, NULL, '1', NULL, 'DEPO-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00000, NULL, 0.00000, NULL, NULL, NULL, 10.00000, 18.00000, 1.80000, 11.80000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL, 'sysadmin', '2015-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4, 14, -1, '1', '1', NULL, 5, 7, 4, NULL, NULL, '2015-07-07', '2015-07-07', NULL, NULL, '14:10:12', 3, 'Hafta', NULL, '4', 'FİŞ-4', NULL, NULL, '1', NULL, 'DEPO-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8.00000, NULL, 0.00000, NULL, NULL, NULL, 8.00000, 18.00000, 1.44000, 9.44000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL, 'sysadmin', '2015-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (5, 14, -1, '1', '1', NULL, 5, 7, 5, NULL, NULL, '2015-07-07', '2015-07-07', NULL, NULL, '14:10:32', 3, 'Hafta', NULL, '5', 'FİŞ-5', NULL, NULL, '1', NULL, 'DEPO-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4.00000, NULL, 0.00000, NULL, NULL, NULL, 4.00000, 18.00000, 0.72000, 4.72000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL, 'sysadmin', '2015-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (6, 14, -1, '1', '1', NULL, 5, 7, 6, NULL, NULL, '2015-07-07', '2015-07-07', NULL, NULL, '14:11:09', 3, 'Hafta', NULL, '6', 'FİŞ-6', NULL, NULL, '1', NULL, 'DEPO-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00000, NULL, 0.00000, NULL, NULL, NULL, 30.00000, 18.00000, 5.40000, 35.40000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL, 'sysadmin', '2015-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (7, 14, -1, '1', '1', NULL, 5, 7, 7, NULL, NULL, '2015-07-07', '2015-07-07', NULL, NULL, '14:12:22', 3, 'Hafta', NULL, '7', 'FİŞ-7', NULL, NULL, '1', NULL, 'DEPO-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3.00000, NULL, 0.00000, NULL, NULL, NULL, 3.00000, 18.00000, 0.54000, 3.54000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL, 'sysadmin', '2015-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); CREATE TABLE IF NOT EXISTS `dbo_stkhar` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `STKHARFISTIPI` tinyint(3) DEFAULT NULL COMMENT 'Fiş Tipi', `STKHARTIPI` tinyint(3) DEFAULT NULL COMMENT 'İşlem Tipi', `STKHARISLEMTIP` tinyint(3) DEFAULT NULL COMMENT 'Kayıt Tipi', `STKHARKAYNAK` tinyint(3) DEFAULT NULL COMMENT 'Kaynak Program', `STKHARKAYNAKHY` tinyint(3) DEFAULT NULL COMMENT 'Kaynak Hiyerarşi', `STKHAROPRKOD` varchar(40) DEFAULT NULL COMMENT 'Operatör Kodu', `STKHARCALFLAG` char(1) DEFAULT NULL COMMENT 'Aktif / Pasif', `STKHARSTAFLAG` char(1) DEFAULT NULL COMMENT 'State Flag', `STKHARREFNO` int(10) DEFAULT NULL COMMENT 'Referans No', `STKHARKARREFNO` int(10) DEFAULT NULL COMMENT 'Karşı Referans No', `STKHARSIRANO` smallint(10) DEFAULT NULL COMMENT 'Sıra No', `STKHARIDNO` tinyint(3) DEFAULT NULL COMMENT 'Hareket ID Kolon No', `STKHARTAR` date DEFAULT NULL COMMENT 'Hareket Tarihi', `STKHARHICTAR` date DEFAULT NULL COMMENT 'Hicri Tarih', `STKHARURTTAR` date DEFAULT NULL COMMENT 'Uretim Tarihi', `STKHARTESTAR` date DEFAULT NULL COMMENT 'Teslim Tarihi', `STKHAREVRAKNO1` varchar(40) DEFAULT NULL COMMENT 'Evrak No 1', `STKHARCARKOD` varchar(80) DEFAULT NULL COMMENT 'Cari Kod', `STKHARADRESITEM` tinyint(3) DEFAULT NULL COMMENT 'Adres Tip', `STKHARANADEPO` varchar(40) DEFAULT NULL COMMENT 'Ana Depo', `STKHARKARDEPO` varchar(40) DEFAULT NULL COMMENT 'Karşı Depo', `STKHARISYERI` varchar(40) DEFAULT NULL COMMENT 'İş Yeri', `STKHARMASMER` varchar(40) DEFAULT NULL COMMENT 'Masraf Merkezi', `STKHARPARTIKOD` varchar(40) DEFAULT NULL COMMENT 'Parti Kodu', `STKHAROZKOD1` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 1', `STKHAROZKOD2` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 2', `STKHAROZKOD3` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 3', `STKHAROZKOD4` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 4', `STKHAROZKOD5` varchar(40) DEFAULT NULL COMMENT 'Özel Kod 5', `STKHARSTKKOD` varchar(80) DEFAULT NULL COMMENT 'Stok Kodu', `STKHARSERINO1` varchar(40) DEFAULT NULL COMMENT 'Seri No 1', `STKHARSERINO2` varchar(40) DEFAULT NULL COMMENT 'Seri No 2', `STKHARSTKBRM` varchar(10) DEFAULT NULL COMMENT 'Birim', `STKHARSTKBRM2` varchar(10) DEFAULT NULL COMMENT 'Birim 2', `STKHARRESIM` tinyint(3) DEFAULT NULL COMMENT 'Stok Resim', `STKHARACIKLAMA1` varchar(80) DEFAULT NULL COMMENT 'Açıklama 1', `STKHARACIKLAMA2` varchar(80) DEFAULT NULL COMMENT 'Açıklama 2', `STKHARACIKLAMA3` varchar(80) DEFAULT NULL COMMENT 'Açıklama 3', `STKHARPROJE` varchar(80) DEFAULT NULL COMMENT 'Proje Kod', `STKHARMAKKOD` varchar(80) DEFAULT NULL COMMENT 'Makine Kod', `STKHARMAKYOL` int(11) DEFAULT NULL COMMENT 'Makine Yol', `STKHARMIKTAR` decimal(17,5) DEFAULT NULL COMMENT 'Miktar', `STKHARMIKTAR2` decimal(17,5) DEFAULT NULL COMMENT 'Miktar 2', `STKHARMIKTAR2TOP` decimal(17,5) DEFAULT NULL COMMENT 'Miktar 2 Toplam', `STKHARFIYATNO` tinyint(3) DEFAULT NULL COMMENT 'Fiyat No', `STKHARFIYAT` decimal(17,5) DEFAULT NULL COMMENT 'Fiyat', `STKHARNETFIYAT` decimal(17,5) DEFAULT NULL COMMENT 'Net Fiyat', `STKHARMALFIYAT` decimal(17,5) DEFAULT NULL COMMENT 'Maliyet Fiyat', `STKHARDOVFIYAT` decimal(17,5) DEFAULT NULL COMMENT 'Döviz Fiyat', `STKHARTUTAR` decimal(17,5) DEFAULT NULL COMMENT 'Tutar', `STKHARISKORAN1` decimal(17,5) DEFAULT NULL COMMENT 'İsk. 1 %', `STKHARISKTUT1` decimal(17,5) DEFAULT NULL COMMENT 'İsk. Tut. 1', `STKHARISKORAN2` decimal(17,5) DEFAULT NULL COMMENT 'İsk. 2 %', `STKHARISKTUT2` decimal(17,5) DEFAULT NULL COMMENT 'İsk. Tut. 2', `STKHARISKORAN3` decimal(17,5) DEFAULT NULL COMMENT 'İsk. 3 %', `STKHARISKTUT3` decimal(17,5) DEFAULT NULL COMMENT 'İsk. Tut. 3', `STKHARTOPMAS` decimal(17,5) DEFAULT NULL COMMENT 'Toplam Masraf', `STKHARDIGIND` decimal(17,5) DEFAULT NULL COMMENT 'Diğer İndirimler', `STKHARTOPIND` decimal(17,5) DEFAULT NULL COMMENT 'Toplam İndirimler', `STKHARARATOP` decimal(17,5) DEFAULT NULL COMMENT 'Ara Toplam', `STKHARISKORAN4` decimal(17,5) DEFAULT NULL COMMENT 'İsk. 4 %', `STKHARISKTUT4` decimal(17,5) DEFAULT NULL COMMENT 'İsk. Tut. 4', `STKHARKDVORAN` decimal(17,5) DEFAULT NULL COMMENT 'Kdv %', `STKHARKDVTUT` decimal(17,5) DEFAULT NULL COMMENT 'Kdv Tutar', `STKHARSATTUTAR` decimal(17,5) DEFAULT NULL COMMENT 'Toplam Tutar', `STKHARPARABIRIM` varchar(10) DEFAULT NULL COMMENT 'Para Birim', `STKHARDOVTAR` date DEFAULT NULL COMMENT 'Döviz Tarihi', `STKHARDOVKOD` varchar(10) DEFAULT NULL COMMENT 'Döviz Kodu', `STKHARDOVTUR` varchar(10) DEFAULT NULL COMMENT 'Döviz Piyasa', `STKHARDOVKUR` decimal(17,5) DEFAULT NULL COMMENT 'Döviz Kuru', `STKHARDOVTUTAR` decimal(17,5) DEFAULT NULL COMMENT 'Döviz Tutar', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin5 ROW_FORMAT=FIXED; INSERT INTO `dbo_stkhar` (`id`, `STKHARFISTIPI`, `STKHARTIPI`, `STKHARISLEMTIP`, `STKHARKAYNAK`, `STKHARKAYNAKHY`, `STKHAROPRKOD`, `STKHARCALFLAG`, `STKHARSTAFLAG`, `STKHARREFNO`, `STKHARKARREFNO`, `STKHARSIRANO`, `STKHARIDNO`, `STKHARTAR`, `STKHARHICTAR`, `STKHARURTTAR`, `STKHARTESTAR`, `STKHAREVRAKNO1`, `STKHARCARKOD`, `STKHARADRESITEM`, `STKHARANADEPO`, `STKHARKARDEPO`, `STKHARISYERI`, `STKHARMASMER`, `STKHARPARTIKOD`, `STKHAROZKOD1`, `STKHAROZKOD2`, `STKHAROZKOD3`, `STKHAROZKOD4`, `STKHAROZKOD5`, `STKHARSTKKOD`, `STKHARSERINO1`, `STKHARSERINO2`, `STKHARSTKBRM`, `STKHARSTKBRM2`, `STKHARRESIM`, `STKHARACIKLAMA1`, `STKHARACIKLAMA2`, `STKHARACIKLAMA3`, `STKHARPROJE`, `STKHARMAKKOD`, `STKHARMAKYOL`, `STKHARMIKTAR`, `STKHARMIKTAR2`, `STKHARMIKTAR2TOP`, `STKHARFIYATNO`, `STKHARFIYAT`, `STKHARNETFIYAT`, `STKHARMALFIYAT`, `STKHARDOVFIYAT`, `STKHARTUTAR`, `STKHARISKORAN1`, `STKHARISKTUT1`, `STKHARISKORAN2`, `STKHARISKTUT2`, `STKHARISKORAN3`, `STKHARISKTUT3`, `STKHARTOPMAS`, `STKHARDIGIND`, `STKHARTOPIND`, `STKHARARATOP`, `STKHARISKORAN4`, `STKHARISKTUT4`, `STKHARKDVORAN`, `STKHARKDVTUT`, `STKHARSATTUTAR`, `STKHARPARABIRIM`, `STKHARDOVTAR`, `STKHARDOVKOD`, `STKHARDOVTUR`, `STKHARDOVKUR`, `STKHARDOVTUTAR`) VALUES (1, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 1, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'SERDAR GÜNGÖR', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 10.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 10.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 10.00000, NULL, 0.00000, 18.00000, 1.80000, 10.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, 3.34459), (2, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 2, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'SERDAR GÜNGÖR', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 15.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 15.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 15.00000, NULL, 0.00000, 18.00000, 2.70000, 15.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, 5.01689), (3, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 3, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'SERDAR GÜNGÖR', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 20.00000, NULL, 0.00000, NULL, NULL, 0.00000, NULL, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 0.00000, NULL, 0.00000, 18.00000, 0.00000, 0.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, 0.00000), (4, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 4, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'SERDAR GÜNGÖR', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 25.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 25.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 25.00000, NULL, 0.00000, 18.00000, 4.50000, 25.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, 8.36148), (5, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 5, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'ALİ VAMİN', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 10.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 10.00000, NULL, 0.00000, 18.00000, 1.80000, 10.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, NULL), (6, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 6, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'ALİ VAMİN', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 15.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 15.00000, NULL, 0.00000, 18.00000, 2.70000, 15.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, NULL), (7, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 7, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'ALİ VAMİN', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20.00000, NULL, 0.00000, NULL, NULL, 0.00000, NULL, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 0.00000, NULL, 0.00000, 18.00000, 0.00000, 0.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, NULL), (8, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 1, NULL, 8, 0, '2015-07-06', '2015-07-06', NULL, NULL, 'FİŞ-1', 'ALİ VAMİN', 1, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 25.00000, NULL, 0.00000, NULL, NULL, 0.00000, NULL, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 0.00000, NULL, 0.00000, 18.00000, 0.00000, 0.00000, 'TL', '2015-07-06', 'EURO', 'MBNKSAT', 2.98990, 0.00000), (9, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 1, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (10, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 2, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 2.00000, NULL, 0.00000, 18.00000, 0.36000, 2.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.67168), (11, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 3, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 4.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 4.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 4.00000, NULL, 0.00000, 18.00000, 0.72000, 4.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 1.34336), (12, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 4, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 5.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 5.00000, NULL, 0.00000, 18.00000, 0.90000, 5.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 1.67920), (13, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 5, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (14, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 6, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 2.00000, NULL, 0.00000, 18.00000, 0.36000, 2.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (15, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 7, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 4.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 4.00000, NULL, 0.00000, 18.00000, 0.72000, 4.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (16, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 2, NULL, 8, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-2', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 5.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 5.00000, NULL, 0.00000, 18.00000, 0.90000, 5.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (17, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 3, NULL, 1, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-3', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (18, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 3, NULL, 2, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-3', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 2.00000, NULL, 0.00000, 18.00000, 0.36000, 2.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.67168), (19, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 3, NULL, 3, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-3', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 3.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 3.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 3.00000, NULL, 0.00000, 18.00000, 0.54000, 3.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 1.00752), (20, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 3, NULL, 4, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-3', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 4.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 4.00000, NULL, 0.00000, 18.00000, 0.72000, 4.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 1.34336), (21, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 1, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (22, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 2, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (23, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 3, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (24, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 4, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (25, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 5, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (26, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 6, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (27, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 7, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (28, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 4, NULL, 8, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-4', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (29, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 5, NULL, 1, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-5', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (30, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 5, NULL, 2, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-5', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (31, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 5, NULL, 3, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-5', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (32, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 5, NULL, 4, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-5', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (33, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 1, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (34, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 2, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (35, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 3, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 11.00000, 11.00000, NULL, NULL, 11.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 11.00000, NULL, 0.00000, 18.00000, 1.98000, 11.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 3.69425), (36, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 4, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (37, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 5, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1105', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (38, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 6, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (39, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 7, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (40, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 8, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1103', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 11.00000, 11.00000, NULL, NULL, 11.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 11.00000, NULL, 0.00000, 18.00000, 1.98000, 11.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (41, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 9, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1104', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (42, 14, 2, 1, 5, 7, 'sysadmin', '1', NULL, 6, NULL, 10, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-6', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1105', NULL, NULL, 'ADET', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, NULL), (43, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 7, NULL, 1, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-7', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1101', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 1.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 1.00000, NULL, 0.00000, 18.00000, 0.18000, 1.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.33584), (44, 14, 1, 1, 5, 7, 'sysadmin', '1', NULL, 7, NULL, 2, 0, '2015-07-07', '2015-07-07', NULL, NULL, 'FİŞ-7', '1', NULL, 'DEPO-01', NULL, 'MERKEZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1102', NULL, NULL, 'ADET', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 1.00000, 1.00000, NULL, NULL, 2.00000, NULL, 0.00000, NULL, 0.00000, NULL, 0.00000, NULL, NULL, 0.00000, 2.00000, NULL, 0.00000, 18.00000, 0.36000, 2.00000, 'TL', '2015-07-07', 'EURO', 'MBNKSAT', 2.97760, 0.67168);