UFN_PLANNEDGIFTADDITION_GETDESIGNATIONS

Gets the designations linked to a planned gift addition

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTADDITIONID	uniqueidentifier	IN

Definition

Copy



          CREATE function dbo.UFN_PLANNEDGIFTADDITION_GETDESIGNATIONS
          (
            @PLANNEDGIFTADDITIONID uniqueidentifier
          )
          returns table
            as return (
              select
                PLANNEDGIFTADDITIONDESIGNATION.ID,
                PLANNEDGIFTADDITIONDESIGNATION.DESIGNATIONID,
                PLANNEDGIFTADDITIONDESIGNATION.AMOUNT,
                PLANNEDGIFTADDITIONDESIGNATION.SEQUENCE,
                PLANNEDGIFTADDITIONDESIGNATION.CATEGORYCODEID,
                PLANNEDGIFTADDITIONDESIGNATION.TYPECODEID,
                PLANNEDGIFTADDITIONDESIGNATION.USECODEID,
                PLANNEDGIFTADDITIONDESIGNATION.DATE,
                PLANNEDGIFTADDITIONDESIGNATION.BASECURRENCYID,
                PLANNEDGIFTADDITIONDESIGNATION.ORGANIZATIONAMOUNT,
                PLANNEDGIFTADDITIONDESIGNATION.ORGANIZATIONEXCHANGERATEID,
                PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONAMOUNT,
                PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONCURRENCYID,
                PLANNEDGIFTADDITIONDESIGNATION.BASEEXCHANGERATEID
              from dbo.PLANNEDGIFTADDITIONDESIGNATION
              left join dbo.DESIGNATION
                  on PLANNEDGIFTADDITIONDESIGNATION.DESIGNATIONID = DESIGNATION.ID
              where PLANNEDGIFTADDITIONDESIGNATION.PLANNEDGIFTADDITIONID = @PLANNEDGIFTADDITIONID);