USP_DATALIST_PDACCOUNTCODEMAPSUBLEDGER2

Returns a list of mapped account code values.

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_PDACCOUNTCODEMAPSUBLEDGER2(@ID uniqueidentifier)
as
    set nocount on;

       select ID,
            SUBLEDGER,
            SUBLEDGERTYPE,
            DESCRIPTION,
            SITEID,
            @ID as ACCOUNTSYSTEMID
      from dbo.PDACCOUNTCODEMAPSUBLEDGER 
      where SUBLEDGERTYPE in (1,3,4)
union       
      select ID,
            SUBLEDGER,
            SUBLEDGERTYPE,
            DESCRIPTION,
            SITEID,
            @ID as ACCOUNTSYSTEMID
      from dbo.PDACCOUNTCODEMAPSUBLEDGER 
      where SUBLEDGERTYPE = 2 and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('BB1C17BC-9E0B-4683-B490-EE40D511FA05') = 1
      order by SUBLEDGER