USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTGIFTFEE

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@APPLICATIONTYPEID	uniqueidentifier	IN	Application type
@PAYMENTMETHODID	uniqueidentifier	IN	Payment method

Definition

Copy



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

                select
                    PDACCOUNTCODEMAPPING.ID,
                    dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('2DBCE41F-9A2C-4FED-9513-BC09CDE4496C', REVENUETYPE) REVENUETYPE,
                    dbo.UFN_PDACCOUNTCODEMAPAPPLICATIONTYPE_TYPENAMESTRING ('2DBCE41F-9A2C-4FED-9513-BC09CDE4496C', APPLICATIONTYPE)    APPLICATIONTYPE,
                    dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('2DBCE41F-9A2C-4FED-9513-BC09CDE4496C', 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 = '2DBCE41F-9A2C-4FED-9513-BC09CDE4496C' and 
                    PDACCOUNTCODEMAPPING.PDACCOUNTSYSTEMID = @ID 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)
                        )
                    )