System Cross References Dialog Box

To access this dialog box: In the Plant Applications Administrator, right-click on a Data Source (Global Configuration > Data Source Types) and click Modify System Cross References.

In the System Cross References dialog box, you configure cross-references between Plant Applications items and "foreign" keys within an external system.

You can also import and export system cross references to and from Excel.

Subscription

Choosing a subscription from the drop-down list serves two purposes:

  • It filters searches for existing cross-references.

  • It allows you to enter XML information for the selected subscription, which will be used by the connector to an external system. For the Enterprise Connector, you will most likely need to select Variables for the Plant Applications Item. If you select:

  • ProductionPerformance subscription, then the stored procedure will expect <MaterialProducedActualProperty> to be entered in the XML Header data box.

  • ConsumptionPerformance subscription, then the stored procedure will expect <MaterialConsumedActualProperty> to be entered in the XML Header data box.

  • TestConformance subscription, then the stored procedure will expect <TestPerformance> to be entered in the XML Header data box.

When you choose a subscription from the drop-down menu, a window opens in the center of the dialog box, allowing you to enter additional information that identifies the cross-referenced items.

Plant Applications Item

This is a search filter for existing cross references, and also limits hits when searching for Plant Applications items to add when creating new cross-references. If you are searching for existing cross references, select the item type associated with the cross reference you want to find before clicking Search. If you are adding new items, choose the item type you want to add before clicking Add New.

Search String

This is a search filter for existing cross-references. Enter a character string contained within the name(s) of the items you wish to find. The search will return only items in the category defined in Plant Applications Item.

Filter

Enter a string to limit hits when adding new items. Characters may be from the beginning, within, or at the end of an item name. You may use the percent symbol (%) as a wild card character within the string.

New Alias

Enter the name of an alias to which to map a foreign key.

See also