Return Process Constraints

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Return Process Constraints

Internal Table Name: ReturnProcessConstraints

Return Process Constraints are limitations placed on the Return Processes that must be met for a solution to be considered feasible. You control the scope of the constraint (periods, sites, products and processes) and the type of constraint (such as a minimum or maximum).

Expression

Technology: NO

Table: ReturnProcessConstraints

Internal Name: ExpressionName

Type: Short Text (100)

This is an optional name for the Return Process Constraint. You can then use the Inventory Process Constraint in:

an Expression Constraint by specifying the Expression for either the Expression 1 or Expression 2 value. This enables you to combine constraints.
an Expression Based Cost by using this value in the Expression field. This enables you to defined fixed and variable cost components that are incurred as a result of the constraint.

Period

Technology: NO

Table: ReturnProcessConstraints

Internal Name: PeriodName

Type: Short Text (50)

One of (ALL_Periods) (All), (ALL_Periods) (Each), period name, period group.

Select the period which the constraint will apply to. If there are no Periods specified in the model, you can select (ALL_Periods) (All) to apply the constraint to the planning horizon.

In a multi-period model, if you select no value for Period, it will behave the same as if you select (ALL_Periods) (All) and apply the constraint across the planning horizon. In order to ensure the correct behavior, Coupa recommends that you select the specific period or, when using (ALL_Periods) or another period filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full horizon/group
(Each) to apply the constraint per period

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Customer

Technology: NO

Table: ReturnProcessConstraints

Internal Name: SiteName

Type: Short Text (100)

One of (ALL_Customers), customer name, customer group.

Select the customer at which this return process constraint applies. When this field is set to (ALL_Customers), the constraint applies to all customers. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Product

Technology: NO

Table: ReturnProcessConstraints

Internal Name: ProductName

Type: Short Text (100)

One of (ALL_Products), product name, product group.

Select the product for which this return process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Destination

Technology: NO

Table: ReturnProcessConstraints

Internal Name: DestinationName

Type: Short Text (100)

One of (ALL_Sites), site name, site group.

Select the destination site at which this return process constraint applies. When this field is set to (ALL_Sites), the constraint applies to all sites. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Process

Technology: NO

Table: ReturnProcessConstraints

Internal Name: ProcessName

Type: Short Text (100)

One of (ALL_ReturnProcesses), return process name, return process group.

Select the process for which this return process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Process Step

Technology: NO

Table: ReturnProcessConstraints

Internal Name: StepName

Type: Short Text (100)

One of (ALL_ReturnProcessSteps), (None), return process step name, return process step group.

Select the process step for which this return process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Next Process Step

Technology: NO

Table: ReturnProcessConstraints

Internal Name: NextStepName

Type: Short Text (100)

One of (ALL_ReturnProcessSteps), (None), return process step name, return process step group.

Select the next process step for which this return process constraint applies. If you use a filter/group, you actively select how to apply the constraint:

(All) to apply the constraint to the full group
(Each) to apply the constraint per group member

If you are setting the values outside the Supply Chain Guru X or Modeler user interface, see Controlling Each and All through the model database.

Constraint Value

Technology: NO

Table: ReturnProcessConstraints

Internal Name: Requirement

Type: Short Text (100)

Enter the amount required for the period-customer-destination-product-process-process step-next step name combination. Enter a value, then optionally select a quantity, weight, volume, or time unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Constraint Type

Technology: NO

Table: ReturnProcessConstraints

Internal Name: RequirementType

Type: Short Text (25)

One of Min, Cond Min, Max, Fixed, Define.

Choose the constraint type. This defines how the Constraint Value is used.

Min – At least X is required.
Max – At most X is allowed.
Fixed – X is required.
Cond Min – Either at least X is required or there must be none at all.
Define – Network Optimization does not use the Constraint Value to satisfy the constraint. Instead, the constraint value is specified in the Expression Constraint. See Considerations for grouped constraints for additional information.

Constraint Period

Technology: NO

Table: ReturnProcessConstraints

Internal Name: RequirementPeriod

Type: Short Text (50)

One of Period Length, Day, Week, Month (30 Day), Quarter (91 Day), Year, Horizon.

Choose the period over which the Constraint Value is to be established. When this field is left blank the horizon of the optimization will be used as the Constraint Period.

Work Center

Technology: NO

Table: ReturnProcessConstraints

Internal Name: WorkCenter

Type: Short Text (100)

One of (ALL_WorkCenters), work center name, work center group.

Select the Work Center or Work Center group that applies to the Transportation Process.

Work Resource

Technology: NO

Table: ReturnProcessConstraints

Internal Name: WorkResource

Type: Short Text (100)

One of (ALL_WorkResources), work resource process step name, work resource process step group.

Select the Work Resource or Work Resource group that applies to the Transportation Process.

Status

Technology: NO

Table: ReturnProcessConstraints

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

Specify whether or not to include the specific constraint in the model.

Default: Include

Notes

Technology: NO

Table: ReturnProcessConstraints

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the return process constraint.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No