Table: dbo.Transaction_Template_N_Journal_Entry
This dictionary table associates a jouranl entry transaction with a transaction template.
Columns
NameTypeConstraintsDescription
transaction_template_KEYint (4)NOT NULLPrimary key. Also the foreign key to the transaction template being associated with a journal entry.
journal_entry_KEYint (4)NOT NULLForeign key to the journal entry.
Primary key
NameColumnsDescription
PK_Transaction_Template_N_Journal_Entry$transaction_template_KEYtransaction_template_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Template_N_Journal_Entry$journal_entry_KEYjournal_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Transaction_Template_N_Journal_Entry__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry (journal_entry_KEY)
FK_Transaction_Template_N_Journal_Entry__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)

Schema diagram