Transaction Costs

The Transactions Costs view object stores the actual cost of receipts and issues for the transactions available in costing transactions view object. It holds the entire history of what the actual cost was after every adjustment, and the cost is stored in its entirety on each adjustment instead of being stored in incremental costs. Receipt costs can come in externally from the incoming acquisition costs flow or internally from the costing engine, transfers at cost and transactions that use current item cost. Issue costs can come from RTV transactions, miscellaneous issue transactions, transfer credits and freight charges, and negative PO quantity adjustments.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstTransactionCostsExtractPVO

Primary Keys : CstTransactionCostsPEOTransactionCostId

Initial Extract Date : CstTransactionCostsPEOCreationDate

Incremental Extract Date : CstTransactionCostsPEOLastUpdateDate

Attributes

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

Name	Description
CstTransactionCostsPEOAbsorptionType	Absorption type for which the transaction cost row is created.
CstTransactionCostsPEOAccountingStatus	Accounting status of the transaction. Possible values are: D, E, F, N, X, and Z. D indicates draft accounted. E indicates error. F indicates final accounted. N indicates not accounted. X indicates excluded from accounting. Z indicates not applicable.
CstTransactionCostsPEOAdjustmentDate	Adjustment date provided by the user while creating manual adjustments.
CstTransactionCostsPEOAdjustmentTransactionId	Unique identifier of the cost adjustment.
CstTransactionCostsPEOBaseTxnActionId	Identifier of the inventory transaction action. For origin as INV, the value is from the lookup type INV_TRANSACTION_ACTIONS. For origin as CST, the value is from the lookup type CST_BASE_TXN_ACTIONS.
CstTransactionCostsPEOBaseTxnSourceTypeId	Identifier of the inventory transaction source type. For origin as INV, the value is from the INV_TXN_SOURCE_TYPES_TL table. For origin as CST, the value is from the lookup type CST_BASE_TXN_SOURCE_TYPES.
CstTransactionCostsPEOBaseTxnTypeId	Identifier of the inventory transaction type. For origin as INV, the value is from the INV_TRANSACTION_TYPES_TL table.
CstTransactionCostsPEOCodeCombinationId	Code combination of the account entered by the users while creating costs.
CstTransactionCostsPEOCostDate	Date used to sequence the transaction for processing.
CstTransactionCostsPEOCostElementId	Unique identifier of the cost element. This is the primary key of the cost elements view object.
CstTransactionCostsPEOCostReference	A specific business object or value that further refines the cost source information, such as the source cost organization identifier or an effective date.
CstTransactionCostsPEOCostSource	Source of the cost. A list of accepted values is defined in the lookup type CST_COST_SOURCES.
CstTransactionCostsPEOCostedQty	Quantity that has been processed by costing.
CstTransactionCostsPEOCostingStatus	Costing status of the transaction. Possible values are: C, E, N, P, X, and W. C indicates fully costed. E indicates error. N indicates not processed. P indicates partially costed. X indicates excluded W indicates pending.
CstTransactionCostsPEOCostingUomCode	The unit of measure code of the transaction quantity.
CstTransactionCostsPEOCreatedBy	User who created the transaction cost row.
CstTransactionCostsPEOCreationDate	Date when the transaction cost row was created.
CstTransactionCostsPEOCstInvTransactionId	Unique identifier of the costing inventory transaction. This is the primary key of the costing inventory transactions view object.
CstTransactionCostsPEOCurrencyCode	Code that identifies the currency associated with the transaction cost.
CstTransactionCostsPEOEffDate	Date when the cost became in effect for the transaction. For new costs, the effective date is the date stamped on the transaction. For user adjustments, the effective date is the user entry date. For acquisition cost adjustments, the effective date is the system date at time of cost processing.
CstTransactionCostsPEOExpensePoolId	Identifier of the expense pool for which the transaction cost row is created. Indicates the following when negative value: -1 indicates freight cost, -2 indicates gain or loss on transfer price, -3 indicates transfer price, -4 indicates expensed landed cost management cost element, -5 indicates additional taxes for Brazil, and -22 indicates used by internal logic to ignore cost for this node but transfer it to the next node for costing as gain or loss.
CstTransactionCostsPEOLastUpdateDate	Date when the transaction cost row was last updated.
CstTransactionCostsPEOLastUpdateLogin	Session login associated with the user who last updated the transaction cost row.
CstTransactionCostsPEOLastUpdatedBy	User who last updated the transaction cost row.
CstTransactionCostsPEOOverheadGroupId	Identifier of the transaction overhead group.
CstTransactionCostsPEOOverheadId	Identifier of the transaction overhead.
CstTransactionCostsPEOPeriodName	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.
CstTransactionCostsPEOPerpavgCostId	Identifier of the perpetual average cost created for the transaction cost row.
CstTransactionCostsPEOPostedFlag	Indicates if the receipt has been propagated to CST_PERPAVG_COST or CST_WRITEOFF_COSTS, or if the expense, overhead or transfer credit, has been propagated to CST_LAYER_COSTS. Possible values are: N,Y, and X. N indicates no. Y indicates yes. X indicates not required.
CstTransactionCostsPEOQuantityOnhand	On hand quantity as of the cost date.
CstTransactionCostsPEOTransactionCostId	Unique identifier of the transaction cost row. This is the primary key of the transaction costs view object.
CstTransactionCostsPEOTransactionId	Unique identifier of the costing transaction.
CstTransactionCostsPEOTxnCurrencyCode	Code that identifies the currency associated with the transaction.
CstTransactionCostsPEOTxnCurrencyConversionDate	Date used for currency conversion. For acquisition cost adjustments, this value defaults to the effective date if a specific currency conversion date override isn't provided. An acquisition cost adjustment could be a result of a combination of multiple retro price adjustments and invoices, and each of these could have their own corresponding accounting dates and as such it's not feasible to pick a specific price change or invoice to decide on the currency conversion date. So instead of having a complicated set of rules to pick the currency conversion date, the date of computation of the acquisition cost is used for the currency conversion.
CstTransactionCostsPEOTxnCurrencyConversionRate	Rate that's used for the currency conversion. This value will be null if conversion isn't required.
CstTransactionCostsPEOTxnCurrencyConversionType	Rate type that's used for the currency conversion.
CstTransactionCostsPEOTxnUnitCost	Unit cost of the transaction before currency conversion.
CstTransactionCostsPEOUnitCost	Unit cost of the cost element associated with the transaction.
CstTransactionCostsPEOUserAdjustmentId	Unique identifier of the user adjustment.
CstTransactionCostsPEOValidCostFlag	Indicates if the transaction cost is a valid cost. Example: Acquisition cost after a manual cost adjustment is invalid and should not be used for inventory valuation.