USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPAYMENT

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

Parameters

Parameter	Parameter Type	Mode	Description
@APPLICATIONTYPEID	uniqueidentifier	IN	Application type
@PAYMENTMETHODID	uniqueidentifier	IN	Payment method

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTPAYMENT
(
    @APPLICATIONTYPEID uniqueidentifier = null,
    @PAYMENTMETHODID uniqueidentifier = null
)
as
    set nocount on;

    select  PDACCOUNTCODEMAPPING.ID,
    dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('1A692E94-3214-44B8-A658-F2927230BC25', REVENUETYPE) REVENUETYPE,
    dbo.UFN_PDACCOUNTCODEMAPAPPLICATIONTYPE_TYPENAMESTRING ('1A692E94-3214-44B8-A658-F2927230BC25', APPLICATIONTYPE)    APPLICATIONTYPE,
    dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('1A692E94-3214-44B8-A658-F2927230BC25', PAYMENTMETHOD)    PAYMENTMETHOD,
    dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(DEBITGLACCOUNTID) DEBITACCOUNT,
    DEBITVALUE.SHORTDESCRIPTION as DEBITCODE,
    dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(CREDITGLACCOUNTID) CREDITACCOUNT,
    CREDITVALUE.SHORTDESCRIPTION as CREDITCODE
    from dbo.PDACCOUNTCODEMAPPING
        left join dbo.PDACCOUNTSEGMENTVALUE DEBITVALUE on DEBITPDACCOUNTSEGMENTVALUEID = DEBITVALUE.ID
        left join dbo.PDACCOUNTSEGMENTVALUE CREDITVALUE on CREDITPDACCOUNTSEGMENTVALUEID = CREDITVALUE.ID
    where PDACCOUNTCODEMAPOFFICEID = '1A692E94-3214-44B8-A658-F2927230BC25' and PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B' 
    and (@APPLICATIONTYPEID is null or (@APPLICATIONTYPEID in (select ID from dbo.PDACCOUNTCODEMAPAPPLICATIONTYPE a where (a.NAMEID & APPLICATIONTYPE) > 0)))
    and (@PAYMENTMETHODID is null or (@PAYMENTMETHODID in (select ID from dbo.PDACCOUNTCODEMAPPAYMENTMETHODTYPE p where (p.nameid & PAYMENTMETHOD) > 0)))