Table: dbo.Form_1099_Nec_Option
The specific options related to a 1099 NEC form.
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary and Foreign Key.
fatca_filing_requirement | bit (1) | NOT NULL | Whether or not the foreign account tax compliance act flag is set.
fatca_filing_requirement_override | bit (1) |  | User override to the fatca_filing_requirement column. Null indicates not overridden.
fatca_filing_requirement_original_override | bit (1) |  | Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
fatca_filing_requirement_corrected_override | bit (1) |  | Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
is_second_irs_notification_incorrect_recipient_tin | bit (1) | NOT NULL | 1099 nec form property
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.
is_direct_sales_of_5000_or_more | bit (1) | NOT NULL | This relates to an IRS requirement called Payer made direct sales totaling $5,000 or more of["BR"] consumer products to recipient for resale. New for 2021. 1 = checked and 0 = blank. This relates directly to the Enter Transactions option dialog.
is_direct_sales_of_5000_or_more_override | bit (1) |  | The override for whether or not the recipient made direct sales of $5000 or more of consumer products. Null indicates not overridden.["BR"] New for 2021. 1 = checked and 0 = blank. This relates to the Edit Payroll Tax Forms Recipient Data Tab screen.
is_direct_sales_of_5000_or_more_original_override | bit (1) |  | Original override of whether is direct sales of $5000 or more. Null indicates not overridden.["BR"] New for 2021. 1 = checked and 0 = blank. This relates to the Edit Payroll Tax Forms Original Recipient Data Tab screen.
is_direct_sales_of_5000_or_more_corrected_override | bit (1) |  | Corrected override of whether is direct sales of $5000 or more. Null indicates not overridden.["BR"] New for 2021. 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_Nec_Option$form_1099_KEY | form_1099_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099_Nec_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |