Table: dbo.GL_Transaction_N_Bank_Transaction
This dictionary table associates a bank transaction with its associated GL transaction specific detail.
Columns
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLPrimary key. Also the foreign key to the GL transaction detail being associated with a bank transaction.
bank_transaction_KEYint (4)NOT NULLForeign key to Bank_Transaction.
Primary key
NameColumnsDescription
PK_GL_Transaction_N_Bank_Transaction$gl_transaction_KEYgl_transaction_KEY
Unique constraints
NameColumnsDescription
UK_GL_Transaction_N_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Transaction_N_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_GL_Transaction_N_Bank_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)

Schema diagram