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
Name | Type | Constraints | Description
enter_transaction_data_entry_session_element_KEY | int (4) | NOT NULL | Primary key for this table.
gl_transaction_KEY | int (4) | NOT NULL | The gl transaction key to be included in the current data entry session.
staff_KEY | int (4) | NOT NULL | The staff member that data entry session belongs to.
only_for_client_access | bit (1) | NOT NULL | The data entry session belongs to either 'Client Access' or to 'ACS'; this flag tells us which.

Primary key
Name | Columns | Description
PK_Enter_Transaction_Data_Entry_Session_Element | enter_transaction_data_entry_session_element_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Enter_Transaction_Data_Entry_Session_Element__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | GL_Transaction (gl_transaction_KEY) |
FK_Enter_Transaction_Data_Entry_Session_Element__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |