Costing Transactions
The Costing Transactions view object contains information about the costing transactions. The imported inventory transactions are converted to costing transaction type, exploded for Cost Org - Book and stamped with suitable costing setup like item cost profile, valuation unit and costing method and so on.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstTransactionsExtractPVO
Primary Keys : CstTransactionsPEOTransactionId
Initial Extract Date : CstTransactionsPEOCreationDate
Incremental Extract Date : CstTransactionsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CstTransactionsPEOAccountingStatus | Value that identifies the current accounting status of the transaction for display. A list of accepted values is defined in the lookup type CST_ACCOUNTING_STATUS. |
CstTransactionsPEOAdditionalProcessingCode | Value that identifies what kind of processing needs to be done. The value is defined in CST_TXN_SOURCE_ACTIONS for the transaction type and is used by cost processors for additional processing. |
CstTransactionsPEOBaseTxnActionId | Value that uniquely identifies the inventory transaction action. For origin as INV, a list of accepted values is defined in the lookup type INV_TRANSACTION_ACTIONS. For origin as CST. A list of accepted values is defined in the lookup type CST_BASE_TXN_ACTIONS. |
CstTransactionsPEOBaseTxnSourceTypeId | Value that identifies the inventory transaction source type identifier. This is a part of the primary key of the Costing Internal Transaction Types view object. |
CstTransactionsPEOBaseTxnTypeId | Value that identifies the inventory transaction type identifier. This is a part of the primary key of the Costing Internal Transaction Types view object. |
CstTransactionsPEOBusinessUnitId | Value that uniquely identifies the business unit of the inventory organization. |
CstTransactionsPEOCodeCombinationId | Value that uniquely identifies the code combination for the referenced account. |
CstTransactionsPEOCogsPostedFlag | Value that identifies whether or not cogs has been recognized for the transaction or not yet. |
CstTransactionsPEOConsignedAcctDistBasis | Value that identifies the Consigned Accounting Distribution basis for the cost profile. |
CstTransactionsPEOConsignedFlag | Value that identifies whether the transaction is consigned or owned. |
CstTransactionsPEOCostBookId | Value that uniquely identifies the cost book assigned to the Cost Organization. This is the primary key of the Cost Books view object. |
CstTransactionsPEOCostDate | Date to be used for transaction sequencing. |
CstTransactionsPEOCostMethodCode | Value that identifies the cost method code used for processing the transaction. A list of accepted values is defined in the lookup type CST_COST_METHODS. |
CstTransactionsPEOCostOrgId | Value that uniquely identifies the cost organization associated with the inventory organization. |
CstTransactionsPEOCostProfileId | Value that uniquely identifies the cost profile. This is the primary key of the Cost Profiles view object. |
CstTransactionsPEOCostStatus | Value that identifies the current costing status of the transaction for display. A list of accepted values is defined in the lookup type CST_COST_STATUS. |
CstTransactionsPEOCostTransactionType | Value that identifies the costing transaction type. A list of accepted values is defined in the lookup type CST_QUANTITY_FLOW. |
CstTransactionsPEOCostedQty | Value that identifies quantity that has been processed in costing. |
CstTransactionsPEOCostingStatus | Value that identifies the status of the transaction which denotes whether a transaction has been preprocessed, processed by cost processors, distributions have been created or processed by subledger accounting. |
CstTransactionsPEOCostingUomCode | Value that identifies the unit of measure for the costed quantity. |
CstTransactionsPEOCreateAcctForConsTxns | Value that identifies the creating accounting for consigned transactions. Possible values are Y or N. |
CstTransactionsPEOCreatedBy | User who created the costing transaction. |
CstTransactionsPEOCreationDate | Date and time when the costing transaction was created. |
CstTransactionsPEOCstInvTransactionDtlId | Value that identifies the source inventory transaction detail that references costings inventory transaction details table. |
CstTransactionsPEOCstInvTransactionId | Value that uniquely identifies the inventory transaction that references costings inventory transaction table. This is the primary key of the Costing Inventory Transactions view object. |
CstTransactionsPEOCstTransferOrderDistId | Value that uniquely identifies the transfer order distribution. |
CstTransactionsPEOCstTransferOrderLineId | Value that uniquely identifies the transfer order line. |
CstTransactionsPEOCstWoOperationTxnId | Value that uniquely identifies the work order operation transaction. This is the primary key of the Costing Work Order Operation Transactions view object. |
CstTransactionsPEOCstWorkOrderId | Value that uniquely identifies the work order associated with the transaction. This is the primary key of the Costing Work Orders view object. |
CstTransactionsPEOCstWorkOrderOperationId | Value that uniquely identifies the work order operation associated with the transaction. This is the primary key of the Costing Work Order Operations view object. |
CstTransactionsPEODooFullfillLineId | Value that uniquely identifies the source fulfillment line in distributed order orchestration. |
CstTransactionsPEODooSplitFulfillLineId | Value that uniquely identifies the distributed order orchestration fulfillment line identifier. |
CstTransactionsPEODsSourceLineId | Value that identifies the flow type, ASN OR INVOICE, either Shipment Line ID or Transaction Event ID will be stored. |
CstTransactionsPEOEnforceTxnDateOrderFlag | Value that identifies the profile option to have cost dates in the same order as the transaction date. Possible values are Yes and No. |
CstTransactionsPEOErrorCode | Value that identifies the error code for transaction. |
CstTransactionsPEOExpenseTransactionFlag | Value that identifies whether a transaction is an asset or expense transaction. |
CstTransactionsPEOFobPoint | Value that identifies the Free on board point and determines the point of transfer of liability or ownership. It's 1 for SHIPMENT and 2 for RECEIPT. |
CstTransactionsPEOIntercompanyInvoicingFlag | Value that identifies whether the transaction is eligible for intercompany invoicing or not. |
CstTransactionsPEOInternalProfitTracking | Value that identifies whether profit in inventory is to be tracked or not. This column is used by Costing and the values it can hold are Y and N. |
CstTransactionsPEOIntransitFlag | Value that identifies whether the transaction is a issue or receipt into in transit. |
CstTransactionsPEOInvTxnSourceTypeId | Value that identifies transaction source type identifier including custom source types. |
CstTransactionsPEOInventoryItemId | Value that identifies the inventory Item associated to the transaction. |
CstTransactionsPEOInventoryOrgId | Value that uniquely identifies the inventory organization to which the item belongs. |
CstTransactionsPEOItemCostProfileId | Value that uniquely identifies the item cost profile. This is the primary key of the Item Cost Profiles view object. |
CstTransactionsPEOLastUpdateDate | Date when the costing transaction row was last updated. |
CstTransactionsPEOLastUpdateLogin | Session login associated with the user who last updated the costing transaction row. |
CstTransactionsPEOLastUpdatedBy | User who last updated the costing transaction row. |
CstTransactionsPEOLeTimezoneCode | Value that identifies the legal entity time zone. If NULL, then LE time zone isn't enabled for the data in the row and the dates are assumed to be in database time zone. |
CstTransactionsPEOLogicalFlag | Value that identifies whether this transaction type is logical. Such transactions have no on-hand quantity impact and don't trigger reaveraging. These transaction show the financial flow. |
CstTransactionsPEOManualReceiptReqdFlag | Value that identifies if the manual receipt is created or not for transfer to expense destination. |
CstTransactionsPEOMatchedToAddlTaxFlag | Value that identifies if additional taxes are required and available for the transaction. Expected values are: X indicates not expected, N indicates expected but missing, Y indicates expected and present. |
CstTransactionsPEOMatchedToCostFlag | Value that identifies transactions that have an associated cost in the Transaction Costs view object. Valid values are N, Y, or X. Transactions for which this doesn't apply are marked with X. N means waiting for the incoming acquisition cost, transfer cost, or current item cost to be stamped in Transaction Costs. |
CstTransactionsPEONegativeQtyCode | Value that identifies the negative quantity code defines the action of cost method processors when the inventory quantity becomes negative. A list of accepted values is defined in the lookup type CST_NEGATIVE_QUANTITY_CODES |
CstTransactionsPEOOperationScrapCostType | Value that identifies the work order valuation option for including scrap costs as a part of inventory or expense out. A list of accepted values is defined in the lookup type ORA_CST_OPERATION_SCRAP. |
CstTransactionsPEOOwningCostOrgId | Value that uniquely identifies the cost organization that owns the transaction. Owning Cost Org is different from Cost Org for consignment transactions. |
CstTransactionsPEOPartialCompletionFlag | Value that identifies if a product completion transaction is processed as partial completion. Valid values are NULL, N and Y. |
CstTransactionsPEOPeriodName | 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. |
CstTransactionsPEOPoDistributionId | Value that identifies the purchase order distribution. |
CstTransactionsPEOPoItemDescription | Value that identifies the item description for purchase orders where purchase is made for noninventory items |
CstTransactionsPEOPoItemDescriptionType | Value that identifies the type of purchase in case purchase is made for noninventory item based on description. Valid values are GOODS or SERVICES. |
CstTransactionsPEOPostedFlag | Value that identifies whether or not the transaction has been posted to quantity layers. It gets updated by Review Cost Accounting Distributions process |
CstTransactionsPEOPreprocessingStatus | Value that identifies the cost preprocessing status for transaction. |
CstTransactionsPEOPricingOption | Value that identifies the pricing option identifier. It signifies whether the option is to use the PO price, transfer price, or the cost markup as the transfer cost. |
CstTransactionsPEOProcessDate | Date at which the average cost processor processed this transaction. It gives the sequence of transaction processing. |
CstTransactionsPEOProjectFlag | Option for identifying if projects is enabled. Will be populated as Y for project enabled sales order issue transaction for now and later extended to all transactions types where projects is enabled. |
CstTransactionsPEOPropagateCostAdjFlag | The values can be Y or N, Default, and dictates whether or not cost adjustments will be propagated. |
CstTransactionsPEOProvisionalCompletionType | Value that identifies the work order valuation option for valuing work order partial completions into inventory. A list of accepted values is defined in the lookup type ORA_CST_PARTIAL_COMPLETION. |
CstTransactionsPEOQuantity | Value that identifies the transaction quantity. |
CstTransactionsPEOQuantityDepleted | Value that identifies the total quantity that has been depleted for an issue transaction. This doesn't include the negative depletions or reversals. |
CstTransactionsPEOQuantityFlowCode | Value that identifies the quantity flow code, FIFO or LIFO. A list of accepted values is defined in the lookup type CST_QUANTITY_FLOW_CODES |
CstTransactionsPEORcvTransactionId | Value that uniquely identifies the receiving transaction. |
CstTransactionsPEORecOnhandAvailFlag | Value that identifies the record on hand available option. |
CstTransactionsPEOReceiptWithoutCostCode | Value that identifies which receipt cost will be used for a receipt without any cost. The default value is CURRENT. A list of accepted values is defined in the lookup type CST_RECEIPT_WITHOUT_COST. |
CstTransactionsPEOReferenceDeliveryId | Value that uniquely identifies the delivery identifier of the forward flow. |
CstTransactionsPEOReferenceDooFullfillLineId | Value that uniquely identifies the referenced fulfillment line. |
CstTransactionsPEOReferencedReturnFlag | Value that identifies the referenced RMA. Possible values are : Y, N, and NULL. Y indicates the return is a referenced return N indicates it's unreferenced. NULL indicates it's a prerelease 13 return flow or this column isn't applicable for the flow. |
CstTransactionsPEOReferencedRmaCostCode | Value that identifies the cost to be used for referenced RMA transactions. The default value is SO_COST. A list of accepted values is defined in the lookup type CST_REFERENCED_RMA_COST. |
CstTransactionsPEORunMode | Value that identifies the mode in which this transaction is created and is used to specify whether it can be reprocessed. |
CstTransactionsPEOSimpleProcFlag | Value that identifies whether the drop ship delivery is for Simple Procurement or for Global Procurement flow. |
CstTransactionsPEOStagedForTxfrCostFlag | Value that identifies if the physical transfer transaction has the cost staged in the cst_transfer_txn_costs tables for transfer cost preprocessing. |
CstTransactionsPEOStructureInstanceNumber | Value that identifies the valuation structure instance number for transaction. |
CstTransactionsPEOSupplyType | Value that identifies the supply type on WIP transactions. The various supply types are Assembly Pull, Operation Pull, Push and Phantom. |
CstTransactionsPEOTransactionAmount | Value that identifies the transaction Amount in purchase order currency. Applicable for fixed price lines. |
CstTransactionsPEOTransactionCurrencyCode | Value that identifies the purchase order currency for the amount column. Applicable for fixed price lines. |
CstTransactionsPEOTransactionDate | Date when this transaction happened. |
CstTransactionsPEOTransactionFlowType | Value that identifies the transaction flow. A list of accepted values is defined in the lookup type ORA_CST_TRANSACTION_FLOW_TYPES. |
CstTransactionsPEOTransactionGroupId | Value that's used to group related transactions together. |
CstTransactionsPEOTransactionId | Value that uniquely identifies the transaction in costing. This is the primary key of the Costing Transactions view object. |
CstTransactionsPEOTransactionQty | Value that identifies the transaction quantity of the inventory transaction. |
CstTransactionsPEOTransactionUomCode | Value that identifies the unit of measure code in which transaction quantity is specified. |
CstTransactionsPEOTransferBookId | Value that uniquely identifies the cost book to be used for processing transfer transaction. |
CstTransactionsPEOTransferCostOrgId | Value that uniquely identifies the cost organization associated with inventory organization of the other leg of transfer transaction. |
CstTransactionsPEOTransferCstInvTxnDtlId | Value that uniquely identifies source inventory transaction detail, such as lot or serial, identifying the other leg of transfer transaction. This is populated only if the item is lot or serial controlled in both source and destination organizations. |
CstTransactionsPEOTransferCstInvTxnId | Identifier of the source inventory transaction indicating the other leg of transfer transaction. |
CstTransactionsPEOTransferPercentage | Percentage of value to attribute to transfer costs in an interorganization transfer. |
CstTransactionsPEOTransferTransactionGroupId | Value that identifies the transaction group whose average cost is required to process this transaction. |
CstTransactionsPEOTransferUomConversionFactor | Value that identifies the conversion factor between primary UOM code of the issue transaction and the primary UOM code of the receipt transaction. |
CstTransactionsPEOTransferValUnitId | Value that uniquely identifies the valuation unit associated with the other leg of transfer transaction. |
CstTransactionsPEOTxnSourceDocNumber | Value that identifies the transactions Source Document Number. |
CstTransactionsPEOTxnSourceDocType | Value that identifies the transactions source documents reference document type. A list of accepted values is defined in the lookup type ORA_CST_TRANSACTION_FLOW_TYPES. |
CstTransactionsPEOTxnSourceRefDocNumber | Value that identifies the transactions Source Documents Reference Document Number. |
CstTransactionsPEOTxnSourceRefDocType | Value that identifies the transactions Source Documents Reference Document Type. A list of accepted values is defined in the lookup type ORA_CST_TRANSACTION_FLOW_TYPES. |
CstTransactionsPEOUomCode | Value that identifies unit of measure code of the transaction quantity. |
CstTransactionsPEOUomConversionFactor | Value that identifies the UOM conversion factor from primary UOM to costing UOM, because the incoming cost is always in the primary UOM. |
CstTransactionsPEOUseItemCostFlag | Value that identifies the receipt transactions that didn't come with its own cost and are to use an existing item cost in the application, current perpetual average, a specific layer cost, or the current standard cost. Valid values are Y or N. Doesn't apply to transfer transactions. |
CstTransactionsPEOValOnhandFlag | Value that identifies if the on hand calculations have been done for the layer. Possible values are N not processed, NULL indicates processed for on hand calculations |
CstTransactionsPEOValStructureId | Value that uniquely identifies the valuation structure. This is the primary key of the Valuation Structures view object. |
CstTransactionsPEOValUnitCombinationId | Value that uniquely identifies the Valuation Unit Code Combination. This is the primary key of the Valuation Unit Combinations view object. |
CstTransactionsPEOValUnitDetailId | Value that uniquely identifies the valuation unit detail line. |
CstTransactionsPEOValUnitId | Value that uniquely identifies the valuation unit for the transaction. This is the primary key of the Valuation Units view object. |
CstTransactionsPEOWoCostAllocationBasis | Value that identifies the basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. A list of accepted values is defined in the lookup type ORA_WIS_COST_ALLOC_BASIS. |
CstTransactionsPEOWoLayerPostedFlag | Value that identifies whether the transaction has been created in the WIP layer table. Possible values are: N indicates layer not created, Y indicates Layer created, X indicates excluded from layer creation. |
CstTransactionsPEOWoUpdateEventTxnId | Value that uniquely identifies the work order close transaction. This reference is used to identify if a product transaction was available in the application during work order close. If this reference is missing and the work order is closed, a reclose of the work order is performed. This is the primary key of the Costing Work Order Update Event Transactions view object. |
CstTransactionsPEOWorkCenterId | Value that uniquely identifies the work center where the operation is executed. |
CstTransactionsPEOWshDeliveryDetailId | Value that uniquely identifies the Shipping delivery detail. |