UFN_ADJUSTMENTHISTORY_GETPROPERTYDISTRIBUTION

            CREATE function dbo.UFN_ADJUSTMENTHISTORY_GETPROPERTYDISTRIBUTION
            (
            )
            returns @RESULT table
            (
                ID nvarchar(36),
                ADJUSTMENTHISTORYPROPERTYID 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 @PROPERTYDETAILID uniqueidentifier;
                declare @ADJUSTMENTHISTORYPROPERTYID uniqueidentifier;

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

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

                /*for all the adjustmentpropertyhistories where the GL distribution hasn't been stored, return the calculated distribution*/
                open NEEDSGLCURSOR;
                    fetch next from NEEDSGLCURSOR into @ADJUSTMENTHISTORYPROPERTYID;
                    while @@FETCH_STATUS = 0 
                    begin
                        /*this should be the case for undeleted sold-property so find that sold-property*/
                        select
                            @PROPERTYDETAILID = PROPERTYDETAILADJUSTMENT.PROPERTYDETAILID
                        from dbo.PROPERTYDETAILADJUSTMENT
                        inner join dbo.ADJUSTMENTHISTORYPROPERTY on ADJUSTMENTHISTORYPROPERTY.PROPERTYDETAILADJUSTMENTID = PROPERTYDETAILADJUSTMENT.ID
                        where ADJUSTMENTHISTORYPROPERTY.ID = @ADJUSTMENTHISTORYPROPERTYID

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

                        fetch next from NEEDSGLCURSOR into @ADJUSTMENTHISTORYPROPERTYID;
                    end

                --When a cursor is used, it should be explicitly closed/deallocated in case of blocking or USP running long

                close NEEDSGLCURSOR;
                deallocate NEEDSGLCURSOR;

                return;
            end