Table: dbo.Tax_Form_Liability_Processing_Lock
This table is used to implement a locking mechanism for tax form liability processing. When a tax form's liabilities are being processed an entry is first made into this table to indicate that other users are prevented from processing identical liabilities.
Columns
NameTypeConstraintsDescription
tax_form_liability_processing_lock_KEYint (4)NOT NULLPrimary key for this table.
user_session_guiduniqueidentifier (16)NOT NULLThe user session identifier of the user locking the forms.
client_KEYint (4)NOT NULLForeign key to client being processed.
tax_form_KEYint (4)NOT NULLForeign key to the tax form being processed.
period_end_datesmalldatetime (4)NOT NULLPeriod end date for the liabilities being processed.
Primary key
NameColumnsDescription
PK_Tax_Form_Liability_Processing_Locktax_form_liability_processing_lock_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Form_Liability_Processing_Lock__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)
FK_Tax_Form_Liability_Processing_Lock__Client__client_KEYclient_KEYClient (client_KEY)
FK_Tax_Form_Liability_Processing_Lock__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)

Schema diagram