Table: dbo.Balance_Type
ACS Balance Types - enumerates the supported calculation basis of journal entry balances
Columns
NameTypeConstraintsDescription
balance_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (20)NOT NULLValues: Unadjusted, Adjusted, Report, Tax, Other
editablebit (1)NOT NULLTrue if this balance type allows the user to select which types of journal entries are included in the calculated balance amount.
roundablebit (1)NOT NULLTrue if user can set this balance type to be rounded on reports for a client
Primary key
NameColumnsDescription
PK_Balance_Typebalance_type_KEY
Unique constraints
NameColumnsDescription
UK_Balance_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Balance_Definition__Balance_Type__balance_type_KEYbalance_type_KEYBalance_Definition
FK_User_Preference__Balance_Type__view_account_activity_balance_type_KEYview_account_activity_balance_type_KEYUser_Preference
FK_Client_Consolidation_Option__Balance_Type__balance_type_KEYbalance_type_KEYClient_Consolidation_Option
FK_Client_Consolidation_Option__Balance_Type__used_previously__balance_type_KEYused_previously__balance_type_KEYClient_Consolidation_Option
FK_Journal_Entry_Template__Balance_Type__balance_type_KEYbalance_type_KEYJournal_Entry_Template

Schema diagram