Serkan Sonmez's Diary

Logo Edefter "I/O Error 105" hatası hakkında

Logo Tiger3'de e-defter uygulamasını çalıştırdığınızda Berat gönderme ekranında "I/O Error 105" hatası geliyorsa büyük ihtimalle 2.67.00.00 öncesi versiyonu kullanıyor olabilirsiniz. Programı üst versiyona yükseltince sorun ortadan kalkıyor.

Ayrıca başka bir sorun Java versiyonundan da kaynaklanıyor olabilir. Kullandığımız Java versiyonu JRE 1.08.221 32 bit. Java versiyonunu https://www.oracle.com/tr/java/technologies/javase/javase8u211-later-archive-downloads.html#license-lightbox üzerinden indirebilirsiniz.

Merkez Bankası döviz kurlarını T-SQL ile çeken SQL scripti

--1- sql server ayarları

Use master

sp_configure 'show advanced options' , 1

Reconfigure with Override

sp_configure 'Ole Automation Procedures' , 1

Reconfigure with Override

-- 2.Döviz Kurlarının Yazılacağı Tablo oluşturuluyor

if not exists (select * from sys.tables where name = N'DOVIZKURLARI' and type = 'U')

begin

Create table DOVIZKURLARI (Tarih date,

CrossOrder Smallint,

Kod NVarchar(5),

CurrencyCode NVarchar(5),

UNIT varchar(50),

Isim varchar(100),

CurrencyName varchar(100) ,

ForexBuying float ,

ForexSelling float,

BanknoteBuying float,

BanknoteSelling float)

end

--3. Stored Procedure oluşturuluyor

if exists (select * from sys.objects where type = 'P' AND name = 'UPR_GetDovizKurlari_MerkezBankasi')

drop procedure UPR_GetDovizKurlari_MerkezBankasi

Create proc [dbo].[UPR_GetDovizKurlari_MerkezBankasi]

(@pYil Smallint, @pAy TinyInt, @pGun TinyInt)

begin

Declare @url as varchar(8000)

Set @url = 'https://www.tcmb.gov.tr/kurlar/today.xml'

Set @url = 'https://www.tcmb.gov.tr/kurlar/201903/12032019.xml'

Declare @XmlYilAy NVarchar(6), @XmlTarih NVarchar(10)

Set @XmlYilAy = Right('0000' + cast(@pYil as varchar(4)) , 4) + Right('00' + cast(@pAy as varchar(2)) , 2)

Set @XmlTarih = Right('00' + cast(@pGun as varchar(2)) , 2) + Right('00' + cast(@pAy as varchar(2)) , 2) + Right('0000' + cast(@pYil as varchar(4)) , 4)

If DateFromParts(@pYil, @pAy, @pGun) = DateAdd(dd,0,DateDiff(dd,0,GetDate())) --gelen parametrelergünün tarihi ise

Set @url = 'https://www.tcmb.gov.tr/kurlar/today.xml'

else

Set @url = 'https://www.tcmb.gov.tr/kurlar/' + @XmlYilAy + '/' + @XmlTarih + '.xml'

Print @url

declare @OBJ AS INT

declare @RESULT AS INT

EXEC @RESULT = SP_OACREATE 'MSXML2.XMLHTTP', @OBJ OUT

EXEC @RESULT = SP_OAMethod @OBJ , 'open' , null , 'GET', @url, false

EXEC @RESULT = SP_OAMethod @OBJ, send, NULL,''

If OBJECT_ID('tempdb..#XML') IS NOT Null DROP TABLE #XML

Create table #XML ( STRXML varchar(max))

Insert INTO #XML(STRXML) EXEC @RESULT = SP_OAGetProperty @OBJ, 'responseXML.xml'

--Select * From #XML

DECLARE @XML AS XML

SELECT @XML = STRXML FROM #XML

DROP TABLE #XML

DECLARE @HDOC AS INT

EXEC SP_XML_PREPAREDOCUMENT @HDOC OUTPUT , @XML

Delete from DOVIZKURLARI where tarih = DateFromParts(@pYil, @pAy, @pGun)

INSERT INTO DOVIZKURLARI ( Tarih,CrossOrder,Kod,CurrencyCode,UNIT,Isim,CurrencyName,ForexBuying,ForexSelling,BanknoteBuying,BanknoteSelling)

SELECT DateFromParts(@pYil, @pAy, @pGun) As Tarih,

* FROM OPENXML(@HDOC, 'Tarih_Date/Currency')

With (CrossOrder NVarchar(5), Kod Varchar(5), CurrencyCode NVarchar(5),

Unit varchar(50) 'Unit',

Isim varchar(100) 'Isim',

CurrencyName varchar(100) 'CurrencyName',

ForexBuying float 'ForexBuying',

ForexSelling float 'ForexSelling',

BanknoteBuying float 'BanknoteBuying',

BanknoteSelling float 'BanknoteSelling'

)

End

---2020,12,15 test amaçlı bir günlük YIL,AY,GÜN

exec UPR_GetDovizKurlari_MerkezBankasi 2020,12,15 --test amaçlı bir günlük

--4. iki tarih arası indir: Geçmiş döneme ait kurları indirebilmek için iki tarih arası sorguyu kullanabilirsiniz.

declare @IlkTarih datetime = '20150101'

declare @SonTarih datetime = '20201218'

declare @Yil int

declare @Ay int

declare @Gun int

WHILE (@IlkTarih<@SonTarih)

BEGIN

set @Yil = year(@IlkTarih)

set @Ay = month(@IlkTarih)

set @Gun = day(@IlkTarih)

exec UPR_GetDovizKurlari_MerkezBankasi @Yil,@Ay,@Gun

SET @IlkTarih = DATEADD(dd,1,@IlkTarih)

END

Malzeme Bazında Sipariş Detayları Sorgusu (Tiger Ticari Sistem)

SELECT 01 AS PERIOD,

CLASS.ACTIVE AS CLASS_ACTIVE,

(CASE CLASS.ACTIVE WHEN 0 THEN '(*%:13046,0)Kullanımda..........'

WHEN 1 THEN '(*%:13046,1)Kullanım Dışı..........' ELSE '' END) AS CLASS_ACTIVE_ADI,

CLASS.CARDTYPE AS CLASS_CARDTYPE,

(CASE CLASS.CARDTYPE WHEN 20 THEN '(*%:1009,20)(MS) Genel Malzeme Sınıfı..........'

WHEN 21 THEN '(*%:1009,21)(MT) Tablolu Malzeme Sınıfı..........' ELSE '' END) AS CLASS_CARDTYPE_TIPI,

CLASS.CODE AS CLASS_CODE, CLASS.NAME AS CLASS_NAME, CLASS.STGRPCODE AS CLASS_STGRPCODE,

CLASS.PRODUCERCODE AS CLASS_PRODUCERCODE, CLASS.SPECODE AS CLASS_SPECODE, CLASS.CYPHCODE AS CLASS_CYPHCODE,

ITEMS.ACTIVE AS ITEMS_ACTIVE,

(CASE ITEMS.ACTIVE WHEN 0 THEN '(*%:13046,0)Kullanımda..........'

WHEN 1 THEN '(*%:13046,1)Kullanım Dışı..........' ELSE '' END) AS ITEMS_ACTIVE_ADI,

ITEMS.CARDTYPE AS ITEMS_CARDTYPE,

(CASE ITEMS.CARDTYPE WHEN 1 THEN '(*%:1009,1)(TM) Ticari Mal..........'

WHEN 2 THEN '(*%:1009,2)(KK) Karma Koli..........'

WHEN 3 THEN '(*%:1009,3)(DM) Depozitolu Mal..........'

WHEN 4 THEN '(*%:1009,4)(SK) Sabit Kıymet..........'

WHEN 10 THEN '(*%:1009,10)(HM) Hammadde..........'

WHEN 11 THEN '(*%:1009,11)(YM) Yarı Mamul..........'

WHEN 12 THEN '(*%:1009,12)(MM) Mamul..........'

WHEN 13 THEN '(*%:1009,13)(TK) Tüketim Malı..........'

WHEN 20 THEN '(*%:1009,20)(MS) Genel Malzeme Sınıfı..........'

WHEN 21 THEN '(*%:1009,21)(MT) Tablolu Malzeme Sınıfı..........' ELSE '' END) AS ITEMS_MALZEME_TIPI,

ITEMS.CODE AS ITEMS_CODE, ITEMS.NAME AS ITEMS_NAME, ITEMS.STGRPCODE AS ITEMS_STGRPCODE, ITEMS.PRODUCERCODE AS ITEMS_PRODUCERCODE,

ITEMS.SPECODE AS ITEMS_SPECODE, ITEMS.CYPHCODE AS ITEMS_CYPHCODE, ITEMS.TRACKTYPE AS ITEMS_TRACKTYPE,

(CASE ITEMS.TRACKTYPE WHEN 0 THEN '(*%:18233,8)İzleme yapılmayacak..........'

WHEN 1 THEN '(*%:18233,8)Lot numarası..........'

WHEN 2 THEN '(*%:18233,8)Seri numarası..........'

WHEN 3 THEN '(*%:18233,8)Seri grubu..........' ELSE '' END) AS ITEMS_IZLEME_TURU,

UNITSETF.CODE AS UNITSETF_CODE, UNITSETF.NAME AS UNITSETF_NAME,

UNITSETF.SPECODE AS UNITSETF_SPECODE, UNITSETF.CYPHCODE AS UNITSETF_CYPHCODE, UNITSETL.CODE AS UNITSETL_CODE,

UNITSETL.NAME AS UNITSETL_NAME,

CASE WHEN ITMUNITA_2.CONVFACT2>0 THEN ITMUNITA_2.CONVFACT2/ITMUNITA_2.CONVFACT1 ELSE 0 END AS ITMUNITA_2_KATSAYI,

UNITSETL_2.CODE AS UNITSETL_2_CODE, UNITSETL_2.NAME AS UNITSETL_2_NAME,

CASE WHEN ITMUNITA_3.CONVFACT2>0 THEN ITMUNITA_3.CONVFACT2/ITMUNITA_3.CONVFACT1 ELSE 0 END AS ITMUNITA_3_KATSAYI,

UNITSETL_3.CODE AS UNITSETL_3_CODE, UNITSETL_3.NAME AS UNITSETL_3_NAME, ITMUNITA_1.LINENR AS ITMUNITA_LINENR, ITMUNITA_1.BARCODE AS ITMUNITA_BARCODE,

ITMUNITA_1.WIDTH AS ITMUNITA_WIDTH, UNITSETL1.CODE AS WIDTH_CODE, ITMUNITA_1.LENGTH AS ITMUNITA_LENGTH,

UNITSETL2.CODE AS LENGTH_CODE, ITMUNITA_1.HEIGHT AS ITMUNITA_HEIGHT, UNITSETL3.CODE AS HEIGHT_CODE, ITMUNITA_1.AREA AS ITMUNITA_AREA,

UNITSETL4.CODE AS AREA_CODE, ITMUNITA_1.VOLUME_ AS ITMUNITA_VOLUME_, UNITSETL5.CODE AS VOLUME_CODE, ITMUNITA_1.GROSSVOLUME AS ITMUNITA_GROSSVOLUME,

UNITSETL6.CODE AS GROSSVOLUME_CODE, ITMUNITA_1.WEIGHT AS ITMUNITA_WEIGHT, UNITSETL7.CODE AS WEIGHT_CODE, ITMUNITA_1.GROSSWEIGHT AS ITMUNITA_GROSSWEIGHT,

UNITSETL8.CODE AS GROSSWEIGHT_CODE, ITMUNITA_1.CONVFACT1 AS ITMUNITA_CONVFACT1, ITMUNITA_1.CONVFACT2 AS ITMUNITA_CONVFACT2,

ORFLINE.LOGICALREF AS ORFLINE_LOGICALREF, ORFLINE.LINETYPE AS ORFLINE_LINETYPE,

(CASE ORFLINE.LINETYPE

WHEN 0 THEN '(*%:13063,1)Malzeme..........'

WHEN 1 THEN '(*%:13063,2)Promosyon..........'

WHEN 2 THEN '(*%:13063,3)İndirim..........'

WHEN 3 THEN '(*%:13063,4)Masraf..........'

WHEN 4 THEN '(*%:13063,5)Hizmet..........'

WHEN 5 THEN '(*%:13063,6)Depozito..........'

WHEN 6 THEN '(*%:13063,7)Karma Koli..........'

WHEN 7 THEN '(*%:13063,8)Karma Koli Satırı..........'

WHEN 8 THEN '(*%:13063,9)Sabit Kıymet..........'

WHEN 9 THEN '(*%:13063,10)Ek Malzeme..........'

WHEN 10 THEN '(*%:13063,11)Malzeme Sınıfı..........'

WHEN 11 THEN '(*%:13063,12)Fason..........' ELSE '' END) AS ORFLINE_SATIR_TURU,

ORFLINE.PREVLINEREF AS ORFLINE_PREVLINEREF, ORFLINE.PREVLINENO AS ORFLINE_PREVLINENO,

ORFLINE.TRCODE AS ORFLINE_TRCODE, ORFLINE.DATE_ AS ORFLINE_DATE_, DATEPART(YYYY,ORFLINE.DATE_) AS ORFLINE_YEAR,

CASE WHEN DATEPART(qq,ORFLINE.DATE_) IN (1,2) THEN 1 ELSE 2 END AS ORFLINE_HALF, DATEPART(qq,ORFLINE.DATE_) AS ORFLINE_QUARTER,

DATEPART(MM,ORFLINE.DATE_) AS ORFLINE_MONTH, DATEPART(wk,ORFLINE.DATE_) AS ORFLINE_WEEK, DATEPART(dd,ORFLINE.DATE_) AS ORFLINE_DAY,

ORFLINE.TIME_ AS ORFLINE_TIME_, ORFLINE.GLOBTRANS AS ORFLINE_GLOBTRANS,

ORFLINE.SOURCEINDEX AS ORFLINE_SOURCEINDEX, ORFLINE.SOURCECOSTGRP AS ORFLINE_SOURCECOSTGRP,

ORFLINE.ORDFICHEREF AS ORFLINE_ORDFICHEREF, ORFLINE.LINENO_ AS ORFLINE_LINENO_,

ORFLINE.CLIENTREF AS ORFLINE_CLIENTREF, ORFLINE.SPECODE AS ORFLINE_SPECODE, ORFLINE.DELVRYCODE AS ORFLINE_DELVRYCODE,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN (ORFLINE.AMOUNT*(CASE ORFLINE.UINFO2 WHEN 0 THEN 1 ELSE ORFLINE.UINFO2/ORFLINE.UINFO1 END)) ELSE 0 END))) AS ORFLINE_INPUT_AMOUNT,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE (ORFLINE.AMOUNT*(CASE ORFLINE.UINFO2 WHEN 0 THEN 1 ELSE ORFLINE.UINFO2/ORFLINE.UINFO1 END)) END))) AS ORFLINE_OUTPUT_AMOUNT,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.PRICE ELSE 0 END))) AS ORFLINE_INPUT_PRICE, (((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.PRICE END))) AS ORFLINE_OUTPUT_PRICE,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.TOTAL ELSE 0 END))) AS ORFLINE_INPUT_TOTAL, (((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.TOTAL END))) AS ORFLINE_OUTPUT_TOTAL,

ORFLINE.PRCURR AS ORFLINE_PRCURR, (((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.PRPRICE ELSE 0 END))) AS ORFLINE_INPUT_PRPRICE,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.PRPRICE END))) AS ORFLINE_OUTPUT_PRPRICE,

ORFLINE.TRCURR AS ORFLINE_TRCURR, ORFLINE.TRRATE AS ORFLINE_TRRATE, ORFLINE.REPORTRATE AS ORFLINE_REPORTRATE,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.DISTCOST ELSE 0 END))) AS ORFLINE_INPUT_DISTCOST,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.DISTCOST END))) AS ORFLINE_OUTPUT_DISTCOST,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.DISTDISC ELSE 0 END))) AS ORFLINE_INPUT_DISTDISC,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.DISTDISC END))) AS ORFLINE_OUTPUT_DISTDISC,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.DISTEXP ELSE 0 END))) AS ORFLINE_INPUT_DISTEXP,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.DISTEXP END))) AS ORFLINE_OUTPUT_DISTEXP,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.DISTPROM ELSE 0 END))) AS ORFLINE_INPUT_DISTPROM,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.DISTPROM END))) AS ORFLINE_OUTPUT_DISTPROM, ORFLINE.DISCPER AS ORFLINE_DISCPER,

ORFLINE.LINEEXP AS ORFLINE_LINEEXP, ORFLINE.UOMREF AS ORFLINE_UOMREF, ORFLINE.USREF AS ORFLINE_USREF, ORFLINE.UINFO1 AS ORFLINE_UINFO1,

ORFLINE.UINFO2 AS ORFLINE_UINFO2, ORFLINE.VATINC AS ORFLINE_VATINC, ORFLINE.VAT AS ORFLINE_VAT,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.VATAMNT ELSE 0 END))) AS ORFLINE_INPUT_VATAMNT,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.VATAMNT END))) AS ORFLINE_OUTPUT_VATAMNT,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.VATMATRAH ELSE 0 END))) AS ORFLINE_INPUT_VATMATRAH,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.VATMATRAH END))) AS ORFLINE_OUTPUT_VATMATRAH, ORFLINE.CANCELLED AS ORFLINE_CANCELLED,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN ORFLINE.LINENET ELSE 0 END))) AS ORFLINE_INPUT_LINENET,

(((CASE WHEN ORFLINE.TRCODE IN (2) THEN 0 ELSE ORFLINE.LINENET END))) AS ORFLINE_OUTPUT_LINENET,

ORFICHE.TRCODE AS ORFICHE_TRCODE,

(CASE ORFICHE.TRCODE WHEN 2 THEN '(*%:1012,2002)Satınalma Siparişleri..........'

WHEN 1 THEN '(*%:1012,5001)Satış Siparişleri..........' ELSE '' END) AS ORFICHE_TRCODE_ADI, ORFICHE.FICHENO AS ORFICHE_FICHENO,

ORFICHE.DATE_ AS ORFICHE_DATE_, ORFICHE.TIME_ AS ORFICHE_TIME_, ORFICHE.DOCODE AS ORFICHE_DOCODE, ORFICHE.SPECODE AS ORFICHE_SPECODE,

ORFICHE.CYPHCODE AS ORFICHE_CYPHCODE, ORFICHE.STATUS AS ORFICHE_STATUS,

(CASE ORFICHE.STATUS

WHEN 0 THEN '(*%:3137,1)Öneri..........'

WHEN 2 THEN '(*%:3137,2)Sevkedilemez..........'

WHEN 4 THEN '(*%:3137,4)Sevkedilebilir..........' ELSE '' END) AS ORFICHE_STATUS_ADI,

ORFICHE.CLIENTREF AS FORFICHE_CLIENTREF, ORFICHE.RECVREF AS ORFICHE_RECVREF,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.ADDDISCOUNTS ELSE 0 END))) AS ORFICHE_INPUT_ADDDISCOUNTS,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.ADDDISCOUNTS END))) AS ORFICHE_OUTPUT_ADDDISCOUNTS,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.TOTALDISCOUNTS ELSE 0 END))) AS ORFICHE_INPUT_TOTALDISCOUNTS,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.TOTALDISCOUNTS END))) AS ORFICHE_OUTPUT_TOTALDISCOUNTS,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.TOTALDISCOUNTED ELSE 0 END))) AS ORFICHE_INPUT_TOTALDISCOUNTED,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.TOTALDISCOUNTED END))) AS ORFICHE_OUTPUT_TOTALDISCOUNTED,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.ADDEXPENSES ELSE 0 END))) AS ORFICHE_INPUT_ADDEXPENSES,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.ADDEXPENSES END))) AS ORFICHE_OUTPUT_ADDEXPENSES,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.TOTALEXPENSES ELSE 0 END))) AS ORFICHE_INPUT_TOTALEXPENSES,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.TOTALEXPENSES END))) AS ORFICHE_OUTPUT_TOTALEXPENSES,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.TOTALPROMOTIONS ELSE 0 END))) AS ORFICHE_INPUT_TOTALPROMOTIONS,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.TOTALPROMOTIONS END))) AS ORFICHE_OUTPUT_TOTALPROMOTIONS,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.TOTALVAT ELSE 0 END))) AS ORFICHE_INPUT_TOTALVAT,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.TOTALVAT END))) AS ORFICHE_OUTPUT_TOTALVAT,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.GROSSTOTAL ELSE 0 END))) AS ORFICHE_INPUT_GROSSTOTAL,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.GROSSTOTAL END))) AS ORFICHE_OUTPUT_GROSSTOTAL,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.NETTOTAL ELSE 0 END))) AS ORFICHE_INPUT_NETTOTAL,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.NETTOTAL END))) AS ORFICHE_OUTPUT_NETTOTAL, ORFICHE.REPORTRATE AS ORFICHE_REPORTRATE,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.REPORTNET ELSE 0 END))) AS ORFICHE_INPUT_REPORTNET,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.REPORTNET END))) AS ORFICHE_OUTPUT_REPORTNET,

ORFICHE.TRCURR AS ORFICHE_TRCURR, ORFICHE.TRRATE AS ORFICHE_TRRATE,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN ORFICHE.TRNET ELSE 0 END))) AS ORFICHE_INPUT_TRNET,

(((CASE WHEN ORFLINE.TRCODE IN (1,2,3) THEN 0 ELSE ORFICHE.TRNET END))) AS ORFICHE_OUTPUT_TRNET, ORFICHE.CANCELLED AS ORFICHE_CANCELLED,

(CASE ORFICHE.CANCELLED WHEN 0 THEN '(*%:9504,0)İptal Edilmemiş Fişler..........'

WHEN 1 THEN '(*%:9504,1)İptal Edilmiş Fişler..........' ELSE '' END) AS ORFICHE_CANCELLED_AÇIKLAMA, SHIPINFO.CODE AS SHIPINFO_CODE,

SHIPINFO.NAME AS SHIPINFO_NAME, SHIPINFO.SPECODE AS SHIPINFO_SPECODE, SHIPINFO.CYPHCODE AS SHIPINFO_CYPHCODE, CAPIWHOUSE.NR AS CAPIWHOUSE_NR,

CAPIWHOUSE.NAME AS CAPIWHOUSE_NAME, CAPIDIV.NR AS CAPIDIV_NR, CAPIDIV.NAME AS CAPIDIV_NAME, CAPIDEPT.NR AS CAPIDEPT_NR,

CAPIDEPT.NAME AS CAPIDEPT_NAME, CLCARD.CODE AS CLCARD_CODE, CLCARD.DEFINITION_ AS CLCARD_DEFINITION_, CLCARD.SPECODE AS CLCARD_SPECODE,

CLCARD.TAXOFFICE AS CLCARD_TAXOFFICE, CLCARD.TAXNR AS CLCARD_TAXNR, CLCARD.CYPHCODE AS CLCARD_CYPHCODE, CLCARD.INCHARGE AS CLCARD_INCHARGE,

CLCARD.ACTIVE AS CLCARD_ACTIVE,

(CASE CLCARD.ACTIVE WHEN 0 THEN '(*%:13046,0)Kullanımda..........' WHEN 1 THEN '(*%:13046,1)Kullanım Dışı..........' ELSE '' END) AS CLCARD_ACTIVE_ADI,

CLCARD.CITY AS CLCARD_CITY, CLCARD.TRADINGGRP AS CLCARD_TRADINGGRP, CLCARD.CARDTYPE AS CLCARD_CARDTYPE, (CASE CLCARD.CARDTYPE

WHEN 1 THEN '(*%:5003,1)(AL) Alıcı..........' WHEN 2 THEN '(*%:5003,2)(SA) Satıcı..........' WHEN 3 THEN '(*%:5003,3)(AS) Alıcı + Satıcı..........'

WHEN 4 THEN '(*%:5003,1)(GS) Grup Şirketi..........' ELSE '' END) AS CLCARD_CARDTYPE_ADI, PAYPLANS.CODE AS PAYPLANS_CODE, PAYPLANS.DEFINITION_ AS PAYPLANS_DEFINITION_,

PAYPLANS.SPECODE AS PAYPLANS_SPECODE, PAYPLANS.CYPHCODE AS PAYPLANS_CYPHCODE, PROJECT.CODE AS PROJECT_CODE, PROJECT.NAME AS PROJECT_NAME,

EMCENTER.CODE AS EMCENTER_CODE, EMCENTER.DEFINITION_ AS EMCENTER_DEFINITION_, SLSMAN.CODE AS SLSMAN_CODE,

SLSMAN.DEFINITION_ AS SLSMAN_DEFINITION_ FROM LG_002_ITEMS ITEMS (NOLOCK)

LEFT OUTER JOIN LG_002_ITMCLSAS ITC (NOLOCK) ON ITEMS.LOGICALREF=ITC.CHILDREF AND ITC.UPLEVEL=0

LEFT OUTER JOIN LG_002_ITEMS CLASS (NOLOCK) ON ITC.PARENTREF=CLASS.LOGICALREF

LEFT OUTER JOIN LG_002_ITMUNITA ITMUNITA_1 (NOLOCK) ON ITEMS.LOGICALREF=ITMUNITA_1.ITEMREF AND ITMUNITA_1.LINENR=1

LEFT OUTER JOIN LG_002_ITMUNITA ITMUNITA_2 (NOLOCK) ON ITEMS.LOGICALREF=ITMUNITA_2.ITEMREF AND ITMUNITA_2.LINENR=2

LEFT OUTER JOIN LG_002_ITMUNITA ITMUNITA_3 (NOLOCK) ON ITEMS.LOGICALREF=ITMUNITA_3.ITEMREF AND ITMUNITA_3.LINENR=3

LEFT OUTER JOIN LG_002_UNITSETF UNITSETF (NOLOCK) ON ITEMS.UNITSETREF=UNITSETF.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL (NOLOCK) ON ITMUNITA_1.UNITLINEREF=UNITSETL.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL_2 (NOLOCK) ON ITMUNITA_2.UNITLINEREF=UNITSETL_2.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL_3 (NOLOCK) ON ITMUNITA_3.UNITLINEREF=UNITSETL_3.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL1 (NOLOCK) ON ITMUNITA_1.WIDTHREF=UNITSETL1.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL2 (NOLOCK) ON ITMUNITA_1.LENGTHREF=UNITSETL2.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL3 (NOLOCK) ON ITMUNITA_1.HEIGHTREF=UNITSETL3.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL4 (NOLOCK) ON ITMUNITA_1.AREAREF=UNITSETL4.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL5 (NOLOCK) ON ITMUNITA_1.VOLUMEREF=UNITSETL5.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL6 (NOLOCK) ON ITMUNITA_1.GROSSVOLREF=UNITSETL6.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL7 (NOLOCK) ON ITMUNITA_1.WEIGHTREF=UNITSETL7.LOGICALREF

LEFT OUTER JOIN LG_002_UNITSETL UNITSETL8 (NOLOCK) ON ITMUNITA_1.GROSSWGHTREF=UNITSETL8.LOGICALREF

LEFT OUTER JOIN LG_002_01_ORFLINE ORFLINE (NOLOCK) ON ITEMS.LOGICALREF=ORFLINE.STOCKREF AND ORFLINE.LINETYPE NOT IN (2,3,4)

LEFT OUTER JOIN LG_002_01_ORFICHE ORFICHE (NOLOCK) ON ORFLINE.ORDFICHEREF=ORFICHE.LOGICALREF

LEFT OUTER JOIN "TIGER3"..LG_SLSMAN SLSMAN (NOLOCK) ON ORFICHE.SALESMANREF=SLSMAN.LOGICALREF AND SLSMAN.FIRMNR=002

LEFT OUTER JOIN LG_002_SHIPINFO SHIPINFO (NOLOCK) ON ORFICHE.SHIPINFOREF=SHIPINFO.LOGICALREF

LEFT OUTER JOIN "TIGER3"..L_CAPIWHOUSE CAPIWHOUSE WITH(NOLOCK) ON ORFICHE.SOURCEINDEX=CAPIWHOUSE.NR AND CAPIWHOUSE.FIRMNR=002

LEFT OUTER JOIN "TIGER3"..L_CAPIDIV CAPIDIV (NOLOCK) ON ORFICHE.BRANCH=CAPIDIV.NR AND CAPIDIV.FIRMNR=002

LEFT OUTER JOIN "TIGER3"..L_CAPIDEPT CAPIDEPT (NOLOCK) ON ORFICHE.DEPARTMENT=CAPIDEPT.NR AND CAPIDEPT.FIRMNR=002

LEFT OUTER JOIN LG_002_CLCARD CLCARD (NOLOCK) ON ORFICHE.CLIENTREF=CLCARD.LOGICALREF

LEFT OUTER JOIN LG_002_PAYPLANS PAYPLANS (NOLOCK) ON ORFICHE.PAYDEFREF = PAYPLANS.LOGICALREF

LEFT OUTER JOIN LG_002_EMCENTER EMCENTER (NOLOCK) ON ORFICHE.CENTERREF = EMCENTER.LOGICALREF

LEFT OUTER JOIN LG_002_PROJECT PROJECT (NOLOCK) ON ORFICHE.PROJECTREF = PROJECT.LOGICALREF WHERE ITEMS.CARDTYPE<>22

Logo BordroPlus Borç Kesinti Liste Sorgusu (LH_001_PERLOAN - LH_001_LOANDEF )

BordroPlus programında borç listesini almak için aşağıdaki sorguyu kullanabilirsiniz, veya view haline de getirebilirsiniz.

LH_001_PERLOAN: borç kayıtlarının tutulduğu tablo

LH_001_LOANDEF : Borç türlerinin tanım tablosu

SELECT DISTINCT

YEAR( PNTLN."PERDBEG") as Yil,

MONTH( PNTLN."PERDBEG") as Ay,

PERSONS.CODE as PersonelSicilKodu,

PERSONS.NAME + ' ' + PERSONS.SURNAME AS AdiSoyadi,

LH_001_LOANDEF.CODE AS KesintiKodu,

LH_001_LOANDEF.DEFINITION_ AS KesintiAciklama,

PNTLN."PERDBEG" AS "PeriodBegdate",

PNTLN."AMNT" AS "KesintiTutari",

PERSONS.LREF AS PersonelReferans,

PERSONS.LOCINDATE AS IsyerineGirisTarihi

,PNTLN.XREF AS "Loan_Reference",

PNTLN."LREF" AS "Puantaj_Reference",

PNTLN."PREF" AS "Point_Reference",

L_CAPIDIV.NAME as Isyeri

,L_CAPIDIV.NR as IsyNr

,L_CAPIDIV.FIRMNR as KrmNr

FROM

LH_001_PNTLINE PNTLN WITH(NOLOCK)

LEFT OUTER JOIN LH_001_PAYELEM PAYMENTELEMENTINFO WITH(NOLOCK) ON PAYMENTELEMENTINFO.TYP=PNTLN.TYP AND PAYMENTELEMENTINFO.NR=PNTLN.NR -- (PAYMENTELEMENTINFO."LREF" = PNTLN."PAYELEMREF")

LEFT OUTER JOIN LH_001_FIRMPAR FIRMPARINFO WITH(NOLOCK) ON FIRMPARINFO.TYP=PNTLN.TYP AND FIRMPARINFO.NR=PNTLN.NR AND FIRMPARINFO.FIRMNR=PNTLN.FIRMNR -- (FIRMPARINFO."LREF" = PNTLN."FIRMPARREF")

LEFT JOIN LH_001_PERLOAN WITH(NOLOCK) ON LH_001_PERLOAN.LREF =PNTLN.XREF

LEFT JOIN LH_001_LOANDEF WITH(NOLOCK) ON LH_001_LOANDEF.LREF =LH_001_PERLOAN.CARDREF

LEFT JOIN LH_001_PERSON PERSONS WITH(NOLOCK) ON PERSONS.LREF =PNTLN."PERREF"

LEFT JOIN L_CAPIFIRM WITH(NOLOCK) ON PNTLN.FIRMNR = L_CAPIFIRM.LOGICALREF

LEFT JOIN L_CAPIDIV WITH(NOLOCK) ON L_CAPIDIV.FIRMNR = PNTLN.FIRMNR AND L_CAPIDIV.NR = PNTLN.LOCNR

WHERE LH_001_LOANDEF.GROUPNR IS NOT NULL

Serkan Sonmez's Diary

Logo Edefter "I/O Error 105" hatası hakkında

Merkez Bankası döviz kurlarını T-SQL ile çeken SQL scripti

Malzeme Bazında Sipariş Detayları Sorgusu (Tiger Ticari Sistem)

Logo BordroPlus Borç Kesinti Liste Sorgusu (LH_001_PERLOAN - LH_001_LOANDEF )

BlackListIP control on Serenity platform (.NET Core)

Android Uygulama Örneği

Facebook Card