Table: dbo.Balance_Definition
Balance Definition Table - Defines what journal entry types make up a balance for a client
Columns
NameTypeConstraintsDescription
balance_definition_KEYint (4)NOT NULLPrimary key
balance_type_KEYint (4)NOT NULLKey to the Balance_Type table -- Balance that is being defined for this client
client_KEYint (4)NOT NULLKey to the Client table
round_balancebit (1)NOT NULLTrue if this balance should be rounded on reports
Primary key
NameColumnsDescription
PK_Balance_Definitionbalance_definition_KEY
Unique constraints
NameColumnsDescription
UK_Balance_Definition$balance_type_KEY$client_KEYbalance_type_KEY, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Balance_Definition__Balance_Type__balance_type_KEYbalance_type_KEYBalance_Type (balance_type_KEY)
FK_Balance_Definition__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Balance_Definition_Journal_Entry_Type_Component__Balance_Definition__balance_definition_KEYbalance_definition_KEYBalance_Definition_Journal_Entry_Type_Component
FK_Recorded_Event_Object_N_Balance_Definition__Balance_Definition__balance_definition_KEYbalance_definition_KEYRecorded_Event_Object_N_Balance_Definition

Schema diagram