CREATE VIEW dbo.DEPO_YAZDIRMA_LISTESI_BAKIYE
AS
SELECT        LOGICALREF, FICHENO, DATE_, CODE, DEFINITION_, ITMCODE, ITMNAME, MARKA, ISONR, RAF, AMOUNT, ROW_NUMBER() OVER (PARTITION BY LOGICALREF
ORDER BY STLLOGREF) AS SIRA
FROM            dbo.DEPO_FIS_MALZEME_LISTESI_BAKIYE