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
Name | Type | Constraints | Description
journal_entry_template_automatic_percentage_source_account_KEY | int (4) | NOT NULL | Primary key
journal_entry_KEY | int (4) | NOT NULL | Foreign key for the associated parent Journal Entry
from__gl_account_KEY | int (4) | NOT NULL | Beginning GL account in the source account range
to__gl_account_KEY | int (4) |  | Ending GL account in the source account range, can be blank if only one account to include.
gl_balance_calculation_method_KEY | int (4) | NOT NULL | Type of balance calculation to perform on the source account range: YTD or current.

Primary key
Name | Columns | Description
PK_Journal_Entry_Template_Automatic_Percentage_Source_Account | journal_entry_template_automatic_percentage_source_account_KEY |
Unique constraints
Name | Columns | Description
UK_Journal_Entry_Template_Automatic_Percentage_Source_Account$journal_entry_template_automatic_percentage_source_account_KEY$fro | journal_entry_template_automatic_percentage_source_account_KEY, from__gl_account_KEY, to__gl_account_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Account__from__gl_account_KEY | from__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Account__to__gl_account_KEY | to__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Balance_Calculation_Method__gl_balance_calculation_method_KEY | gl_balance_calculation_method_KEY | GL_Balance_Calculation_Method (gl_balance_calculation_method_KEY) |
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__Journal_Entry_Template__journal_entry_KEY | journal_entry_KEY | Journal_Entry_Template (journal_entry_KEY) |