Table: dbo.GL_Balance_Effect
This table stores type definition for the balances.
Columns
NameTypeConstraintsDescription
gl_balance_effect_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (60)NOT NULLA description for the GL_Balance_Effect.
Primary key
NameColumnsDescription
PK_GL_Balance_Effectgl_balance_effect_KEY
Unique constraints
NameColumnsDescription
UK_GL_Balance_Effect$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Import_Template_Column_GL_Account_Data__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYImport_Template_Column_GL_Account_Data
FK_Journal_Entry_Template__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYJournal_Entry_Template
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYJournal_Entry_Template_Automatic_Percentage_Distribution
FK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYBank_Reconciliation_Rapid_Clear_Unmatched_Transaction

Schema diagram