Table: dbo.Print_Receivable_Transaction_Detail_Selection
This table stores locks for receivable transaction detail records (aka fees) tied to invoices that are printing so that other users may not print them.
Columns
NameTypeConstraintsDescription
receivable_transaction_detail_KEYint (4)NOT NULLPrimary key for this table and foreign key into table Receivable_Transaction_Detail for the receivable transaction detail record (fee) to be locked and printed.
user_session_guiduniqueidentifier (16)NOT NULLForeign key into table User_Session for the user session associated with the print job for which we are locking a receivable transaction detail record (fee).
Primary key
NameColumnsDescription
PK_Print_Receivable_Transaction_Detail_Selection$receivable_transaction_detail_KEYreceivable_transaction_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Receivable_Transaction_Detail_Selection__Receivable_Transaction_Detail__receivable_transaction_detail_KEYreceivable_transaction_detail_KEYReceivable_Transaction_Detail (receivable_transaction_detail_KEY)
FK_Print_Receivable_Transaction_Detail_Selection__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram