Table: dbo.Quick_Books_Payee
Quick Books Payee
Columns
Name | Type | Constraints | Description
quick_books_payee_KEY | int (4) | NOT NULL | Primary key.
client_KEY | int (4) | NOT NULL | The client_KEY for this payee.
name | nvarchar (160) | NOT NULL | name.
full_name | nvarchar (510) | NOT NULL | full name.
first_name | nvarchar (100) | NOT NULL | first name.
middle_name | nvarchar (40) | NOT NULL | middle name.
last_name | nvarchar (100) | NOT NULL | last name.
is_active | bit (1) | NOT NULL | flag for indicating the active status of the payee.
list_id | nvarchar (120) | NOT NULL | The Quick Books list id for the payee.
quick_books_payee_type_KEY | int (4) | NOT NULL | Key for the payee type of this payee.
do_not_import | bit (1) | NOT NULL | when set true, this tells us that the user does not want to import a particular vendor or employee from QuickBooks into Accounting CS. The vendor or employee will not be added and will not be mapped to an existing Accounting CS vendor or employee. This setting needs to be saved so that the data mapping user interface can display a user choice from a previous import.

Primary key
Name | Columns | Description
PK_Quick_Books_Payee | quick_books_payee_KEY |
Unique constraints
Name | Columns | Description
UK_Quick_Books_Payee$full_name$list_id$client_KEY | full_name, list_id, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Payee__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Quick_Books_Payee__Quick_Books_Payee_Type__quick_books_payee_type_KEY | quick_books_payee_type_KEY | Quick_Books_Payee_Type (quick_books_payee_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Vendor__Quick_Books_Payee__export__quick_books_payee_KEY | export__quick_books_payee_KEY | Vendor |
FK_Quick_Books_Payee_N_Vendor__Quick_Books_Payee__quick_books_payee_KEY | quick_books_payee_KEY | Quick_Books_Payee_N_Vendor |
FK_Employee__Quick_Books_Payee__export__quick_books_payee_KEY | export__quick_books_payee_KEY | Employee |
FK_Quick_Books_Payee_N_Employee__Quick_Books_Payee__quick_books_payee_KEY | quick_books_payee_KEY | Quick_Books_Payee_N_Employee |