Receipt Accounting Purchase In-transit Amounts

The Receipt Accounting Purchase In-transit Amounts view object contains the information related to shipment and receipt for an ASN at purchase order schedule level.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrPurchaseIntransitAmtsExtractPVO

Primary Keys : CmrAsnIntransitAmtsPEOAsnIntransitId

Initial Extract Date : CmrAsnIntransitAmtsPEOCreationDate

Incremental Extract Date : CmrAsnIntransitAmtsPEOLastUpdateDate

Attributes

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

Name	Description
CmrAsnIntransitAmtsPEOAsnIntransitId	Surrogate key identifying the ASN in-transit amount record. Value is populated from CMR_PROCESS_RUN_DTLS_S sequence.
CmrAsnIntransitAmtsPEOAsnLineNumber	Value that indicates the receiving shipment line number.
CmrAsnIntransitAmtsPEOAsnStatus	Value that indicates the shipment line status code. Possible values are EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, CANCELLED.
CmrAsnIntransitAmtsPEOAsnUomCode	Value that indicates the unit of measure code for the receiving shipment receipt line.
CmrAsnIntransitAmtsPEOBillToBusinessUnitId	Value that indicates the Bill to Business unit used for creating in-transit data.
CmrAsnIntransitAmtsPEOBusinessUnitId	Value that indicates the Business unit where in-transit inventory value is recorded.
CmrAsnIntransitAmtsPEOCreatedBy	User who created the row.
CmrAsnIntransitAmtsPEOCreationDate	Date and time of the creation of the row.
CmrAsnIntransitAmtsPEOCurrencyCode	Value that indicates the currency code of the PO price.
CmrAsnIntransitAmtsPEOCurrencyConversionDate	Date used to determine the exchange rates for currency conversion.
CmrAsnIntransitAmtsPEOCurrencyConversionRate	Value that indicates the currency conversion rate derived from the PO.
CmrAsnIntransitAmtsPEOCurrencyConversionType	Value that indicates the conversion type derived from PO header for currency conversion.
CmrAsnIntransitAmtsPEODestinationTypeCode	Value that indicates the type of destination for the material. Possible values include Inventory and Expense.
CmrAsnIntransitAmtsPEOFobLookupCode	Value that indicates the type of free-on-board terms for the document. References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE as FOB.
CmrAsnIntransitAmtsPEOFuncCurrencyCode	Value that identifies the functional currency code of the ledger.
CmrAsnIntransitAmtsPEOIntransitAmount	Value that indicates the in-transit amount for the ASN line at the PO schedule level. In-transit amount is the product of in-transit quantity and PO Price including any nonrecoverable tax.
CmrAsnIntransitAmtsPEOIntransitAmtFuncCurr	Value that indicates the in-transit amount for the ASN line at the PO schedule level in functional currency. In-transit amount is the product of in-transit quantity, PO Price including any nonrecoverable tax and currency conversion rate.
CmrAsnIntransitAmtsPEOIntransitQuantity	Value that indicates the in-transit quantity in source document UOM for a specific ASN line at the PO schedule level. In-transit quantity is the difference between shipped quantity and received quantity.
CmrAsnIntransitAmtsPEOInventoryItemId	Value that identifies the inventory item and references EGP_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID.
CmrAsnIntransitAmtsPEOInventoryOrgId	Value that indicates the inventory organization where the in-transit value is recorded.
CmrAsnIntransitAmtsPEOLastUpdateDate	Date and time of the row was last updated.
CmrAsnIntransitAmtsPEOLastUpdateLogin	Indicates the session login associated to the user who last updated the row.
CmrAsnIntransitAmtsPEOLastUpdatedBy	User who last updated the row.
CmrAsnIntransitAmtsPEOLatestReceiptDate	Indicates the latest receipt date for the PO schedule and ASN line.
CmrAsnIntransitAmtsPEOLeTimezoneCode	Time zone code of the legal entity.
CmrAsnIntransitAmtsPEOLineNumber	User specified number for the purchase order line.
CmrAsnIntransitAmtsPEONewNrTax	Value that indicates the updated nonrecoverable tax per unit amount in the source document UOM.
CmrAsnIntransitAmtsPEONewPoPrice	Value that indicates the changed purchase price per unit specified by the buyer on the purchase order in the source document UOM.
CmrAsnIntransitAmtsPEONrTax	Value that indicates the nonrecoverable tax per unit amount in the source document UOM.
CmrAsnIntransitAmtsPEOOwnershipChange	Indicates Ownership change for the FOB code.
CmrAsnIntransitAmtsPEOPeriodEndDate	Indicates the end date of the accounting period.
CmrAsnIntransitAmtsPEOPeriodName	Value that indicates the accounting period for which the in-transit is computed and recorded.
CmrAsnIntransitAmtsPEOPeriodStartDate	Indicates the start date of the accounting period.
CmrAsnIntransitAmtsPEOPoItemDescription	Value that indicates the item description specified on the purchase order line. Especially needed for purchase orders involving noninventory items.
CmrAsnIntransitAmtsPEOPoLineLocationId	Value that identifies the purchase order shipment schedule.
CmrAsnIntransitAmtsPEOPoNumber	User specified number for the purchase order.
CmrAsnIntransitAmtsPEOPoPrice	Purchase price per unit specified by the buyer on the purchase order in the source document UOM.
CmrAsnIntransitAmtsPEOPoScheduleNumber	Value that indicates the user-specified number for the purchase order shipment.
CmrAsnIntransitAmtsPEOPostedFlag	Value that indicates whether the transaction is processed.
CmrAsnIntransitAmtsPEOPriorIntransitQuantity	Value that indicates the prior in-transit quantity in source document UOM for a specific ASN line at the PO schedule level. Prior in-transit quantity is the difference between shipped quantity and received quantity.
CmrAsnIntransitAmtsPEOReceiptNumber	Value that indicates the receipt number for the receiving shipment header row and references RCV_SHIPMENT_headers{RECEIPT_NUM}.
CmrAsnIntransitAmtsPEOReceivedQuantity	Value that indicates the quantity received in source document UOM for the ASN line at the PO schedule level.
CmrAsnIntransitAmtsPEORetroPriceFlag	Identifies the retro price change event.
CmrAsnIntransitAmtsPEOReturnQuantity	Identifies the return quantity.
CmrAsnIntransitAmtsPEOReversalQuantity	Value that indicates the reversal in-transit quantity in source document UOM for the ASN line at the PO schedule level. Reversal quantity is calculated as the sum of all new receipt quantity recorded for the ASN line after the in-transit was booked.
CmrAsnIntransitAmtsPEORunDate	Indicates the date on which the record in-transit inventory for external purchases process is run.
CmrAsnIntransitAmtsPEORunMode	Indicates the run mode of the process which created the record. Possible values are Report and Accounting.
CmrAsnIntransitAmtsPEOScheduleStatus	Value that indicates the schedule status.
CmrAsnIntransitAmtsPEOShipToLocationId	Value that identifies the specific location where the goods are being shipped.
CmrAsnIntransitAmtsPEOShipmentDate	Indicates the date on which the shipment was created.
CmrAsnIntransitAmtsPEOShipmentHeaderId	Value that indicates the receiving shipment header unique identifier.
CmrAsnIntransitAmtsPEOShipmentLineId	Value that indicates the receiving shipment line unique identifier.
CmrAsnIntransitAmtsPEOShipmentNumber	Shipment number assigned by the shipment's source. Corresponds to the ASN number, in-transit shipment number, and transfer order shipment number.
CmrAsnIntransitAmtsPEOShipmentQuantity	Value that indicates the quantity shipped in source document UOM for the ASN line at the PO schedule level.
CmrAsnIntransitAmtsPEOSourceDocUomCode	Value that indicates the source document's unit of measure code.
CmrAsnIntransitAmtsPEOTransactionDate	Value that identifies the date of the in-transit transaction.
CmrAsnIntransitAmtsPEOTransactionType	Value that identifies the receiving transaction type.
CmrAsnIntransitAmtsPEOUomConversionFactor	Value that indicates the conversion factor from the shipment transaction UOM to the PO source document UOM.
CmrAsnIntransitAmtsPEOVendorId	Value that identifies the supplier and references PO_VENDORS.VENDOR_ID.
CmrAsnIntransitAmtsPEOVendorSiteId	Value that identifies the supplier site and references PO_VENDOR_SITES_ALL.VENDOR_SITE_ID.