UFN_BENEFIT_GETGLDISTRIBUTION2

Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
Definition

Copy


create function dbo.UFN_BENEFIT_GETGLDISTRIBUTION2(@REVENUEID uniqueidentifier) 
            returns table
            as
      return (
                    select 
                        BENEFITGLDISTRIBUTION.ID, 
                        BENEFITGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                        BENEFITGLDISTRIBUTION.TRANSACTIONTYPECODE,
                        BENEFITGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT,
                        BENEFITGLDISTRIBUTION.ACCOUNT, 
                        BENEFITGLDISTRIBUTION.PROJECT, 
                        BENEFITGLDISTRIBUTION.AMOUNT, 
                        BENEFITGLDISTRIBUTION.REFERENCE,
                        BENEFITGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        BENEFITGLDISTRIBUTION.BASECURRENCYID,
                        BENEFITGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        BENEFITGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        BENEFITGLDISTRIBUTION.BASEEXCHANGERATEID,
                        BENEFITGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID,
                        BENEFITGLDISTRIBUTION.REVENUEBENEFITID
                    from 
                        dbo.BENEFITGLDISTRIBUTION  
                        join GLTRANSACTION  on BENEFITGLDISTRIBUTION.GLTRANSACTIONID = GLTRANSACTION.ID
                    where 
                        REVENUEID = @REVENUEID
                        and BENEFITGLDISTRIBUTION.BENEFITTYPECODE = 1
                        and OUTDATED = 0 and (GLTRANSACTION.POSTSTATUSCODE = 0  or  exists(select * from BENEFITADJUSTMENT where REVENUEID = @REVENUEID ))
            )