Table: dbo.Quick_Books_Account_N_Checkbook
This table will have an entry for every quickbooks gl account of type Bank that is mapped to an acs checking account.
Columns
Name | Type | Constraints | Description
quick_books_account_KEY | int (4) | NOT NULL | The key which links us to a quickbooks account table record.
checkbook_KEY | int (4) | NOT NULL | The key which links us to a checkbook table record.

Primary key
Name | Columns | Description
PK_Quick_Books_Account_N_Checkbook$quick_books_account_KEY | quick_books_account_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Account_N_Checkbook__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Quick_Books_Account_N_Checkbook__Quick_Books_Account__quick_books_account_KEY | quick_books_account_KEY | Quick_Books_Account (quick_books_account_KEY) |