Resource Rate Details
The Resource Rate Details view object contains the cost element level breakup of resource rates published to cost accounting from a cost planning scenario.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstStdResourceRateDtlsExtractPVO
Primary Keys : ResourceRateDetailsPEOStdResourceRateDetailId
Initial Extract Date : ResourceRateDetailsPEOCreationDate
Incremental Extract Date : ResourceRateDetailsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ResourceRateDetailsPEOCostElementId | Value that uniquely identifies the cost element of resource rate detail. This is the primary key of the Cost Elements view object. |
| ResourceRateDetailsPEOCreatedBy | User who created resource rate detail. |
| ResourceRateDetailsPEOCreationDate | Date and time when the resource rate detail was created. |
| ResourceRateDetailsPEOExpensePoolId | Value that uniquely identifies the expense pool of resource rate detail. |
| ResourceRateDetailsPEOLastUpdateDate | Date when the resource rate detail was last updated. |
| ResourceRateDetailsPEOLastUpdateLogin | Session login associated with the user who last updated the resource rate detail. |
| ResourceRateDetailsPEOLastUpdatedBy | User who last updated the resource rate detail. |
| ResourceRateDetailsPEOStdResourceRateDetailId | Value that uniquely identifies the resource rate detail. This is the primary key of the Resource Rate Details view object. |
| ResourceRateDetailsPEOStdResourceRateId | Value that uniquely identifies the standard resource rate under which the resource rate details are defined. |
| ResourceRateDetailsPEOUnitRate | Unit rate for the cost element in the resource rate currency. |
| ResourceRatesPEOCostBookId | Value that uniquely identifies the cost book assigned to the cost organization. This is the primary key of the Cost Books view object. |
| ResourceRatesPEOCostOrgId | Value that uniquely identifies the cost organization of the resource for which resource rate details are defined. |
| ResourceRatesPEOCurrencyCode | Code that identifies the currency in which the resource rate is defined. |
| ResourceRatesPEOEffectiveEndDate | Date till which the resource rate is effective. |
| ResourceRatesPEOEffectiveStartDate | Date when the resource rate becomes effective. |
| ResourceRatesPEOFromPeriodName | Value that identifies the beginning period that the standard cost is effective for periodic average cost enabled items. |
| ResourceRatesPEOInvOrgId | Value that uniquely identifies the inventory organization for which the resource rate is entered. |
| ResourceRatesPEOLastUsedDate | Date when the resource rate was last used. |
| ResourceRatesPEOLastUsedTransactionId | Value that uniquely identifies the last resource transaction which used this standard resource rate for accounting purposes. |
| ResourceRatesPEOPlanningResourceRateId | Value that uniquely identifies the cost planning resource rate from which the resource rate is published. |
| ResourceRatesPEOPreviousEffectiveEndDate | Date till which the previous resource rate was effective. |
| ResourceRatesPEOPreviousEffectiveStartDate | Date when the previous resource rate became effective. |
| ResourceRatesPEOPreviousStdResourceRateId | Value that uniquely identifies the previous resource rate that's replaced by this standard resource rate. |
| ResourceRatesPEOResourceId | Value that uniquely identifies the resource for which the resource rate details are published. |
| ResourceRatesPEOScenarioEventId | Value that uniquely identifies the scenario event from which the resource rate is published. |
| ResourceRatesPEOScenarioId | Value that uniquely identifies the scenario for which the resource rate is published. |
| ResourceRatesPEOSourceDi | Contains one of the following values: Y, N, or NULL. If Y, then the standard resource rate details was created using the desktop integration interface. If N or NULL, then the standard resource rate details wasn't created using the desktop integration interface. The default value in N. |
| ResourceRatesPEOStagedForStdCostAdjFlag | Contains one of the following values: Y or N. If Y, then the resource rate is staged for work in process revaluation. If N, then the resource rate isn't yet staged for work in process revaluation. The default value in N. |
| ResourceRatesPEOStatusCode | Code that indicates the status of the standard resource rate. A list of accepted values defined in the lookup type ORA_CST_STD_COST_STATUSES. |
| ResourceRatesPEOStdResourceRateId | Value that uniquely identifies the standard resource rate from which the standard resource rate detail is published. |
| ResourceRatesPEOToPeriodName | Value that identifies the last period that the standard cost is effective for periodic average cost enabled items. |
| ResourceRatesPEOTotalRate | Total of all the unit rates for a resource rate. |
| ResourceRatesPEOUomCode | Code that identifies the unit of measure for the resource. |