Table: dbo.Transaction_Template
Transaction Templates - Parent table for template information used to create OnDemand or recurring transactions.
Columns
NameTypeConstraintsDescription
transaction_template_KEYint (4)NOT NULLPrimary key
transaction_template_idnvarchar (22)NOT NULLId for the template
descriptionnvarchar (240)NOT NULLDescription
journal_KEYint (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_KEYint (4)NOT NULLSpecifies the frequency at which transactions should be generated from the template.
frequency_intervalint (4)NOT NULLThe interval between generations of the template based on the frequency.
transaction_template_automatic_type_KEYint (4)Required subtype for templates of frequency automatic. For all other types the value should remain null.
client_KEYint (4)NOT NULL
next_recurrence__gl_period_KEYint (4)The next GL period in which the transaction recurs.
Primary key
NameColumnsDescription
PK_Transaction_Templatetransaction_template_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Transaction_Template__Client__client_KEYclient_KEYClient (client_KEY)
FK_Transaction_Template__GL_Period__next_recurrence__gl_period_KEYnext_recurrence__gl_period_KEYGL_Period (gl_period_KEY)
FK_Transaction_Template__Journal__journal_KEYjournal_KEYJournal (journal_KEY)
FK_Transaction_Template__Transaction_Template_Automatic_Type__transaction_template_automatic_type_KEYtransaction_template_automatic_type_KEYTransaction_Template_Automatic_Type (transaction_template_automatic_type_KEY)
FK_Transaction_Template__Transaction_Template_Frequency__transaction_template_frequency_KEYtransaction_template_frequency_KEYTransaction_Template_Frequency (transaction_template_frequency_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Scheduled_Transaction_Interval__Transaction_Template__transaction_template_KEYtransaction_template_KEYScheduled_Transaction_Interval
FK_Transaction_Template_Schedule_Option__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template_Schedule_Option
FK_Transaction_Template_Note__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template_Note
FK_Transaction_Template_N_GL_Transaction__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template_N_GL_Transaction
FK_Payable_Transaction_Template_Distribution__Transaction_Template__transaction_template_KEYtransaction_template_KEYPayable_Transaction_Template_Distribution
FK_AR_Transaction_Template__Transaction_Template__transaction_template_KEYtransaction_template_KEYAR_Transaction_Template
FK_Transaction_Template_N_Journal_Entry__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template_N_Journal_Entry
FK_Bank_Transaction__Transaction_Template__generated_by__transaction_template_KEYgenerated_by__transaction_template_KEYBank_Transaction
FK_Payable_Transaction_Template__Transaction_Template__transaction_template_KEYtransaction_template_KEYPayable_Transaction_Template
FK_Bank_Transaction_Template__Transaction_Template__transaction_template_KEYtransaction_template_KEYBank_Transaction_Template

Schema diagram