Define and Modify Relational Conditions

Edit online

About this task

You can use relational conditions to connect fields for syntax or compliance reasons. For example, field A is invalid unless field B is present. If you create a condition that pairs fields A and B, a compliance error is generated if one of those fields is not present.

You can also view the conditional relationships between elements and composites, as provided by the EDI standard. If a composite is added to the relationship it will compare the condition to the first non-null element in the composite it finds.

Note: The Sterling B2B Integrator Map Editor enables you to edit these conditional relationships, but if you do, you may generate a compliance error.

To define and modify field, element, and composite relational conditions:

Procedure

  1. In the Sterling B2B Integrator Map Editor, double-click the field, composite, or element you want to modify.
  2. In the Element Properties dialog box, click the Conditions tab.
  3. Select the field connection condition from the type of relationship list. Valid values are:
    • Paired/Multiple – If any of the specified fields are present, all fields must be present.
    • Required – At least one of the specified fields must be present.
    • Exclusion – No more than one of the specified fields can be present.
    • Conditional – If the first condition field is present, the rest of the fields must also be present.
    • List Conditional – If the first condition field is present, at least one of the specified fields must also be present.
  4. Select the first field from the condition field list.

    This is the field on which the conditional relationship depends if you chose Conditional or List Conditional from the type of relationship list.

    The condition field list is active only if you chose either Conditional or List Conditional from the Type of relationship list.

  5. From the Available fields list, select a field or fields and click Add.

    The Sterling B2B Integrator Map Editor moves the fields to the Fields used in relationship list, to include the fields as a part of the conditional relationship.

    The Available fields list contains all the fields in the map that are valid to be used in a condition at this point.

    The Fields used in relationship list contains the fields that you selected to be a part of the conditional relationship.

    To remove the fields from the conditional relationship, select a field or fields from the Fields used in relationship list and click Remove to move the fields back to the Available fields list.

  6. Click OK to add the conditional relationship to the field, element, or composite.