Spend Expressions

Internal Table Name: SpendExpressions

Use this table to define constraint expressions that further control spend. For example, you can construct expressions that establish ratios between spend accounts that must be adhered to. For example, constraints could require that 3 times the warehousing max spend cannot exceed the operating cost max spend.

For examples of how to define spend constraints, see Spend constraints examples.

Name

Technology: NO

Table: SpendExpressions

Internal Name: SpendExpressionName

Type: Short Text (100)

This column is the name of the spend expression.

Element

Technology: NO

Table: SpendExpressions

Internal Name: Element

Type: Short Text (100)

Select the spend account or constraint type to be applied to the expression. This is one of:

  • Constraint - Max: The value determined by the expression must be less than or equal to the Value defined.

  • Constraint - Min: The value determined by the expression must be greater than or equal to the Value defined.

  • Constraint - Fixed: The value determined by the expression must be equal to the Value defined.

  • Constraint - Conditional Min: The value determined by the expression must be less than or equal to the Value defined, or none at all.

  • Spend Account name: The Name from the Spend Accounts table.

  • Spend Expression name: The Name from the Spend Expressions table.

For examples of how to define spend constraints, see Spend constraints examples.

Value

Technology: NO

Table: SpendExpressions

Internal Name: Value

Type: Number (Double)

Enter the value that is evaluated in the expression, such as the minimum, maximum or fixed value. The value can be a positive or negative number.

Status

Technology: NO

Table: SpendExpressions

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

Choose the status for the spend expression:

  • Include - This spend expression will be included in an optimization run.

  • Exclude - This spend expression will be excluded from an optimization run.

Default: Include

Notes

Technology: NO

Table: SpendExpressions

Internal Name: Notes

Type: Short Text (100)

Enter optional descriptive notes about the spend expression.

Last modified: Friday May 12, 2023

Is this useful?