Table: dbo.GL_Balancing_Entry_N_Bank_Transaction
This dictionary table links a GL balancing entry with the one or more bank transactions that the entry balances.
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLPrimary key. Also the foreign key to a bank transaction being balanced by the associated balancing entry.
gl_balancing_entry_KEYint (4)NOT NULLForeign key to the GL balancing entry.
Primary key
NameColumnsDescription
PK_GL_Balancing_Entry_N_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Balancing_Entry_N_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_GL_Balancing_Entry_N_Bank_Transaction__GL_Balancing_Entry__gl_balancing_entry_KEYgl_balancing_entry_KEYGL_Balancing_Entry (gl_balancing_entry_KEY)

Schema diagram