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