Work Order Costs

The Work Order Costs view object contains the WIP costs for a work order and is used for determining the product cost for nonstandard cost methods, the residual WIP balance for standard cost method products which are accounted as variances, and the value of the WIP material return transaction.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstWorkOrderCostsExtractPVO

Primary Keys : CstWorkOrderCostsPEOWorkOrderCostId

Initial Extract Date : CstWorkOrderCostsPEOCreationDate

Incremental Extract Date : CstWorkOrderCostsPEOLastUpdateDate

Attributes

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

Name	Description
CstWorkOrderCostsPEOAbsorptionType	Absorption type indicates whether the cost needs to be included in the WIP value or should it be expensed. A list of accepted values is defined in the lookup type CST_ABSORPTION_TYPE.
CstWorkOrderCostsPEOCostBookId	Value that uniquely identifies the cost book associated with the cost organization. This is the primary key of the Cost Books view object.
CstWorkOrderCostsPEOCostDate	Cost date of the inventory or resource transaction.
CstWorkOrderCostsPEOCostElementId	Value that uniquely identifies the cost element.
CstWorkOrderCostsPEOCostId	Value that uniquely identifies the cost at the source.
CstWorkOrderCostsPEOCostOrgId	Value that uniquely identifies the cost organization associated with the inventory organization.
CstWorkOrderCostsPEOCreatedBy	User who created the work order cost.
CstWorkOrderCostsPEOCreationDate	Date when the work order cost was created.
CstWorkOrderCostsPEOCstWorkOrderId	Value that uniquely identifies the costing work order. This is the primary key of the Costing Work Orders view object.
CstWorkOrderCostsPEOCstWorkOrderOperationId	Value that uniquely identifies the costing work order operation. This is the primary key of the Costing Work Order Operations view object
CstWorkOrderCostsPEOCurrencyCode	Code that identifies the currency in which the cost is recorded.
CstWorkOrderCostsPEOExpensePoolId	Value that uniquely identifies the expense pool against which the cost is captured. This is the primary key of the Expense Pools view object.
CstWorkOrderCostsPEOInventoryItemId	Value that uniquely identifies the item associated with the WIP inventory transaction.
CstWorkOrderCostsPEOLastUpdateDate	Date when the work order cost was last updated.
CstWorkOrderCostsPEOLastUpdateLogin	Session login associated with the user who last updated the work order cost.
CstWorkOrderCostsPEOLastUpdatedBy	User who last updated the work order cost.
CstWorkOrderCostsPEOPoItemDescription	Item description in the purchase order. This is captured only for items not defined in Product Information Management.
CstWorkOrderCostsPEOQuantity	Quantity recorded on the transaction associated with the cost.
CstWorkOrderCostsPEORecloseFlag	Contains one of the following values: Y, N, or NULL. If Y, then the work order cost is posted after work order close and the variances are recomputed. If N, then the work order cost is posted after work order close and the variances aren't yet recomputed. If NULL, the work order cost was posted before the work order close. The default value is NULL.
CstWorkOrderCostsPEOResourceId	Value that uniquely identifies the resource associated with the WIP resource transaction.
CstWorkOrderCostsPEOSourceTable	Source where the cost is recorded.
CstWorkOrderCostsPEOTransactionId	Value that uniquely identifies the transaction in costing.
CstWorkOrderCostsPEOUnitCost	Cost per unit recorded at the cost element and expense pool level.
CstWorkOrderCostsPEOUomCode	Code that identifies the unit of measure.
CstWorkOrderCostsPEOWipCostType	Type of WIP cost incurred. The accepted values are COMPONENT indicating materials and outside processing items, NEG_COMPONENT indicating materials returned from work order in the case of rework or transform, PRODUCT indicating output items, RESOURCE indicating manufacturing resources, VARIANCE indicating cost variances at the work order, and SCRAP indicating items discarded at work order.
CstWorkOrderCostsPEOWipTxnSign	Transaction sign indicates whether the cost must be added or subtracted from the total WIP cost. Contains one of the following values: 1 or -1. This value is multiplied with the quantity and unit cost to arrive at the net cost.
CstWorkOrderCostsPEOWoCostAllocationBasis	Basis for the cost allocation of output items in a process manufacturing work order. It can be either a percentage value or a fixed value. A list of accepted values is defined in the lookup type ORA_WIS_COST_ALLOC_BASIS.
CstWorkOrderCostsPEOWorkOrderCostId	Value that uniquely identifies the work order cost. This is the primary key of the Work Order Costs view object.