Table: dbo.Enter_Transaction_Data_Entry_Session_Element
This table keeps track of the gl transaction keys that make up a staff member's current data entry session.
Columns
NameTypeConstraintsDescription
enter_transaction_data_entry_session_element_KEYint (4)NOT NULLPrimary key for this table.
gl_transaction_KEYint (4)NOT NULLThe gl transaction key to be included in the current data entry session.
staff_KEYint (4)NOT NULLThe staff member that data entry session belongs to.
only_for_client_accessbit (1)NOT NULLThe data entry session belongs to either 'Client Access' or to 'ACS'; this flag tells us which.
Primary key
NameColumnsDescription
PK_Enter_Transaction_Data_Entry_Session_Elemententer_transaction_data_entry_session_element_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Enter_Transaction_Data_Entry_Session_Element__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)
FK_Enter_Transaction_Data_Entry_Session_Element__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram