UFN_DSQL_JOURNALENTRYFROMACCOUNTSTRUCTURE

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_JOURNALENTRYFROMACCOUNTSTRUCTURE] (@ID as uniqueidentifier)
returns nvarchar(max)
as
begin    
    declare @COLUMN as int;
    select @COLUMN = SEGMENTCOLUMN 
        from 
            ACCOUNTSTRUCTURE as GAS 
        where GAS.ID=@ID;

    declare @v as nvarchar(max)
set @v=N'select DATAELEMENT ' + cast(@COLUMN as nvarchar(3)) + 'ID as DATAELEMENTID,* from JOURNALENTRY'
    return @v
end