Use this application to exclude specific elements from being transferred to the target system for inserts and/or updates. The data initialization process for each integration package includes preloading the list of elements for which this feature is supported. You can then select those elements that you want excluded from the integration process for a given object and instance.
You must first define an individual instance or instances for the integration package(s) installed at your site. (Please see the Interface Configuration and Scheduler documentation for additional information regarding setting up an instance.) Next, you can use this screen to add or edit a set of elements to be excluded for each object being processed in the selected interface and instance. The set of excluded elements becomes a part of the existing object instance.
Enter, or use Lookup to select, the interface ID for this object record. The interface IDs available for selection are pre-defined in the system and depend on the integration packages installed at your site for which elements may be excluded.
Enter, or use Lookup to select, an existing instance ID defined in the Interface Configuration and Scheduler screen.
Enter, or use Lookup to select, an object ID for the elements to be excluded. The object IDs available for selection are pre-defined in the system and depend on the integration packages installed at your site for which elements may be excluded.
This non-editable field displays the element ID for the row.
This field indicates whether or not you can edit the Exclude on Ins. field. If it is "Y," you can exclude this field from processing when new rows are created in the target table from the source.
This field indicates whether or not you can edit the Exclude on Upd. field. If it is "Y," you can exclude this field from processing when rows are updated in the target table from the source.
After selecting a row or rows in the Available Elements table window, select this pushbutton to add the lines to the Selected Elements table window.
After you save your selections, the contents of the Selected Elements table window are associated with the interface, instance ,and object being processed.
To remove a line from the Select Elements table window, highlight the row and select this pushbutton.
This field displays the Element from the Available Elements table window.
Enter a "Y" to exclude this element for new records. This field is enabled only when Allow Exclude on Insert is "Y." The default for this field is "N."
Enter a "Y" to exclude this element for existing records. This field is enabled only when Allow Exclude on Update is "Y." The default for this field is "N."
This field displays the value from the Allow Exclude on Insert field in the Available Elements table window.
This field displays the value from the Allow Exclude on Update field in the Available Elements table window.