Table: dbo.Form_1099_Patr_Option | |||
Detailed options for 1099-PATR form | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table |
is_second_irs_notification_incorrect_recipient_tin | bit (1) | NOT NULL | Form 1099-PATR option: second irs notification incorrect recipiant tin |
is_second_irs_notification_incorrect_recipient_tin_override | bit (1) | The override for whether the IRS should be notified about a recipient's second TIN. | |
is_second_irs_notification_incorrect_recipient_tin_original_override | bit (1) | Original override of whether it is the second irs notification of incorrect recipent tin. | |
is_second_irs_notification_incorrect_recipient_tin_corrected_override | bit (1) | Corrected override of whether it is the second irs notification of incorrect recipent tin. | |
specified_cooperatives | bit (1) | NOT NULL | This 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_override | bit (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_override | bit (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_override | bit (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 | |||
Name | Columns | Description | |
PK_Form_1099_Patr_Option$form_1099_KEY | form_1099_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Form_1099_Patr_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |