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. |
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. |