Detailed options for 1099-B form. |
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. |