Table: dbo.Journal_Entry_Template_Automatic_Percentage_Distribution
Journal_Entry_Template_Automatic_Percentage_Distribution - allocates a percentage of the source amount to a gl account.
Columns
Name | Type | Constraints | Description
journal_entry_template_automatic_percentage_distribution_KEY | int (4) | NOT NULL | Primary key
journal_entry_KEY | int (4) | NOT NULL | Foreign key for the associated parent Journal Entry
gl_account_KEY | int (4) | NOT NULL | GL Account to be debited or credited.
percentage | decimal (5, 2) | NOT NULL | Amount to allocate to the GL Account.
gl_balance_effect_KEY | int (4) | NOT NULL | Indicates if the distribution is a debit or a credit.

Primary key
Name | Columns | Description
PK_Journal_Entry_Template_Automatic_Percentage_Distribution | journal_entry_template_automatic_percentage_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__GL_Balance_Effect__gl_balance_effect_KEY | gl_balance_effect_KEY | GL_Balance_Effect (gl_balance_effect_KEY) |
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__Journal_Entry_Template__journal_entry_KEY | journal_entry_KEY | Journal_Entry_Template (journal_entry_KEY) |