USP_ACCOUNTINGELEMENTSECURITYGROUPELEMENT_DELETE_PROMPTDATA

Provides the prompt for the "Accounting Element Security Group Element: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Represents information to be displayed in the record operation prompt.
@NAME	nvarchar(10)	INOUT

Definition

Copy



              create procedure dbo.USP_ACCOUNTINGELEMENTSECURITYGROUPELEMENT_DELETE_PROMPTDATA
              (
                  @ID uniqueidentifier,
                  @NAME nvarchar(10) = null output
              )
              as begin
                  set nocount on;

                  select
                      @NAME = DATAELEMENT.SHORTID
                  from
                      dbo.DATAELEMENT
                inner join dbo.ACCOUNTINGELEMENTSECURITYGROUPELEMENT on DATAELEMENT.ID = ACCOUNTINGELEMENTSECURITYGROUPELEMENT.DATAELEMENTID
                  where
                      ACCOUNTINGELEMENTSECURITYGROUPELEMENT.ID = @ID

                  return 0;
              end