Resource Costs

The Resource Costs view object contains the breakup of resource cost at cost element and expense pool level, which is used to create accounting distributions for the resource transactions.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstResourceCostsExtractPVO

Primary Keys : CstResourceCostsPEOResourceCostId

Initial Extract Date : CstResourceCostsPEOCreationDate

Incremental Extract Date : CstResourceCostsPEOLastUpdateDate

Attributes

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

Name	Description
CstResourceCostsPEOAdditionalProcessingCode	Additional processing code is used on adjustment transactions and is set to WIP_STD_RESOURCE when the adjustment is triggered by cost change else it's set to NULL. An adjustment transaction is a transaction where the cost transaction type is set to ADJUST. Additional processing code is optional.
CstResourceCostsPEOBaseTxnTypeId	Value that uniquely identifies the resource transaction type.
CstResourceCostsPEOCostBookId	Value that unique identifies the cost book associated with the cost organization. This is the primary key of the Cost Books view object.
CstResourceCostsPEOCostDate	Cost date of the resource transaction.
CstResourceCostsPEOCostElementId	Value that uniquely identifies the cost element against which the cost is captured. This is the primary key of the Cost Elements view object.
CstResourceCostsPEOCostOrgId	Value that uniquely identifies the cost organization associated with the plant where the resource was consumed.
CstResourceCostsPEOCostReference	Reference that identifies a specific business object or value which further refines the cost source information, such as the identifier of the source cost organization or an effective date. Value would be of the form Cost Scenario Number - Effective Start Date.
CstResourceCostsPEOCostSource	Source of the cost, such as standard cost. A list of accepted values is defined in the lookup type CST_COST_SOURCES.
CstResourceCostsPEOCostTransactionType	Type of cost transaction. A list of accepted values is defined in the lookup type CST_QUANTITY_FLOW.
CstResourceCostsPEOCreatedBy	User who created the resource cost.
CstResourceCostsPEOCreationDate	Date and time when the resource cost was created.
CstResourceCostsPEOCurrencyCode	Code that identifies the currency of the cost organization and cost book in which the resource transaction is processed.
CstResourceCostsPEODistributionId	Value that uniquely identifies the distribution header, if the distributions have been created for the resource transaction .
CstResourceCostsPEOEffDate	Date when the resource cost becomes effective. This is same as the cost date.
CstResourceCostsPEOExpensePoolId	Value that uniquely identifies the expense pool against which the cost is captured. This is the primary key of Expense Pools view object.
CstResourceCostsPEOLastUpdateDate	Date when the resource cost was last updated.
CstResourceCostsPEOLastUpdateLogin	Session login associated with the user who last updated the resource cost.
CstResourceCostsPEOLastUpdatedBy	User who last updated the resource cost.
CstResourceCostsPEOPeriodName	Value that identifies the period in which the transaction is processed. This value is populated for transactions of items using the periodic average cost method.
CstResourceCostsPEOPostedFlag	Contains one of the following values: Y or N. If Y, then the distributions have been created for the resource cost. If N, then the distributions haven't been created for the resource cost. This attributes doesn't have any default value.
CstResourceCostsPEOQuantity	Resource usage in the primary unit of measure.
CstResourceCostsPEOResourceCostId	Value that uniquely identifies the resource cost. This is the primary key of the Resource Costs view object.
CstResourceCostsPEOResourceId	Value that uniquely identifies the resource that was consumed.
CstResourceCostsPEOResourceTransactionId	Value that uniquely identifies the resource transaction in costing.
CstResourceCostsPEOStdResourceRateId	Value that uniquely identifies the resource rate. This is the primary key of the Resource Rate Details view object.
CstResourceCostsPEOUnitCost	Resource rate per unit in the cost book currency for each cost element and expense pool combination applicable on the transaction. The rate per unit is derived based on the cost date.
CstResourceCostsPEOUomCode	Code that identifies the unit of measure of the resource transaction.