Table: dbo.Print_Check_Selection
Columns
NameTypeConstraintsDescription
print_check_selection_KEYint (4)NOT NULLPrimary key.
user_session_guiduniqueidentifier (16)NOT NULLThe user session for the person printing the check. 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, which is one of potential problems we want to address with this table.
bank_transaction_KEYint (4)NOT NULLThe bank transaction for the payroll, vendor or vendor agent check we are printing.
reference_numbernvarchar (32)NOT NULLThe check number of the payroll, vendor or vendor agent check we are printing.
transaction_datesmalldatetime (4)NOT NULLThe check date of the payroll, vendor or vendor agent check we are printing.
was_check_createdbit (1)NOT NULLFlags the check as programmatically-created. Example: a vendor agent check, which the application creates.
source__payable_transaction_KEYint (4)If the vendor check being printed has a payable transaction as its source (ie. the vendor check was created to pay the payable transaction), then this foreign key will point to said payable. Otherwise, this column will be set to null.
source__pending_ap_payment_KEYint (4)If the AP check being printed has a pending AP payment from Manage Payments as its source (ie. the AP check was created to pay one or more AP payable transactions), then this foreign key will point to the Manage Payments pending payment row. Otherwise, this column will be set to null.
check_print_run_KEYint (4)NOT NULLThe print run this record is associated with.
vendor_payment_method_KEYint (4)Selected vendor payment method, NULL if there isn't one
Primary key
NameColumnsDescription
PK_Print_Check_Selectionprint_check_selection_KEY
Unique constraints
NameColumnsDescription
UK_Print_Check_Selection$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Check_Selection__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Print_Check_Selection__Check_Print_Run__check_print_run_KEYcheck_print_run_KEYCheck_Print_Run (check_print_run_KEY)
FK_Print_Check_Selection__Payable_Transaction__source__payable_transaction_KEYsource__payable_transaction_KEYPayable_Transaction (payable_transaction_KEY)
FK_Print_Check_Selection__Pending_AP_Payment__source__pending_ap_payment_KEYsource__pending_ap_payment_KEYPending_AP_Payment (pending_ap_payment_KEY)
FK_Print_Check_Selection__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)
FK_Print_Check_Selection__Vendor_Payment_Method__vendor_payment_method_KEYvendor_payment_method_KEYVendor_Payment_Method (vendor_payment_method_KEY)Foreign key to the Vendor_Payment_Method table.

Schema diagram