UFN_ACCOUNTHASELEMENTS

Returns 1 if the specified element IDs are defined on the selected account

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@ACCOUNTID	uniqueidentifier	IN
@ID1	uniqueidentifier	IN
@ID2	uniqueidentifier	IN
@ID3	uniqueidentifier	IN
@ID4	uniqueidentifier	IN
@ID5	uniqueidentifier	IN
@ID6	uniqueidentifier	IN
@ID7	uniqueidentifier	IN
@ID8	uniqueidentifier	IN
@ID9	uniqueidentifier	IN
@ID10	uniqueidentifier	IN
@ID11	uniqueidentifier	IN
@ID12	uniqueidentifier	IN
@ID13	uniqueidentifier	IN
@ID14	uniqueidentifier	IN
@ID15	uniqueidentifier	IN
@ID16	uniqueidentifier	IN
@ID17	uniqueidentifier	IN
@ID18	uniqueidentifier	IN
@ID19	uniqueidentifier	IN
@ID20	uniqueidentifier	IN
@ID21	uniqueidentifier	IN
@ID22	uniqueidentifier	IN
@ID23	uniqueidentifier	IN
@ID24	uniqueidentifier	IN
@ID25	uniqueidentifier	IN
@ID26	uniqueidentifier	IN
@ID27	uniqueidentifier	IN
@ID28	uniqueidentifier	IN
@ID29	uniqueidentifier	IN
@ID30	uniqueidentifier	IN

Definition

Copy



CREATE function [dbo].[UFN_ACCOUNTHASELEMENTS](
                    @ACCOUNTID uniqueidentifier = null,
                    @ID1 uniqueidentifier = null,
                    @ID2 uniqueidentifier = null,
                    @ID3 uniqueidentifier = null,
                    @ID4 uniqueidentifier = null,
                    @ID5 uniqueidentifier = null,
                    @ID6 uniqueidentifier = null,
                    @ID7 uniqueidentifier = null,
                    @ID8 uniqueidentifier = null,
                    @ID9 uniqueidentifier = null,
                    @ID10 uniqueidentifier = null,
                    @ID11 uniqueidentifier = null,
                    @ID12 uniqueidentifier = null,
                    @ID13 uniqueidentifier = null,
                    @ID14 uniqueidentifier = null,
                    @ID15 uniqueidentifier = null,
                    @ID16 uniqueidentifier = null,
                    @ID17 uniqueidentifier = null,
                    @ID18 uniqueidentifier = null,
                    @ID19 uniqueidentifier = null,
                    @ID20 uniqueidentifier = null,
                    @ID21 uniqueidentifier = null,
                    @ID22 uniqueidentifier = null,
                    @ID23 uniqueidentifier = null,
                    @ID24 uniqueidentifier = null,
                    @ID25 uniqueidentifier = null,
                    @ID26 uniqueidentifier = null,
                    @ID27 uniqueidentifier = null,
                    @ID28 uniqueidentifier = null,
                    @ID29 uniqueidentifier = null,
                    @ID30 uniqueidentifier = null) 
        returns bit AS 
    begin
        declare @count integer
        declare @found integer
        declare @bit bit
        set @bit=0
        set @count=0
        set @found=0
        if not @ACCOUNTID is null begin
            if not @ID1 is null begin set @count=@count+1 end
            if not @ID2 is null begin set @count=@count+1 end
            if not @ID3 is null begin set @count=@count+1 end
            if not @ID4 is null begin set @count=@count+1 end
            if not @ID5 is null begin set @count=@count+1 end
            if not @ID6 is null begin set @count=@count+1 end
            if not @ID7 is null begin set @count=@count+1 end
            if not @ID8 is null begin set @count=@count+1 end
            if not @ID9 is null begin set @count=@count+1 end
            if not @ID10 is null begin set @count=@count+1 end
            if not @ID11 is null begin set @count=@count+1 end
            if not @ID12 is null begin set @count=@count+1 end
            if not @ID13 is null begin set @count=@count+1 end
            if not @ID14 is null begin set @count=@count+1 end
            if not @ID15 is null begin set @count=@count+1 end
            if not @ID16 is null begin set @count=@count+1 end
            if not @ID17 is null begin set @count=@count+1 end
            if not @ID18 is null begin set @count=@count+1 end
            if not @ID19 is null begin set @count=@count+1 end
            if not @ID20 is null begin set @count=@count+1 end
            if not @ID21 is null begin set @count=@count+1 end
            if not @ID22 is null begin set @count=@count+1 end
            if not @ID23 is null begin set @count=@count+1 end
            if not @ID24 is null begin set @count=@count+1 end
            if not @ID25 is null begin set @count=@count+1 end
            if not @ID26 is null begin set @count=@count+1 end
            if not @ID27 is null begin set @count=@count+1 end
            if not @ID28 is null begin set @count=@count+1 end
            if not @ID29 is null begin set @count=@count+1 end
            if not @ID30 is null begin set @count=@count+1 end
            if @count>0 begin
                select @found=COUNT(DATAELEMENTID) FROM dbo.UFN_LEDGERACCOUNT_DATAELEMENTS(@ACCOUNTID) WHERE NOT DATAELEMENTID IS NULL AND DATAELEMENTID IN
                (@ID1,@ID2,@ID3,@ID4,@ID5,@ID6,@ID7,@ID8,@ID9,@ID10,@ID11,@ID12,@ID13,@ID14,@ID15,@ID16,@ID17,@ID18,@ID19,@ID20,@ID21,@ID22,@ID23,@ID24,@ID25,@ID26,@ID27,@ID28,@ID29,@ID30)
                if @found<@count begin
                    select @found=@found+COUNT(PDACCOUNTSEGMENTVALUE.ID) FROM PDACCOUNTSEGMENTVALUE INNER JOIN PDACCOUNTSTRUCTURE ON PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID=PDACCOUNTSTRUCTURE.ID AND PDACCOUNTSTRUCTURE.ELEMENTTYPECODE=2 WHERE PDACCOUNTSEGMENTVALUE.ID IN
                    (@ID1,@ID2,@ID3,@ID4,@ID5,@ID6,@ID7,@ID8,@ID9,@ID10,@ID11,@ID12,@ID13,@ID14,@ID15,@ID16,@ID17,@ID18,@ID19,@ID20,@ID21,@ID22,@ID23,@ID24,@ID25,@ID26,@ID27,@ID28,@ID29,@ID30)
                end
            end

        end
        if @found>=@count begin set @bit=1 end
        return @bit
    end