Table: dbo.Quick_Books_Payee_N_Employee
This table will have an entry for every quickbooks payee of type employee that is mapped to an acs employee.
Columns
Name | Type | Constraints | Description
quick_books_payee_KEY | int (4) | NOT NULL | The key which links us to a Quick_Books_Payee table record.
employee_KEY | int (4) | NOT NULL | The key which links us to an Employee table record.

Primary key
Name | Columns | Description
PK_Quick_Books_Payee_N_Employee$quick_books_payee_KEY | quick_books_payee_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Payee_N_Employee__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Quick_Books_Payee_N_Employee__Quick_Books_Payee__quick_books_payee_KEY | quick_books_payee_KEY | Quick_Books_Payee (quick_books_payee_KEY) |