This is a direct import (i.e., data is uploaded directly to the data table) that allows for inserting new records and updating existing ones.

When importing material-related records from the text file (those with a line type of Inventory or a line type of Misc referencing an SM Cost Type with a Material cost type category) , if the Tax Type identifier (in Template Detail) is set to Use Viewpoint Default, the system will default the Tax Type for each record based on the Matl Type Override defined for the work order scope's call type, as well as the work completed line's billable status and taxability status.

For example, if the call type's Matl Tax Override is set to Sales and the imported line is billable and taxable, the system will set the Tax Type for the work completed line to Sales. If the line is billable, but not taxable, the system will set the Tax Type to blank.

If you do not use the Viewpoint default and the Tax Type for the import record does not correspond to the Material Tax Override value specified for the call type on the work order scope, the system will automatically default the correct value based on the Material Tax Override option specified for the work order scope and the work completed line's billable status and taxability status.