In Transit on Hand Valuations

The In Transit on Hand Valuations view object contains in transit inventory valuation with quantities at the inventory organization level and the costs as total cost.

Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstIntrOnhandValuationsExtractPVO

Primary Keys : CstIntrOnhandValuationsPEOValuationId

Initial Extract Date : CstIntrOnhandValuationsPEOCreationDate

Incremental Extract Date : CstIntrOnhandValuationsPEOLastUpdateDate

Attributes

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

Name	Description
CstIntrOnhandValuationsPEOAccountedFlag	Value that indicates that the valuation row is accounted.
CstIntrOnhandValuationsPEOAcctdCmrRcvQuantity	Value that identifies the accounted received quantity in receipt accounting for the flow where transfer receipts aren't processed in the cost accounting.
CstIntrOnhandValuationsPEOAcctdOnhandValue	Value that identifies the in transit on hand valuation that's accounted.
CstIntrOnhandValuationsPEOAcctdQuantityOnhand	Value that identifies the accounted quantity on hand for the period.
CstIntrOnhandValuationsPEOBusinessUnitId	Value that identifies the business unit associated to the in transit node.
CstIntrOnhandValuationsPEOCmrRcvProcessedFlag	Value that indicates that the expense receipt from receipt accounting has been processed for the in transit flow. Valued values are N or Null. If N, then it isn't processed. If NULL, then it has been processed or isn't applicable.
CstIntrOnhandValuationsPEOCmrRcvQuantity	Value that identifies the received quantity in receipt accounting for the flow where transfer receipts aren't processed in the cost accounting.
CstIntrOnhandValuationsPEOConsignedFlag	Value that indicates that the in transit on hand quantity is for consigned transactions.
CstIntrOnhandValuationsPEOCostBookId	Value that identifies the cost book assigned to the cost organization.
CstIntrOnhandValuationsPEOCostOrgId	Value that identifies the cost organization associated with the inventory organization.
CstIntrOnhandValuationsPEOCreatedBy	User who created the row.
CstIntrOnhandValuationsPEOCreationDate	Date and time that the row was created.
CstIntrOnhandValuationsPEOCurrencyCode	Value that identifies the currency of the transaction.
CstIntrOnhandValuationsPEOEndDate	Value that identifies the identifies the date effectivity. The information in the row is valid up to this date.
CstIntrOnhandValuationsPEOExpenseTransactionFlag	Value that indicates that the in transit on hand quantity is for expense transactions.
CstIntrOnhandValuationsPEOInventoryItemId	Value that identifies the inventory item for which the on hand quantity is maintained.
CstIntrOnhandValuationsPEOInventoryOrgId	Value that identifies the inventory organization for the in transit node.
CstIntrOnhandValuationsPEOItemOrganizationId	Value that identifies the master organization used for item lookup and validation. The item may or may not be defined for in transit organizations.
CstIntrOnhandValuationsPEOLastUpdateDate	Date and time the row was last updated.
CstIntrOnhandValuationsPEOLastUpdateLogin	Session login associated to the user who last updated the row.
CstIntrOnhandValuationsPEOLastUpdatedBy	User who last updated the row.
CstIntrOnhandValuationsPEOOnhandValue	Value that identifies the in transit on hand valuation for a given item, organization, and cost element.
CstIntrOnhandValuationsPEOPeriodName	Value that identifies the period in which the valuation exists.
CstIntrOnhandValuationsPEOPriorValuationId	Value that identifies the prior period valuation row in this table.
CstIntrOnhandValuationsPEOQuantityOnhand	Value that identifies the owned in transit quantity for the period.
CstIntrOnhandValuationsPEOShipFromInvOrgId	Value that identifies the ship from inventory organization for the transfer flow.
CstIntrOnhandValuationsPEOShipToInvOrgId	Value that identifies the ship to inventory organization for the transfer flow.
CstIntrOnhandValuationsPEOStartDate	Value that identifies the date of the snapshot of on hand inventory and cost taken for reporting in OTBI analysis.
CstIntrOnhandValuationsPEOTransactionFlowType	Value that identifies the identifies the in transit flow type.
CstIntrOnhandValuationsPEOTransferTxnId	Value that identifies the shipment transaction identifier for the transfer flow.
CstIntrOnhandValuationsPEOTxnSourceDocNumber	Value that identifies the document number of the in transit valuation.
CstIntrOnhandValuationsPEOTxnSourceDocType	Value that identifies the document type of the in transit valuation.
CstIntrOnhandValuationsPEOTxnSourceRefDocNumber	Value that identifies the reference document of the in transit valuation.
CstIntrOnhandValuationsPEOTxnSourceRefDocType	Value that identifies the reference document type of the in transit valuation.
CstIntrOnhandValuationsPEOUomCode	Value that identifies the unit of measure of the quantities.
CstIntrOnhandValuationsPEOValuationId	Value that identifies the surrogate key that identifies a row in this table.