Network Spend Account Summary

Internal Table Name: NetworkSpendAccountSummary

This table provides information about the spend accounts used in the optimization. This information includes values for the total spend, max budget and remaining budget.

Scenario

Table: NetworkSpendAccountSummary

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

The scenario for which the output data was generated.

Spend Account

Table:NetworkSpendAccountSummary

Internal Name: SpendAccountName

Displays the identifier of the spend account to which the cost is applied. There can be multiple cost types applied to an account.

Cost Type

Table: NetworkSpendAccountSummary

Internal Name: CostType

The Network Cost type, such as "Fixed Operating Cost" or "Capital Investment Cost" that was applied to the spend account.

Period

Table: NetworkSpendAccountSummary

Internal Name: PeriodName

The period(s) for which the spend account cost applies.

Location

Table: NetworkSpendAccountSummary

Internal Name: LocationName

The site(s) or customer(s) for which the spend account cost applies.

Product

Table: NetworkSpendAccountSummary

Internal Name: ProductName

The product(s) for which the spend account cost applies.

Source

Table: NetworkSpendAccountSummary

Internal Name: SourceName

The source site(s) for which the spend account cost applies.

Mode

Table: NetworkSpendAccountSummary

Internal Name: ModeName

The mode(s) for which the spend account cost applies.

Work Center

Table: NetworkSpendAccountSummary

Internal Name: WorkCenterName

The work center(s) for which the spend account cost applies.

Work Resource

Table: NetworkSpendAccountSummary

Internal Name: WorkResourceName

The work resource(s) for which the spend account cost applies.

Transportation Asset

Table: NetworkSpendAccountSummary

Internal Name: TransportationAssetName

The transportation asset(s) for which the spend account cost applies.

Process

Table: NetworkSpendAccountSummary

Internal Name: ProcessName

The process(s) for which the spend account cost applies. This can be a sourcing, production, transportation, inventory or return process.

Process Step

Table: NetworkSpendAccountSummary

Internal Name: ProcessStepName

The process step(s) for which the spend account cost applies. This can be a step from a sourcing, production, transportation, inventory or return process.

Next Process Step

Table: NetworkSpendAccountSummary

Internal Name: NextProcessStepName

The next process step(s) for which the spend account cost applies. This can be a step from a sourcing, production, transportation, inventory or return process.

Bill Of Material

Table: NetworkSpendAccountSummary

Internal Name: BOMName

The bill(s) of material for which the spend account cost applies.

Expression

Table: NetworkSpendAccountSummary

Internal Name: ExpressionCostName

The expression based cost for which the spend account cost applies.

Total Spend

Table: NetworkSpendAccountSummary

Internal Name: TotalSpend

Displays the total cost incurred for the selected elements for the Network Cost defined in the Spend Account.

Max Budget

Table: NetworkSpendAccountSummary

Internal Name: MaxBudget

Displays the maximum spend allowed for the selected elements for the Network Cost defined in the Spend Account.

Remaining Budget

Table: NetworkSpendAccountSummary

Internal Name: RemainingBudget

Displays any remaining budgeted spend: the Max Budget - Total Spend.

Budget Utilization

Table: NetworkSpendAccountSummary

Internal Name: BudgetUtilization

Displays the percentage of the budgeted spend that has been used by the total spend.

Scenario ID

Table: NetworkSpendAccountSummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: NetworkSpendAccountSummary

Internal Name: StepNumber

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

Last modified: Friday May 12, 2023

Is this useful?