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