set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


create FUNCTION [dbo].[FunGoodLastFee](@Code int)
	
RETURNS money
AS
	BEGIN
	Declare @R money
SELECT     TOP (1) @R= Fee 
FROM         VWInvoiceDetailComplete
WHERE     (GoodSysCode = @code) AND (Amani = 1) AND (Type = 2) OR
                      (GoodSysCode = @code) AND (NOT (FK_DocsysCode IS NULL)) AND (Type = 2)
ORDER BY SysCode DESC
RETURN @R
	END