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) |