Table: dbo.Form_1099_B_Option
Detailed options for 1099-B 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_sale_or_exchange | datetime (8, 3) |  | Form 1099-B option: date of sale or exchange
number_of_shares_exchanged | int (4) |  | Form 1099-B option: number of shares exchanged
cusip_number | nvarchar (128) |  | Form 1099-B option: cusip number
classes_of_stock_exchanged | nvarchar (128) |  | Form 1099-B option: classes of stock exchanged
are_gross_proceeds | bit (1) | NOT NULL | Form 1099-B option: gross proceeds
cannot_take_loss_on_return_for_box_2_amt | bit (1) | NOT NULL | Form 1099-B option: cannot take loss on return for box 2 amt
are_gross_proceeds_less_commission_or_premiums | bit (1) | NOT NULL | Form 1099-B option: gross proceeds less commission or premiums
is_second_irs_notification_incorrect_recipient_tin | bit (1) | NOT NULL | Form 1099-B option: second irs notification incorrect recipiant tin
corporation_name | nvarchar (256) |  | Form 1099-B option: corporation name
description | nvarchar (256) |  | Form 1099-B option: description
corporation_name_override | nvarchar (256) |  | The override for the recipient's corporation name.
date_of_sale_or_exchange_override | datetime (8, 3) |  | The override the recipient's date of sale.
cusip_number_override | nvarchar (128) |  | The override for the recipient's cusip number.
are_gross_proceeds_override | bit (1) |  | The override for whether or not the stocks or bonds amount was reported as gross proceeds.
are_gross_proceeds_less_commission_or_premiums_override | bit (1) |  | The override for whether or not the stocks or bonds amount was reported as gross proceeds less commission.
number_of_shares_exchanged_override | int (4) |  | The override for the recipient's number of shares.
classes_of_stock_exchanged_override | nvarchar (128) |  | The override for the recipient's classes of stock.
description_override | nvarchar (256) |  | The override for the recipient's 1099-B description.
cannot_take_loss_on_return_for_box_2_amt_override | bit (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_override | bit (1) |  | The override for whether the IRS should be notified about a recipient's second TIN.
date_of_acquisition | datetime (8, 3) |  | The date the property was acquired
date_of_acquisition_override | datetime (8, 3) |  | Any override to the date the property was acquired, or null if there isn't an override.
noncovered_security | bit (1) | NOT NULL | Whether or not the property is a noncovered security
noncovered_security_override | bit (1) |  | Any override to whether or not the property is a noncovered security, or null if there isn't an override.
corporation_name_original_override | nvarchar (256) |  | Original override of the corporation name.
date_of_sale_or_exchange_original_override | datetime (8, 3) |  | Original override of the date of sale or exchange.
cusip_number_original_override | nvarchar (128) |  | Original override of the cusip number.
are_gross_proceeds_original_override | bit (1) |  | Original override of whether there are gross proceeds.
are_gross_proceeds_less_commission_or_premiums_original_override | bit (1) |  | Original override of whether there are gross proceeds less commission or premiums.
number_of_shares_exchanged_original_override | int (4) |  | Original override of the number of shares exchanged.
classes_of_stock_exchanged_original_override | nvarchar (128) |  | Original override of the classes of stock exchanged.
description_original_override | nvarchar (256) |  | Original override of the description.
cannot_take_loss_on_return_for_box_2_amt_original_override | bit (1) |  | Original override of whether they cannot take a loss on return for box 2.
is_second_irs_notification_incorrect_recipient_tin_original_override | bit (1) |  | Original override of is whether is is the second irs notification of incorrect recipent tin.
date_of_acquisition_original_override | datetime (8, 3) |  | Original override of date of acquisition.
noncovered_security_original_override | bit (1) |  | Original override of noncovered security.
corporation_name_corrected_override | nvarchar (256) |  | Corrected override of corporation name.
date_of_sale_or_exchange_corrected_override | datetime (8, 3) |  | Corrected override of the date of sale or exchange.
cusip_number_corrected_override | nvarchar (128) |  | Corrected override of the cusip number.
are_gross_proceeds_corrected_override | bit (1) |  | Corrected override of whether there are gross proceeds.
are_gross_proceeds_less_commission_or_premiums_corrected_override | bit (1) |  | Corrected override of whether there are gross proceeds less commission or premiums.
number_of_shares_exchanged_corrected_override | int (4) |  | Corrected override of the number of shares exchanged.
classes_of_stock_exchanged_corrected_override | nvarchar (128) |  | Corrected override of the classes of stock exchanged.
description_corrected_override | nvarchar (256) |  | Corrected override of the description.
cannot_take_loss_on_return_for_box_2_amt_corrected_override | bit (1) |  | Corrected override of whether they cannot take a loss on return for box 2.
is_second_irs_notification_incorrect_recipient_tin_corrected_override | bit (1) |  | Corrected override of is whether is is the second irs notification of incorrect recipent tin.
date_of_acquisition_corrected_override | datetime (8, 3) |  | Corrected override of date of acquisition.
noncovered_security_corrected_override | bit (1) |  | Corrected override of noncovered security.
basis_reported | bit (1) | NOT NULL | Basis reported.
basis_reported_override | bit (1) |  | Override of the basis reported.
basis_reported_original_override | bit (1) |  | Original override of the basis reported.
basis_reported_corrected_override | bit (1) |  | Corrected override of the basis reported.
stock_symbol | nvarchar (24) |  | Stock Symbol. Null indicates no value.
stock_symbol_override | nvarchar (24) |  | Override of the stock symbol. Null indicates not overridden.
stock_symbol_original_override | nvarchar (24) |  | Original override of the stock symbol. Null indicates not overridden.
stock_symbol_corrected_override | nvarchar (24) |  | Corrected override of the stock symbol. Null indicates not overridden.
quantity_sold | decimal (9, 2) |  | Quantity Sold. Null indicates no value.
quantity_sold_override | decimal (9, 2) |  | Override of the quantity sold. Null indicates not overridden.
quantity_sold_original_override | decimal (9, 2) |  | Original override of the quantity sold. Null indicates not overridden.
quantity_sold_corrected_override | decimal (9, 2) |  | Corrected override of the quantity sold. Null indicates not overridden.
form_1099_b_form_8949_code_KEY | int (4) | NOT NULL | Form 1099 B form 8949 code.
override_form_1099_b_form_8949_code_KEY | int (4) |  | Form 1099 B override form 8949 code. Null indicates not overridden.
original_override_form_1099_b_form_8949_code_KEY | int (4) |  | Form 1099 B original override form 8949 code. Null indicates not overridden.
corrected_override_form_1099_b_form_8949_code_KEY | int (4) |  | Form 1099 B corrected override form 8949 code. Null indicates not overridden.
form_1099_b_box_1f_code_KEY | int (4) | NOT NULL | Form 1099 B Box 1F code.
override_form_1099_b_box_1f_code_KEY | int (4) |  | Form 1099 B override Box 1F code. Null indicates not overridden.
original_override_form_1099_b_box_1f_code_KEY | int (4) |  | Form 1099 B original override Box 1F code. Null indicates not overridden.
corrected_override_form_1099_b_box_1f_code_KEY | int (4) |  | Form 1099 B corrected override Box 1F code. Null indicates not overridden.
fatca_filing_requirement | bit (1) | NOT NULL | Whether or not the foreign account tax compliance act flag is set.
fatca_filing_requirement_override | bit (1) |  | User override to the fatca_filing_requirement column. Null indicates not overridden.
fatca_filing_requirement_original_override | bit (1) |  | Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
fatca_filing_requirement_corrected_override | bit (1) |  | Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
ordinary | bit (1) | NOT NULL | Whether or not the ordinary flag is set.
ordinary_override | bit (1) |  | User override to the ordinary column. Null indicates not overridden.
ordinary_original_override | bit (1) |  | Original override to the ordinary column for corrected 1099s. Null indicates not overridden.
ordinary_corrected_override | bit (1) |  | Corrected override to the ordinary column for corrected 1099s. Null indicates not overridden.
proceeds_from_collectibles | bit (1) | NOT NULL | Whether or not the proceeds from collectibles flag is set.
proceeds_from_collectibles_override | bit (1) |  | User override to the proceeds_from_collectibles column. Null indicates not overridden.
proceeds_from_collectibles_original_override | bit (1) |  | Original override to the proceeds_from_collectibles column for corrected 1099s. Null indicates not overridden.
proceeds_from_collectibles_corrected_override | bit (1) |  | Corrected override to proceeds_from_collectibles column for corrected 1099s. Null indicates not overridden.
proceeds_from_qof | bit (1) | NOT NULL | Whether or not the proceeds_from_qof flag is set.
proceeds_from_qof_override | bit (1) |  | User override to the proceeds_from_qof column. Null indicates not overridden.
proceeds_from_qof_original_override | bit (1) |  | Original override to the proceeds_from_qof column for corrected 1099s. Null indicates not overridden.
proceeds_from_qof_corrected_override | bit (1) |  | Corrected override to proceeds_from_qof column for corrected 1099s. Null indicates not overridden.

Primary key
Name | Columns | Description
PK_Form_1099_B_Option$form_1099_KEY | form_1099_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099_B_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
FK_Form_1099_B_Option__Form_1099_B_Box_1F_Code__corrected_override_form_1099_b_box_1f_code_KEY | corrected_override_form_1099_b_box_1f_code_KEY | Form_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_KEY | form_1099_b_box_1f_code_KEY | Form_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_KEY | original_override_form_1099_b_box_1f_code_KEY | Form_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_KEY | override_form_1099_b_box_1f_code_KEY | Form_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_KEY | corrected_override_form_1099_b_form_8949_code_KEY | Form_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_KEY | form_1099_b_form_8949_code_KEY | Form_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_KEY | original_override_form_1099_b_form_8949_code_KEY | Form_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_KEY | override_form_1099_b_form_8949_code_KEY | Form_1099_B_Form_8949_Code (form_1099_b_form_8949_code_KEY) |