Table: dbo.Print_1096_Selection
This table is used by tax processing code to drive 1096 form printing.
Columns
Name | Type | Constraints | Description
print_1096_selection_KEY | int (4) | NOT NULL | Primary key for this table. The print engine uses this to uniquely identify each 1096 during a print run.
print_1099_KEY | int (4) | NOT NULL | Foreign key into the Print_1099 table.
client_KEY | int (4) | NOT NULL | Foreign key to the client who is having a 1096 form printed for them.
contact_KEY | int (4) |  | The contact to use on the 1096.
signature__contact_KEY | int (4) |  | The key for the staff member who will be signing the 1096.
preparation_date | smalldatetime (4) |  | The preparation date to display on the form. If null, then display nothing on the form.
is_correcting_tin | bit (1) | NOT NULL | Whether is correcting tin.
is_correcting_return_type | bit (1) | NOT NULL | Whether is correcting return type.
is_correcting_name | bit (1) | NOT NULL | If true, then this record has a name change that should trigger an "Error Type 2" 1099 correction.

Primary key
Name | Columns | Description
PK_Print_1096_Selection | print_1096_selection_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_1096_Selection__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Print_1096_Selection__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |
FK_Print_1096_Selection__Contact__signature__contact_KEY | signature__contact_KEY | Contact (contact_KEY) |
FK_Print_1096_Selection__Print_1099__print_1099_KEY | print_1099_KEY | Print_1099 (print_1099_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Print_1099_Selection__Print_1096_Selection__print_1096_selection_KEY | print_1096_selection_KEY | Print_1099_Selection |