Table: dbo.Quick_Books_Transaction_Distribution
This table will store the transaction distributions of transactions imported from QuickBooks.
Columns
Name | Type | Constraints | Description
quick_books_transaction_distribution_KEY | int (4) | NOT NULL | Primary Key for this table.
quick_books_transaction_KEY | int (4) | NOT NULL | Foreign key to the quickbooks transaction table, a table which stores the transaction keys of transactions imported from QuickBooks.
amount | decimal (9, 2) | NOT NULL | The amount of a transaction distribution.
gl_account_KEY | int (4) | NOT NULL | This is a foreign key to the GL Account table. The gl account of a transaction distribution.

Primary key
Name | Columns | Description
PK_Quick_Books_Transaction_Distribution | quick_books_transaction_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Transaction_Distribution__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Quick_Books_Transaction_Distribution__Quick_Books_Transaction__quick_books_transaction_KEY | quick_books_transaction_KEY | Quick_Books_Transaction (quick_books_transaction_KEY) |