UFN_QUERY_WRITEOFF_GETGLDISTRIBUTION

            CREATE function dbo.UFN_QUERY_WRITEOFF_GETGLDISTRIBUTION(
                @WRITEOFFID uniqueidentifier
            )
            returns @WRITEOFFGLDISTRIBUTION table
            (
                ID uniqueidentifier null,
                WRITEOFFID uniqueidentifier not null,
                TRANSACTIONTYPE nvarchar(20) not null,
                ACCOUNT nvarchar(100) not null,
                PROJECT nvarchar(100) null,
                AMOUNT money not null
            )
            as
            begin
                if @WRITEOFFID is null return;

                insert into @WRITEOFFGLDISTRIBUTION(
                    ID, 
                    WRITEOFFID, 
                    TRANSACTIONTYPE, 
                    ACCOUNT, 
                    PROJECT, 
                    AMOUNT
                )
                select 
                    ID, 
                    WRITEOFFID, 
                    TRANSACTIONTYPE, 
                    ACCOUNT, 
                    PROJECT, 
                    AMOUNT
                from dbo.WRITEOFFGLDISTRIBUTION
                where WRITEOFFID = @WRITEOFFID
                    and OUTDATED = 0;

                return;
            end