Table: dbo.Journal_Entry_Template
Contains Journal Entry specific template information.
Columns
NameTypeConstraintsDescription
journal_entry_KEYint (4)NOT NULLPrimary key.
compounding_priorityint (4)Used to sort the templates so that automatic percentage templates that compound can generate transactions in the correct order. Leave null for journal entries templates that are not automatic or do not need to compound.
is_dirtybit (1)NOT NULLFlag indicating that any transactions generated from this template need to be recalculated.
first_period__gl_period_KEYint (4)Indicates the period in which automatic type transaction templates should begin generating transactions. Required when frequency type is automatic, for all other types it should be set to null.
balance_type_KEYint (4)Indicates the balance type to be used when calculating a source amounts when generating transactions from automatic templates. Required when frequency type is automatic, for all other types it should be set to null.
automatic_journal_entry_period_option_KEYint (4)The period option for an automatic journal entry template. Null if the template is for something other than an automatic journal entry.
gl_balance_effect_KEYint (4)Indicates how automatic journal entry calculation should determine the sign of the distributions in the journal entry it creates.
Primary key
NameColumnsDescription
PK_Journal_Entry_Template$journal_entry_KEYjournal_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal_Entry_Template__Automatic_Journal_Entry_Period_Option__automatic_journal_entry_period_option_KEYautomatic_journal_entry_period_option_KEYAutomatic_Journal_Entry_Period_Option (automatic_journal_entry_period_option_KEY)
FK_Journal_Entry_Template__Balance_Type__balance_type_KEYbalance_type_KEYBalance_Type (balance_type_KEY)
FK_Journal_Entry_Template__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYGL_Balance_Effect (gl_balance_effect_KEY)
FK_Journal_Entry_Template__GL_Period__first_period__gl_period_KEYfirst_period__gl_period_KEYGL_Period (gl_period_KEY)
FK_Journal_Entry_Template__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry (journal_entry_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__Journal_Entry_Template__journal_entry_KEYjournal_entry_KEYJournal_Entry_Template_Automatic_Percentage_Distribution
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__Journal_Entry_Template__journal_entry_KEYjournal_entry_KEYJournal_Entry_Template_Automatic_Percentage_Source_Account

Schema diagram