USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTGIFTAIDS2

Returns a list of account code mappings for Gift Aid 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_PDACCOUNTCODEMAPDEVELOPMENTGIFTAIDS2
    (
        @PDACCOUNTSYSTEMID uniqueidentifier
    )
    as
        set nocount on;

        select  ID,
      dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('46920386-2344-42C9-9572-192FBBF06E91', REVENUETYPE) REVENUETYPE,
        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

        from dbo.PDACCOUNTCODEMAPPING
        where PDACCOUNTCODEMAPOFFICEID = '46920386-2344-42C9-9572-192FBBF06E91' and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID