Table: dbo.Transaction_Template_N_GL_Transaction
This dictionary table associates a transaction template with a GL transaction that was created from it.
Columns
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLPrimary key. Also the foreign key to the gl transaciton being associated with a transaction template.
transaction_template_KEYint (4)NOT NULLForeign key to the transaction template.
Primary key
NameColumnsDescription
PK_Transaction_Template_N_GL_Transaction$gl_transaction_KEYgl_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Transaction_Template_N_GL_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)
FK_Transaction_Template_N_GL_Transaction__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)

Schema diagram