Contains Journal Entry specific template information. |
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. |