Table: dbo.Balance_Definition
Balance Definition Table - Defines what journal entry types make up a balance for a client
Columns
Name | Type | Constraints | Description
balance_definition_KEY | int (4) | NOT NULL | Primary key
balance_type_KEY | int (4) | NOT NULL | Key to the Balance_Type table -- Balance that is being defined for this client
client_KEY | int (4) | NOT NULL | Key to the Client table
round_balance | bit (1) | NOT NULL | True if this balance should be rounded on reports

Primary key
Name | Columns | Description
PK_Balance_Definition | balance_definition_KEY |
Unique constraints
Name | Columns | Description
UK_Balance_Definition$balance_type_KEY$client_KEY | balance_type_KEY, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Balance_Definition__Balance_Type__balance_type_KEY | balance_type_KEY | Balance_Type (balance_type_KEY) |
FK_Balance_Definition__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Balance_Definition_Journal_Entry_Type_Component__Balance_Definition__balance_definition_KEY | balance_definition_KEY | Balance_Definition_Journal_Entry_Type_Component |
FK_Recorded_Event_Object_N_Balance_Definition__Balance_Definition__balance_definition_KEY | balance_definition_KEY | Recorded_Event_Object_N_Balance_Definition |