CREATE VIEW dbo.PLASIYER_IADE_DETAYLARI
AS
SELECT   CAST(STL.DATE_ AS DATE) AS TARIH, INV.FICHENO AS FATURANO, CC.CODE AS FKOD, CC.DEFINITION_ AS FUNVAN, ITM.CODE AS MKOD, ITM.NAME AS MACK, SLS.DEFINITION_, 
                         STL.VATAMNT + STL.LINENET AS TUTAR
FROM         dbo.LG_011_07_STLINE AS STL LEFT OUTER JOIN
                         dbo.LG_011_07_INVOICE AS INV ON INV.LOGICALREF = STL.INVOICEREF LEFT OUTER JOIN
                         dbo.LG_011_ITEMS AS ITM ON ITM.LOGICALREF = STL.STOCKREF LEFT OUTER JOIN
                         dbo.LG_011_CLCARD AS CC ON CC.LOGICALREF = STL.CLIENTREF LEFT OUTER JOIN
                         dbo.LG_SLSMAN AS SLS ON SLS.LOGICALREF = STL.SALESMANREF
WHERE     (STL.TRCODE = 3) AND (STL.CANCELLED = 0) AND (STL.LINETYPE = 0)