Inventory Process Constraints

Internal Table Name: InventoryProcessConstraints

Inventory Process Constraints are limitations placed on the Inventory 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: InventoryProcessConstraints

Internal Name: ExpressionName

Type: Short Text (100)

This is an optional name for the Inventory 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: InventoryProcessConstraints

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.

Site

Technology: NO

Table: InventoryProcessConstraints

Internal Name: SiteName

Type: Short Text (100)

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

Select the site at which this production 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.

Product

Technology: NO

Table: InventoryProcessConstraints

Internal Name: ProductName

Type: Short Text (100)

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

Select the product for which this inventory 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

Technology: NO

Table: InventoryProcessConstraints

Internal Name: ProcessName

Type: Short Text (100)

One of (ALL_InventoryProcesses), process name.

Select the process for which this inventory 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: InventoryProcessConstraints

Internal Name: StepName

Type: Short Text (100)

One of (ALL_InventoryProcessSteps), (None), process step name.

Select the process step for which this inventory 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: InventoryProcessConstraints

Internal Name: NextStepName

Type: Short Text (100)

One of (ALL_InventoryProcessSteps), (None), process step name.

Select the next process step for which this inventory 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.

Work Center

Technology: NO

Table: InventoryProcessConstraints

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 Inventory Process. 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.

Work Resource

Technology: NO

Table: InventoryProcessConstraints

Internal Name: WorkResource

Type: Short Text (100)

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

Select the Work Resource or Work Resource group that applies to the Inventory Process. 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: InventoryProcessConstraints

Internal Name: Requirement

Type: Short Text (100)

Enter the amount of inventory required for the period-site-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: InventoryProcessConstraints

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: InventoryProcessConstraints

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.

Status

Technology: NO

Table: InventoryProcessConstraints

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: InventoryProcessConstraints

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the inventory process constraint.

Last modified: Wednesday May 15, 2024

Is this useful?