Table: dbo.Form_1099_G_Option | |||
Detailed options for 1099-G form | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table |
box_2_amount_tax_year | int (4) | Form 1099-G option: box 2 amount tax year | |
box_2_is_trade_or_business_income | bit (1) | NOT NULL | Form 1099-G option: box 2 is trade or business income |
box_2_amount_tax_year_override | int (4) | The override for the tax year for the recipient's tax refunds, credits, and offsets. | |
box_2_is_trade_or_business_income_override | bit (1) | The override for whether the recipient's tax refunds, credits, or offsets are trade or business income. | |
box_2_amount_tax_year_original_override | int (4) | Original override of box 2 amount. | |
box_2_is_trade_or_business_income_original_override | bit (1) | Original override of whether box 2 is trade or business income. | |
box_2_amount_tax_year_corrected_override | int (4) | Corrected override of box 2 amount. | |
box_2_is_trade_or_business_income_corrected_override | bit (1) | Corrected override of whether box 2 is trade or business income. | |
second_tin_notification | bit (1) | NOT NULL | Whether or not the second_tin_notification flag is set. |
second_tin_notification_override | bit (1) | User override to the second_tin_notification column. Null indicates not overridden. | |
second_tin_notification_original_override | bit (1) | Original override to the second_tin_notification column for corrected 1099s. Null indicates not overridden. | |
second_tin_notification_corrected_override | bit (1) | Corrected override to second_tin_notification column for corrected 1099s. Null indicates not overridden. |
Primary key | |||
Name | Columns | Description | |
PK_Form_1099_G_Option$form_1099_KEY | form_1099_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Form_1099_G_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |