UFN_REVENUE_GETTRANSACTIONCURRENCY

Returns the TransactionCurrencyID for a revenue record

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



    create function dbo.UFN_REVENUE_GETTRANSACTIONCURRENCY
        (
            @REVENUEID uniqueidentifier
        )
        returns uniqueidentifier
        as
        begin
            declare @TRANSACTIONCURRENCYID uniqueidentifier;

            select
                @TRANSACTIONCURRENCYID = REVENUE.TRANSACTIONCURRENCYID
            from
                dbo.REVENUE
            where
                REVENUE.ID = @REVENUEID;

            return @TRANSACTIONCURRENCYID;
        end