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. |