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
Name | Type | Constraints | Description
print_1099_KEY | int (4) | NOT NULL | Primary key for this table.
user_session_guid | uniqueidentifier (16) | NOT NULL | The 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_KEY | int (4) | NOT NULL | The type of 1099 to process.
beginning_date | smalldatetime (4) | NOT NULL | The beginning date for bank transactions to be filtered on.
ending_date | smalldatetime (4) | NOT NULL | The ending date for bank transactions to be filtered on.

Primary key
Name | Columns | Description
PK_Print_1099 | print_1099_KEY |
Unique constraints
Name | Columns | Description
UK_Print_1099$user_session_guid$w2_1099_type_KEY | user_session_guid, w2_1099_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_1099__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |
FK_Print_1099__W2_1099_Type__w2_1099_type_KEY | w2_1099_type_KEY | W2_1099_Type (w2_1099_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Print_1096_Selection__Print_1099__print_1099_KEY | print_1099_KEY | Print_1096_Selection |
FK_Print_1099_Selection__Print_1099__print_1099_KEY | print_1099_KEY | Print_1099_Selection |