Receipt Accounting Transactions

The Receipt Accounting Transactions view object contains receipt transaction information for purchase order receipts and interorganization transfer receipts.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrTransactionsExtractPVO

Primary Keys : CmrTransactionsPEOTransactionId

Initial Extract Date : CmrTransactionsPEOCreationDate

Incremental Extract Date : CmrTransactionsPEOLastUpdateDate

Attributes

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

Name Description
CmrTransactionsPEOAssessableValue Value that identifies the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes.
CmrTransactionsPEOBillToBusinessUnitId Value that identifies the bill to business unit.
CmrTransactionsPEOBudgetaryControlFlag Value that indicates if it's a budget control enabled transaction.
CmrTransactionsPEOCmrPoDistributionId 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. For interorganization flows it will be NULL.
CmrTransactionsPEOCmrPoLineLocationId Value that identifies the receipt accounting PO line location.
CmrTransactionsPEOCmrRcvTransactionId Value that identifies the receiving transaction. For trade event flow, it will be NULL.
CmrTransactionsPEOCmrRootDeliverTxnId Value that identifies the internal root deliver transaction ID.
CmrTransactionsPEOCmrRootReceiveTxnId Value that identifies the internal root or first receiving transaction ID.
CmrTransactionsPEOConsignedFlag Value that indicates if it's a consigned purchase order receipt transaction.
CmrTransactionsPEOCountryOfOriginCode Value that identifies the code for the country of manufacture.
CmrTransactionsPEOCreatedBy User who created the row.
CmrTransactionsPEOCreationDate Date and time the row was created.
CmrTransactionsPEOCstInvTransactionId Value that uniquely identifies the costing Inventory transaction and maps to CST_INV_TRANSACTIONS.CST_INV_TRANSACTION_ID for interorganization transfer orders.
CmrTransactionsPEOCurrencyConversionDate Date to be used to determine the exchange rates for currency conversion.
CmrTransactionsPEOCurrencyConversionRate Value that identifies the optional user specified currency conversion rate.
CmrTransactionsPEOCurrencyConversionType Value that identifies the currency conversion type for consigned global purchase orders where po currency is different from ledger currency. This is used to account consigned receipts
CmrTransactionsPEODefaultTaxationCountry Value that identifies the default taxation country code.
CmrTransactionsPEODestinationTypeCode Value that identifies the destination type. For interorganization flows it will be INVENTROY. For PO flows, costing will depend on the values in CMR_PURCHASE_ORDER_DTLS.
CmrTransactionsPEODocumentFiscalClassification Value that identifies the document fiscal classification code.
CmrTransactionsPEODsReceiptSourceLineId Value that identifies the source document line ID that created the drop ship receipt.
CmrTransactionsPEOEncumbranceAccountingFlag Value that indicates if encumbrance accounting is enabled.
CmrTransactionsPEOErrorCode Value that identifies the error code encountered during the processing of the transaction. This is for global procurement receipts that are missing trade events average cost.
CmrTransactionsPEOExternalSystemReference Value that identifies the external system reference of transaction.
CmrTransactionsPEOFinalDischargeLocationId Value that identifies the final discharge location.
CmrTransactionsPEOFirstPtyRegId Value that identifies the first-party tax registration ID for the transaction.
CmrTransactionsPEOFiscalDocAccessKnum Value that identifies the fiscal document access key number.
CmrTransactionsPEOFiscalDocHeaderId Value that uniquely identifies the fiscal document header.
CmrTransactionsPEOFiscalDocLineId Value that uniquely identifies the fiscal document line.
CmrTransactionsPEOFiscalDocScheduleId Value that uniquely identifies the fiscal document schedule ID.
CmrTransactionsPEOFtrId Value that identifies the financial trade relation ID on complex flows.
CmrTransactionsPEOIntendedUse Value that identifies the intended use code of the receiving transaction. This identifies the purpose for which the product is used.
CmrTransactionsPEOIntendedUseClassifId Value that identifies the intended use classification.
CmrTransactionsPEOInvShippingTransactionId Value that identifies the shipping transaction for interorganization flows.
CmrTransactionsPEOInventoryItemId Value that identifies the inventory item and references EGP_SYSTEM_ITEMS_B.inventory_item_id.
CmrTransactionsPEOLastUpdateDate User who last updated the row.
CmrTransactionsPEOLastUpdateLogin Date and time the row was most recently updated.
CmrTransactionsPEOLastUpdatedBy Session login associated to the user who last updated the row.
CmrTransactionsPEOLcmProcessedFlag Value that indicates whether LCM charges are processed for this transaction.
CmrTransactionsPEOLeTimezoneCode Value that identifies the time zone code of the legal entity.
CmrTransactionsPEOLiquidatedAmount Value that identifies the net liquidated amount that will be used in the case of a service PO for calculating the XCC reversal amount.
CmrTransactionsPEOLiquidatedQty Value that identifies the liquidated quantity that will be used for calculation of the reversal amount.
CmrTransactionsPEOManualReceiptReqdFlag Value that indicates if a manual receipt is required for an internal transfers based transfer order document for an expense destination type.
CmrTransactionsPEONonrecoverableTax Value that identifies the purchase order nonrecoverable tax value used when the transaction is processed. This column is used in global procurement flows.
CmrTransactionsPEOOwnershipChangeEventNumber Value that identifies the trade events ownership change transaction number.
CmrTransactionsPEOParentTransactionId Value that identifies the parent receiving transaction.
CmrTransactionsPEOPhysicalReturnReqdFlag Value that indicates whether to store if a physical return is required.
CmrTransactionsPEOPoDistributionId Value that identifies the purchase order distribution ID and maps to CMR_PURCHASE_ORDER_DTLS.EXTERNAL_SYSTEM_REF_ID.
CmrTransactionsPEOPoLineLocationId Value that identifies the purchase order shipment schedule.
CmrTransactionsPEOPoUnitPrice Value that identifies the purchase order price value that's used when the transaction is processed. This column is used in global procurement flows.
CmrTransactionsPEOPostedFlag Value that indicates if the transaction is processed.
CmrTransactionsPEOPrimaryQty Value that identifies the receiving transaction quantity in the item primary unit of measure.
CmrTransactionsPEOPrimaryUomCode Value that identifies the unit of measure code in which the primary transaction quantity is specified.
CmrTransactionsPEOPriorTradeInvOrgId Value that identifies the prior trade inventory organization on complex flows.
CmrTransactionsPEOProductCategory Value that identifies the product category code of the transaction line.
CmrTransactionsPEOProductFiscClassId Value that identifies the product fiscal classification ID for the inventory item.
CmrTransactionsPEOProductType Product type code of the inventory item. Possible values are GOODS and SERVICES.
CmrTransactionsPEOProfitCenterBusinessUnitId Value that identifies the profit center business where the accounting entry will be created.
CmrTransactionsPEOProjectFlag Value that indicates whether this is a projects enabled transaction.
CmrTransactionsPEORcvParentTransactionId Value that identifies the receiving parent transaction that denotes the parent of each receiving transaction.
CmrTransactionsPEORcvTransactionId Value that identifies the receiving transaction.
CmrTransactionsPEOReceiptCreationDate Value that indicates whether the receipt creation date is used to calculate the back dated receipt.
CmrTransactionsPEOReceiptLineNumber Value that identifies the receipt line number of the receipt transaction.
CmrTransactionsPEOReceiptNumber Value that identifies the receipt number for the receiving shipment receipt header row and references to RCV_SHIPMENT_headers RECEIPT_NUM.
CmrTransactionsPEORefFiscalDocAccessKnum Value that identifies the reference fiscal document access key number.
CmrTransactionsPEORefFiscalDocHeaderId Value that identifies the reference fiscal document header ID.
CmrTransactionsPEORefFiscalDocLineId Value that identifies the reference fiscal document Line ID.
CmrTransactionsPEORefFiscalDocScheduleId Value that uniquely identifies the reference fiscal document schedule.
CmrTransactionsPEORootDeliverTxnDate Value that indicates the transaction date on the associated root or first delivery transaction.
CmrTransactionsPEORootReceiptEventDate Value that identifies the event date on the PO that's used to process the root receipt transaction.
CmrTransactionsPEORootReceiveTxnId Value that identifies the root receiving transaction ID.
CmrTransactionsPEOSecondaryTransactionQty Value that identifies the transaction quantity in terms of the item's secondary unit of measure.
CmrTransactionsPEOSecondaryUomCode Value that identifies the unit of measure code in which the secondary transaction quantity is specified.
CmrTransactionsPEOShipFromInvOrgId Value that identifies the inventory organization.
CmrTransactionsPEOShipFromLocationId Value that identifies the ship from location.
CmrTransactionsPEOShipToBusinessUnitId Value that identifies the business unit where the item is shipped or delivered.
CmrTransactionsPEOShipToOrganizationId Value that identifies the inventory organization where the item is stored.
CmrTransactionsPEOShipmentLineNumber Value that identifies the shipment line number of receipt transaction.
CmrTransactionsPEOShipmentNumber Value that identifies the shipment number of the receipt transaction and references to RCV_SHIPMENT_headers SHIPMENT_NUM.
CmrTransactionsPEOSoldToBusinessUnitId Value that identifies the business unit where the invoice is created and accrual is accounted.
CmrTransactionsPEOSourceDocQty Value that identifies the transaction quantity in the source document UOM.
CmrTransactionsPEOSourceDocUomCode Value that identifies the source document unit of measure.
CmrTransactionsPEOSourceDocumentCode Value that identifies the source document code of the receipt transaction. Maps to FND_LOOKUP_VALUES_B.LOOKUP_CODE where the lookup_type is RCV_SOURCE_DOCUMENT_TYPE.
CmrTransactionsPEOTaxClassificationCode Value that identifies the tax classification code.
CmrTransactionsPEOTaxInvoiceDate Value that identifies the date of the fiscal document.
CmrTransactionsPEOTaxInvoiceNumber Value that identifies the number of the fiscal document.
CmrTransactionsPEOTaxProcessedFlag Value that indicates if tax has been processed.
CmrTransactionsPEOThirdPtyRegId Value that identifies the third party tax registration ID.
CmrTransactionsPEOTradeEventId Value that identifies the trade event ID and references to CST_TRADE_EVENTS.TRADE_EVENT_ID.
CmrTransactionsPEOTransactionAmt Value that identifies the transaction amount for service line items.
CmrTransactionsPEOTransactionDate Date when this transaction occurred.
CmrTransactionsPEOTransactionId Value that identifies the transaction ID and surrogate key column.
CmrTransactionsPEOTransactionQty Value that identifies the receiving transaction quantity.
CmrTransactionsPEOTransactionType Value that identifies the receiving event types associated with the transaction.
CmrTransactionsPEOTransactionUomCode Value that identifies the transaction unit of measure of the receipt transaction.
CmrTransactionsPEOTransferOrderDistId Value that identifies the transfer order ID and maps to CST_TRANSFER_ORDER_DISTS.distribution_id.
CmrTransactionsPEOTransferOrderHeaderId Value that identifies the transfer order header and maps to INV_TRANSFER_ORDER_HEADERS.HEADER_ID.
CmrTransactionsPEOTransferOrderLineId Value that identifies the transfer order line and maps to CST_TRANSFER_ORDER_LINES.EXTERNAL_SYSTEM_REF_ID.
CmrTransactionsPEOTransferPriceQty Value that identifies the transfer price quantity.
CmrTransactionsPEOTransferPriceUomCode Value that identifies the unit of measure code in which transfer price quantity is specified.
CmrTransactionsPEOTransferToOwnedTxnId Value that identifies the inventory transfer to owned transaction ID with positive quantity. Indicate quantity is moved inventory from consigned.
CmrTransactionsPEOTrxBusinessCategory Value that identifies the transaction business category code.
CmrTransactionsPEOUserDefinedFiscClass Value that identifies the user-defined fiscal classification code.
CmrTransactionsPEOXccNetLiquidationAmount Value that identifies the sum of all receipt transaction amounts against a service PO schedule for deliver transactions.
CmrTransactionsPEOXccNetLiquidationQty Value that identifies the sum of all receipt transaction quantities against a PO schedule for deliver transactions.