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
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLForeign key into the Form_1099 table.
include_recipientbit (1)The override for whether the recipient should be printed and included in the totals.
employer_identification_numbernvarchar (22)The override for the recipient's ein.
recipient_namenvarchar (100)The override for the recipient's name.
address_1nvarchar (100)The override for the recipient's street address line 1.
address_2nvarchar (100)The override for the recipient's street address line 2.
citynvarchar (80)The override for the recipient's city.
state_abbreviationnvarchar (4)The override for the recipient's state.
postal_codenvarchar (20)The override for the recipient's postal code.
box_1_amountdecimal (9, 2)The override for the recipient's box 1 amount.
box_1a_amountdecimal (9, 2)The override for the recipient's box 1a amount.
box_1b_amountdecimal (9, 2)The override for the recipient's box 1b amount.
box_2_amountdecimal (9, 2)The override for the recipient's box 2 amount.
box_2a_amountdecimal (9, 2)The override for the recipient's box 2a amount.
box_2b_amountdecimal (9, 2)The override for the recipient's box 2b amount.
box_2c_amountdecimal (9, 2)The override for the recipient's box 2c amount.
box_2d_amountdecimal (9, 2)The override for the recipient's box 2d amount.
box_3_amountdecimal (9, 2)The override for the recipient's box 3 amount.
box_4_amountdecimal (9, 2)The override for the recipient's box 4 amount.
box_5_amountdecimal (9, 2)The override for the recipient's box 5 amount.
box_6_amountdecimal (9, 2)The override for the recipient's box 6 amount.
box_7_amountdecimal (9, 2)The override for the recipient's box 7 amount.
box_8_amountdecimal (9, 2)The override for the recipient's box 8 amount.
box_9_amountdecimal (9, 2)The override for the recipient's box 9 amount.
box_9b_amountdecimal (9, 2)The override for the recipient's box 9b amount.
box_10_amountdecimal (9, 2)The override for the recipient's box 10 amount.
box_11_amountdecimal (9, 2)The override for the recipient's box 11 amount.
box_12_amountdecimal (9, 2)The override for the recipient's box 12 amount.
box_13_amountdecimal (9, 2)The override for the recipient's box 13 amount.
box_14_amountdecimal (9, 2)The override for the recipient's box 14 amount.
box_15_amountdecimal (9, 2)The override for the recipient's box 15 amount.
box_15a_amountdecimal (9, 2)The override for the recipient's box 15a amount.
box_15b_amountdecimal (9, 2)The override for the recipient's box 15b amount.
box_16_amountdecimal (9, 2)The override for the recipient's box 16 amount.
box_18_amountdecimal (9, 2)The override for the recipient's box 18 amount.
state_numbernvarchar (50)The override for the recipient's state number.
localitynvarchar (50)The override for the recipient's locality.
box_12b_amountdecimal (9, 2)The override for the recipient's box 12b amount.
box_13a_amountdecimal (9, 2)The override for the recipient's box 13a amount.
box_14a_amountdecimal (9, 2)The override for the recipient's box 14a amount.
withholding_statenvarchar (4)The override for the state that the withholding applies to.
box_17_amountdecimal (9, 2)The override for the recipient's box 17 amount.
recipient_1099_override_KEYint (4)NOT NULLPrimary key for this table.
form_1099_override_type_KEYint (4)NOT NULL1099 override type.
box_1d_amountdecimal (9, 2)The override for the recipients box 1d amount. Null indicates not overridden.
box_1e_amountdecimal (9, 2)The override for the recipients box 1e amount. Null indicates not overridden.
box_1g_amountdecimal (9, 2)The override for the recipients box 1g amount. Null indicates not overridden.
box_1f_amountdecimal (9, 2)The override for the recipients box 1f amount. Null indicates not overridden.
box_4c_amountdecimal (9, 2)The override for the recipients box 4c amount. Null indicates not overridden.
box_6b_amountdecimal (9, 2)The override for the recipients box 6b amount. Null indicates not overridden.
box_19_amountdecimal (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_amountdecimal (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_amountdecimal (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
NameColumnsDescription
PK_Recipient_1099_Overriderecipient_1099_override_KEY
Unique constraints
NameColumnsDescription
UK_Recipient_1099_Override$form_1099_KEY$form_1099_override_type_KEYform_1099_KEY, form_1099_override_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recipient_1099_Override__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Recipient_1099_Override__Form_1099_Override_Type__form_1099_override_type_KEYform_1099_override_type_KEYForm_1099_Override_Type (form_1099_override_type_KEY)

Schema diagram