Table: dbo.GL_Transaction_N_Journal_Entry
This dictionary table associates a jouranl entry transaction with its associated GL transaction.
Columns
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLPrimary key. Also the foreign key to the GL transaction being associated with a journal entry.
journal_entry_KEYint (4)NOT NULLForeign key to the journal entry.
Primary key
NameColumnsDescription
PK_GL_Transaction_N_Journal_Entry$gl_transaction_KEYgl_transaction_KEY
Unique constraints
NameColumnsDescription
UK_GL_Transaction_N_Journal_Entry$journal_entry_KEYjournal_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Transaction_N_Journal_Entry__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)
FK_GL_Transaction_N_Journal_Entry__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry (journal_entry_KEY)

Schema diagram