USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENT_COMMITMENTREVALUATIONCURRENCY

Returns a list of account code mappings for commitment revaluation currency gain/loss 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_PDACCOUNTCODEMAPDEVELOPMENT_COMMITMENTREVALUATIONCURRENCY(
                    @ID uniqueidentifier
                )
                as
                    set nocount on;

                    select  
                        PDACCOUNTCODEMAPPING.ID,
                        dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('C256C03B-8FD7-4D16-B6C3-5C2C05D7FA92', PDACCOUNTCODEMAPPING.PAYMENTMETHOD) TYPE,
                        dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING ('C256C03B-8FD7-4D16-B6C3-5C2C05D7FA92', PDACCOUNTCODEMAPPING.REVENUETYPE) REVENUETYPE,
                        dbo.UFN_PDACCOUNTCODEMAPFOREIGNCURRENCY_NAMESTRING(PDACCOUNTCODEMAPPING.ID) CURRENCY,
                        dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(PDACCOUNTCODEMAPPING.DEBITGLACCOUNTID) DEBITACCOUNT,
                        DEBITVALUE.SHORTDESCRIPTION as DEBITCODE,
                        dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(PDACCOUNTCODEMAPPING.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 = 'C256C03B-8FD7-4D16-B6C3-5C2C05D7FA92'
                        and PDACCOUNTCODEMAPPING.PDACCOUNTSYSTEMID = @ID
                    order by 
                        TYPE, REVENUETYPE;