Table: dbo.Quick_Books_Transaction_N_GL_Transaction
This dictionary table associates a gl transaction with an associated quickbooks transaction.
Columns
NameTypeConstraintsDescription
quick_books_transaction_KEYint (4)NOT NULLForeign key to quick books transaction table.
gl_transaction_KEYint (4)NOT NULLForeign key to gl transaction table.
Primary key
NameColumnsDescription
PK_Quick_Books_Transaction_N_GL_Transaction$quick_books_transaction_KEYquick_books_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Transaction_N_GL_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)
FK_Quick_Books_Transaction_N_GL_Transaction__Quick_Books_Transaction__quick_books_transaction_KEYquick_books_transaction_KEYQuick_Books_Transaction (quick_books_transaction_KEY)

Schema diagram