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
NameTypeConstraintsDescription
journal_entry_template_automatic_percentage_distribution_KEYint (4)NOT NULLPrimary key
journal_entry_KEYint (4)NOT NULLForeign key for the associated parent Journal Entry
gl_account_KEYint (4)NOT NULLGL Account to be debited or credited.
percentagedecimal (5, 2)NOT NULLAmount to allocate to the GL Account.
gl_balance_effect_KEYint (4)NOT NULLIndicates if the distribution is a debit or a credit.
Primary key
NameColumnsDescription
PK_Journal_Entry_Template_Automatic_Percentage_Distributionjournal_entry_template_automatic_percentage_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYGL_Balance_Effect (gl_balance_effect_KEY)
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__Journal_Entry_Template__journal_entry_KEYjournal_entry_KEYJournal_Entry_Template (journal_entry_KEY)

Schema diagram