USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTAUCTIONDONATION

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

                select  
                    ID,
                    dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('EA277BDE-867E-4198-A38E-6FB2F972FD32', 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 = 'EA277BDE-867E-4198-A38E-6FB2F972FD32' and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID