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