Table: dbo.Form_1099_A_Option
Detailed options for 1099-A form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
date_of_aquisitiondatetime (8, 3)Form 1099-A option: date of aquisition
is_borrower_liable_for_debtbit (1)NOT NULLForm 1099-A option: borrower liable for debt
description_of_propertynvarchar (256)Form 1099-A option: description of property
date_of_acquisition_overridedatetime (8, 3)The override for the recipient's date of acquisition.
is_borrower_liable_for_debt_overridebit (1)The override for whether or not the recipient has debt liability.
description_of_property_overridenvarchar (256)The override for the recipient's 1099-A description.
date_of_acquisition_original_overridedatetime (8, 3)Original override for the recipents date of acquisition.
is_borrower_liable_for_debt_original_overridebit (1)Original override for whether borrower is liabile for debt.
description_of_property_original_overridenvarchar (256)Original override for the description of property.
date_of_acquisition_corrected_overridedatetime (8, 3)Corrected override for the recipents date of acquisition.
is_borrower_liable_for_debt_corrected_overridebit (1)Corrected override for whether borrower is liabile for debt.
description_of_property_corrected_overridenvarchar (256)Corrected override for the description of property.
Primary key
NameColumnsDescription
PK_Form_1099_A_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_A_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram