Table: dbo.Form_1099_B_Option
Detailed options for 1099-B form.
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
date_of_sale_or_exchangedatetime (8, 3)Form 1099-B option: date of sale or exchange
number_of_shares_exchangedint (4)Form 1099-B option: number of shares exchanged
cusip_numbernvarchar (128)Form 1099-B option: cusip number
classes_of_stock_exchangednvarchar (128)Form 1099-B option: classes of stock exchanged
are_gross_proceedsbit (1)NOT NULLForm 1099-B option: gross proceeds
cannot_take_loss_on_return_for_box_2_amtbit (1)NOT NULLForm 1099-B option: cannot take loss on return for box 2 amt
are_gross_proceeds_less_commission_or_premiumsbit (1)NOT NULLForm 1099-B option: gross proceeds less commission or premiums
is_second_irs_notification_incorrect_recipient_tinbit (1)NOT NULLForm 1099-B option: second irs notification incorrect recipiant tin
corporation_namenvarchar (256)Form 1099-B option: corporation name
descriptionnvarchar (256)Form 1099-B option: description
corporation_name_overridenvarchar (256)The override for the recipient's corporation name.
date_of_sale_or_exchange_overridedatetime (8, 3)The override the recipient's date of sale.
cusip_number_overridenvarchar (128)The override for the recipient's cusip number.
are_gross_proceeds_overridebit (1)The override for whether or not the stocks or bonds amount was reported as gross proceeds.
are_gross_proceeds_less_commission_or_premiums_overridebit (1)The override for whether or not the stocks or bonds amount was reported as gross proceeds less commission.
number_of_shares_exchanged_overrideint (4)The override for the recipient's number of shares.
classes_of_stock_exchanged_overridenvarchar (128)The override for the recipient's classes of stock.
description_overridenvarchar (256)The override for the recipient's 1099-B description.
cannot_take_loss_on_return_for_box_2_amt_overridebit (1)The override for whether or not the recipient cannot take a loss on ther tax return basd on the stocks and bonds.
is_second_irs_notification_incorrect_recipient_tin_overridebit (1)The override for whether the IRS should be notified about a recipient's second TIN.
date_of_acquisitiondatetime (8, 3)The date the property was acquired
date_of_acquisition_overridedatetime (8, 3)Any override to the date the property was acquired, or null if there isn't an override.
noncovered_securitybit (1)NOT NULLWhether or not the property is a noncovered security
noncovered_security_overridebit (1)Any override to whether or not the property is a noncovered security, or null if there isn't an override.
corporation_name_original_overridenvarchar (256)Original override of the corporation name.
date_of_sale_or_exchange_original_overridedatetime (8, 3)Original override of the date of sale or exchange.
cusip_number_original_overridenvarchar (128)Original override of the cusip number.
are_gross_proceeds_original_overridebit (1)Original override of whether there are gross proceeds.
are_gross_proceeds_less_commission_or_premiums_original_overridebit (1)Original override of whether there are gross proceeds less commission or premiums.
number_of_shares_exchanged_original_overrideint (4)Original override of the number of shares exchanged.
classes_of_stock_exchanged_original_overridenvarchar (128)Original override of the classes of stock exchanged.
description_original_overridenvarchar (256)Original override of the description.
cannot_take_loss_on_return_for_box_2_amt_original_overridebit (1)Original override of whether they cannot take a loss on return for box 2.
is_second_irs_notification_incorrect_recipient_tin_original_overridebit (1)Original override of is whether is is the second irs notification of incorrect recipent tin.
date_of_acquisition_original_overridedatetime (8, 3)Original override of date of acquisition.
noncovered_security_original_overridebit (1)Original override of noncovered security.
corporation_name_corrected_overridenvarchar (256)Corrected override of corporation name.
date_of_sale_or_exchange_corrected_overridedatetime (8, 3)Corrected override of the date of sale or exchange.
cusip_number_corrected_overridenvarchar (128)Corrected override of the cusip number.
are_gross_proceeds_corrected_overridebit (1)Corrected override of whether there are gross proceeds.
are_gross_proceeds_less_commission_or_premiums_corrected_overridebit (1)Corrected override of whether there are gross proceeds less commission or premiums.
number_of_shares_exchanged_corrected_overrideint (4)Corrected override of the number of shares exchanged.
classes_of_stock_exchanged_corrected_overridenvarchar (128)Corrected override of the classes of stock exchanged.
description_corrected_overridenvarchar (256)Corrected override of the description.
cannot_take_loss_on_return_for_box_2_amt_corrected_overridebit (1)Corrected override of whether they cannot take a loss on return for box 2.
is_second_irs_notification_incorrect_recipient_tin_corrected_overridebit (1)Corrected override of is whether is is the second irs notification of incorrect recipent tin.
date_of_acquisition_corrected_overridedatetime (8, 3)Corrected override of date of acquisition.
noncovered_security_corrected_overridebit (1)Corrected override of noncovered security.
basis_reportedbit (1)NOT NULLBasis reported.
basis_reported_overridebit (1)Override of the basis reported.
basis_reported_original_overridebit (1)Original override of the basis reported.
basis_reported_corrected_overridebit (1)Corrected override of the basis reported.
stock_symbolnvarchar (24)Stock Symbol. Null indicates no value.
stock_symbol_overridenvarchar (24)Override of the stock symbol. Null indicates not overridden.
stock_symbol_original_overridenvarchar (24)Original override of the stock symbol. Null indicates not overridden.
stock_symbol_corrected_overridenvarchar (24)Corrected override of the stock symbol. Null indicates not overridden.
quantity_solddecimal (9, 2)Quantity Sold. Null indicates no value.
quantity_sold_overridedecimal (9, 2)Override of the quantity sold. Null indicates not overridden.
quantity_sold_original_overridedecimal (9, 2)Original override of the quantity sold. Null indicates not overridden.
quantity_sold_corrected_overridedecimal (9, 2)Corrected override of the quantity sold. Null indicates not overridden.
form_1099_b_form_8949_code_KEYint (4)NOT NULLForm 1099 B form 8949 code.
override_form_1099_b_form_8949_code_KEYint (4)Form 1099 B override form 8949 code. Null indicates not overridden.
original_override_form_1099_b_form_8949_code_KEYint (4)Form 1099 B original override form 8949 code. Null indicates not overridden.
corrected_override_form_1099_b_form_8949_code_KEYint (4)Form 1099 B corrected override form 8949 code. Null indicates not overridden.
form_1099_b_box_1f_code_KEYint (4)NOT NULLForm 1099 B Box 1F code.
override_form_1099_b_box_1f_code_KEYint (4)Form 1099 B override Box 1F code. Null indicates not overridden.
original_override_form_1099_b_box_1f_code_KEYint (4)Form 1099 B original override Box 1F code. Null indicates not overridden.
corrected_override_form_1099_b_box_1f_code_KEYint (4)Form 1099 B corrected override Box 1F code. Null indicates not overridden.
fatca_filing_requirementbit (1)NOT NULLWhether or not the foreign account tax compliance act flag is set.
fatca_filing_requirement_overridebit (1)User override to the fatca_filing_requirement column. Null indicates not overridden.
fatca_filing_requirement_original_overridebit (1)Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
fatca_filing_requirement_corrected_overridebit (1)Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
ordinarybit (1)NOT NULLWhether or not the ordinary flag is set.
ordinary_overridebit (1)User override to the ordinary column. Null indicates not overridden.
ordinary_original_overridebit (1)Original override to the ordinary column for corrected 1099s. Null indicates not overridden.
ordinary_corrected_overridebit (1)Corrected override to the ordinary column for corrected 1099s. Null indicates not overridden.
proceeds_from_collectiblesbit (1)NOT NULLWhether or not the proceeds from collectibles flag is set.
proceeds_from_collectibles_overridebit (1)User override to the proceeds_from_collectibles column. Null indicates not overridden.
proceeds_from_collectibles_original_overridebit (1)Original override to the proceeds_from_collectibles column for corrected 1099s. Null indicates not overridden.
proceeds_from_collectibles_corrected_overridebit (1)Corrected override to proceeds_from_collectibles column for corrected 1099s. Null indicates not overridden.
proceeds_from_qofbit (1)NOT NULLWhether or not the proceeds_from_qof flag is set.
proceeds_from_qof_overridebit (1)User override to the proceeds_from_qof column. Null indicates not overridden.
proceeds_from_qof_original_overridebit (1)Original override to the proceeds_from_qof column for corrected 1099s. Null indicates not overridden.
proceeds_from_qof_corrected_overridebit (1)Corrected override to proceeds_from_qof column for corrected 1099s. Null indicates not overridden.
Primary key
NameColumnsDescription
PK_Form_1099_B_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_B_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__corrected_override_form_1099_b_box_1f_code_KEYcorrected_override_form_1099_b_box_1f_code_KEYForm_1099_B_Box_1F_Code (form_1099_b_box_1f_code_KEY)
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__form_1099_b_box_1f_code_KEYform_1099_b_box_1f_code_KEYForm_1099_B_Box_1F_Code (form_1099_b_box_1f_code_KEY)
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__original_override_form_1099_b_box_1f_code_KEYoriginal_override_form_1099_b_box_1f_code_KEYForm_1099_B_Box_1F_Code (form_1099_b_box_1f_code_KEY)
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__override_form_1099_b_box_1f_code_KEYoverride_form_1099_b_box_1f_code_KEYForm_1099_B_Box_1F_Code (form_1099_b_box_1f_code_KEY)
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__corrected_override_form_1099_b_form_8949_code_KEYcorrected_override_form_1099_b_form_8949_code_KEYForm_1099_B_Form_8949_Code (form_1099_b_form_8949_code_KEY)
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__form_1099_b_form_8949_code_KEYform_1099_b_form_8949_code_KEYForm_1099_B_Form_8949_Code (form_1099_b_form_8949_code_KEY)
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__original_override_form_1099_b_form_8949_code_KEYoriginal_override_form_1099_b_form_8949_code_KEYForm_1099_B_Form_8949_Code (form_1099_b_form_8949_code_KEY)
FK_Form_1099_B_Option__Form_1099_B_Form_8949_Code__override_form_1099_b_form_8949_code_KEYoverride_form_1099_b_form_8949_code_KEYForm_1099_B_Form_8949_Code (form_1099_b_form_8949_code_KEY)

Schema diagram