Table: dbo.Journal_Entry_Template_Automatic_Percentage_Source_Account
Journal_Entry_Template_Automatic_Percentage_Source_Account - source account information used in the calculation for automatic percentage journal entries.
Columns
NameTypeConstraintsDescription
journal_entry_template_automatic_percentage_source_account_KEYint (4)NOT NULLPrimary key
journal_entry_KEYint (4)NOT NULLForeign key for the associated parent Journal Entry
from__gl_account_KEYint (4)NOT NULLBeginning GL account in the source account range
to__gl_account_KEYint (4)Ending GL account in the source account range, can be blank if only one account to include.
gl_balance_calculation_method_KEYint (4)NOT NULLType of balance calculation to perform on the source account range: YTD or current.
Primary key
NameColumnsDescription
PK_Journal_Entry_Template_Automatic_Percentage_Source_Accountjournal_entry_template_automatic_percentage_source_account_KEY
Unique constraints
NameColumnsDescription
UK_Journal_Entry_Template_Automatic_Percentage_Source_Account$journal_entry_template_automatic_percentage_source_account_KEY$frojournal_entry_template_automatic_percentage_source_account_KEY, from__gl_account_KEY, to__gl_account_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Account__from__gl_account_KEYfrom__gl_account_KEYGL_Account (gl_account_KEY)
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Account__to__gl_account_KEYto__gl_account_KEYGL_Account (gl_account_KEY)
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Balance_Calculation_Method__gl_balance_calculation_method_KEYgl_balance_calculation_method_KEYGL_Balance_Calculation_Method (gl_balance_calculation_method_KEY)
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__Journal_Entry_Template__journal_entry_KEYjournal_entry_KEYJournal_Entry_Template (journal_entry_KEY)

Schema diagram