Table: dbo.Journal_Entry_Reversal
This table stores links between an journal entry that has been reversed and its journal entry reversal.
Columns
NameTypeConstraintsDescription
reversed__journal_entry_KEYint (4)NOT NULLPrimary key and foreign key to the parent journal entry being reversed
reversal__journal_entry_KEYint (4)NOT NULLForeign key to the journal entry created to reverse the other
Primary key
NameColumnsDescription
PK_Journal_Entry_Reversal$reversal__journal_entry_KEYreversal__journal_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal_Entry_Reversal__Journal_Entry__reversal__journal_entry_KEYreversal__journal_entry_KEYJournal_Entry (journal_entry_KEY)
FK_Journal_Entry_Reversal__Journal_Entry__reversed__journal_entry_KEYreversed__journal_entry_KEYJournal_Entry (journal_entry_KEY)

Schema diagram