USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENT_INTERCURRENCY

Returns a list of account code mappings for intercurrency 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_INTERCURRENCY
(
  @ID uniqueidentifier
)
as
    set nocount on;

    select ID
    ,dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(DEBITGLACCOUNTID) ACCOUNT
    ,(select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = DEBITPDACCOUNTSEGMENTVALUEID)  ACCOUNTCODE
    from dbo.PDACCOUNTCODEMAPPING
  where PDACCOUNTCODEMAPOFFICEID = '6869C589-0842-4280-8C00-E8DA6B4AB6FA'
    and PDACCOUNTCODEMAPPING.PDACCOUNTSYSTEMID = @ID
  order by ACCOUNT, ACCOUNTCODE