Options tab

This tab includes the options for creating, updating and comparing interfaces and enables you to specify import options.

These are the possible scenarios:

  • The interface mode Read updates Infor Production Scheduling and the mode Write updates the ASCII file or the ODBC database.
  • The Delete option is available based on the selected entity. The Delete check box is displayed only if the interface mode is set to Read.
  • You can use a combination of two searches to select the orders that must be deleted. To prevent complex search definitions, the interface prepares a set of records based on the delete mentioned order if in search value and does not consider the records that are selected for the keep order if in search option.
  • If you select the Bulk option in the Format tab, the Create option is enabled and the Update option is disabled. You cannot change this configuration. You must ensure that the target table does not contain records.
    Note: You must clear the target table before exporting the data. This process step is executed by default when the Web Viewer integration template is used.

This table shows the possible actions you can specify in the different interface types and modes:

  Interface mode ASCII ODBC
Read
  • Add records that do not exist in Infor Production Scheduling.
  • Update existing records in Infor Production Scheduling.
  • Update the decoupled inflow products. This option is displayed only if the process step - inflow products entity is selected.
  • Delete or retain records if the records are available in the selected search.
  • Manual conformation: Enables you to confirm all changes manually or override the proposed change (for process batches only).
The possible actions are same as the ASCII interface.
Write
  • Select search: limit export selection.
  • The export file is over-written.
  • Select search: limit export selection.
  • Add records that do not exist in the ODBC database.
  • Update the existing records in the ODBC database. The Update option is not displayed if Bulk is selected in the Format tab.
Delete Delete or retain records if the records are available in the selected search. The possible actions are same as the ASCII interface.
Related topics