Table: dbo.Form_1099_Patr_Option
Detailed options for 1099-PATR form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
is_second_irs_notification_incorrect_recipient_tinbit (1)NOT NULLForm 1099-PATR option: second irs notification incorrect recipiant tin
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_second_irs_notification_incorrect_recipient_tin_original_overridebit (1)Original override of whether it is the second irs notification of incorrect recipent tin.
is_second_irs_notification_incorrect_recipient_tin_corrected_overridebit (1)Corrected override of whether it is the second irs notification of incorrect recipent tin.
specified_cooperativesbit (1)NOT NULLThis relates to an IRS requirement called Specified Cooperatives. New for 2020+. 1 = checked and 0 = blank. This relates directly to the Enter Transactions option dialog.
specified_cooperatives_overridebit (1)This relates to an IRS requirement called Specified Cooperatives. New for 2020+. 1 = checked and 0 = blank. This relates to the Edit Payroll Tax Forms Recipient Data Tab screen.
specified_cooperatives_original_overridebit (1)This relates to an IRS requirement called Specified Cooperatives. New for 2020+. 1 = checked and 0 = blank. This relates to the Edit Payroll Tax Forms Original Recipient Data Tab screen.
specified_cooperatives_corrected_overridebit (1)This relates to an IRS requirement called Specified Cooperatives. New for 2020+. 1 = checked and 0 = blank. This relates to the Edit Payroll Tax Forms Corrected Recipient Data Tab screen.
Primary key
NameColumnsDescription
PK_Form_1099_Patr_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_Patr_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram