Logo Amortisman Raporu

Select 
	M.CODE [Sabit Kıymet Kodu],
	M.NAME [Sabit Kıymet Adı], 
	EX.FIELDCONT [İngilizce Açıklama],
	M.SPECODE [ÖzelKod1],
	M.SPECODE3 [ÖzelKod2],
	M.SPECODE3 [ÖzelKod3],
	M.SPECODE4 [ÖzelKod4],
	M.SPECODE5 [ÖzelKod5],
	FG.REGCODE [Kayıt Kodu],
	FG.INVALUE [Giriş Maliyeti],
	FG.DEPRDUR [Amortisman Süresi],
	FG.DEPRRATE [Amortisman Oranı],
	FY.CALCMON [Ay],
	FY.YEAR_ [Yıl],
	FY.LOCFIGS2_PERDDEPR [Dönem Amortismanı],
	FG.DATEIN [Giriş Tarihi],
	FY.LOCFIGS_ACCDEPREOY [Toplam Birikmiş Amortisman],
	T.ONHAND [Miktar],
	I.FICHENO [Alım FaturaNo],
	C.DEFINITION_ [Cari Hesap Ünvanı],
	Case When C.ISPERSCOMP=1 Then C.TCKNO Else C.TAXNR End [Vergi No],
	C.TAXOFFICE [Vergi Dairesi],
	L.VATAMNT [KDV Tutarı],
	L.VAT [KDV Oranı],
	E.FICHENO [Mahsup FişNo],
	E.DATE_ [Mahsup Tarihi],
	M1.CODE [Alımlar Hesabı],
	M2.CODE [Gider Hesabı],
	M3.CODE [Birikmiş Amortisman Hesabı]
From 
	LG_072_ITEMS M
	Inner Join LG_072_FAREGIST FG On FG.CRDREF=M.LOGICALREF
	Inner Join LG_072_FAYEAR FY On FY.FREGREF=FG.LOGICALREF
	Left Join LG_072_LNGEXCSETS EX On EX.DOCREF=M.LOGICALREF And EX.LANGID=2
	Left Join LV_072_01_GNTOTST T On T.STOCKREF=M.LOGICALREF And T.INVENNO=-1
	Left Join LG_072_01_STLINE L On L.FAREGREF=FG.LOGICALREF And L.TRCODE=1
	Left Join LG_072_01_INVOICE I On I.LOGICALREF=L.INVOICEREF
	Left Join LG_072_CLCARD C On C.LOGICALREF=I.CLIENTREF
	Left Join LG_072_01_EMFICHE E On E.LOGICALREF=I.ACCFICHEREF
	Left Join LG_072_CRDACREF A1 On A1.CARDREF=M.LOGICALREF And	A1.TRCODE=2 And A1.TYP=1
	Left Join LG_072_EMUHACC M1 On M1.LOGICALREF=A1.ACCOUNTREF
	Left Join LG_072_CRDACREF A2 On A2.CARDREF=M.LOGICALREF And	A2.TRCODE=2 And A2.TYP=20
	Left Join LG_072_EMUHACC M2 On M2.LOGICALREF=A2.ACCOUNTREF
	Left Join LG_072_CRDACREF A3 On A3.CARDREF=M.LOGICALREF And	A3.TRCODE=2 And A3.TYP=23
	Left Join LG_072_EMUHACC M3 On M3.LOGICALREF=A3.ACCOUNTREF
Where 
	M.CARDTYPE=4 
	And FY.TABLETY=0