UFN_SALESORDER_VALIDCONTACTRELATIONSHIP

Determines if the relationship on the sales order is a valid contact relationship for the constituent on the order.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@RELATIONSHIPID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SALESORDER_VALIDCONTACTRELATIONSHIP
            (
                @ID uniqueidentifier,
                @RELATIONSHIPID uniqueidentifier
            )
            returns bit as
            begin
                declare @CONSTITUENTID uniqueidentifier;
                declare @CONTACTRELATIONSHIPID uniqueidentifier;

                select
                    @CONSTITUENTID = CONSTITUENTID,
                    @CONTACTRELATIONSHIPID = CONTACTRELATIONSHIPID
                from
                    dbo.SALESORDER
                where
                    ID = @ID;

                return dbo.UFN_RELATIONSHIP_ISCURRENTCONTACT(@CONTACTRELATIONSHIPID, @CONSTITUENTID);
            end