USP_DATALIST_DESIGNATIONGLMAPPING

Returns a list of the types of GL mapping and their 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_DESIGNATIONGLMAPPING (@ID uniqueidentifier)
                as 
                    set nocount on;

                    select 'Account number', ACCOUNTNUMBER from dbo.DESIGNATION where ID = @ID
                        union all
                    select 'Project code', PROJECTCODE from dbo.DESIGNATION where ID = @ID