Table: dbo.Print_1096_Selection
This table is used by tax processing code to drive 1096 form printing.
Columns
NameTypeConstraintsDescription
print_1096_selection_KEYint (4)NOT NULLPrimary key for this table. The print engine uses this to uniquely identify each 1096 during a print run.
print_1099_KEYint (4)NOT NULLForeign key into the Print_1099 table.
client_KEYint (4)NOT NULLForeign key to the client who is having a 1096 form printed for them.
contact_KEYint (4)The contact to use on the 1096.
signature__contact_KEYint (4)The key for the staff member who will be signing the 1096.
preparation_datesmalldatetime (4)The preparation date to display on the form. If null, then display nothing on the form.
is_correcting_tinbit (1)NOT NULLWhether is correcting tin.
is_correcting_return_typebit (1)NOT NULLWhether is correcting return type.
is_correcting_namebit (1)NOT NULLIf true, then this record has a name change that should trigger an "Error Type 2" 1099 correction.
Primary key
NameColumnsDescription
PK_Print_1096_Selectionprint_1096_selection_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_1096_Selection__Client__client_KEYclient_KEYClient (client_KEY)
FK_Print_1096_Selection__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Print_1096_Selection__Contact__signature__contact_KEYsignature__contact_KEYContact (contact_KEY)
FK_Print_1096_Selection__Print_1099__print_1099_KEYprint_1099_KEYPrint_1099 (print_1099_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Print_1099_Selection__Print_1096_Selection__print_1096_selection_KEYprint_1096_selection_KEYPrint_1099_Selection

Schema diagram