Costing Operation Transactions
The Costing Operation Transactions view object contains the operation transactions to be processed by the Create Cost Accounting Distributions process. The transactions are staged for every cost book associated to the cost organization.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstOperationTxnsExtractPVO
Primary Keys : CstOperationTxnsPEOOperationTransactionId
Initial Extract Date : CstOperationTxnsPEOCreationDate
Incremental Extract Date : CstOperationTxnsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CstOperationTxnsPEOAccountingStatus | Accounting status of the transaction. A list of accepted values is defined in the lookup type CST_ACCOUNTED_FLAG. |
CstOperationTxnsPEOBaseTxnActionId | Value that uniquely identifies the transaction action. |
CstOperationTxnsPEOBaseTxnSourceTypeId | Value that uniquely identifies the transaction source type. The value will always be 0. |
CstOperationTxnsPEOBaseTxnTypeId | Value that uniquely identifies the transaction type. |
CstOperationTxnsPEOCostBookId | Value that uniquely identifies the cost book associated to the cost organization. This is the primary key of the Cost Books view object. |
CstOperationTxnsPEOCostDate | Cost date derived within costing to sequence the transactions for processing. |
CstOperationTxnsPEOCostOrgId | Value that uniquely identifies the cost organization associated to the plant where the work order is executed. |
CstOperationTxnsPEOCostProfileId | Value that uniquely identifies the asset or expense cost profile linked to the item cost profile. This cost profile is used to get the valuation options for the transaction. This is the primary key of the Cost Profiles view object. |
CstOperationTxnsPEOCostTransactionType | Type of cost transaction. A list of accepted values is defined in the lookup type CST_QUANTITY_FLOW. |
CstOperationTxnsPEOCostingStatus | Costing status that identifies whether a transaction has been preprocessed, processed by cost processor, distributions have been created, processed by subledger accounting, and so on. A list of accepted values is defined in the lookup type CST_COST_STATUS. |
CstOperationTxnsPEOCreatedBy | User who created the operation transaction. |
CstOperationTxnsPEOCreationDate | Date and time when the operation transaction was created. |
CstOperationTxnsPEOCstWoOperationTxnId | Value that uniquely identifies the work order operation transaction in costing. This is the primary key of the Costing Work Order Operation Transactions view object. |
CstOperationTxnsPEOCstWorkOrderId | Value that uniquely identifies the work order for which operation transaction was performed. This is the primary key of the Costing Work Orders view object. |
CstOperationTxnsPEOCstWorkOrderOperationId | Value that uniquely identifies the work order operation at which this transaction was performed. This is the primary key of the Costing Work Order Operations view object. |
CstOperationTxnsPEOErrorCode | Code that identifies the error message if the transaction is in an error state. |
CstOperationTxnsPEOFromDispatchState | 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. |
CstOperationTxnsPEOInventoryItemId | Value that uniquely identifies the primary product associated with the work order where the resource was consumed. |
CstOperationTxnsPEOInventoryOrganizationId | Value that uniquely identifies the plant where the operation was performed. |
CstOperationTxnsPEOItemCostProfileId | Value that unique identifies the item cost profile of the primary product of the work order associated to the operation transaction. This is the primary key of the Item Cost Profiles view object. |
CstOperationTxnsPEOLastUpdateDate | Date when the operation transaction was last updated. |
CstOperationTxnsPEOLastUpdateLogin | Session login associated with the user who last updated the operation transaction. |
CstOperationTxnsPEOLastUpdatedBy | User who last updated the operation transaction. |
CstOperationTxnsPEOLeTimezoneCode | Code that identifies the legal entity time zone configured. If NULL, then legal entity time zone isn't enabled and the dates are assumed to be in the server time zone. |
CstOperationTxnsPEOOperationScrapCostType | Cost type indicates how to handle the scrap costs. A list of accepted values is defined in the lookup type ORA_CST_OPERATION_SCRAP. |
CstOperationTxnsPEOOperationScrapValuationType | Valuation type indicates when to calculate the value of scrap transactions. A list of accepted values is defined in the lookup type ORA_CST_OP_SCRAP_VALUATION. |
CstOperationTxnsPEOOperationSeqNumber | Sequence number identifies the operation sequence within a work order. This is the sequence in which operation will be performed in the work order. |
CstOperationTxnsPEOOperationTransactionId | Value that uniquely identifies the operation transaction in costing. |
CstOperationTxnsPEOPeriodName | Value that identifies the period in which the transaction is processed. This value is populated for transactions of items using the periodic average cost method. |
CstOperationTxnsPEOPostedFlag | Contains one of the following values: Y, N, or E. If Y, then the transaction has been processed and costs created in the Work Order Operation Transaction Costs view object. If N, then the transaction hasn't been processed. If E, then the transaction is in an error state. This attribute doesn't have a default value. |
CstOperationTxnsPEOPreprocessingStatus | Preprocessing status of the transactions. Contains one of the following values: SUCCESS or ERROR. |
CstOperationTxnsPEOPrimaryQuantity | Transaction quantity in the primary unit of measure. |
CstOperationTxnsPEOPrimaryUomCode | Code that identifies the primary unit of measure of the item. |
CstOperationTxnsPEOProvisionalCompletionType | Completion type indicates how to process partial completions. A list of accepted values is defined in the lookup type ORA_CST_PARTIAL_COMPLETION. |
CstOperationTxnsPEOReasonCode | Code that identifies the reason for either rejecting the quantities at the operation or scrapping at the operation. |
CstOperationTxnsPEOToDispatchState | 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. |
CstOperationTxnsPEOTransactionDate | Date and time when the transaction was performed. |
CstOperationTxnsPEOTransactionQuantity | Transaction quantity in the transaction unit of measure. |
CstOperationTxnsPEOTransactionUomCode | Code that identifies the transaction unit of measure. |
CstOperationTxnsPEOTxnSourceDocNumber | Document number of the transaction. This is the operation transaction identifier. |
CstOperationTxnsPEOTxnSourceDocType | Document type of the transaction. The value will always be WO indicating work order. |
CstOperationTxnsPEOTxnSourceRefDocNumber | Reference document number of the transaction. This is the work order reference. |
CstOperationTxnsPEOTxnSourceRefDocType | Reference document type of the transaction. The value will always be WO indicating work order. |
CstOperationTxnsPEOWoUpdateEventTxnId | Value that uniquely identifies the work order close transaction. This is the primary key of the Costing Work Order Update Events view object. |
CstOperationTxnsPEOWorkCenterId | Value that uniquely identifies the work center where the operation was performed. |