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