UFN_ADJUSTMENTHISTORY_GETWRITEOFFDISTRIBUTION

            CREATE function dbo.UFN_ADJUSTMENTHISTORY_GETWRITEOFFDISTRIBUTION
            (
            )
            returns @RESULT table
            (
                ID nvarchar(36),
                ADJUSTMENTHISTORYWRITEOFFID uniqueidentifier,
                TYPECODE tinyint,
                TYPE nvarchar(20),
                TRANSACTIONTYPECODE tinyint,
                TRANSACTIONTYPE nvarchar(50),
                ACCOUNT nvarchar(100),
                PROJECT nvarchar(100),
                REFERENCE nvarchar(255),
                AMOUNT money
            )
            as
            begin
                declare @WRITEOFFID uniqueidentifier;
                declare @ADJUSTMENTHISTORYWRITEOFFID uniqueidentifier;

                declare NEEDSGLCURSOR cursor local fast_forward for
                    select
                        ADJUSTMENTHISTORYWRITEOFFID 
                    from @RESULT
                    where ADJUSTMENTHISTORYWRITEOFFID not in (select ADJUSTMENTHISTORYWRITEOFFID from @RESULT where TYPECODE = 1);

                insert into @RESULT(ID, ADJUSTMENTHISTORYWRITEOFFID, TYPECODE, TYPE, TRANSACTIONTYPECODE, TRANSACTIONTYPE, ACCOUNT, PROJECT, REFERENCE, AMOUNT)
                    select
                        cast(ID as nvarchar(36)),
                        ADJUSTMENTHISTORYWRITEOFFID,
                        TYPECODE,
                        TYPE,
                        TRANSACTIONTYPECODE,
                        TRANSACTIONTYPE,
                        ACCOUNT,
                        PROJECT,
                        REFERENCE,
                        AMOUNT
                    from dbo.ADJUSTMENTHISTORYWRITEOFFDISTRIBUTION;

                /*for all the adjustment write-off histories where the GL distribution hasn't been stored, return the calculated distribution*/
                open NEEDSGLCURSOR;
                    fetch next from NEEDSGLCURSOR into @ADJUSTMENTHISTORYWRITEOFFID;
                    while @@FETCH_STATUS = 0 
                    begin
                        /*this should be the case for undeleted write-off so find that write-off*/
                        select
                            @WRITEOFFID = WRITEOFFADJUSTMENT.WRITEOFFID
                        from dbo.WRITEOFFADJUSTMENT
                        inner join dbo.ADJUSTMENTHISTORYWRITEOFF on ADJUSTMENTHISTORYWRITEOFF.WRITEOFFADJUSTMENTID = WRITEOFFADJUSTMENT.ID
                        where ADJUSTMENTHISTORYWRITEOFF.ID = @ADJUSTMENTHISTORYWRITEOFFID

                        if not @WRITEOFFID is null /*if we couldn't find the write-off, there's no sense in finding its GL info*/
                            insert into @RESULT(ID, ADJUSTMENTHISTORYWRITEOFFID, TYPECODE, TYPE, TRANSACTIONTYPECODE, TRANSACTIONTYPE, ACCOUNT, PROJECT, REFERENCE, AMOUNT)
                                select
                                    cast(row_number() over (order by AMOUNT) as nvarchar(36)),
                                    @ADJUSTMENTHISTORYWRITEOFFID,
                                    1,
                                    'Adjustment',
                                    TRANSACTIONTYPECODE,
                                    DEBITCREDIT,
                                    ACCOUNT,
                                    PROJECT,
                                    REFERENCE,
                                    AMOUNT
                                from dbo.UFN_REVENUE_GETWRITEOFFGLDISTRIBUTION(@WRITEOFFID);

                        fetch next from NEEDSGLCURSOR into @ADJUSTMENTHISTORYWRITEOFFID;
                    end
                deallocate NEEDSGLCURSOR;

                return;
            end