The table used to store Recipient 1099 overrides for all 1099 types. The schema for this table should closely match that in Print_1099_Selection but accept NULL to indicate a field that is not overridden and the calculated value should be used. |
form_1099_KEY | int (4) | NOT NULL | Foreign key into the Form_1099 table. |
include_recipient | bit (1) | | The override for whether the recipient should be printed and included in the totals. |
employer_identification_number | nvarchar (22) | | The override for the recipient's ein. |
recipient_name | nvarchar (100) | | The override for the recipient's name. |
address_1 | nvarchar (100) | | The override for the recipient's street address line 1. |
address_2 | nvarchar (100) | | The override for the recipient's street address line 2. |
city | nvarchar (80) | | The override for the recipient's city. |
state_abbreviation | nvarchar (4) | | The override for the recipient's state. |
postal_code | nvarchar (20) | | The override for the recipient's postal code. |
box_1_amount | decimal (9, 2) | | The override for the recipient's box 1 amount. |
box_1a_amount | decimal (9, 2) | | The override for the recipient's box 1a amount. |
box_1b_amount | decimal (9, 2) | | The override for the recipient's box 1b amount. |
box_2_amount | decimal (9, 2) | | The override for the recipient's box 2 amount. |
box_2a_amount | decimal (9, 2) | | The override for the recipient's box 2a amount. |
box_2b_amount | decimal (9, 2) | | The override for the recipient's box 2b amount. |
box_2c_amount | decimal (9, 2) | | The override for the recipient's box 2c amount. |
box_2d_amount | decimal (9, 2) | | The override for the recipient's box 2d amount. |
box_3_amount | decimal (9, 2) | | The override for the recipient's box 3 amount. |
box_4_amount | decimal (9, 2) | | The override for the recipient's box 4 amount. |
box_5_amount | decimal (9, 2) | | The override for the recipient's box 5 amount. |
box_6_amount | decimal (9, 2) | | The override for the recipient's box 6 amount. |
box_7_amount | decimal (9, 2) | | The override for the recipient's box 7 amount. |
box_8_amount | decimal (9, 2) | | The override for the recipient's box 8 amount. |
box_9_amount | decimal (9, 2) | | The override for the recipient's box 9 amount. |
box_9b_amount | decimal (9, 2) | | The override for the recipient's box 9b amount. |
box_10_amount | decimal (9, 2) | | The override for the recipient's box 10 amount. |
box_11_amount | decimal (9, 2) | | The override for the recipient's box 11 amount. |
box_12_amount | decimal (9, 2) | | The override for the recipient's box 12 amount. |
box_13_amount | decimal (9, 2) | | The override for the recipient's box 13 amount. |
box_14_amount | decimal (9, 2) | | The override for the recipient's box 14 amount. |
box_15_amount | decimal (9, 2) | | The override for the recipient's box 15 amount. |
box_15a_amount | decimal (9, 2) | | The override for the recipient's box 15a amount. |
box_15b_amount | decimal (9, 2) | | The override for the recipient's box 15b amount. |
box_16_amount | decimal (9, 2) | | The override for the recipient's box 16 amount. |
box_18_amount | decimal (9, 2) | | The override for the recipient's box 18 amount. |
state_number | nvarchar (50) | | The override for the recipient's state number. |
locality | nvarchar (50) | | The override for the recipient's locality. |
box_12b_amount | decimal (9, 2) | | The override for the recipient's box 12b amount. |
box_13a_amount | decimal (9, 2) | | The override for the recipient's box 13a amount. |
box_14a_amount | decimal (9, 2) | | The override for the recipient's box 14a amount. |
withholding_state | nvarchar (4) | | The override for the state that the withholding applies to. |
box_17_amount | decimal (9, 2) | | The override for the recipient's box 17 amount. |
recipient_1099_override_KEY | int (4) | NOT NULL | Primary key for this table. |
form_1099_override_type_KEY | int (4) | NOT NULL | 1099 override type. |
box_1d_amount | decimal (9, 2) | | The override for the recipients box 1d amount. Null indicates not overridden. |
box_1e_amount | decimal (9, 2) | | The override for the recipients box 1e amount. Null indicates not overridden. |
box_1g_amount | decimal (9, 2) | | The override for the recipients box 1g amount. Null indicates not overridden. |
box_1f_amount | decimal (9, 2) | | The override for the recipients box 1f amount. Null indicates not overridden. |
box_4c_amount | decimal (9, 2) | | The override for the recipients box 4c amount. Null indicates not overridden. |
box_6b_amount | decimal (9, 2) | | The override for the recipients box 6b amount. Null indicates not overridden. |
box_19_amount | decimal (9, 2) | | The override for the recipient's 1099 box 19 amount. NULL indicates not overridden. As of 2020-10-06, only on 1099-R. |
box_2e_amount | decimal (9, 2) | | The override for the recipient's 1099 box 2e amount. NULL indicates not overridden. New on Form 1099-DIV for 2021. |
box_2f_amount | decimal (9, 2) | | The override for the recipient's 1099 box 2f amount. NULL indicates not overridden. New on Form 1099-DIV for 2021. |