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