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