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. |