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 |