Import and export files can contain all the information in your Vendor list. The keyword for the Vendor list is VEND.
NAME | (Required) The name of the vendor. | ||||
TIMESTAMP | (Export files only) A unique number that identifies the company file from which you exported the Vendor list. | ||||
REFNUM | (Export files only) A unique number that identifies an entry in the list. | ||||
PRINTAS | The name you would like checks to be made out to. This field allows you to make checks out to a different name than the name that appears on your Vendor list. | ||||
ADDR1-5 | The vendor's address. | ||||
VTYPE | Your classification for the vendor (QuickBooks calls this a “vendor type”). If you import a vendor type that is not on your Vendor Type list, QuickBooks adds the new vendor type to the list. | ||||
CONT1 | The name of your primary contact with the vendor. | ||||
PHONE1 | The vendor's phone number. | ||||
PHONE2 | The vendor's alternate phone number. | ||||
FAXNUM | The vendor's FAX number. | ||||
NOTE | A short note or phrase you want to associate with the vendor. QuickBooks automatically puts your note in the Memo field of checks you send to the vendor. | ||||
TAXID | The vendor's tax identification number. | ||||
LIMIT | Your credit limit with the vendor. If you are creating an import file, enter the dollar amount. | ||||
TERMS | Your payment terms with the vendor. | ||||
NOTEPAD | Your notes about the vendor. If you are creating an import file, the notes appear in the Notepad window for the vendor. | ||||
SALUTATION | The vendor's salutation, or title (Mr., Ms., Doctor, etc.). | ||||
COMPANYNAME | The name of the vendor's company. | ||||
FIRSTNAME | The vendor's first name. | ||||
MIDINIT | The vendor's middle initial. | ||||
LASTNAME | The vendor's last name. | ||||
CUSTFLD1
CUSTFLD2 . . CUSTFLD15 |
The custom field entries for the vendor. Custom fields let you track special information about the vendor, such as the vendor's birthday or email address. | ||||
1099 | Indicates whether you file a 1099-MISC form for this vendor. If you are creating an import file, enter one of these keywords in the 1099 field:
|