Searching for EDI Correlations

Sterling B2B Integrator enables you to find and correlate an AS2 message with an EDI document or data, group, or transaction through a link in the EDI Correlation Search details—a Document Correlation information link that displays detailed interchange information about AS2 messages.

If you are using AS2, the Document Correlation link enables you using AS2 to quickly and easily view interchange details about AS2 messages, and to see the correlation between an AS2 message and a corresponding EDI document or data.

To search for AS2 correlations:

  1. From the Administration menu, select Business Process > Monitor > Advanced Search > EDI Correlation.
  2. In the Search Option area, specify any combination of the following search criteria, as appropriate:

    Field

    Description

    Action

    All Level Options

    Location

    EDI correlations maintained in a specific location.

    Select one of the following options:
    • Live Tables – Display live (active) EDI correlations.
    • Restored Tables – Display EDI correlations restored from an offline location.

    Search Level Type

    EDI processing level.

    Select one of the following options:
    • Interchange – For the search query, display results from the interchange level.
    • Group – For the search query, display results from the group level.
    • Transaction – For the search query, display results from the transaction level.

    Test Mode

    Mode of the Sterling B2B Integrator system where documents that contain the EDI correlations were created.

    Select one of the following options:

    • Any (default)
    • Test
    • Production
    • Information
    • Interchange is a test
    • Syntax only test
    • Echo request
    • Echo response

    Direction

    Flow of the documents that contain the EDI correlations.

    Select one of the following options:
    • Any (default)
    • Inbound
    • Outbound

    Sender ID

    ID for the organization that is sending documents.

    Type the identifier of the sender.

    Receiver ID

    ID for the receiving organization.

    Type the identifier of the receiver.

    Sender ID Qualifier

    Qualifier used with the Sender ID to define the organization that is sending documents.

    Type the qualifier of the sender.

    Receiver ID Qualifier

    Qualifier used with the Receiver ID for the receiving organization.

    Type the qualifier of the receiver.

    Start Date

    Documents in progress or completed after the specified start date and time.

    Using the following formats, type a starting date and time range and select AM or PM:
    • Date – MM/DD/YYYY
    • Time – HR:MN:SC
    Note: Defaults to a range of the last 24 hours.

    End Date

    Documents in progress or completed before the specified end date and time.

    Using the following formats, type an end date and time range and select AM or PM:
    • Date – MM/DD/YYYY
    • Time – HR:MN:SC
    Note: Defaults to a range of the last 24 hours.

    Interchange Level Options

    Interchange Control Number

    Sequential number, located at the beginning and end of an interchange, used to verify that all interchanges sent have been received and that the information in the interchange is complete.

    Type the control number that references the interchange.

    Standard

    EDI standard you agree to use for a trading partnership.

    Type the name of the standard (including CHIPS or Fedwire).

    Acknowledgement Status

    Status of an expected acknowledgement at the interchange level.

    Select one of the following options:
    • Any (default)
    • Waiting
    • Accepted
    • Accepted with Errors
    • Rejected
    • OverDue
    • Received
    • None
    • Manually Accepted

    Compliance Status

    Status of compliance checking at the interchange level.

    Select one of the following options:
    • Any (default)
    • OK
    • NOT OK

    Start Date

    EDI correlations generated or completed for documents at the interchange level after the specific start date and time. This date is compared with the interchange date/time in the data.

    Using the following formats, type a starting date and time range and select AM or PM:
    • Date – MM/DD/YYYY
    • Time – HR:MN:SC
    Note: Defaults to a range of the last 24 hours.

    End Date

    EDI correlations generated or completed for documents at the interchange level before the specific end date and time. This date is compared with the interchange date/time in the data.

    Using the following formats, type an end date and time range and select AM or PM:
    • Date – MM/DD/YYYY
    • Time – HR:MN:SC
    Note: Defaults to a range of the last 24 hours.

    Group Level Options

    Functional Group ID

    ID of the functional group indicated in the document.

    Type the ID of the functional group.

    Group Control Number

    Sequential number, used to verify that all groups sent have been received and that the information in the group is complete.

    Type the control number that references the group.

    Acknowledgement Status

    Status of an expected acknowledgement at the group level.

    Select one of the following options:
    • Any (default)
    • Waiting
    • Accepted
    • Accepted with Errors
    • Rejected
    • OverDue
    • Received
    • None
    • Manually Accepted
    • Partially Accepted

    Compliance Status

    Status of compliance checking at the functional group level.

    Select one of the following options:
    • Any (default)
    • OK
    • NOT OK

    Start Date

    EDI correlations generated or completed for documents at the group level after the specific start date and time. This date is compared with the group date/time in the data.

    Using the following formats, type a starting date and time range and select A.M. or P.M.:
    • Date – MM/DD/YYYY
    • Time – HR:MN:SC
    Note: Defaults to a range of the last 24 hours.

    End Date

    EDI correlations generated or completed for documents at the group level before the specific end date and time. This date is compared with the group date/time in the data.

    Using the following formats, type an end date and time range and select A.M. or P.M.:
    • Date – MM/DD/YYYY
    • Time – HR:MN:SC
    Note: Defaults to a range of the last 24 hours.

    Transaction Level Options

    Transaction Set ID

    ID of the transaction set indicated in the document.

    Type the ID of the transaction set.

    Compliance Status

    Status of compliance checking at the transaction set level.

    Select one of the following options:
    • Any (default)
    • OK
    • NOT OK

    Message Repair Status

    Status of message repair (for SWIFT documents only).

    Select one of the following options:
    • Any
    • Ready for Edit
    • Ready for Resend
    • Aborted
    • Resent
  3. Click Go! to display the EDI correlation records that match your search criteria.
  4. In the EDI Correlation Interchange Results page, click info in the Detail column for the AS2 interchange for which you want to view details.
  5. In the EDI Correlation Interchange/Group/Transaction Detail Results page, click info to the right of Document Correlations.
  6. For SWIFT documents, on the EDI Correlation Transaction Results page, click info in the Detail column for the document you want to edit.
  7. In the Document Correlation Details page, view details about the AS2 message you selected, and to see the correlation between the AS2 message and corresponding EDI document or data. The details available include:
    • time stamp
    • scope
    • process ID
    • document name
    • data value