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