USP_DATALIST_PDACCOUNTCODEMAPTREASURYFOREIGNCURRENCY

Returns a list of account code mappings for Foreign Currency in the Business office.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPTREASURYFOREIGNCURRENCY
(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select  ID,
    dbo.UFN_PDACCOUNTCODEMAPPAYMENTMETHODTYPE_TYPENAMESTRING ('403376F5-2D08-44ff-BCAE-7EA5F40AA237', PAYMENTMETHOD) TYPE,
  dbo.UFN_PDACCOUNTCODEMAPFOREIGNCURRENCY_NAMESTRING(ID) CURRENCY,
    dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER(CREDITGLACCOUNTID) CREDITACCOUNT,
   (select SHORTDESCRIPTION from PDACCOUNTSEGMENTVALUE where ID = CREDITPDACCOUNTSEGMENTVALUEID)  CREDITCODE

    from dbo.PDACCOUNTCODEMAPPING
    where PDACCOUNTCODEMAPOFFICEID = '403376F5-2D08-44ff-BCAE-7EA5F40AA237' 
    and PDACCOUNTSYSTEMID = @CONTEXTID