Table: dbo.Balance_Type
ACS Balance Types - enumerates the supported calculation basis of journal entry balances
Columns
Name | Type | Constraints | Description
balance_type_KEY | int (4) | NOT NULL | Primary key
description | nvarchar (20) | NOT NULL | Values: Unadjusted, Adjusted, Report, Tax, Other
editable | bit (1) | NOT NULL | True if this balance type allows the user to select which types of journal entries are included in the calculated balance amount.
roundable | bit (1) | NOT NULL | True if user can set this balance type to be rounded on reports for a client

Primary key
Name | Columns | Description
PK_Balance_Type | balance_type_KEY |
Unique constraints
Name | Columns | Description
UK_Balance_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Balance_Definition__Balance_Type__balance_type_KEY | balance_type_KEY | Balance_Definition |
FK_User_Preference__Balance_Type__view_account_activity_balance_type_KEY | view_account_activity_balance_type_KEY | User_Preference |
FK_Client_Consolidation_Option__Balance_Type__balance_type_KEY | balance_type_KEY | Client_Consolidation_Option |
FK_Client_Consolidation_Option__Balance_Type__used_previously__balance_type_KEY | used_previously__balance_type_KEY | Client_Consolidation_Option |
FK_Journal_Entry_Template__Balance_Type__balance_type_KEY | balance_type_KEY | Journal_Entry_Template |