Receiving Transactions
The Receiving Transactions view object contains the receiving transactions that came through the receiving interface CMR_I_RCV_TRANSACTIONS and successfully passed interface validations.
Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvTransactionsExtractPVO
Primary Keys : CmrRcvTransactionsPEOCmrRcvTransactionId
Initial Extract Date : CmrRcvTransactionsPEOCreationDate
Incremental Extract Date : CmrRcvTransactionsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CmrRcvTransactionsPEOAllocatedFlag | Value that identifies the allocation status of the receipt. Valid values are Y and N. |
| CmrRcvTransactionsPEOAsnType | Value that identifies the ASN type of the shipment. Valid values are ASN and ASBN for ASN or ASBN creation and STD for a receipt. |
| CmrRcvTransactionsPEOAssessableValue | Value that identifies the assessable value that's the deemed price at which a product is valued, by the tax authority for a given tax, for tax calculation purposes. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOAttribute1 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute10 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute11 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute12 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute13 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute14 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute15 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute2 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute3 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute4 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute5 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute6 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute7 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute8 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttribute9 | Segment for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOAttributeCategory | Context Name for Receiving Transactions descriptive flexfield. |
| CmrRcvTransactionsPEOBillToBusinessUnitId | Value that identifies the bill-to business unit. |
| CmrRcvTransactionsPEOCmrPoDistributionId | Value that identifies the entity in receipt accounting PO distributions. This value will exist for match to PO, as well as match to receipt cases. |
| CmrRcvTransactionsPEOCmrPoLineLocationId | Value that identifies the purchase order line location in receipt accounting. |
| CmrRcvTransactionsPEOCmrRcvTransactionId | Value that uniquely identifies the internal receiving transaction. |
| CmrRcvTransactionsPEOCmrRootDeliverTxnId | Value that identifies the internal root or the first deliver transaction. |
| CmrRcvTransactionsPEOCmrRootReceiveTxnId | Value that identifies the internal root or the first receiving transaction. |
| CmrRcvTransactionsPEOConsignedFlag | Value that indicates if this's a consigned transaction. |
| CmrRcvTransactionsPEOCountryOfOriginCode | Value that identifies the code for the country of manufacture. |
| CmrRcvTransactionsPEOCreatedBy | User who created the row. |
| CmrRcvTransactionsPEOCreationDate | Date and time the row was created. |
| CmrRcvTransactionsPEOCurrencyConversionDate | Date to be used to determine the exchange rates for the currency conversion. |
| CmrRcvTransactionsPEOCurrencyConversionRate | Value that identifies the user specified currency conversion rate. |
| CmrRcvTransactionsPEODefaultTaxationCountry | Value that identifies the default taxation country code. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEODestinationTypeCode | Value that identifies the destination type for the material. Valid values include Receiving, Inventory and Expense. |
| CmrRcvTransactionsPEODocumentFiscalClassification | Value that identifies the document fiscal classification code. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOErrorCode | Value that identifies the transaction error code. |
| CmrRcvTransactionsPEOExternalSystemRefId | Value that uniquely identifies the receiving transaction in the source system. |
| CmrRcvTransactionsPEOExternalSystemReference | Value that identifies the external source system. |
| CmrRcvTransactionsPEOFinalDischargeLocationId | Value that identifies the final discharge location. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOFirstPtyRegId | Value that identifies the first-party tax registration ID used for the transaction. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOFiscalDocAccessKnum | Value that identifies the fiscal document access key number. |
| CmrRcvTransactionsPEOFiscalDocHeaderId | Value that uniquely identifies the fiscal document header. |
| CmrRcvTransactionsPEOFiscalDocLineId | Value that uniquely identifies the fiscal document line. |
| CmrRcvTransactionsPEOFiscalDocScheduleId | Value that identifies the fiscal document schedule ID, as captured in the fiscal document. |
| CmrRcvTransactionsPEOFtrId | Value that identifies the financial trade relationship. |
| CmrRcvTransactionsPEOIntendedUse | Value that identifies the intended use code of the receiving transaction. This identifies the purpose for which the product is used. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOIntendedUseClassifId | Value that identifies the intended use classification identifier. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOInterfaceBatchName | Value that identifies the batch name of the external systems interface run. |
| CmrRcvTransactionsPEOInterfaceBatchNumber | Value that identifies the batch number of the external systems interface run. This parameter is added to facilitate the source system to identify which transactions were sent in which run on the source system. |
| CmrRcvTransactionsPEOInvShippingTransactionId | Value that identifies the header for an intercompany transaction flow. |
| CmrRcvTransactionsPEOInventoryItemId | Value that identifies the inventory item and references EGP_SYSTEM_ITEMS_B.inventory_item_id. |
| CmrRcvTransactionsPEOLastUpdateDate | Date and time the row was most recently updated. |
| CmrRcvTransactionsPEOLastUpdateLogin | Session login associated with the user who last updated the row. |
| CmrRcvTransactionsPEOLastUpdatedBy | User who last updated the row. |
| CmrRcvTransactionsPEOOrigTfOrdInvShipTxnId | Value that identifies the reference to the inventory transaction of the original transfer order shipment for a given return transfer order. |
| CmrRcvTransactionsPEOParentTransactionId | Value that uniquely identifies the parent receiving transaction. |
| CmrRcvTransactionsPEOPhysicalReturnReqdFlag | Value that indicates if the physical return of materials is required for returns against a transfer order. |
| CmrRcvTransactionsPEOPjcBillableFlag | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcCapitalizableFlag | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcContextCategory | Context name for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcContractId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcContractLineId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcExpenditureItemDate | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcExpenditureTypeId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcFundingAllocationId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcInterfacedStatus | Value that identifies the status of the transaction, with respect to the projects integration. |
| CmrRcvTransactionsPEOPjcOrganizationId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcProjectId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute1 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute10 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute2 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute3 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute4 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute5 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute6 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute7 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute8 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcReservedAttribute9 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcTaskId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute1 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute10 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute2 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute3 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute4 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute5 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute6 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute7 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute8 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcUserDefAttribute9 | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPjcWorkTypeId | Segment for the Standardized Project Cost Collection Widget descriptive flexfield. |
| CmrRcvTransactionsPEOPoDistributionId | Value that uniquely identifies the purchase order distribution. |
| CmrRcvTransactionsPEOPoLineLocationId | Value that identifies the purchase order shipment schedule. |
| CmrRcvTransactionsPEOPreprocessedStatus | Value that identifies the processing status of the transactions. |
| CmrRcvTransactionsPEOPrimaryQuantity | Value that identifies the transaction quantity in the item's primary unit of measure. |
| CmrRcvTransactionsPEOPrimaryUomCode | Value that identifies the unit of measure code in which the primary transaction quantity is specified. |
| CmrRcvTransactionsPEOPriorTradeInvOrgId | Value that identifies the prior trade inventory organization in the trade relationship. This value will be the same as the ship_from_inv_org_id value for interorganization flows. |
| CmrRcvTransactionsPEOProcessByCaFlag | Value that indicates the cost accounting preprocess status for eligible transactions. |
| CmrRcvTransactionsPEOProductCategory | Value that identifies the product category code of the transaction line. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOProductFiscClassId | Value that identifies the product fiscal classification ID for the inventory item. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOProductType | Value that identifies the product type code of the inventory item. Possible values are GOODS and SERVICES. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEORcvParentTransactionId | Value that identifies the parent transaction identifier sent from receiving. |
| CmrRcvTransactionsPEORcvPoDistributionId | Value that uniquely identifies the purchase order distribution identifier taken from receiving. |
| CmrRcvTransactionsPEOReceiptCreationDate | Value that identifies the receipt creation date. |
| CmrRcvTransactionsPEOReceiptLineNumber | Value that identifies the number corresponding to the shipment line. |
| CmrRcvTransactionsPEOReceiptNumber | Value that identifies the receipt number for the receiving shipment receipt header row and references to RCV_SHIPMENT_headers{RECEIPT_NUM}. |
| CmrRcvTransactionsPEOReceiptSourceCode | Value that identifies the source type of the shipment or the receipt. Valid values are VENDOR, INVENTORY, TRANSFER ORDER, CUSTOMER, and OUTSOURCER. |
| CmrRcvTransactionsPEORefFiscalDocAccessKnum | Value that identifies the reference fiscal document access key number as captured in the fiscal document. |
| CmrRcvTransactionsPEORefFiscalDocHeaderId | Value that identifies the reference fiscal document header ID as captured in the fiscal document. |
| CmrRcvTransactionsPEORefFiscalDocLineId | Value that identifies the reference fiscal document line ID as captured in the fiscal document. |
| CmrRcvTransactionsPEORefFiscalDocScheduleId | Value that uniquely identifies the reference fiscal document schedule. |
| CmrRcvTransactionsPEORootDeliverTxnDate | Value that identifies the transaction date on the associated root of the first delivery transaction. |
| CmrRcvTransactionsPEORootDeliverTxnId | Value that identifies the root or first deliver transaction. |
| CmrRcvTransactionsPEORootReceiveTxnId | Value that identifies the root or first receiving transaction. |
| CmrRcvTransactionsPEOSecondaryTransactionQty | Value that identifies the transaction quantity in terms of the item's secondary unit of measure. |
| CmrRcvTransactionsPEOSecondaryUomCode | Value that identifies the unit of measure code in which the secondary transaction quantity is specified. |
| CmrRcvTransactionsPEOShipFromInvOrgId | Value that identifies the inventory shipping organization. |
| CmrRcvTransactionsPEOShipFromLocationId | Value that identifies the ship from location. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOShipToOrganizationId | Value that uniquely identifies the destination organization. |
| CmrRcvTransactionsPEOShipmentHeaderId | Value that uniquely identifies the receiving shipment header. |
| CmrRcvTransactionsPEOShipmentLineId | Value that uniquely identifies the receiving shipment line. |
| CmrRcvTransactionsPEOShipmentLineNumber | Value that identifies the receipt transaction's shipment document line number. |
| CmrRcvTransactionsPEOShipmentNum | Value that identifies the shipment number assigned by the shipment's source. This value corresponds to the ASN number, in-transit shipment number, and transfer order shipment number. |
| CmrRcvTransactionsPEOShipmentNumber | Value that identifies the shipment number assigned by the shipment's source. |
| CmrRcvTransactionsPEOSourceDocQuantity | Value that identifies the transaction quantity in the source document's unit of measure. |
| CmrRcvTransactionsPEOSourceDocUomCode | Value that identifies the source document unit of measure. |
| CmrRcvTransactionsPEOSourceDocumentCode | Value that identifies the source document code for the receiving transactions. This value maps to FND_LOOKUP_VALUES_B.LOOKUP_CODE where lookup_type is RCV_SOURCE_DOCUMENT_TYPE. |
| CmrRcvTransactionsPEOTaxClassificationCode | Value that identifies the tax classification code. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOTaxInvoiceDate | Value that identifies the date of the fiscal document. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOTaxInvoiceNumber | Value that identifies the number of the fiscal document. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOTaxProcessedFlag | Value that indicates if tax calculation has been processed for the receipt. |
| CmrRcvTransactionsPEOThirdPtyRegId | Value that identifies the third-party tax registration ID for the transaction. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOTransactionAmount | Value that identifies the amount received for services for service-based purchase orders. |
| CmrRcvTransactionsPEOTransactionDate | Date when this transaction occurred. |
| CmrRcvTransactionsPEOTransactionQuantity | Value that identifies the transaction quantity of the receipt transaction. |
| CmrRcvTransactionsPEOTransactionType | Value that identifies the receiving event types associated with the transaction. |
| CmrRcvTransactionsPEOTransactionUomCode | Value that identifies the transaction unit of measure of the receipt transactions. |
| CmrRcvTransactionsPEOTransferOrderDistId | Value that uniquely identifies the transfer order distribution. |
| CmrRcvTransactionsPEOTransferOrderHeaderId | Value that uniquely identifies the transfer order header. |
| CmrRcvTransactionsPEOTransferOrderLineId | Value that uniquely identifies the transfer order line. |
| CmrRcvTransactionsPEOTransferPriceQty | Value that identifies the transfer price quantity. |
| CmrRcvTransactionsPEOTransferPriceUomCode | Value that identifies the unit of measure code in which transfer price quantity is specified. |
| CmrRcvTransactionsPEOTrxBusinessCategory | Value that identifies the transaction business category code. This attribute is also used as a tax determinant. |
| CmrRcvTransactionsPEOTxnGroupId | Value that identifies the transaction group of receipt transactions. |
| CmrRcvTransactionsPEOUserDefinedFiscClass | Value that identifies the user-defined fiscal classification code. This attribute is also used as a tax determinant. |