Table: dbo.Print_AR_Transaction_Selection
This is a locking table that ensures an AR Transaction added to it is not being printed by more than one user at a time.
Columns
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLThe primary key for this table and foreign key to the AR Transaction record being printed.
reference_numbernvarchar (32)NOT NULLThe reference number of the AR Transaction being printed. New reference numbers are not saved back to the transaction until the printing process is over. This stores the reference number for use in reports.
user_session_guiduniqueidentifier (16)NOT NULLGuid that identifies the user session this record is part of.
Primary key
NameColumnsDescription
PK_Print_AR_Transaction_Selection$gl_transaction_KEYgl_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_AR_Transaction_Selection__AR_Transaction__gl_transaction_KEYgl_transaction_KEYAR_Transaction (gl_transaction_KEY)
FK_Print_AR_Transaction_Selection__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)

Schema diagram