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