UFN_SALESORDER_REFUNDS

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_SALESORDER_REFUNDS(@ID uniqueidentifier)
returns table
as return
    select ID from dbo.CREDIT_EXT where SALESORDERID = @ID

    union
    select
        FT.ID
    from
        dbo.FINANCIALTRANSACTION as FT
    inner join
        dbo.SALESORDER on SALESORDER.REVENUEID = FT.PARENTID
    where
        SALESORDER.ID = @ID
        and FT.TYPECODE = 23  -- Refund