| Table: dbo.Quick_Books_Payee_N_Vendor | |||
| This table will have an entry for every quickbooks payee of type vendor that is mapped to an acs vendor. | |||
| 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. |
| vendor_KEY | int (4) | NOT NULL | The key which links us to an Vendor table record. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Quick_Books_Payee_N_Vendor$quick_books_payee_KEY | quick_books_payee_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Quick_Books_Payee_N_Vendor__Quick_Books_Payee__quick_books_payee_KEY | quick_books_payee_KEY | Quick_Books_Payee (quick_books_payee_KEY) | |
| FK_Quick_Books_Payee_N_Vendor__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) | |