Write-off Costs

The Write-off Costs view object contains information about the inventory write off costs.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstWriteoffCostsExtractPVO

Primary Keys : CstWriteoffCostsPEOWriteoffCostId

Initial Extract Date : CstWriteoffCostsPEOCreationDate

Incremental Extract Date : CstWriteoffCostsPEOLastUpdateDate

Attributes

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

Name Description
CstWriteoffCostsPEOAbsorptionType Indicates the type of absorption. Possible values are defined in the lookup type CST_ABSORPTION_TYPE.
CstWriteoffCostsPEOAdditionalProcessingCode Indicates the optional further definition of the cost transaction type.
CstWriteoffCostsPEOAdjPostedFlag Indicates the status of adjustment propagation. Possible values are X, N, and Y.
CstWriteoffCostsPEOBaseTxnTypeId Unique identifier of the inventory transaction type.
CstWriteoffCostsPEOCostBookId Unique identifier of cost book assigned to cost organization.
CstWriteoffCostsPEOCostDate Date on which the transaction is costed in costing system.
CstWriteoffCostsPEOCostElementId Unique identifier of the cost element corresponding to cost of the transaction.
CstWriteoffCostsPEOCostOrgId Unique identifier of the cost organization associated with the inventory organization.
CstWriteoffCostsPEOCostReference Identifies the cost reference.
CstWriteoffCostsPEOCostSource Identifies the cost source.
CstWriteoffCostsPEOCostTransactionType Identifies the type of costing transaction. It's used by the costing engine to categorize group processing.
CstWriteoffCostsPEOCreatedBy User who created the write off cost row.
CstWriteoffCostsPEOCreationDate Date and time when the write off cost row was created.
CstWriteoffCostsPEOCurrencyCode Identifies the currency of the transaction.
CstWriteoffCostsPEODepTrxnId Unique identifier of depletion transaction
CstWriteoffCostsPEODistributionId Unique identifier of the cost distribution header record. This is the primary key of the Cost Distributions view object.
CstWriteoffCostsPEODistributionType Indicates the cost distribution type.
CstWriteoffCostsPEOEffDate Date from which cost is effective.
CstWriteoffCostsPEOExpensePoolId Unique identifier of the expense pool. This is the primary key of the Overhead Expense Pools view object.
CstWriteoffCostsPEOInventoryItemId Unique identifier of the inventory item.
CstWriteoffCostsPEOLastUpdateDate Date when the write off cost row was last updated.
CstWriteoffCostsPEOLastUpdateLogin Session login associated with the user who last updated the write off cost row.
CstWriteoffCostsPEOLastUpdatedBy User who last updated the write off cost row.
CstWriteoffCostsPEOOnhandQuantity Identifies the on hand quantity of the inventory at the time this layer was costed.
CstWriteoffCostsPEOOnhandValue Identifies the on hand value for the inventory at the time this layer was costed. The value is stored at the item-cost element level.
CstWriteoffCostsPEOOnhandValueStatusFlag Indicates on hand value status. Possible values are: U, P, X, and L.
CstWriteoffCostsPEOPeriodName 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.
CstWriteoffCostsPEOPostedFlag Indicates whether write off cost is posted or not.
CstWriteoffCostsPEOQuantity Identifies the current on-hand quantity.
CstWriteoffCostsPEORecTrxnId Unique identifier of the receipt transaction.
CstWriteoffCostsPEOTransactionCostId Unique identifier of the transaction cost. It's the primary key of Transaction Costs view object.
CstWriteoffCostsPEOTransactionId Unique identifier of the costing transaction. This is the primary key of the Costing Transactions view object.
CstWriteoffCostsPEOUnitCost Identifies the current transaction cost.
CstWriteoffCostsPEOUomCode Identifies the unit of measure.
CstWriteoffCostsPEOValOnhandFlag Indicates whether the on hand calculations have been done for this layer. Possible values are N and NULL.
CstWriteoffCostsPEOValUnitId Unique identifier of the valuation unit ID. This is part of primary key of Valuation Unit Combinations view object.
CstWriteoffCostsPEOWoCostPostedFlag Indicates whether costs related to WIP have been transferred to CST_WORK_ORDER_COSTS. Possible values are: N, Y, and X.
CstWriteoffCostsPEOWriteoffCostId Unique identifier of the write off cost transaction.