Where clause when creating interfaces

When creating ODBC-type interfaces you can define a where clause. A where clause is a typical SQL clause used to retrieve/update a selection of records from the table. Infor Production Scheduling specific variables that can be used are %current_time and %last_activation. The %last_activation variable can be used to select all records in the external database that are to be retrieved/updated after the last activation of the interface. With the %current_time variable you are able to limit the interface to records within a period of time relative to the current date.