Import and export files can contain all the information in your Employee
list. import files^IIF, . The keyword for the Employee list is EMP.
Column headings
The following table shows the column headings for the Employee list. import files^IIF, . The
NAME and INIT columns are required.
NAME | (Required) The name of the employee. |
TIMESTAMP | (Export files only) A unique number that identifies the company file from
which you exported the Employee list. |
REFNUM | (Export files only) A unique number that identifies an entry in the
list. |
INIT | (Required) The employee's initials. |
ADDR1 | The first line of the employee's address. |
ADDR2 | The second line of the employee's address. |
ADDR3 | The third line of the employee's address. |
ADDR4 | The fourth line of the employee's address. |
ADDR5 | The fifth line of the employee's address. |
SSNO | The employee's Social Security number. |
PHONE1 | The employee's phone number. |
PHONE2 | An alternate phone number for the employee. |
NOTEPAD | Your notes about the employee. import files^IIF, . If you are creating an import file, the notes
appear in the Notepad window for the employee. |
FIRSTNAME | The employee's first name. |
MIDINIT | The employee's middle initial. |
LASTNAME | The employee's last name. |
SALUTATION | The employee's salutation, or title (Mr., Ms., Doctor, etc.). |
CUSTFLD1
CUSTFLD2
.
. CUSTFLD7 | The custom field entries for the employee (you can have up to 7 custom field
entries). import files^IIF, . Custom fields let you track special information about the employee,
such as the employee's birthday or email address. import files^IIF, . What you use custom
fields for is entirely up to you. |
NOTE | The name or number of the account you want to associate with this employee.
QuickBooks requires an account number if you want to set up this employee as an
online payee. import files^IIF, . The payee uses this number to identify you. |