Table: dbo.Trial_Balance_Split_Screen_Grid_Option
Table to store the options on a per client basis for the Journal Entry Split Screen View in the Trial Balance Grid.
Columns
Name | Type | Constraints | Description
trial_balance_split_screen_grid_option_KEY | int (4) | NOT NULL | Primary key
journal_KEY | int (4) | NOT NULL | Foreign Key to the Journal table. This is used as the default journal for new entries in the split screen grid.
journal_entry_type_KEY | int (4) | NOT NULL | Foreign Key to the Journal_Entry_Type table. This is used as the defaule journal entry type for new entries in the split screen grid.
client_KEY | int (4) | NOT NULL | Foreign Key to the Client table. Each option belongs to a particular staff/client pair. This is the client part of that pair.
staff_KEY | int (4) | NOT NULL | Foreign Key to the Staff table. Each option belongs to a particular staff/client pair. This is the staff part of that pair.
display_split_screen | bit (1) | NOT NULL | Option to show or hide the split screen view.
default_to_posting_period_date | bit (1) | NOT NULL | Option to set the default posting period date for new Journal Entries

Primary key
Name | Columns | Description
PK_Trial_Balance_Split_Screen_Grid_Option | trial_balance_split_screen_grid_option_KEY |
Unique constraints
Name | Columns | Description
UK_Trial_Balance_Split_Screen_Grid_Option$client_KEY$staff_KEY | client_KEY, staff_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Trial_Balance_Split_Screen_Grid_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Trial_Balance_Split_Screen_Grid_Option__Journal__journal_KEY | journal_KEY | Journal (journal_KEY) |
FK_Trial_Balance_Split_Screen_Grid_Option__Journal_Entry_Type__journal_entry_type_KEY | journal_entry_type_KEY | Journal_Entry_Type (journal_entry_type_KEY) |
FK_Trial_Balance_Split_Screen_Grid_Option__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |