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
Name | Type | Constraints | Description
gl_transaction_KEY | int (4) | NOT NULL | The primary key for this table and foreign key to the AR Transaction record being printed.
reference_number | nvarchar (32) | NOT NULL | The 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_guid | uniqueidentifier (16) | NOT NULL | Guid that identifies the user session this record is part of.

Primary key
Name | Columns | Description
PK_Print_AR_Transaction_Selection$gl_transaction_KEY | gl_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_AR_Transaction_Selection__AR_Transaction__gl_transaction_KEY | gl_transaction_KEY | AR_Transaction (gl_transaction_KEY) |
FK_Print_AR_Transaction_Selection__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |