Costing Transaction Layers

The Costing Transaction Layers view object track quantities for all flows in costing.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstTransactionLayersExtractPVO

Primary Keys : CstTransactionLayersPEORecTrxnId, CstTransactionLayersPEODepTrxnId, CstTransactionLayersPEOTransactionId

Initial Extract Date : CstTransactionLayersPEOCreationDate

Incremental Extract Date : CstTransactionLayersPEOLastUpdateDate

Attributes

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

Name	Description
CstTransactionLayersPEOCostBookId	The unique identifier of the cost book associated with the cost organization.
CstTransactionLayersPEOCostDate	Date used to sequence the transaction for processing.
CstTransactionLayersPEOCostOrgId	The unique identifier of the cost organization associated with the inventory organization.
CstTransactionLayersPEOCostTransactionType	Cost transaction type. Possible values are: ISSUE, RECEIPT and ADJUST.
CstTransactionLayersPEOCreatedBy	User who created the costing transaction layer row.
CstTransactionLayersPEOCreationDate	Date when the costing transaction layer row was created.
CstTransactionLayersPEODepTrxnId	Unique identifier of the deplete transaction. This attribute is a part of the composite key of the costing transaction layers view object.
CstTransactionLayersPEOInventoryItemId	Unique identifier of the inventory item.
CstTransactionLayersPEOLastUpdateDate	Date when the costing transaction layer row was last updated.
CstTransactionLayersPEOLastUpdateLogin	Session login associated with the user who last updated the costing transaction layer row.
CstTransactionLayersPEOLastUpdatedBy	User who last updated the costing transaction layer row.
CstTransactionLayersPEOPeriodName	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.
CstTransactionLayersPEOPostedFlag	Processing status of the costing transaction layer.
CstTransactionLayersPEOQuantity	Quantity associated with costing transaction layer.
CstTransactionLayersPEOQuantityOnhand	Running on hand balance of the item in a valuation unit within a cost org book.
CstTransactionLayersPEORecOnhand	Nondepleted on hand for a receipt layer. This attribute will have no value for a depletion layer.
CstTransactionLayersPEORecOnhandAvailFlag	Indicates if the receipt has on hand available so that it can be used for depletion. Possible value are: N or Y. N indicates on hand unavailable. Y indicates on hand available.
CstTransactionLayersPEORecTrxnId	Unique identifier of the receipt transaction. This attribute is a part of the composite key of the costing transaction layers view object.
CstTransactionLayersPEOTransactionId	Unique identifier of the costing transaction for which the transaction layer is created. This attribute is a part of the composite key of the costing transaction layers view object.
CstTransactionLayersPEOUomCode	The unit of measure code of the transaction quantity.
CstTransactionLayersPEOValOnhandFlag	Indicates if the on hand calculations have been done for the costing transaction layer. Possible values are: N or NULL. N indicates not processed. NULL indicates processed for on hand calculations.
CstTransactionLayersPEOValUnitId	Unique identifier of the valuation unit. This is the primary key of the valuation units view object.