Table: dbo.Print_1099_Selection
This ephemeral table is used by tax processing code to drive 1099 and 1096 form printing. It determines each form's account number. Updates to schema for this table typically must be paralleled in table Recipient_1099_Override but accept NULL there.
Columns
NameTypeConstraintsDescription
print_1099_selection_KEYint (4)NOT NULLPrimary key for this table. The print engine uses this to uniquely identify each 1099 or 1096 during a print run.
print_1099_KEYint (4)NOT NULLThe foreign key into the Print_1099 table.
client_KEYint (4)NOT NULLForeign key to the client whose employee is having a 1099/1096 form printed for them.
account_numberint (4)NOT NULLA unique number for each 1099/1096 per client within a given print run.
form_1099_KEYint (4)NOT NULLThe foreign key into the Form_1099 table.
print_1096_selection_KEYint (4)The foreign key into the Print_1096_Selection table. If this is null, then this is not part of the recipient list being included on the 1096.
box_1_amountdecimal (9, 2)NOT NULLThe 1099's box 1 amount
box_1a_amountdecimal (9, 2)NOT NULLThe 1099's box 1a amount
box_1b_amountdecimal (9, 2)NOT NULLThe 1099's box 1b amount
box_2_amountdecimal (9, 2)NOT NULLThe 1099's box 2 amount
box_2a_amountdecimal (9, 2)NOT NULLThe 1099's box 2a amount
box_2b_amountdecimal (9, 2)NOT NULLThe 1099's box 2b amount
box_2c_amountdecimal (9, 2)NOT NULLThe 1099's box 2c amount
box_2d_amountdecimal (9, 2)NOT NULLThe 1099's box 2d amount
box_3_amountdecimal (9, 2)NOT NULLThe 1099's box 3 amount
box_4_amountdecimal (9, 2)NOT NULLThe 1099's box 4 amount
box_5_amountdecimal (9, 2)NOT NULLThe 1099's box 5 amount
box_6_amountdecimal (9, 2)NOT NULLThe 1099's box 6 amount
box_7_amountdecimal (9, 2)NOT NULLThe 1099's box 7 amount
box_8_amountdecimal (9, 2)NOT NULLThe 1099's box 8 amount
box_9_amountdecimal (9, 2)NOT NULLThe 1099's box 9 amount
box_9b_amountdecimal (9, 2)NOT NULLThe 1099's box 9b amount
box_10_amountdecimal (9, 2)NOT NULLThe 1099's box 10 amount
box_11_amountdecimal (9, 2)NOT NULLThe 1099's box 11 amount
box_12_amountdecimal (9, 2)NOT NULLThe 1099's box 12 amount
box_12b_amountdecimal (9, 2)NOT NULLThe 1099's box 12b amount
box_13_amountdecimal (9, 2)NOT NULLThe 1099's box 13 amount
box_13a_amountdecimal (9, 2)NOT NULLThe 1099's box 13a amount
box_14_amountdecimal (9, 2)NOT NULLThe 1099's box 14 amount
box_14a_amountdecimal (9, 2)NOT NULLThe 1099's box 14a amount
box_15_amountdecimal (9, 2)NOT NULLThe 1099's box 15 amount
box_15a_amountdecimal (9, 2)NOT NULLThe 1099's box 15a amount
box_15b_amountdecimal (9, 2)NOT NULLThe 1099's box 15b amount
box_16_amountdecimal (9, 2)NOT NULLThe 1099's box 16 amount
box_18_amountdecimal (9, 2)NOT NULLThe 1099's box 18 amount
box_17_amountdecimal (9, 2)The 1099's box 17 amount
form_1099_correction_type_KEYint (4)Form 1099 correction type.
form_1099_override_type_KEYint (4)NOT NULL1099 override type.
box_1d_amountdecimal (9, 2)NOT NULLThe 1099s box 1d amount.
box_1e_amountdecimal (9, 2)NOT NULLThe 1099s box 1e amount.
box_1g_amountdecimal (9, 2)NOT NULLThe 1099s box 1g amount.
box_1f_amountdecimal (9, 2)NOT NULLThe 1099s box 1f amount.
box_4c_amountdecimal (9, 2)NOT NULLThe 1098c box 4c amount.
box_6b_amountdecimal (9, 2)NOT NULLThe 1098c box 6b amount.
box_19_amountdecimal (9, 2)NOT NULLThe 1099 box 19 amount. As of 2020-09-14, only on 1099-R.
box_2e_amountdecimal (9, 2)NOT NULLThe 1099 box 2e amount. New on Form 1099-DIV for 2021.
box_2f_amountdecimal (9, 2)NOT NULLThe 1099 box 2f amount. New on Form 1099-DIV for 2021.
Primary key
NameColumnsDescription
PK_Print_1099_Selectionprint_1099_selection_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_1099_Selection__Client__client_KEYclient_KEYClient (client_KEY)
FK_Print_1099_Selection__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Print_1099_Selection__Form_1099_Correction_Type__form_1099_correction_type_KEYform_1099_correction_type_KEYForm_1099_Correction_Type (form_1099_correction_type_KEY)
FK_Print_1099_Selection__Form_1099_Override_Type__form_1099_override_type_KEYform_1099_override_type_KEYForm_1099_Override_Type (form_1099_override_type_KEY)
FK_Print_1099_Selection__Print_1096_Selection__print_1096_selection_KEYprint_1096_selection_KEYPrint_1096_Selection (print_1096_selection_KEY)
FK_Print_1099_Selection__Print_1099__print_1099_KEYprint_1099_KEYPrint_1099 (print_1099_KEY)

Schema diagram