| Table: dbo.Form_1099_Misc_Option | |||
| The specific options for printing a 1099 MISC form. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the parent 1099 print options row. |
| is_direct_sales_of_5000_or_more | bit (1) | NOT NULL | 1099 MISC form property |
| is_second_incorrect_recipient_tin_notification | bit (1) | NOT NULL | 1099 MISC form property |
| 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. | |
| 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_direct_sales_of_5000_or_more_original_override | bit (1) | Original override of whether is direct sales of 5000 or more. | |
| 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_direct_sales_of_5000_or_more_corrected_override | bit (1) | Corrected override of whether is direct sales of 5000 or more. | |
| 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. | |
| foreign_country_or_us_possession | nvarchar (256) | NOT NULL | 1099 MISC option: foreign country or US possession. |
| foreign_country_or_us_possession_override | nvarchar (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_override | nvarchar (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_override | nvarchar (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_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_Misc_Option$form_1099_KEY | form_1099_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Form_1099_Misc_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) | |