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