Receipt Accounting Event Details
The Receipt Accounting Event Details view object contains automatic and manual accrual clearing event details.
Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvEventsExtractPVO
Primary Keys : CmrRcvEventsPEOAccountingEventId
Initial Extract Date : CmrRcvEventsPEOCreationDate
Incremental Extract Date : CmrRcvEventsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CmrRcvEventsPEOAccountedFlag | Value that indicates if the event is accounted. |
| CmrRcvEventsPEOAccountingEventId | Value that identifies the receiving accounting event and surrogate key. |
| CmrRcvEventsPEOBillToBusinessUnitId | Value that identifies the bill to business unit. |
| CmrRcvEventsPEOBudgetaryControlFlag | Value that indicates if transaction is budgetary control enabled. |
| CmrRcvEventsPEOBusinessUnitId | Value that identifies the business unit where the account event is created. It can be either the invoicing or delivering business unit. |
| CmrRcvEventsPEOCmrPoDistributionId | Value that identifies the entity in receipt accounting PO distributions. This value will exist for match to PO, as well as a match to receipt cases. |
| CmrRcvEventsPEOCmrPoLineLocationId | Value that identifies the CMR PO line location for purchase orders. |
| CmrRcvEventsPEOCmrRcvTransactionId | Value that identifies the receiving transaction. |
| CmrRcvEventsPEOConsignedAcctDistBasis | Value that identifies the consigned accounting distribution basis for the cost profile. |
| CmrRcvEventsPEOConsignedFlag | Value that indicates if this is a consigned purchase order transaction. |
| CmrRcvEventsPEOCreateAcctDistBasis | User who created the row. |
| CmrRcvEventsPEOCreatedBy | Date and time the row was created. |
| CmrRcvEventsPEOCreationDate | Value that identifies whether to create accounting for consigned transactions. |
| CmrRcvEventsPEOCstInvTransactionId | Value that identifies the costing inventory transaction ID and maps to the CST_INV_TRANSACTIONS table. |
| CmrRcvEventsPEODeliverToBusinessUnitId | Value that identifies the item business unit and for normal POs it's same as the sold to business unit. |
| CmrRcvEventsPEODeliverToInventoryOrgId | Value that identifies the inventory organization in global procurement the items are transferred to. |
| CmrRcvEventsPEODooFullfillLineId | Value that identifies the DOO fulfillment line ID. |
| CmrRcvEventsPEOEncumbranceAccountingFlag | Value that indicates if transaction is encumbrance accounting enabled. |
| CmrRcvEventsPEOEncumbranceReversalAcctAmt | Value that identifies the encumbrance reversal amount in functional currency. |
| CmrRcvEventsPEOEncumbranceReversalEntrAmt | Value that identifies the encumbrance reversal amount in transaction currency. |
| CmrRcvEventsPEOEntityCode | Value that identifies the SLA entity code and maps to column ENTITY_CODE in CMR_RCV_EVENT_TYPES. |
| CmrRcvEventsPEOErrorCode | Value that identifies the error code during the processing of an accounting event. Possible errors are ledger period and event ID creation in SLA. |
| CmrRcvEventsPEOEventClassCode | Value that identifies the SLA event class code and maps to column EVENT_CLASS_CODE in CMR_RCV_EVENT_TYPES. |
| CmrRcvEventsPEOEventDate | Value that identifies the purchase order price effective date. |
| CmrRcvEventsPEOEventId | Value that identifies the SLA event. |
| CmrRcvEventsPEOEventSource | Value that identifies the receiving accounting event source. |
| CmrRcvEventsPEOEventSourceId | Value that identifies the receiving accounting event source ID. For event accrual clearing it's accrual clearing ID. For the invoice distribution, and other events, it's the CMR PO distribution ID. |
| CmrRcvEventsPEOEventTransactionId | Value that uniquely identifies the transaction event. |
| CmrRcvEventsPEOEventTxnTableName | Value that identifies the transaction event creation source transaction table name. |
| CmrRcvEventsPEOEventTypeCode | Value that identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES. |
| CmrRcvEventsPEOExchangeRate | Value that identifies the user specified currency conversion rate and is populated for project PO deliver transactions. |
| CmrRcvEventsPEOExpRetroPriceFlag | Value that identifies the expense adjustment created event. Valid values are Y, X, and Z. If Y, then it was due to price change. If X, then it was accrual clearing. If Z, then it was accrual reversal. |
| CmrRcvEventsPEOFiscalDocAccessKnum | Value that identifies the fiscal document access key number. |
| CmrRcvEventsPEOFiscalDocLineNumber | Value that Indicates the line number of the fiscal document item line. |
| CmrRcvEventsPEOFiscalDocNumber | Value that Indicates the number for the fiscal document given on the fiscal document sent by the supplier. |
| CmrRcvEventsPEOFiscalDocumentDetailId | Value that identifies the fiscal document details ID. |
| CmrRcvEventsPEOFundReservationStatus | Value that identifies the fund reservation status returned by budgetary control engine. |
| CmrRcvEventsPEOGlDate | Value that identifies the accounted date. This can be the same as the transaction date, or any GL open or future period start date. |
| CmrRcvEventsPEOInvShippingTransactionId | Value that identifies the interorganization shipment transaction. |
| CmrRcvEventsPEOInventoryItemId | Value that identifies the inventory item and references EGP_SYSTEM_ITEMS_B.inventory_item_id. |
| CmrRcvEventsPEOInventoryOrgId | Value that identifies the inventory organization where the item is stored. |
| CmrRcvEventsPEOLastUpdateDate | Date and time the row was most recently updated. |
| CmrRcvEventsPEOLastUpdateLogin | Session login associated with the user who last updated the row. |
| CmrRcvEventsPEOLastUpdatedBy | User who last updated the row. |
| CmrRcvEventsPEOLeTimezoneCode | Value that identifies the time zone code of the legal entity. |
| CmrRcvEventsPEOLedgerId | Value that identifies the ledger of the profit center business unit. |
| CmrRcvEventsPEOLegalEntityId | Value that identifies the legal entity of the profit center business unit. |
| CmrRcvEventsPEOManualReceiptReqdFlag | Value that indicates if the manual receipt is created for a transfer order expense destination flow. |
| CmrRcvEventsPEOPjcExpenditureItemDate | Date when the project expenditure transaction occurred. |
| CmrRcvEventsPEOPjcTxnStatusCode | Value that indicates whether the distribution record has been interfaced to projects. |
| CmrRcvEventsPEOPoItemDescription | Value that indicates the item description specified in purchase order line. This is especially needed for purchase orders involving noninventory items. |
| CmrRcvEventsPEOPoLineLocationId | Value that identifies the purchase order shipment schedule. |
| CmrRcvEventsPEOPoSyncCallFlag | Value that indicates whether the PO status sync has been called. |
| CmrRcvEventsPEOPrimaryQty | Value that identifies the receiving transaction quantity in the item primary UOM. |
| CmrRcvEventsPEOPrimaryUomCode | Value that identifies the item unit of measure in which the transaction quantity is converted to the item unit measure. |
| CmrRcvEventsPEOPriorBusinessUnitId | Value that identifies the prior business unit ID in global procurement intercompany flow. |
| CmrRcvEventsPEOPriorInventoryOrgId | Value that identifies the prior inventory organization ID in a global procurement intercompany flow. |
| CmrRcvEventsPEOProcessingGroupId | Value that identifies the processing group ID used in processing. |
| CmrRcvEventsPEOReceiptCreationDate | Value that identifies the receipt creation date to determine if it's a back dated transaction. |
| CmrRcvEventsPEORefFiscalDocAccessKnum | Value that identifies the reference fiscal document access key number. |
| CmrRcvEventsPEOReferenceDocNumber | Value that identifies the reference document number of accounted transactions. |
| CmrRcvEventsPEORootDeliverTxnDate | Value that identifies the transaction date on the associated root of the first delivery transaction. |
| CmrRcvEventsPEORootReceiptEventDate | Value that identifies the event date on the PO that's used to process the Root Receipt Transaction |
| CmrRcvEventsPEOSecondaryTransactionQty | Value that identifies the transaction quantity in terms of the item's secondary unit of measure. |
| CmrRcvEventsPEOSecondaryUomCode | Value that identifies the unit of measure code in which the secondary transaction quantity is specified. |
| CmrRcvEventsPEOShipFromInvOrgId | Value that identifies the inventory shipping organization. |
| CmrRcvEventsPEOShipToLocationId | Value that identifies the specific location that the goods are being shipped. |
| CmrRcvEventsPEOShipmentLineId | Value that uniquely identifies the receiving shipment receiving receipt line. |
| CmrRcvEventsPEOShipmentNumber | Value that identifies the shipment number for interorganization transfers. |
| CmrRcvEventsPEOSlaTransactionNumber | Value that identifies the transaction number passed to SLA for all event types. For physical receipts it's the receipt number. For trade events it's null. |
| CmrRcvEventsPEOSourceDocDistribNumber | Value that indicates the user-specified number for the purchase order distribution. |
| CmrRcvEventsPEOSourceDocLineNumber | Value that indicates the user-specified number for the purchase order line. |
| CmrRcvEventsPEOSourceDocNumber | Value that identifies the source document number of accounted transactions. Valid values are available in the ORA_CMR_DOC_FLOW_TYPES lookup. |
| CmrRcvEventsPEOSourceDocQty | Value that identifies the transaction quantity in the source document unit of measure. |
| CmrRcvEventsPEOSourceDocShipmentNumber | Value that indicates the user-specified number for the purchase order shipment. |
| CmrRcvEventsPEOSourceDocUomCode | Value that identifies the source document number of accounted transactions. |
| CmrRcvEventsPEOTradeEventId | Value that identifies the trade event and maps to CST_TRADE_EVENTS.TRADE_EVENT_ID |
| CmrRcvEventsPEOTradeOverheadId | Value that identifies the trade overhead for all overhead and subinventory cost propagation transactions. |
| CmrRcvEventsPEOTransactionDate | Date when this transaction occurred. |
| CmrRcvEventsPEOTransactionId | Value that identifies the transaction for logical receipt and logical deliver transactions. |
| CmrRcvEventsPEOTransactionQty | Value that identifies the transaction quantity of receipt transactions. |
| CmrRcvEventsPEOTransactionReversalFlag | Value that indicates the transaction reversal option for period end accrual transactions for cases where the PO price or transaction amount and nonrecoverable taxes changed but not the net accrual amount. |
| CmrRcvEventsPEOTransactionTypeCode | Value that identifies the transaction type code. |
| CmrRcvEventsPEOTransactionUomCode | Value that identifies the transaction unit of measure of receipt transactions. |
| CmrRcvEventsPEOTransferOrderDistId | Value that identifies the transfer order distribution. |
| CmrRcvEventsPEOTransferOrderHeaderId | Value that identifies the transfer order header and maps to INV_TRANSFER_ORDER_HEADERS.HEADER_ID. |
| CmrRcvEventsPEOTransferOrderLineId | Value that identifies the transfer order line and maps to CST_TRANSFER_ORDER_LINES.EXTERNAL_SYSTEM_REF_ID. |
| CmrRcvEventsPEOTropChargeLineId | Value that identifies the trade operation charge line ID for this landed cost charge. |
| CmrRcvEventsPEOUninvDelQty | Value that identifies the uninvoiced delivered quantity, for retro price change events, and for budgetary control purpose. |
| CmrRcvEventsPEOVendorId | Value that identifies the supplier and references to POZ_SUPPLIERS.VENDOR_ID. |
| CmrRcvEventsPEOVendorSiteId | Value that identifies the supplier site and references to POZ_SUPPLIER_SITES_ALL_M.VENDOR_SITE_ID. |
| CmrRcvEventsPEOXccDataSetId | Value that uniquely identifies the ID assigned by budgetary control when the consuming products interact with budgetary control and are stamped for the particular transaction batch. |