Table: dbo.Balance_Definition_Journal_Entry_Type_Component
Connects a client balance to the journal entry types that are it's components.
Columns
NameTypeConstraintsDescription
balance_definition_journal_entry_type_component_KEYint (4)NOT NULLPrimary key
balance_definition_KEYint (4)NOT NULLKey to the Balance_Definition Table
journal_entry_type_KEYint (4)NOT NULLKey to the Journal_Entry_Type table
Primary key
NameColumnsDescription
PK_Balance_Definition_Journal_Entry_Type_Componentbalance_definition_journal_entry_type_component_KEY
Unique constraints
NameColumnsDescription
UK_Balance_Definition_Journal_Entry_Type_Component$balance_definition_KEY$journal_entry_type_KEYbalance_definition_KEY, journal_entry_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Balance_Definition_Journal_Entry_Type_Component__Balance_Definition__balance_definition_KEYbalance_definition_KEYBalance_Definition (balance_definition_KEY)
FK_Balance_Definition_Journal_Entry_Type_Component__Journal_Entry_Type__journal_entry_type_KEYjournal_entry_type_KEYJournal_Entry_Type (journal_entry_type_KEY)

Schema diagram