Updateable columns

When processing a staged data record, the import process first searches for the existence of that record in Infor Expense Management database by the primary key of the table. If a record already exists in the database, the process updates the record by overwriting the updateable columns with the values supplied by the staged data record. If the record does not exist, the process inserts the new record into the database table. The import process only overwrites “updateable” fields. Refer to these import table specifications for the field properties (that is, Updateable).

This table summarizes the possible actions for the import process: