Table: dbo.Quick_Books_Transaction_Distribution
This table will store the transaction distributions of transactions imported from QuickBooks.
Columns
NameTypeConstraintsDescription
quick_books_transaction_distribution_KEYint (4)NOT NULLPrimary Key for this table.
quick_books_transaction_KEYint (4)NOT NULLForeign key to the quickbooks transaction table, a table which stores the transaction keys of transactions imported from QuickBooks.
amountdecimal (9, 2)NOT NULLThe amount of a transaction distribution.
gl_account_KEYint (4)NOT NULLThis is a foreign key to the GL Account table. The gl account of a transaction distribution.
Primary key
NameColumnsDescription
PK_Quick_Books_Transaction_Distributionquick_books_transaction_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Transaction_Distribution__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Quick_Books_Transaction_Distribution__Quick_Books_Transaction__quick_books_transaction_KEYquick_books_transaction_KEYQuick_Books_Transaction (quick_books_transaction_KEY)

Schema diagram