UFN_DSQL_JOURNALENTRYFROMDATAELEMENT

Returns as sql statement for all columns of JournalEntry plus one column called DATAELEMENTID for the account structure guid that was passed in.

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function [dbo].[UFN_DSQL_JOURNALENTRYFROMDATAELEMENT] (@ID as uniqueidentifier)
returns nvarchar(max)
as
begin    
    declare @COLUMN as int;
    select @COLUMN = SEGMENTCOLUMN 
        from 
            DATAELEMENT as DE
            inner join ACCOUNTSTRUCTURE as GAS on DE.GLACCOUNTSTRUCTUREID = GAS.ID
        where DE.ID=@ID;

    declare @v as nvarchar(max)
    set @v=N'select * from JOURNALENTRY where DATAELEMENT' + cast(@COLUMN as nvarchar(3)) + 'ID = @ID' --+ cast(@ID as nvarchar(700));

    return @v
end