Request Mass Change H

Request Mass Change V

Use this page to Mass Change Data.

To access this page:

  1. Select dspCompose > Requests in the Navigation pane.

  2. Click Roles for a request.

    OR

  1. Click the link in the workflow email generated by dspCompose™.
  2. Click DATA ENTRY for the role that allows data entry.
  3. Click Mass Change on the Page toolbar.
Field Description
COLUMN NAME Displays column name being updated in the target ERP system.
VALUE Displays value being replaced for Column Name in the target ERP system.
Build Where Clause Click to open the Request Mass Change (Where Clause) page to create a where clause that filters the data being updated.
WHERE CLAUSE Displays a where clause that filters the data being updated. Field is protected on the Horizontal View; it can be edited on the Vertical View.
View Data Click to view a report of the data being changed. Data is pulled from the view for this request and is limited if a Where Clause has been applied. This icon is only available until the request is posted.
Execute Click to run the mass change process. This process applies the Value to all rows for the selected Column Name on the data entry page. This icon is active when the other values on the page have been entered and saved.

Request Mass Change V

Request Mass Change H

Use this page to Build Mass Change Where Clause.

Field

Description

Column Name

Displays column name being updated in the target ERP system.

Value

Displays value being replaced for Column Name in the target ERP system.

Advanced Properties

Where Clause

Displays a where clause that filters the data being updated.