Table: dbo.Journal_Entry_Template
Contains Journal Entry specific template information.
Columns
Name | Type | Constraints | Description
journal_entry_KEY | int (4) | NOT NULL | Primary key.
compounding_priority | int (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_dirty | bit (1) | NOT NULL | Flag indicating that any transactions generated from this template need to be recalculated.
first_period__gl_period_KEY | int (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_KEY | int (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_KEY | int (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_KEY | int (4) |  | Indicates how automatic journal entry calculation should determine the sign of the distributions in the journal entry it creates.

Primary key
Name | Columns | Description
PK_Journal_Entry_Template$journal_entry_KEY | journal_entry_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Journal_Entry_Template__Automatic_Journal_Entry_Period_Option__automatic_journal_entry_period_option_KEY | automatic_journal_entry_period_option_KEY | Automatic_Journal_Entry_Period_Option (automatic_journal_entry_period_option_KEY) |
FK_Journal_Entry_Template__Balance_Type__balance_type_KEY | balance_type_KEY | Balance_Type (balance_type_KEY) |
FK_Journal_Entry_Template__GL_Balance_Effect__gl_balance_effect_KEY | gl_balance_effect_KEY | GL_Balance_Effect (gl_balance_effect_KEY) |
FK_Journal_Entry_Template__GL_Period__first_period__gl_period_KEY | first_period__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Journal_Entry_Template__Journal_Entry__journal_entry_KEY | journal_entry_KEY | Journal_Entry (journal_entry_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__Journal_Entry_Template__journal_entry_KEY | journal_entry_KEY | Journal_Entry_Template_Automatic_Percentage_Distribution |
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__Journal_Entry_Template__journal_entry_KEY | journal_entry_KEY | Journal_Entry_Template_Automatic_Percentage_Source_Account |