USP_DATAFORMTEMPLATE_ADD_FORM1099MISCPROCESSTEMPLATE

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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
@CREATETESTFILE	bit	IN	Create test file
@CREATECOMBINEDFEDERALSTATE	bit	IN	Create combined federal/state 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_ADD_FORM1099MISCPROCESSTEMPLATE
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100) = '',
    @DESCRIPTION nvarchar(100) = '',
    @TAXYEAR nvarchar(4) = '',
    @CORRECTEDRETURN bit = 0,
    @PAYERNAME nvarchar(80) = '',
    @CONTACTNAME nvarchar(40) = '',
    @PHONENUMBER nvarchar(25) = '',
    @EMAIL nvarchar(50) = '',
    @CREATE1099FILEFOREFILE bit = 0,
    @TRANSMITTERCODE nvarchar(5) = '',
    @CREATETESTFILE bit = 0,
    @CREATECOMBINEDFEDERALSTATE bit = 0,
    @MARKPRIORYEARDATA bit = 0,
    @FILTERCODE tinyint = 0,
    @IDSETREGISTERID uniqueidentifier = null,
    @INCLUDEACTIVITYBELOWMINIMUMS bit = 0,
    @INCLUDE1099VENDORSWITHNOACTIVITY bit = 0,
    @CREATESELECTIONFROMRESULT bit = 0,
    @OUTPUTIDSETNAME nvarchar(100) = '',
    @OVERWRITEOUTPUTIDSET bit = 0
)
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

    if @FILTERCODE = 0
        set @IDSETREGISTERID = null;

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

    -- handle inserting the data

    insert into dbo.IRSFORM1099MISCPROCESSTEMPLATE
        (ID
        ,NAME
        ,DESCRIPTION
        ,TAXYEAR
        ,CORRECTEDRETURN
        ,PAYERNAME
        ,CONTACTNAME
        ,PHONENUMBER
        ,EMAIL
        ,CREATE1099FILEFOREFILE
        ,TRANSMITTERCODE
        ,CREATETESTFILE
        ,CREATECOMBINEDFEDERALSTATE
        ,MARKPRIORYEARDATA
        ,FILTERCODE
        ,IDSETREGISTERID
        ,INCLUDEACTIVITYBELOWMINIMUMS
        ,INCLUDE1099VENDORSWITHNOACTIVITY
        ,CREATESELECTIONFROMRESULT
        ,OUTPUTIDSETNAME
        ,OVERWRITEOUTPUTIDSET
        ,ADDEDBYID
        ,CHANGEDBYID
        ,DATEADDED
        ,DATECHANGED)
    values
        (@ID
        ,@NAME
        ,@DESCRIPTION
        ,@TAXYEAR
        ,@CORRECTEDRETURN
        ,@PAYERNAME
        ,@CONTACTNAME
        ,@PHONENUMBER
        ,@EMAIL
        ,@CREATE1099FILEFOREFILE
        ,@TRANSMITTERCODE
        ,@CREATETESTFILE
        ,@CREATECOMBINEDFEDERALSTATE
        ,@MARKPRIORYEARDATA
        ,@FILTERCODE
        ,@IDSETREGISTERID
        ,@INCLUDEACTIVITYBELOWMINIMUMS
        ,@INCLUDE1099VENDORSWITHNOACTIVITY
        ,@CREATESELECTIONFROMRESULT
        ,@OUTPUTIDSETNAME
        ,@OVERWRITEOUTPUTIDSET
        ,@CHANGEAGENTID
        ,@CHANGEAGENTID
        ,@CURRENTDATE
        ,@CURRENTDATE)

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0