Enhanced Item Cost Output SDO

The set of data elements returned by the query of item costs information.

QName: {http://xmlns.oracle.com/apps/scm/costing/itemCosts/itemCostServiceV2/}ItemCostServiceOutput

Logical Business Objects

  • SCM : Cost Management : Item Cost

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Handled by

Item Cost

Attributes

The following table describes attributes in the service data object.

Name Type Description

CountryOfOriginCode

string

Code for the country of manufacture used to stripe Inventory transactions.

CurrencyCode

string

Currency in which item cost is computed.

ErrorFlag

boolean

Error identifier in cases where the service cannot find a cost.

Grade

string

Name of the lot grade.

InventoryOrganizationCode

string

Inventory organization code for which item cost needs to be computed.

InventoryOrganizationId

long

Unique identifier associated with the inventory organization.

ItemCost

double

Total cost of the item calculated for a cost organization, cost book, and cost profile combination.

ItemCostServiceId

long

Unique Item Cost Service Id generated by the system.
  • Primary Key

ItemId

long

Unique identifier associated with the inventory item.

ItemNumber

string

Item for which item cost is computed.

KindOfCost

string

Parameter used to retrieve a cost. If the parameter is CostBookCode, then the cost for that cost book is retrieved. If the parameter is AverageOfPOs, then the average of the specified number of POs is calculated and displayed.

KindOfCostDetail

string

Value for the parameter used to retrieve a cost. The parameter value can be a cost book code, or an integer indicating the number of POs used to compute the average cost.

Locator

string

Name of inventory locator.

LotNumber

string

Identifier associated with the lot.

ProjectId

string

Identifier of the project used to stripe Inventory transactions.

ProjectNumber

string

Project used to stripe Inventory transactions.

ReferenceDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date of the item cost retrieval.

SerialNumber

string

Unique number assigned to a single piece, and never reused for similar pieces.

SubInventoryCode

string

Name associated with the subinventory.

TaskId

string

Identifier of the task used to stripe Inventory transactions.

TaskNumber

string

Task used to stripe Inventory transactions.

UOMCode

string

Costing unit of measure code in which item cost is computed.

UnitOfMeasure

string

Costing unit of measure in which item cost is computed.