UFN_PDACCOUNT_GETMERCHANDISEDEPARTMENT

Returns the merchandise department of the merchandise product instance on a given revenue split.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@REVENUESPLITID uniqueidentifier IN
@REVENUETRANSACTIONTYPECODE tinyint IN
@APPLICATIONCODE tinyint IN
@PAYMENTMETHODCODE tinyint IN
@DESIGNATIONID uniqueidentifier IN

Definition

Copy 


create function dbo.UFN_PDACCOUNT_GETMERCHANDISEDEPARTMENT
(
    @REVENUESPLITID uniqueidentifier,
    @REVENUETRANSACTIONTYPECODE tinyint,
    @APPLICATIONCODE tinyint,
    @PAYMENTMETHODCODE tinyint,
    @DESIGNATIONID uniqueidentifier
)
returns uniqueidentifier
as begin
    declare @MERCHANDISEDEPARTMENTID uniqueidentifier;

    select
        @MERCHANDISEDEPARTMENTID = MERCHANDISEPRODUCT.MERCHANDISEDEPARTMENTID
    from
        dbo.REVENUESPLITORDER
    inner join
        dbo.MERCHANDISEPRODUCTINSTANCE on MERCHANDISEPRODUCTINSTANCE.ID = REVENUESPLITORDER.MERCHANDISEPRODUCTINSTANCEID
    inner join
        dbo.MERCHANDISEPRODUCT on MERCHANDISEPRODUCT.ID = MERCHANDISEPRODUCTINSTANCE.MERCHANDISEPRODUCTID
    where
        REVENUESPLITORDER.ID = @REVENUESPLITID;

    return @MERCHANDISEDEPARTMENTID;
end