USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPLEDGES2

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

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPLEDGES2
    (
        @ID uniqueidentifier
    )
as
    set nocount on;

    select  ID,
    dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('4C565937-8A30-42D0-A0FC-64D269DBC898', REVENUETYPE) REVENUETYPE,
    case when (REVENUETYPE & 11)<>0 then dbo.UFN_PDACCOUNTCODEMAPPLEDGESUBTYPE_TYPENAMESTRING (PDACCOUNTCODEMAPPING.ID) else null end SUBTYPE,
    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,
    case when (REVENUETYPE & 4)<>0 then dbo.UFN_PDACCOUNTCODEMAPWRITEOFFREASONCODES_NAMESTRING (PDACCOUNTCODEMAPPING.ID) else null end REASONCODES

    from dbo.PDACCOUNTCODEMAPPING
    where PDACCOUNTCODEMAPOFFICEID = '4C565937-8A30-42D0-A0FC-64D269DBC898'
    and PDACCOUNTCODEMAPPING.PDACCOUNTSYSTEMID = @ID