Table: dbo.Form_1099_Div_Option
Detailed options for 1099-Div form
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table
foreign_country_or_us_posession | nvarchar (256) |  | Form 1099-Div option: foreign country/US posession
is_second_irs_notification_incorrect_recipient_tin | bit (1) | NOT NULL | Form 1099-DIV option: second irs notification incorrect recipiant tin
foreign_country_or_us_possession_override | nvarchar (256) |  | The override for the recipient's foreign country.
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.
foreign_country_or_us_possession_original_override | nvarchar (256) |  | Original override of the foreign country or us prossession.
is_second_irs_notification_incorrect_recipient_tin_original_override | bit (1) |  | Original override of whether it is ths second irs notification of incorrect recipient tin.
foreign_country_or_us_possession_corrected_override | nvarchar (256) |  | Corrected override of the foreign country or us prossession.
is_second_irs_notification_incorrect_recipient_tin_corrected_override | bit (1) |  | Corrected override of whether it is ths second irs notification of incorrect recipient tin.
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.

Primary key
Name | Columns | Description
PK_Form_1099_Div_Option$form_1099_KEY | form_1099_KEY |

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