Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' Name of 1099 form template.
 DESCRIPTION nvarchar(100)   Default = '' Description of 1099 from template.
 TAXYEAR nvarchar(4)   Default = '' Tax year for process.
 CORRECTEDRETURN bit   Default = 0 Is payer filing a 1099 corection.
 PAYERNAME nvarchar(80)   Default = '' Name of organization or individual filing the 1099 form.
 CONTACTNAME nvarchar(40)   Default = '' Name of contact person for payer/filer.
 PHONENUMBER nvarchar(25)   Default = '' Contact number for payer/filer.
 EMAIL nvarchar(50)   Default = '' Email address for contact person.
 CREATE1099FILEFOREFILE bit   Default = 0 Payer wants to prepare an e-file to send to the IRS.
 TRANSMITTERCODE nvarchar(5)   Default = '' The transmitter code assigned to payer by the IRS.
 CREATETESTFILE bit   Default = 0 Payer wants to create a test file.
 CREATECOMBINEDFEDERALSTATE bit   Default = 0 Payer is participating in the combined federal/state filing.
 MARKPRIORYEARDATA bit   Default = 0 1099 being generated is for a previous year.
 FILTERCODE tinyint   Default = 0 Type of vendor filter to use in the process.
 INCLUDEACTIVITYBELOWMINIMUMS bit   Default = 0 Payer wants to include amounts for box number with totals below the required minimum.
 INCLUDE1099VENDORSWITHNOACTIVITY bit   Default = 0 Payer wants to generate 1099 forms for vendors with no activity.
 CREATESELECTIONFROMRESULT bit   Default = 0 Allows the user to set Selection type and Selection name.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the 1099 misc form process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 FILTER nvarchar(16) (Computed) CASE [FILTERCODE] WHEN 0 THEN N'All vendors' WHEN 1 THEN N'Selected vendors' END Provides a translation for the 'FILTERCODE' field.

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID Vendor selection
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_IRSFORM1099MISCPROCESSTEMPLATE_DATEADDED DATEADDED    
 IX_IRSFORM1099MISCPROCESSTEMPLATE_DATECHANGED DATECHANGED      
 PK_IRSFORM1099MISCPROCESSTEMPLATE ID  
 UC_IRSFORM1099MISCPROCESSTEMPLATE_NAME NAME    

Trigger Name Description
 TR_IRSFORM1099MISCPROCESSTEMPLATE_AUDIT_UPDATE
 TR_IRSFORM1099MISCPROCESSTEMPLATE_AUDIT_DELETE

Referenced by Field
 IRSFORM1099MISCPROCESSTEMPLATEEXPORTFORMAT PARAMETERSETID
 IRSFORM1099MISCPROCESSTEMPLATESTATUS PARAMETERSETID

Entity-Relationship diagram of this table