Table: dbo.Form_1099_Misc_Option
The specific options for printing a 1099 MISC form.
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the parent 1099 print options row.
is_direct_sales_of_5000_or_morebit (1)NOT NULL1099 MISC form property
is_second_incorrect_recipient_tin_notificationbit (1)NOT NULL1099 MISC form property
is_direct_sales_of_5000_or_more_overridebit (1)The override for whether or not the recipient made direct sales of 5000 or more of consumer products.
is_second_irs_notification_incorrect_recipient_tin_overridebit (1)The override for whether the IRS should be notified about a recipient's second TIN.
is_direct_sales_of_5000_or_more_original_overridebit (1)Original override of whether is direct sales of 5000 or more.
is_second_irs_notification_incorrect_recipient_tin_original_overridebit (1)Original override of whether it is the second irs notification of incorrect recipent tin.
is_direct_sales_of_5000_or_more_corrected_overridebit (1)Corrected override of whether is direct sales of 5000 or more.
is_second_irs_notification_incorrect_recipient_tin_corrected_overridebit (1)Corrected override of whether it is the second irs notification of incorrect recipent tin.
foreign_country_or_us_possessionnvarchar (256)NOT NULL1099 MISC option: foreign country or US possession.
foreign_country_or_us_possession_overridenvarchar (256)The override for the recipients foreign country or US possession. Null indicates that the value is not overridden
foreign_country_or_us_possession_original_overridenvarchar (256)The original value override for the recipients foreign country or US possession when doing 1099 corrected. Null indicates that the value is not overridden
foreign_country_or_us_possession_corrected_overridenvarchar (256)The corrected value override for the recipients foreign country or US possession when doing 1099 corrected. Null indicates that the value is not overridden
fatca_filing_requirementbit (1)NOT NULLWhether or not the foreign account tax compliance act flag is set.
fatca_filing_requirement_overridebit (1)User override to the fatca_filing_requirement column. Null indicates not overridden.
fatca_filing_requirement_original_overridebit (1)Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
fatca_filing_requirement_corrected_overridebit (1)Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
Primary key
NameColumnsDescription
PK_Form_1099_Misc_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_Misc_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram