Table: dbo.Print_1099
This table is used by tax processing code to drive 1099 and 1096 form printing. It determines which user is printing, what year they are printing for, and which 1099 type they are printing.
Columns
NameTypeConstraintsDescription
print_1099_KEYint (4)NOT NULLPrimary key for this table.
user_session_guiduniqueidentifier (16)NOT NULLThe user session for the person printing the forms. We note user session (as opposed to user) because the application allows a user to log in more than once. In turn, this permits a user to print from more than one session at the same time.
w2_1099_type_KEYint (4)NOT NULLThe type of 1099 to process.
beginning_datesmalldatetime (4)NOT NULLThe beginning date for bank transactions to be filtered on.
ending_datesmalldatetime (4)NOT NULLThe ending date for bank transactions to be filtered on.
Primary key
NameColumnsDescription
PK_Print_1099print_1099_KEY
Unique constraints
NameColumnsDescription
UK_Print_1099$user_session_guid$w2_1099_type_KEYuser_session_guid, w2_1099_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_1099__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)
FK_Print_1099__W2_1099_Type__w2_1099_type_KEYw2_1099_type_KEYW2_1099_Type (w2_1099_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Print_1096_Selection__Print_1099__print_1099_KEYprint_1099_KEYPrint_1096_Selection
FK_Print_1099_Selection__Print_1099__print_1099_KEYprint_1099_KEYPrint_1099_Selection

Schema diagram