Generally speaking, the import can set any field in any of these tables other than the ID field and any foreign key fields that link these tables to each other.
For lookup-type fields (any field that appears as a drop-down list on the screen) the value given to the import is the full text of the value the user sees on the screen (NOT the ID or code that is looked up and stored in the database). A country or a currency field should be imported using the appropriate three-letter symbol (not the full name). A field that appears as a checkbox on the screen should be imported with a value of “Yes” if the box should be checked and “No” otherwise.
Vendor Service Provided records are always inserted if the data provided is valid. There is no check for the existence of a similar record first.