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
NameTypeConstraintsDescription
trial_balance_split_screen_grid_option_KEYint (4)NOT NULLPrimary key
journal_KEYint (4)NOT NULLForeign Key to the Journal table. This is used as the default journal for new entries in the split screen grid.
journal_entry_type_KEYint (4)NOT NULLForeign 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_KEYint (4)NOT NULLForeign Key to the Client table. Each option belongs to a particular staff/client pair. This is the client part of that pair.
staff_KEYint (4)NOT NULLForeign Key to the Staff table. Each option belongs to a particular staff/client pair. This is the staff part of that pair.
display_split_screenbit (1)NOT NULLOption to show or hide the split screen view.
default_to_posting_period_datebit (1)NOT NULLOption to set the default posting period date for new Journal Entries
Primary key
NameColumnsDescription
PK_Trial_Balance_Split_Screen_Grid_Optiontrial_balance_split_screen_grid_option_KEY
Unique constraints
NameColumnsDescription
UK_Trial_Balance_Split_Screen_Grid_Option$client_KEY$staff_KEYclient_KEY, staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Trial_Balance_Split_Screen_Grid_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_Trial_Balance_Split_Screen_Grid_Option__Journal__journal_KEYjournal_KEYJournal (journal_KEY)
FK_Trial_Balance_Split_Screen_Grid_Option__Journal_Entry_Type__journal_entry_type_KEYjournal_entry_type_KEYJournal_Entry_Type (journal_entry_type_KEY)
FK_Trial_Balance_Split_Screen_Grid_Option__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram