USP_DATAFORMTEMPLATE_EDIT_FORM1099MISCPROCESSTEMPLATE

The save procedure used by the edit dataform template "IRS Form 1099 MISC Process Template Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(100)	IN	Description
@TAXYEAR	nvarchar(4)	IN	Tax year
@CORRECTEDRETURN	bit	IN	Corrected return
@PAYERNAME	nvarchar(80)	IN	Payer/filer name
@CONTACTNAME	nvarchar(40)	IN	Contact name
@PHONENUMBER	nvarchar(25)	IN	Phone number
@EMAIL	nvarchar(50)	IN	Email address
@CREATE1099FILEFOREFILE	bit	IN	Create 1099 file for electronic filing
@TRANSMITTERCODE	nvarchar(5)	IN	Transmitter code
@CREATECOMBINEDFEDERALSTATE	bit	IN	Create combined federal/state file
@CREATETESTFILE	bit	IN	Create test file
@MARKPRIORYEARDATA	bit	IN	Mark prior year data indicator
@FILTERCODE	tinyint	IN	Report:
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@INCLUDEACTIVITYBELOWMINIMUMS	bit	IN	Include activity below minimums
@INCLUDE1099VENDORSWITHNOACTIVITY	bit	IN	Include 1099 vendors with no activity
@CREATESELECTIONFROMRESULT	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FORM1099MISCPROCESSTEMPLATE (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(100),
    @TAXYEAR nvarchar(4),
    @CORRECTEDRETURN bit,
    @PAYERNAME nvarchar(80),
    @CONTACTNAME nvarchar(40),
    @PHONENUMBER nvarchar(25),
    @EMAIL nvarchar(50),
    @CREATE1099FILEFOREFILE bit,
    @TRANSMITTERCODE nvarchar(5),
    @CREATECOMBINEDFEDERALSTATE bit,
    @CREATETESTFILE bit,
    @MARKPRIORYEARDATA bit,
    @FILTERCODE tinyint,
    @IDSETREGISTERID uniqueidentifier,
    @INCLUDEACTIVITYBELOWMINIMUMS bit,
    @INCLUDE1099VENDORSWITHNOACTIVITY bit,
    @CREATESELECTIONFROMRESULT bit,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try

        if @FILTERCODE = 0
            set @IDSETREGISTERID = null;

        if @CREATESELECTIONFROMRESULT = 0
        begin
            set @OUTPUTIDSETNAME = '';
            set @OVERWRITEOUTPUTIDSET = 0;
        end

        -- handle updating the data

        update dbo.IRSFORM1099MISCPROCESSTEMPLATE set
            NAME = @NAME,
            DESCRIPTION = @DESCRIPTION,
            TAXYEAR = @TAXYEAR,
            CORRECTEDRETURN = @CORRECTEDRETURN,
            PAYERNAME = @PAYERNAME,
            CONTACTNAME = @CONTACTNAME,
            PHONENUMBER = @PHONENUMBER,
            EMAIL = @EMAIL,
            CREATE1099FILEFOREFILE = @CREATE1099FILEFOREFILE,
            TRANSMITTERCODE = @TRANSMITTERCODE,
            CREATETESTFILE = @CREATETESTFILE,
            CREATECOMBINEDFEDERALSTATE = @CREATECOMBINEDFEDERALSTATE,
            MARKPRIORYEARDATA = @MARKPRIORYEARDATA, 
            FILTERCODE = @FILTERCODE,
            IDSETREGISTERID = @IDSETREGISTERID,
            INCLUDEACTIVITYBELOWMINIMUMS = @INCLUDEACTIVITYBELOWMINIMUMS,
            INCLUDE1099VENDORSWITHNOACTIVITY  = @INCLUDE1099VENDORSWITHNOACTIVITY,
            CREATESELECTIONFROMRESULT = @CREATESELECTIONFROMRESULT,
            OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
            OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,    
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;