Table: dbo.Print_Payable_Transaction_Selection
Lock payable transactions during printing (similar to table Print_Check_Selection, which locks bank transactions during printing).
Columns
NameTypeConstraintsDescription
print_payable_transaction_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 the potential problems we want to address with this table.
payable_transaction_KEYint (4)NOT NULLThe payable transaction for the vendor agent check we are printing.
bank_transaction_KEYint (4)During a check printing process, Bank Transaction information (relating to the liability ["BR"]on the check) can be used/displayed/printed. This is the bank transaction that is being printed to ["BR"]pay this liability. Note that a given bank transaction can pay multiple liabilities.
check_print_run_KEYint (4)NOT NULLThe print run this record is associated with.
Primary key
NameColumnsDescription
PK_Print_Payable_Transaction_Selectionprint_payable_transaction_selection_KEY
Unique constraints
NameColumnsDescription
UK_Print_Payable_Transaction_Selection$payable_transaction_KEYpayable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Payable_Transaction_Selection__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Print_Payable_Transaction_Selection__Check_Print_Run__check_print_run_KEYcheck_print_run_KEYCheck_Print_Run (check_print_run_KEY)
FK_Print_Payable_Transaction_Selection__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)
FK_Print_Payable_Transaction_Selection__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram