USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPLANNEDGIFTS2

Returns a list of account code mappings for Planned Gifts in the Development office.

Parameters

Parameter	Parameter Type	Mode	Description
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



    CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPLANNEDGIFTS2
    (
        @PDACCOUNTSYSTEMID uniqueidentifier
    )
    as
    set nocount on;

    select  ID,
    dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('40797EBA-446F-4C83-9907-D65FC38410E0', REVENUETYPE) REVENUETYPE,
    dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('40797EBA-446F-4C83-9907-D65FC38410E0', PAYMENTMETHOD) PAYMENTMETHOD,
    dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(DEBITGLACCOUNTID) DEBITACCOUNT,
    (select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = DEBITPDACCOUNTSEGMENTVALUEID)  DEBITCODE,
    dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(CREDITGLACCOUNTID) CREDITACCOUNT,
    (select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = CREDITPDACCOUNTSEGMENTVALUEID)  CREDITCODE,
    dbo.UFN_PDACCOUNTCODEMAPAPPLICATIONTYPE_TYPENAMESTRING ('40797EBA-446F-4C83-9907-D65FC38410E0', APPLICATIONTYPE) APPLICATIONTYPE
    from dbo.PDACCOUNTCODEMAPPING
    where PDACCOUNTCODEMAPOFFICEID = '40797EBA-446F-4C83-9907-D65FC38410E0' and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID