Set inquiry

After a set is created, you can conduct a search for the set to view the extraction records.

Caution: 
After you perform a search for a set, the set is locked. It cannot be accessed by another user. You must close SA Mass Maintenance Administration before you sign out of Distribution SX.e to unlock the set.

Extraction records that are contained in the set are displayed in the Extraction Records grid. The number of records that are displayed are based on the business rule that defines the default limit for returned records. If a set is contains numerous records, you can specify beginning and ending sequence numbers to limit the number of records that are displayed.

The columns that are included in the grid depend on the database table that the set is based on. The grid contains these columns or column types:

  • Seq #

    A unique number that is assigned to the extraction record to identify it within the set.

  • Status Operation

    The action that will be applied to the record during the final update. If a value is not displayed, the extraction record was not changed.

    If you create a record through the import process, and then change a value on the new record, the Status Operation is Create. The value does not change to Update.

  • Status Type

    The status of the record. The column can be blank or contain one of these values:

    • Pending indicates that changes were made to the record, but the final update has not yet occurred.
    • Completed indicates that the final update has occurred. The record was updated, created, or deleted in the database table.
    • Errors indicates that a validation error occurred when the final update was performed. The record was not updated, created, or deleted in the database table.

  • Name/Description column

    An identifier that is associated with the record. This value is based on the database table from which the records were extracted. For example, the customer name is the identifier for records that are extracted from the ARSC table. The product description is the identifier for records that are extracted from the ICSP table.

  • Key columns

    The key values are associated with the Name/Description values.

    For example, if the customer name is in the Name/Description column, the customer number is the key value. More than one key column can be included in the grid. For example, if a customer ship to is in the Name/Description column, both the customer number and the ship to number are key values.

    Key columns are displayed after the Name/Description column.

  • Extraction data columns

    The database columns that were selected for extraction for the set. Up to 10 columns of extraction data can display.

  • Errors

    Validation errors that occurred when during the final update.

You can view the parameters for a set on the Selection Criteria / Extractions Columns page. Search for a set and then click Selection Criteria / Extractions Columns in the grid toolbar.

The header section includes the Where Clause. The WHERE value is the company number. The AND values are based on the Selection Criteria. For example, suppose you selected this criteria for a set from the ARSS-Customer Ship To table in company 5000:

  • Customer #: 8
  • State: CO

The Where Clause field would then contain this information:

  • for each arss where arss.cono = 5000 and arss.custno = 8 and arss.state = 'co'