Table: dbo.Form_1099_S_Option | |||
Detailed options for 1099-S form | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table |
date_of_closing | datetime (8, 3) | Form 1099-S option: date of closing | |
property_or_services_part_of_consideration | bit (1) | NOT NULL | Form 1099-S option: property or services part of consideration |
description | nvarchar (256) | Form 1099-S option: description | |
address | nvarchar (256) | Form 1099-S option: address | |
city | nvarchar (256) | Form 1099-S option: city | |
zip | nvarchar (20) | Form 1099-S option: zip | |
state_abbreviation | nvarchar (4) | Form 1099-S option: state | |
date_of_closing_override | datetime (8, 3) | The override for the recipient's date of closing. | |
description_override | nvarchar (256) | The override for the recipient's 1099-S description. | |
address_override | nvarchar (256) | The override for the recipient's address_1. | |
city_override | nvarchar (256) | The override for the recipient's city. | |
state_abbreviation_override | nvarchar (4) | The override for the recipient's state. | |
zip_override | nvarchar (20) | The override for the recipient's postal code. | |
property_or_services_part_of_consideration_override | bit (1) | The override for whether or not the recipient received property as part of the consideration. | |
date_of_closing_original_override | datetime (8, 3) | Original override of date of closing. | |
description_original_override | nvarchar (256) | Original override of description. | |
address_original_override | nvarchar (256) | Original override of address. | |
city_original_override | nvarchar (256) | Original override of city. | |
state_abbreviation_original_override | nvarchar (4) | Original override of state. | |
zip_original_override | nvarchar (20) | Original override of zip. | |
property_or_services_part_of_consideration_original_override | bit (1) | Original override of whether property or services are part of consideration. | |
date_of_closing_corrected_override | datetime (8, 3) | Corrected override of date of closing. | |
description_corrected_override | nvarchar (256) | Corrected override of description. | |
address_corrected_override | nvarchar (256) | Corrected override of address. | |
city_corrected_override | nvarchar (256) | Corrected override of city. | |
state_abbreviation_corrected_override | nvarchar (4) | Corrected override of state. | |
zip_corrected_override | nvarchar (20) | Corrected override of zip. | |
property_or_services_part_of_consideration_corrected_override | bit (1) | Corrected override of whether property or services are part of consideration. | |
transferor_is_foreign | bit (1) | NOT NULL | Whether or not the transferor is a foreign person flag is set. |
transferor_is_foreign_override | bit (1) | User override to the transferor_is_foreign column. Null indicates not overridden. | |
transferor_is_foreign_original_override | bit (1) | Original override to the transferor_is_foreign column for corrected 1099s. Null indicates not overridden. | |
transferor_is_foreign_corrected_override | bit (1) | Corrected override to transferor_is_foreign column for corrected 1099s. Null indicates not overridden. |
Primary key | |||
Name | Columns | Description | |
PK_Form_1099_S_Option$form_1099_KEY | form_1099_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Form_1099_S_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |