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
NameTypeConstraintsDescription
print_customer_statement_selection_KEYint (4)NOT NULLPrimary key.
user_session_guiduniqueidentifier (16)NOT NULLThe user session for the staff printing the forms.
customer_KEYint (4)NOT NULLThe customer the statement is being printed for.
beginning_datesmalldatetime (4)NOT NULLThe beginning date for AR Transactions to be filtered on.
ending_datesmalldatetime (4)NOT NULLThe ending date for AR Transactions to be filtered on.
statement_datesmalldatetime (4)NOT NULLThe statement date specified by the user to be displayed.
Primary key
NameColumnsDescription
PK_Print_Customer_Statement_Selectionprint_customer_statement_selection_KEY
Unique constraints
NameColumnsDescription
UK_Print_Customer_Statement_Selection$user_session_guid$customer_KEYuser_session_guid, customer_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Customer_Statement_Selection__Customer__customer_KEYcustomer_KEYCustomer (customer_KEY)
FK_Print_Customer_Statement_Selection__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram