SQL Sorgu Satın Alma İndirimleri

SELECT
    INV.DATE_ AS 'FATURA TARİHİ',
    INV.FICHENO AS 'FATURA NO',
    CL.CODE AS  'CARİ KODU',
    CL.DEFINITION_ AS 'CARİ AÇIKLAMASI',
    IT.CODE AS 'STOK KODU',
    IT.NAME AS 'STOK AÇIKLAMASI',
    ST.AMOUNT AS 'MİKTAR',
    ST.PRICE AS 'BİRİM FİYAT',
    (ST.LINENET/ST.AMOUNT) AS 'NET BİRİM FİYAT',
    ST.LINENET AS 'NET FİYAT',
    (((ST.PRICE/100)*(ST.LINENET/ST.AMOUNT)-1)*100) AS 'İSKONTO ORANI'
FROM LG_607_01_STLINE AS ST
    LEFT OUTER JOIN LG_607_ITEMS as IT ON ST.STOCKREF=IT.LOGICALREF
    LEFT OUTER JOIN LG_607_CLCARD as CL ON ST.CLIENTREF=CL.LOGICALREF
    LEFT OUTER JOIN LG_607_01_INVOICE as INV ON ST.INVOICEREF=INV.LOGICALREF
WHERE ST.TRCODE=1 AND ST.LINETYPE=0