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