Standard Cost Details

The Standard Cost Details view object contains inventory item costs for all combinations of cost organization and cost book, which are standard costed. User can further refine these results for a particular cost organization and cost book combination, by the primary book or any other filter.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstStdCostDetailsExtractPVO

Primary Keys : CstStdCostDetailsPEOStdCostDetailId

Initial Extract Date : CstStdCostDetailsPEOCreationDate

Incremental Extract Date : CstStdCostDetailsPEOLastUpdateDate

Attributes

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

Name	Description
CstStdCostDetailsPEOCostElementId	Value that uniquely identifies the cost element of the standard cost detail. This is the primary key of the Cost Elements view object.
CstStdCostDetailsPEOCostLevelCode	Code that identifies the level of the standard cost detail. Applicable values are This Level Cost and Lower Level Cost.
CstStdCostDetailsPEOCreatedBy	User who created or rolled up the standard cost for an item.
CstStdCostDetailsPEOCreationDate	Date and time when the standard cost for an item was created.
CstStdCostDetailsPEOExpensePoolId	Value that uniquely identifies the expense pool. This is the primary key of the Expense Pools view object.
CstStdCostDetailsPEOLastUpdateDate	Date and time when the standard cost detail for an item was last updated.
CstStdCostDetailsPEOLastUpdateLogin	Session login associated with the user who last updated the standard cost detail.
CstStdCostDetailsPEOLastUpdatedBy	User who last updated the standard cost detail.
CstStdCostDetailsPEOStdCostDetailId	Value that uniquely identifies the standard cost detail record. This is the primary key of the Standard Cost Details view object.
CstStdCostDetailsPEOStdCostId	Value that uniquely identifies the standard cost transaction.
CstStdCostDetailsPEOUnitCost	Unit cost for the standard costed item.
CstStdCostsPEOCostBookId	Value that uniquely identifies the cost book assigned to the cost organization. This is the primary key of the Cost Books view object.
CstStdCostsPEOCostOrgId	Value that uniquely identifies the cost organization.
CstStdCostsPEOCostProfileId	Value that uniquely identifies the cost profile for which the standard cost is entered. This is the primary key of the Cost Profiles view object.
CstStdCostsPEOCostType	Value that indicates the cost type. Valid values are: STANDARD or BUY. Buy cost is only used when an item has buy sourcing rules in the organization.
CstStdCostsPEOCreatedBy	User who created or rolled up the standard cost header for an item.
CstStdCostsPEOCreationDate	Date and time when the standard cost header for an item was created.
CstStdCostsPEOCurrencyCode	Code that identifies the currency associated with the item cost.
CstStdCostsPEOEffectiveEndDate	Last date of the date range within which the cost is effective.
CstStdCostsPEOEffectiveStartDate	First date of the date range within which the cost is effective.
CstStdCostsPEOFromPeriodName	Value that identifies the beginning period that the standard cost is effective for periodic average cost enabled items.
CstStdCostsPEOInventoryItemId	Value that uniquely identifies the inventory item for which the standard cost is entered.
CstStdCostsPEOInventoryOrgId	Value that uniquely identifies the inventory organization of the item for which the standard cost is entered.
CstStdCostsPEOLastUpdateDate	Date and time when the standard cost header for an item was last updated.
CstStdCostsPEOLastUpdateLogin	Session login associated with the user who last updated the standard cost header.
CstStdCostsPEOLastUpdatedBy	User who last updated the standard cost header.
CstStdCostsPEOLastUsedDate	The date when the standard cost was last used by the cost processor.
CstStdCostsPEOPreviousEffectiveEndDate	The date until which the previous standard cost record, if any, is effective.
CstStdCostsPEOPreviousEffectiveStartDate	The date from which the previous standard cost record, if any, is effective.
CstStdCostsPEOPreviousStdCostId	Value that uniquely identifies the previous effective standard cost record for the item and valuation unit.
CstStdCostsPEOPreviousTotalCost	Total standard cost applicable prior to the effective dates.
CstStdCostsPEOScenarioId	Value that uniquely identifies the cost scenario. This is the primary key of the Cost Scenarios view object.
CstStdCostsPEOStatusCode	Code that identifies the status of the standard cost. A list of accepted values is defined in the lookup type ORA_CST_STD_COST_STATUSES.
CstStdCostsPEOStdCostId	Value that uniquely identifies the standard cost.
CstStdCostsPEOToPeriodName	Value that identifies the last period that the standard cost is effective for periodic average cost enabled items.
CstStdCostsPEOTotalCost	Total standard cost during the effective dates.
CstStdCostsPEOUomCode	Code that identifies the unit of measure of the standard cost.
CstStdCostsPEOValStructureId	Value that uniquely identifies the valuation structure for which the standard cost is entered. This is the primary key of the Valuation Structures view object.
CstStdCostsPEOValUnitId	Value that uniquely identifies the valuation unit for which the standard cost is entered. This is the primary key of the Valuation Units view object.