| 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 | ||