USP_DATAELEMENT_ADD

Adds a row to the accounting element parent table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@SHORTID	nvarchar(100)	IN
@DESCRIPTION	nvarchar(60)	IN
@TYPECODE	tinyint	IN
@PREVENTDATAENTRY	bit	IN
@PREVENTDATAENTRYBEFOREDATE	datetime	IN
@PREVENTDATAENTRYAFTERDATE	datetime	IN
@PREVENTPOST	bit	IN
@PREVENTPOSTBEFOREDATE	datetime	IN
@PREVENTPOSTAFTERDATE	datetime	IN
@GLACCOUNTSTRUCTUREID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAELEMENT_ADD
(
  @ID uniqueidentifier = null output,
  @SHORTID nvarchar(100) = null,
  @DESCRIPTION nvarchar(60) = null,
  @TYPECODE tinyint = 3,
  @PREVENTDATAENTRY bit = null ,
  @PREVENTDATAENTRYBEFOREDATE datetime = null ,
  @PREVENTDATAENTRYAFTERDATE datetime = null ,
  @PREVENTPOST bit = null ,
  @PREVENTPOSTBEFOREDATE datetime = null,
  @PREVENTPOSTAFTERDATE datetime = null,
  @GLACCOUNTSTRUCTUREID uniqueidentifier = null,
  @CHANGEAGENTID uniqueidentifier = null
)
as

  set nocount on;

  if @ID is null
    set @ID = newid()

  if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate()

  begin try
  insert into dbo.PDACCOUNTSEGMENTVALUE
      (ID, SHORTDESCRIPTION, DESCRIPTION, TYPECODE,PREVENTDATAENTRY,PREVENTDATAENTRYBEFOREDATE,PREVENTDATAENTRYAFTERDATE,PREVENTPOST,PREVENTPOSTBEFOREDATE,PREVENTPOSTAFTERDATE,PDACCOUNTSTRUCTUREID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
      (@ID, @SHORTID, @DESCRIPTION, @TYPECODE,@PREVENTDATAENTRY,@PREVENTDATAENTRYBEFOREDATE,@PREVENTDATAENTRYAFTERDATE,@PREVENTPOST,@PREVENTPOSTBEFOREDATE,@PREVENTPOSTAFTERDATE, @GLACCOUNTSTRUCTUREID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
  end try

  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

return 0;