Table: dbo.Transaction_Template
Transaction Templates - Parent table for template information used to create OnDemand or recurring transactions.
Columns
Name | Type | Constraints | Description
transaction_template_KEY | int (4) | NOT NULL | Primary key
transaction_template_id | nvarchar (22) | NOT NULL | Id for the template
description | nvarchar (240) | NOT NULL | Description
journal_KEY | int (4) |  | Key of the journal to used for any generated transactions. Can be null for OnDemand templates, in which case the user will have to specify the Journal on the generated transaction before saving.
transaction_template_frequency_KEY | int (4) | NOT NULL | Specifies the frequency at which transactions should be generated from the template.
frequency_interval | int (4) | NOT NULL | The interval between generations of the template based on the frequency.
transaction_template_automatic_type_KEY | int (4) |  | Required subtype for templates of frequency automatic. For all other types the value should remain null.
client_KEY | int (4) | NOT NULL |
next_recurrence__gl_period_KEY | int (4) |  | The next GL period in which the transaction recurs.

Primary key
Name | Columns | Description
PK_Transaction_Template | transaction_template_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Transaction_Template__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Transaction_Template__GL_Period__next_recurrence__gl_period_KEY | next_recurrence__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Transaction_Template__Journal__journal_KEY | journal_KEY | Journal (journal_KEY) |
FK_Transaction_Template__Transaction_Template_Automatic_Type__transaction_template_automatic_type_KEY | transaction_template_automatic_type_KEY | Transaction_Template_Automatic_Type (transaction_template_automatic_type_KEY) |
FK_Transaction_Template__Transaction_Template_Frequency__transaction_template_frequency_KEY | transaction_template_frequency_KEY | Transaction_Template_Frequency (transaction_template_frequency_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Scheduled_Transaction_Interval__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Scheduled_Transaction_Interval |
FK_Transaction_Template_Schedule_Option__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template_Schedule_Option |
FK_Transaction_Template_Note__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template_Note |
FK_Transaction_Template_N_GL_Transaction__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template_N_GL_Transaction |
FK_Payable_Transaction_Template_Distribution__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Payable_Transaction_Template_Distribution |
FK_AR_Transaction_Template__Transaction_Template__transaction_template_KEY | transaction_template_KEY | AR_Transaction_Template |
FK_Transaction_Template_N_Journal_Entry__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template_N_Journal_Entry |
FK_Bank_Transaction__Transaction_Template__generated_by__transaction_template_KEY | generated_by__transaction_template_KEY | Bank_Transaction |
FK_Payable_Transaction_Template__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Payable_Transaction_Template |
FK_Bank_Transaction_Template__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Bank_Transaction_Template |