Network Spend Expression Summary

Internal Table Name: NetworkSpendExpressionSummary

This table provides a high level summary of the cost by spend expression. A single spend expression can be defined with multiple records. Records corresponding to each spend expression record used are populated.

Scenario

Table: NetworkSpendExpressionSummary

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Spend Expression

Table: NetworkSpendExpressionSummary

Internal Name: SpendExpressionName

The specific spend expression or the account referenced by the expression to which the summary information applies.

# Accounts Considered

Table: NetworkSpendExpressionSummary

Internal Name: NumAccounts

The number of spend accounts that were associated with the spend expression record.

Constraint Type

Table: NetworkSpendExpressionSummary

Internal Name: ConstraintType

For spend expression records using constraints, the constraint type (such as "Constraint - Fixed") is displayed. For spend expression records that reference a spend account name, the value is "Spend Account Total".

Total Spend

Table: NetworkSpendExpressionSummary

Internal Name: TotalSpend

The total spend incurred by the spend expression record. This value is populated when the spend expression record references a spend account.

Constraint Value

Table: NetworkSpendExpressionSummary

Internal Name: ConstraintValue

The constraint value defined by the spend expression record. This value is populated when the spend expression record references a constraint type (such as "Constraint - Fixed").

Constraint Excess

Table: NetworkSpendExpressionSummary

Internal Name: ConstraintExcess

Displays the amount that the constraint value exceeds what is used by the constraint.

% Constraint Utilized

Table: NetworkSpendExpressionSummary

Internal Name: PercentConstraintUtilized

Displays the percentage of the constraint value that has actually been used.

Scenario ID

Table: NetworkSpendExpressionSummary

Internal Name: ScenarioID

The identifier of the scenario for which the output data was generated.

Sub-Scenario ID

Table: NetworkSpendExpressionSummary

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the output data was generated.