| 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) | |