CREATE VIEW dbo.SATINALMA_FATURALARI_SATIR
AS
SELECT   ITM.CODE, ITM.NAME, ITM.EXPCTGNO AS BARKOD, STL.AMOUNT, STL.INVOICEREF
FROM         dbo.LG_011_08_STLINE AS STL LEFT OUTER JOIN
                         dbo.LG_011_ITEMS AS ITM ON ITM.LOGICALREF = STL.STOCKREF
WHERE     (STL.TRCODE = 1) AND (STL.LINETYPE = 0) AND (STL.CANCELLED = 0) AND (STL.BILLED = 1)