In Transit Valuation Details

The In Transit Valuation Details 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.CstIntrOnhandDetailsExtractPVO

Primary Keys : CstIntrOnhandDetailsPEOValDetailId

Initial Extract Date : CstIntrOnhandDetailsPEOCreationDate

Incremental Extract Date : CstIntrOnhandDetailsPEOLastUpdateDate

Attributes

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

Name	Description
CstIntrOnhandDetailsPEOAccountedFlag	Value that indicates that the in transit valuation is accounted.
CstIntrOnhandDetailsPEOAcctdCmrRcvQuantity	Value that identifies the accounted received quantity in receipt accounting for the flow, where transfer receipts aren't processed in the accounting cost.
CstIntrOnhandDetailsPEOAcctdOnhandValue	Value that identifies the in transit on hand value that's accounted.
CstIntrOnhandDetailsPEOAcctdQuantityOnhand	Value that identifies the accounted quantity on hand for the period.
CstIntrOnhandDetailsPEOBusinessUnitId	Value that identifies the business unit associated with the in transit node.
CstIntrOnhandDetailsPEOCmrRcvProcessedFlag	Value that indicates if 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.
CstIntrOnhandDetailsPEOCmrRcvQuantity	Value that identifies the received quantity in receipt accounting for the flow where transfer receipts aren't processed in cost accounting.
CstIntrOnhandDetailsPEOConsignedFlag	Value that indicates that the in transit on hand quantity is for consigned transactions.
CstIntrOnhandDetailsPEOCostBookId	Value that identifies the cost book assigned to the cost organization.
CstIntrOnhandDetailsPEOCostElementId	Value that identifies the cost element corresponding to the on hand valuation.
CstIntrOnhandDetailsPEOCostOrgId	Value that identifies the cost organization associated with the inventory organization.
CstIntrOnhandDetailsPEOCreatedBy	User who created the row.
CstIntrOnhandDetailsPEOCreationDate	Date and time the row was created.
CstIntrOnhandDetailsPEOCurrencyCode	Value that identifies the currency of the transaction.
CstIntrOnhandDetailsPEOEndDate	Value that identifies the date effectivity. The information in the row is valid up to this date.
CstIntrOnhandDetailsPEOExpenseTransactionFlag	Indicates if the in transit on hand is for expense transactions.
CstIntrOnhandDetailsPEOInventoryItemId	Value that identifies the inventory item for which the on hand quantity is maintained.
CstIntrOnhandDetailsPEOInventoryOrgId	Value that identifies the inventory organization for the in transit node.
CstIntrOnhandDetailsPEOItemOrganizationId	Value that identifies the master organization used for item validation. Items may or may not be defined for in transit organizations.
CstIntrOnhandDetailsPEOLastUpdateDate	Date and time the row was last updated.
CstIntrOnhandDetailsPEOLastUpdateLogin	Session login associated with the user who last updated the row.
CstIntrOnhandDetailsPEOLastUpdatedBy	User who last updated the row.
CstIntrOnhandDetailsPEOOnhandValue	Value that identifies the in transit on hand valuation for a given item, organization, and cost element.
CstIntrOnhandDetailsPEOPeriodName	Value that identifies the period in which the valuation exists.
CstIntrOnhandDetailsPEOPriorValDetailId	Value that identifies the prior period valuation detail row.
CstIntrOnhandDetailsPEOQuantityOnhand	Value that identifies the owned in transit quantity for the period.
CstIntrOnhandDetailsPEOShipFromInvOrgId	Value that identifies the ship from inventory organization for the transfer flow.
CstIntrOnhandDetailsPEOShipToInvOrgId	Value that identifies the ship to inventory organization for the transfer flow.
CstIntrOnhandDetailsPEOStartDate	Value that identifies the date of the snapshot of the on hand Inventory and cost taken for reporting in OTBI analysis.
CstIntrOnhandDetailsPEOTransactionFlowType	Value that identifies the in transit flow type.
CstIntrOnhandDetailsPEOTransferTxnId	Value that identifies the shipment transaction identifier for the transfer flow.
CstIntrOnhandDetailsPEOTxnSourceDocNumber	Value that identifies the document number of the in transit valuation.
CstIntrOnhandDetailsPEOTxnSourceDocType	Value that identifies the document type of the in transit valuation.
CstIntrOnhandDetailsPEOTxnSourceRefDocNumber	Value that identifies the reference document of the in transit valuation.
CstIntrOnhandDetailsPEOTxnSourceRefDocType	Value that identifies the reference document type of the in transit valuation.
CstIntrOnhandDetailsPEOUomCode	Value that identifies the unit of measure of the quantities.
CstIntrOnhandDetailsPEOValDetailId	Value that identifies the surrogate key that identifies a row in this table.
CstIntrOnhandDetailsPEOValuationId	Value that identifies the in transit on hand valuation row.