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 |