USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTAUCTIONGAINLOSS

Returns a list of account code mappings for auction purchase gain\loss 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_PDACCOUNTCODEMAPDEVELOPMENTAUCTIONGAINLOSS
                (
                    @PDACCOUNTSYSTEMID uniqueidentifier
                )
                as
                set nocount on;

                select  
                    ID,
                    dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('C4021214-DBB2-4FED-9CB0-6286C0A2DCAC', REVENUETYPE) REVENUETYPE,
                    dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('C4021214-DBB2-4FED-9CB0-6286C0A2DCAC', PAYMENTMETHOD)    PAYMENTMETHOD,
                    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 = 'C4021214-DBB2-4FED-9CB0-6286C0A2DCAC'
                and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID