Table: dbo.Print_Customer_Statement_Selection
This table is used drive AR Statement printing. It determines which user is printing, which customers are being printed and the dates required by the report variables.
Columns
Name | Type | Constraints | Description
print_customer_statement_selection_KEY | int (4) | NOT NULL | Primary key.
user_session_guid | uniqueidentifier (16) | NOT NULL | The user session for the staff printing the forms.
customer_KEY | int (4) | NOT NULL | The customer the statement is being printed for.
beginning_date | smalldatetime (4) | NOT NULL | The beginning date for AR Transactions to be filtered on.
ending_date | smalldatetime (4) | NOT NULL | The ending date for AR Transactions to be filtered on.
statement_date | smalldatetime (4) | NOT NULL | The statement date specified by the user to be displayed.

Primary key
Name | Columns | Description
PK_Print_Customer_Statement_Selection | print_customer_statement_selection_KEY |
Unique constraints
Name | Columns | Description
UK_Print_Customer_Statement_Selection$user_session_guid$customer_KEY | user_session_guid, customer_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_Customer_Statement_Selection__Customer__customer_KEY | customer_KEY | Customer (customer_KEY) |
FK_Print_Customer_Statement_Selection__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |