Quick Books Payee |
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. |