Costing Work Order Operation Transactions

The Costing Work Order Operation Transactions view object contains information about the work order operation transactions within costing.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstWOOperationTxnsExtractPVO

Primary Keys : CstWOOperationTxnsPEOCstWoOperationTxnId

Initial Extract Date : CstWOOperationTxnsPEOCreationDate

Incremental Extract Date : CstWOOperationTxnsPEOLastUpdateDate

Attributes

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

Name Description
CstWOOperationTxnsPEOBaseTxnActionId Value that uniquely identifies the transaction action.
CstWOOperationTxnsPEOBaseTxnSourceTypeId Value that uniquely identifies the source type of the inventory transaction.
CstWOOperationTxnsPEOBaseTxnTypeId Value that uniquely identifies the type of inventory transaction. The value will always be 0.
CstWOOperationTxnsPEOCreatedBy User who created the costing work order operation transaction.
CstWOOperationTxnsPEOCreationDate Date and time when the costing work order operation transaction was created.
CstWOOperationTxnsPEOCstWoOperationTxnId Value that uniquely identifies the costing work order operation transaction. This is the primary key of the Costing Work Order Operation Transactions view object.
CstWOOperationTxnsPEOCstWorkOrderId Value that uniquely identifies the work order in the source system. This is the primary key of the Costing Work Orders view object.
CstWOOperationTxnsPEOCstWorkOrderOperationId Value that uniquely identifies the work order operation associated to the transaction. This is the primary key of the Costing Work Order Operations view object.
CstWOOperationTxnsPEOExternalSystemRefId Value that uniquely identifies the work order operation transaction in the source system.
CstWOOperationTxnsPEOExternalSystemReference Code that identifies the external system owning the operation transactions.
CstWOOperationTxnsPEOFromDispatchState Starting dispatch status from where the work order operation quantity moves. A list of accepted values is defined in the lookup type ORA_WIE_DISPATCH_STATE.
CstWOOperationTxnsPEOInventoryItemId Value that uniquely identifies the primary product associated with the work order.
CstWOOperationTxnsPEOInventoryOrganizationId Value that uniquely identifies the plant where the work order operation was performed.
CstWOOperationTxnsPEOLastUpdateDate Date when the costing work order operation transaction was last updated.
CstWOOperationTxnsPEOLastUpdateLogin Session login associated with the user who last updated the costing work order operation transaction.
CstWOOperationTxnsPEOLastUpdatedBy User who last updated the costing work order operation transaction.
CstWOOperationTxnsPEOOperationSeqNumber Sequence number of the operation within a work order. This is the sequence in which operation will be performed in the work order.
CstWOOperationTxnsPEOPrimaryQuantity Transaction quantity in the primary unit of measure.
CstWOOperationTxnsPEOPrimaryUomCode Code that identifies the primary unit of measure for the item.
CstWOOperationTxnsPEOProcessedByCaFlag Contains one of the following values N or NULL. If N, then the work order operation transaction isn't yet processed by cost accounting. If NULL, the work order operation transaction is processed by cost accounting. This attribute doesn't have a default value.
CstWOOperationTxnsPEOReasonCode Code that identifies the reason for either rejecting the quantities at the operation or scrapping at the operation.
CstWOOperationTxnsPEOToDispatchState Ending dispatch status where the work order operation quantity moves. A list of accepted values is defined in the lookup type ORA_WIE_DISPATCH_STATE.
CstWOOperationTxnsPEOTransactionDate Date and time when the work order operation transaction is performed.
CstWOOperationTxnsPEOTransactionQuantity Transaction quantity in the transaction unit of measure.
CstWOOperationTxnsPEOTransactionTypeCode Code that identifies the operation transaction type. A list of accepted values is defined in the lookup type ORA_WIE_OP_TRANSACTION_TYPE.
CstWOOperationTxnsPEOTransactionUomCode Code that identifies the transaction unit of measure.
CstWOOperationTxnsPEOWorkCenterId Value that uniquely identifies the work center where the operation is carried out.
CstWOOperationTxnsPEOWorkOrderId Value that unique identifies the work order in the source system.
CstWOOperationTxnsPEOWorkOrderOperationId Value that unique identifies the work order operation associated with the operation transaction.