USP_DATAFORMTEMPLATE_ADD_ACCOUNTINGELEMENTSECURITYGROUPELEMENTSFORM_PRELOAD

The load procedure used by the edit dataform template "Accounting Element Security Group Elements Add Data Form"

Parameters

Parameter Parameter Type Mode Description
@GROUPID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@RECORDTYPEID uniqueidentifier INOUT

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ACCOUNTINGELEMENTSECURITYGROUPELEMENTSFORM_PRELOAD
          (
            @GROUPID uniqueidentifier ,
            @RECORDTYPEID uniqueidentifier = null output
          )
          as
              set nocount on;

            select @RECORDTYPEID = ID from dbo.RECORDTYPE
            where upper(NAME) = 'ACCOUNTING ELEMENT'

            return 0;