Cost Scenarios

The Cost Scenarios view object is used to manage cost scenarios. Cost planning users use cost scenarios to establish standard costed item costs and labor rates, estimate rolled up costs of manufacturing items, and publish item costs and resource rates to cost accounting.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstScenariosExtractPVO

Primary Keys : CstScenariosPEOScenarioId

Initial Extract Date : CstScenariosPEOCreationDate

Incremental Extract Date : CstScenariosPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
CstScenariosPEOAssignmentSetId Value that uniquely identifies the assignment set that's associated to the cost planning scenario. This attribute is mandatory for scenarios that are supply chain cost rollup enabled.
CstScenariosPEOComments Detailed information or comments about the cost scenario being defined.
CstScenariosPEOCostBookId Value that uniquely identifies the accounting cost book to which the results of the cost rollup are associated.
CstScenariosPEOCostOrgId Value that uniquely identifies the accounting cost organization to which the results of the cost rollup are published or the accounting cost organization to which the item costs and resource rates are associated.
CstScenariosPEOCreatedBy User who created the cost scenario.
CstScenariosPEOCreationDate Date and time when the cost scenario was created.
CstScenariosPEOEffectiveEndDate Last date of the date range within which the cost scenario row is effective.
CstScenariosPEOEffectiveStartDate First date of the date range within which the cost scenario row is effective.
CstScenariosPEOInvOrgId Value that uniquely identifies the inventory organization or plant for which the cost planning scenario is created. This is mandatory if the scenario type is manufacturing. This attribute is currently not used.
CstScenariosPEOLastUpdateDate Date when the cost scenario was last updated.
CstScenariosPEOLastUpdateLogin Session login associated with the user who last updated the cost scenario.
CstScenariosPEOLastUpdatedBy User who last updated the cost scenario.
CstScenariosPEOOrganizationContext Code that indicates the organization context for which the cost planning scenario is created. A list of accepted values is defined in the lookup type ORA_CST_ORGANIZATION_CONTEXT. For cost scenarios that include cost rollup group, the organization context is Group, otherwise it's Single.
CstScenariosPEOPlanningCostOrgId Value that uniquely identifies the planning cost organization for which the cost planning scenario is created. This attribute is currently not used.
CstScenariosPEOPlanningMode Planning mode of the scenario to allow changes to existing published costs for only the new items. A list of accepted values is defined in the lookup type ORA_CST_SCENARIO_PLANNING_MODE. This attribute is currently not used.
CstScenariosPEOPreviousScenarioId Value that uniquely identifies the previous scenario. This is populated with the value of the previous scenario and is applicable only when the NEW_ITEMS option is chosen, else it's NULL. This attribute is currently not used.
CstScenariosPEOPublishToAccountingFlag Code that indicates if the scenario is enabled to publish costs for cost accounting. This is obsolete and always set to NULL.
CstScenariosPEOPurposeCode Code that identifies the purpose for which the scenario is defined. A list of accepted values is defined in the lookup type CST_PURPOSE_CODES. This attribute is currently not used.
CstScenariosPEORollupGroupId Value that uniquely identifies the supply chain rollup group for which the cost planning scenario is created.
CstScenariosPEOScenarioHeaderId Value that uniquely identifies the scenario header. For every new version created, the scenario header identifier is inherited from the base version of the scenario. This attribute is currently not used.
CstScenariosPEOScenarioId Value that uniquely identifies the cost scenario. This is the primary key of the Cost Scenarios view object.
CstScenariosPEOScenarioNumber Name defined by user to identify the cost scenario.
CstScenariosPEOScenarioType Code that indicates whether the scenario is for rolling up regular items or configured items. A list of accepted values is defined in the lookup type ORA_CST_SCENARIO_TYPES.
CstScenariosPEOStateCode State of the scenario. A list of accepted values is defined in the lookup type ORA_CST_SCENARIO_STATE.
CstScenariosPEOStatusCode Status of the scenario. A list of accepted values is defined in the lookup type ORA_CST_SCENARIO_STATUS_SMPL.
CstScenariosPEOSupplyChainRollupFlag Value that identifies if the scenario is enabled to run supply chain cost rollup.
CstScenariosPEOTransferCostRuleSetId Value that uniquely identifies the transfer charge rule set associated to the cost scenario.