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. |