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
Name | Type | Constraints | Description
print_1099_selection_KEY | int (4) | NOT NULL | Primary key for this table. The print engine uses this to uniquely identify each 1099 or 1096 during a print run.
print_1099_KEY | int (4) | NOT NULL | The foreign key into the Print_1099 table.
client_KEY | int (4) | NOT NULL | Foreign key to the client whose employee is having a 1099/1096 form printed for them.
account_number | int (4) | NOT NULL | A unique number for each 1099/1096 per client within a given print run.
form_1099_KEY | int (4) | NOT NULL | The foreign key into the Form_1099 table.
print_1096_selection_KEY | int (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_amount | decimal (9, 2) | NOT NULL | The 1099's box 1 amount
box_1a_amount | decimal (9, 2) | NOT NULL | The 1099's box 1a amount
box_1b_amount | decimal (9, 2) | NOT NULL | The 1099's box 1b amount
box_2_amount | decimal (9, 2) | NOT NULL | The 1099's box 2 amount
box_2a_amount | decimal (9, 2) | NOT NULL | The 1099's box 2a amount
box_2b_amount | decimal (9, 2) | NOT NULL | The 1099's box 2b amount
box_2c_amount | decimal (9, 2) | NOT NULL | The 1099's box 2c amount
box_2d_amount | decimal (9, 2) | NOT NULL | The 1099's box 2d amount
box_3_amount | decimal (9, 2) | NOT NULL | The 1099's box 3 amount
box_4_amount | decimal (9, 2) | NOT NULL | The 1099's box 4 amount
box_5_amount | decimal (9, 2) | NOT NULL | The 1099's box 5 amount
box_6_amount | decimal (9, 2) | NOT NULL | The 1099's box 6 amount
box_7_amount | decimal (9, 2) | NOT NULL | The 1099's box 7 amount
box_8_amount | decimal (9, 2) | NOT NULL | The 1099's box 8 amount
box_9_amount | decimal (9, 2) | NOT NULL | The 1099's box 9 amount
box_9b_amount | decimal (9, 2) | NOT NULL | The 1099's box 9b amount
box_10_amount | decimal (9, 2) | NOT NULL | The 1099's box 10 amount
box_11_amount | decimal (9, 2) | NOT NULL | The 1099's box 11 amount
box_12_amount | decimal (9, 2) | NOT NULL | The 1099's box 12 amount
box_12b_amount | decimal (9, 2) | NOT NULL | The 1099's box 12b amount
box_13_amount | decimal (9, 2) | NOT NULL | The 1099's box 13 amount
box_13a_amount | decimal (9, 2) | NOT NULL | The 1099's box 13a amount
box_14_amount | decimal (9, 2) | NOT NULL | The 1099's box 14 amount
box_14a_amount | decimal (9, 2) | NOT NULL | The 1099's box 14a amount
box_15_amount | decimal (9, 2) | NOT NULL | The 1099's box 15 amount
box_15a_amount | decimal (9, 2) | NOT NULL | The 1099's box 15a amount
box_15b_amount | decimal (9, 2) | NOT NULL | The 1099's box 15b amount
box_16_amount | decimal (9, 2) | NOT NULL | The 1099's box 16 amount
box_18_amount | decimal (9, 2) | NOT NULL | The 1099's box 18 amount
box_17_amount | decimal (9, 2) |  | The 1099's box 17 amount
form_1099_correction_type_KEY | int (4) |  | Form 1099 correction type.
form_1099_override_type_KEY | int (4) | NOT NULL | 1099 override type.
box_1d_amount | decimal (9, 2) | NOT NULL | The 1099s box 1d amount.
box_1e_amount | decimal (9, 2) | NOT NULL | The 1099s box 1e amount.
box_1g_amount | decimal (9, 2) | NOT NULL | The 1099s box 1g amount.
box_1f_amount | decimal (9, 2) | NOT NULL | The 1099s box 1f amount.
box_4c_amount | decimal (9, 2) | NOT NULL | The 1098c box 4c amount.
box_6b_amount | decimal (9, 2) | NOT NULL | The 1098c box 6b amount.
box_19_amount | decimal (9, 2) | NOT NULL | The 1099 box 19 amount. As of 2020-09-14, only on 1099-R.
box_2e_amount | decimal (9, 2) | NOT NULL | The 1099 box 2e amount. New on Form 1099-DIV for 2021.
box_2f_amount | decimal (9, 2) | NOT NULL | The 1099 box 2f amount. New on Form 1099-DIV for 2021.

Primary key
Name | Columns | Description
PK_Print_1099_Selection | print_1099_selection_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_1099_Selection__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Print_1099_Selection__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
FK_Print_1099_Selection__Form_1099_Correction_Type__form_1099_correction_type_KEY | form_1099_correction_type_KEY | Form_1099_Correction_Type (form_1099_correction_type_KEY) |
FK_Print_1099_Selection__Form_1099_Override_Type__form_1099_override_type_KEY | form_1099_override_type_KEY | Form_1099_Override_Type (form_1099_override_type_KEY) |
FK_Print_1099_Selection__Print_1096_Selection__print_1096_selection_KEY | print_1096_selection_KEY | Print_1096_Selection (print_1096_selection_KEY) |
FK_Print_1099_Selection__Print_1099__print_1099_KEY | print_1099_KEY | Print_1099 (print_1099_KEY) |