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