Table: dbo.Print_Payable_Transaction_Selection
Lock payable transactions during printing (similar to table Print_Check_Selection, which locks bank transactions during printing).
Columns
Name | Type | Constraints | Description
print_payable_transaction_selection_KEY | int (4) | NOT NULL | Primary key
user_session_guid | uniqueidentifier (16) | NOT NULL | The 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_KEY | int (4) | NOT NULL | The payable transaction for the vendor agent check we are printing.
bank_transaction_KEY | int (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_KEY | int (4) | NOT NULL | The print run this record is associated with.

Primary key
Name | Columns | Description
PK_Print_Payable_Transaction_Selection | print_payable_transaction_selection_KEY |
Unique constraints
Name | Columns | Description
UK_Print_Payable_Transaction_Selection$payable_transaction_KEY | payable_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_Payable_Transaction_Selection__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Print_Payable_Transaction_Selection__Check_Print_Run__check_print_run_KEY | check_print_run_KEY | Check_Print_Run (check_print_run_KEY) |
FK_Print_Payable_Transaction_Selection__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |
FK_Print_Payable_Transaction_Selection__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |