Table: dbo.Recipient_1099_Override
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.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Recipient_1099_Override | recipient_1099_override_KEY |
Unique constraints
Name | Columns | Description
UK_Recipient_1099_Override$form_1099_KEY$form_1099_override_type_KEY | form_1099_KEY, form_1099_override_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recipient_1099_Override__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
FK_Recipient_1099_Override__Form_1099_Override_Type__form_1099_override_type_KEY | form_1099_override_type_KEY | Form_1099_Override_Type (form_1099_override_type_KEY) |