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).

Note: The import process does not delete records for which there is no matching entry in the staging tables.

This table summarizes the possible actions for the import process:

Staging Base Action
Exists Does not exist Create
Exists Exists Update
Does not exist Exists None