Table: dbo.Form_1099_S_Option
Detailed options for 1099-S form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
date_of_closingdatetime (8, 3)Form 1099-S option: date of closing
property_or_services_part_of_considerationbit (1)NOT NULLForm 1099-S option: property or services part of consideration
descriptionnvarchar (256)Form 1099-S option: description
addressnvarchar (256)Form 1099-S option: address
citynvarchar (256)Form 1099-S option: city
zipnvarchar (20)Form 1099-S option: zip
state_abbreviationnvarchar (4)Form 1099-S option: state
date_of_closing_overridedatetime (8, 3)The override for the recipient's date of closing.
description_overridenvarchar (256)The override for the recipient's 1099-S description.
address_overridenvarchar (256)The override for the recipient's address_1.
city_overridenvarchar (256)The override for the recipient's city.
state_abbreviation_overridenvarchar (4)The override for the recipient's state.
zip_overridenvarchar (20)The override for the recipient's postal code.
property_or_services_part_of_consideration_overridebit (1)The override for whether or not the recipient received property as part of the consideration.
date_of_closing_original_overridedatetime (8, 3)Original override of date of closing.
description_original_overridenvarchar (256)Original override of description.
address_original_overridenvarchar (256)Original override of address.
city_original_overridenvarchar (256)Original override of city.
state_abbreviation_original_overridenvarchar (4)Original override of state.
zip_original_overridenvarchar (20)Original override of zip.
property_or_services_part_of_consideration_original_overridebit (1)Original override of whether property or services are part of consideration.
date_of_closing_corrected_overridedatetime (8, 3)Corrected override of date of closing.
description_corrected_overridenvarchar (256)Corrected override of description.
address_corrected_overridenvarchar (256)Corrected override of address.
city_corrected_overridenvarchar (256)Corrected override of city.
state_abbreviation_corrected_overridenvarchar (4)Corrected override of state.
zip_corrected_overridenvarchar (20)Corrected override of zip.
property_or_services_part_of_consideration_corrected_overridebit (1)Corrected override of whether property or services are part of consideration.
transferor_is_foreignbit (1)NOT NULLWhether or not the transferor is a foreign person flag is set.
transferor_is_foreign_overridebit (1)User override to the transferor_is_foreign column. Null indicates not overridden.
transferor_is_foreign_original_overridebit (1)Original override to the transferor_is_foreign column for corrected 1099s. Null indicates not overridden.
transferor_is_foreign_corrected_overridebit (1)Corrected override to transferor_is_foreign column for corrected 1099s. Null indicates not overridden.
Primary key
NameColumnsDescription
PK_Form_1099_S_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_S_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram