| 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) | |