CREATE VIEW dbo.BAKIYE_SIPARIS_LISTESI
AS
SELECT        STOCKREF, CLIENTREF, LOGICALREF, ORDFICHEREF, AMOUNT, SHIPPEDAMOUNT, AMOUNT - SHIPPEDAMOUNT AS BAKIYE
FROM            dbo.LG_011_07_ORFLINE
WHERE        (TRCODE = 1) AND (AMOUNT > SHIPPEDAMOUNT) AND (CANCELLED = 0) AND (LINETYPE = 0)