1. Tables and Views for SCM
  2. CMR_RCV_EVENTS

CMR_RCV_EVENTS

This table will store the receipt transaction accounting event details.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CMR_RCV_EVENTS_PK

ACCOUNTING_EVENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ACCOUNTING_EVENT_ID NUMBER 18 Yes Receiving accounting event identifier and Surrogate Key. Active
SECONDARY_TRANSACTION_QTY NUMBER Transaction quantity in terms of the item's secondary unit of measure.
SECONDARY_UOM_CODE VARCHAR2 3 The unit of measure code in which secondary transaction quantity is specified.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Single column FK: Identifies entity in receipt accounting PO Distributions. This value will exist for match to PO as well as match to receipt cases. Active
CMR_RCV_TRANSACTION_ID NUMBER 18 Single Column FK: Identifies the receiving transaction. Active
CMR_PO_LINE_LOCATION_ID NUMBER 18 Receipt Accounting purchase order line location identifier for purchase orders.
SHIP_FROM_INV_ORG_ID NUMBER 18 Inventory shipping organization identifier.
INV_SHIPPING_TRANSACTION_ID NUMBER 18 Inter-organization shipment transaction identifier.
DOO_FULLFILL_LINE_ID NUMBER 18 DOO Fulfillment line identifier.
TRADE_EVENT_ID NUMBER 18 Trade event identifier and maps to CST_TRADE_EVENTS.TRADE_EVENT_ID.
TROP_CHARGE_LINE_ID NUMBER 18 Trade operation charge line identifier for this landed cost charge.
EVENT_TYPE_CODE VARCHAR2 40 Yes Single column FK: Identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES. Active
EVENT_CLASS_CODE VARCHAR2 30 SLA event class code - maps to column EVENT_CLASS_CODE in CMR_RCV_EVENT_TYPES. Active
LEDGER_ID NUMBER 18 Primary Ledger identifier of the profit center business unit. Active
LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier of the profit center business unit. Active
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to Business Unit identifier.
BUSINESS_UNIT_ID NUMBER 18 Business unit where the accounting event is created. It can be invoicing or delivering business unit. Active
INVENTORY_ORG_ID NUMBER 18 Inventory organization identifier where the item is stored. Active
INVENTORY_ITEM_ID NUMBER 18 Inventory item identifier and references {EGP_SYSTEM_ITEMS_B.inventory_item_id}. Active
TRANSACTION_DATE DATE Yes The date when this transaction happened. Active
GL_DATE DATE Accounted date. This can be the same as transaction date, or any general ledger open / future period start date. Active
ACCOUNTED_FLAG VARCHAR2 1 Indicates if the event has been accounted by the SLA. N - Not Accounted, D - Draft Accounted, F - Final Accounted. Active
ERROR_CODE VARCHAR2 30 Identifies error code during the processing of accounting event. Possible errors could be due to ledger period status or event creation errors in SLA.
EVENT_ID NUMBER 18 Reference to the accounting event created in SLA. Active
CONSIGNED_ACCT_DIST_BASIS VARCHAR2 30 Indicate the consigned accounting distribution basis for the cost profile.
CREATE_ACCT_DIST_BASIS VARCHAR2 1 Indicates whether accounting will be created for consigned transactions. Y = Yes, N = No.
SOURCE_DOC_QTY NUMBER Quantity in source document unit of measure. Active
SOURCE_DOC_UOM_CODE VARCHAR2 25 Source document unit of measure. Active
PRIOR_BUSINESS_UNIT_ID NUMBER 18 It tells the prior business unit identifier in global procurement intercompany flow.
PRIOR_INVENTORY_ORG_ID NUMBER 18 It tells the prior inventory organization identifier in global procurement intercompany flow.
DELIVER_TO_BUSINESS_UNIT_ID NUMBER 18 Item belonging to business unit in global procurement flow and same as sold to business unit in simple purchase order flow. Active
DELIVER_TO_INVENTORY_ORG_ID NUMBER 18 In global procurement, items are transferred to this inventory organization. Active
TRANSACTION_QTY NUMBER Transaction quantity of receipt transactions. This is a display-only column. Active
TRANSACTION_UOM_CODE VARCHAR2 25 Transaction unit of measure of receipt transactions. Active
PRIMARY_QTY NUMBER Receiving transaction quantity in item primary unit of measure. Active
PRIMARY_UOM_CODE VARCHAR2 25 The principal unit of measure in which the quantity of an item is managed. Active
PROCESSING_GROUP_ID NUMBER 18 Stamped to identify the set of transactions that are being processed. Active
EVENT_SOURCE VARCHAR2 25 Receiving accounting event source. For purchase order: PO, transfer order: TO, inter-organization transfer: IOT. Active
SOURCE_DOC_NUMBER VARCHAR2 50 Transaction source document number.
SLA_TRANSACTION_NUMBER VARCHAR2 50 Transaction number identifier pass to SLA for all event types. For physical receipts - receipt number, for trade events - NULL.
ENTITY_CODE VARCHAR2 30 SLA entity code - maps to column ENTITY_CODE in CMR_RCV_EVENT_TYPES. Active
CONSIGNED_FLAG VARCHAR2 1 Indicates if it is a consigned purchase order transaction or not.
TRANSFER_PRICE NUMBER OBSOLETE - transfer price for logical events and if transfer price is existing. Active
PO_UNIT_PRICE NUMBER OBSOLETE - purchase order unit price. Active
TRANSACTION_AMT NUMBER OBSOLETE - transaction amount. Active
NONRECOVERABLE_TAX NUMBER OBSOLETE - non-recoverable tax on purchase order document. Active
ENTERED_CURRENCY_CODE VARCHAR2 15 OBSOLETE - identifies currency of the price. Active
EXCHANGE_RATE_TYPE VARCHAR2 30 OBSOLETE - currency conversion type - conversion type which should be used for currency conversions. Active
EXCHANGE_RATE NUMBER User specified currency conversion rate. This will be populated for project specific purchase order deliver transactions. Active
EXCHANGE_DATE DATE OBSOLETE - The date to be used to determine the currency conversion exchange rate for a currency. Active
EVENT_SOURCE_ID NUMBER 18 Receiving accounting event source identifier. For the event accrual clearing it is accrual clearing identifier, for invoice adjustments invoice distribution identifier, other events it is Receipt Accounting purchase order distribution identifier. Active
PROCUREMENT_ORG_FLAG VARCHAR2 1 OBSOLETE - indicator flag for this transaction belongs to procurement org or not. Active
MULTI_BU_FLAG VARCHAR2 1 OBSOLETE - indicator flag for this transaction belongs to multi business unit or not. Active
TXN_FLOW_HEADER_ID NUMBER 18 OBSOLETE - transaction flow header identifier if transaction belongs to which business unit. Active
DESTINATION_TYPE_CODE VARCHAR2 25 OBSOLETE - identifies the destination type for material - INVENTORY or EXPENSE. Active
INVOICED_FLAG VARCHAR2 1 OBSOLETE - indicator flag for if event is pushed to inventory for one time item. Active
POSTED_FLAG VARCHAR2 1 OBSOLETE - This is an indicator flag for posting logical transactions and intercompany events to inventory. Y means posted, N - means not posted. Active
ENCUMBRANCE_REVERSAL_ENTR_AMT NUMBER Encumbrance reversal amount in transaction currency.
ENCUMBRANCE_REVERSAL_ACCT_AMT NUMBER Encumbrance reversal amount in functional currency.
ROOT_RECEIPT_EVENT_DATE TIMESTAMP Event date on the PO that is used to process the root receipt transaction.
TRANSFER_ORDER_HEADER_ID NUMBER 18 Transfer order header identifier and maps {INV_TRANSFER_ORDER_HEADERS.HEADER_ID}.
TRANSFER_ORDER_LINE_ID NUMBER 18 Transfer order line Identifier and maps {CST_TRANSFER_ORDER_LINES.EXTERNAL_SYSTEM_REF_ID}.
TRANSFER_ORDER_DIST_ID NUMBER 18 Transfer order distribution identifier.
BUDGETARY_CONTROL_FLAG VARCHAR2 1 Flag to indicate if transaction is budgetary control enabled or not.
ENCUMBRANCE_ACCOUNTING_FLAG VARCHAR2 1 Flag to indicate if transaction is encumbrance accounting enabled or not.
XCC_DATA_SET_ID NUMBER 18 Unique identifier assigned by budgetary control when consuming products interact with budgetary control and stamped for the particular transaction batch.
FUND_RESERVATION_STATUS VARCHAR2 30 Fund reservation status returned by budgetary control engine.
PO_SYNC_CALL_FLAG VARCHAR2 1 Flag to indicate whether purchase order status synchronization was completed.
RECEIPT_CREATION_DATE DATE Receipt creation date to determine back dated transaction or not.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
UNINV_DEL_QTY NUMBER Un-invoiced delivered quantity for retro price change events for budgetary control purpose.
REFERENCE_DOC_NUMBER VARCHAR2 50 Reference document number of accounted transactions.
MANUAL_RECEIPT_REQD_FLAG VARCHAR2 1 Flag to denote manual receipt is created or not for transfer order expense destination flow.
EXP_RETRO_PRICE_FLAG VARCHAR2 1 Flag shows expense adjustment created event. Y for price change, X for accrual clearing and Z for accrual reversal.
CST_INV_TRANSACTION_ID NUMBER 18 Costing inventory transaction identifier and maps to CST_INV_TRANSACTIONS table.
SHIPMENT_NUMBER VARCHAR2 30 Shipment number for inter-organization transfers.
FISCAL_DOC_ACCESS_KNUM VARCHAR2 64 Fiscal document access key number.
REF_FISCAL_DOC_ACCESS_KNUM VARCHAR2 64 Reference fiscal document access key number.
FISCAL_DOCUMENT_DETAIL_ID NUMBER 18 Fiscal Document Details Identifier.
TRANSACTION_ID NUMBER 18 Transaction identifier for logical receipt and logical deliver transactions (FK to CMR_TRANSACTIONS).
TRADE_OVERHEAD_ID NUMBER 18 Trade overhead identifier for all overhead and sub inventory cost propagation transactions.
LE_TIMEZONE_CODE VARCHAR2 50 Represents the time zone code of the legal entity.
TRANSACTION_TYPE_CODE VARCHAR2 40 Transaction type code. Stores all transaction types.
EVENT_TXN_TABLE_NAME VARCHAR2 30 Stores transaction event creation source transaction table name.
EVENT_TRANSACTION_ID NUMBER 18 This column identifies transaction event identifier.
TRANSACTION_REVERSAL_FLAG VARCHAR2 1 Transaction reversal flag for period end accrual transactions for cases where purchase order price or transaction amount and non-recoverable taxes changed but not the net accrual amount.
PJC_TXN_STATUS_CODE VARCHAR2 1 Indicates whether the distribution record has been interfaced to projects or not. N/NULL = Not Interfaced, A = Interfaced.
EVENT_DATE TIMESTAMP Purchase order price effective date.
ROOT_DELIVER_TXN_DATE DATE Indicates the transaction date on the associated root/first delivery transaction.
PJC_EXPENDITURE_ITEM_DATE DATE Date on which project expenditure transaction occurred.
LOT_NUMBER VARCHAR2 80 This stores lot number information for inventory item.
SERIAL_NUMBER VARCHAR2 80 This stores serial number information for inventory item.

Foreign Keys

Table Foreign Table Foreign Key Column
cmr_rcv_distributions cmr_rcv_events ACCOUNTING_EVENT_ID
cmr_rcv_event_costs cmr_rcv_events ACCOUNTING_EVENT_ID

Indexes

Index Uniqueness Tablespace Columns Status
CMR_RCV_EVENTS_N1 Non Unique FUSION_TS_TX_DATA CMR_PO_DISTRIBUTION_ID, CMR_RCV_TRANSACTION_ID, TRADE_EVENT_ID, CMR_PO_LINE_LOCATION_ID, TRANSACTION_ID Active
CMR_RCV_EVENTS_N2 Non Unique Default TRANSACTION_DATE, EVENT_SOURCE, BUSINESS_UNIT_ID, BILL_TO_BUSINESS_UNIT_ID, SOURCE_DOC_NUMBER, INVENTORY_ORG_ID, INVENTORY_ITEM_ID, ACCOUNTED_FLAG
CMR_RCV_EVENTS_N3 Non Unique Default FUND_RESERVATION_STATUS
CMR_RCV_EVENTS_N4 Non Unique Default XCC_DATA_SET_ID
CMR_RCV_EVENTS_N5 Non Unique Default EVENT_TXN_TABLE_NAME, EVENT_TRANSACTION_ID, EVENT_SOURCE
CMR_RCV_EVENTS_N6 Non Unique Default EVENT_CLASS_CODE, EVENT_TYPE_CODE, TRANSACTION_TYPE_CODE
CMR_RCV_EVENTS_N7 Non Unique Default TRUNC("TRANSACTION_DATE")
CMR_RCV_EVENTS_N8 Non Unique Default ACCOUNTED_FLAG, GL_DATE
CMR_RCV_EVENTS_N9 Non Unique Default PJC_TXN_STATUS_CODE
CMR_RCV_EVENTS_PK Unique FUSION_TS_TX_DATA ACCOUNTING_EVENT_ID Active
CMR_RCV_EVENTS_U1 Unique Default EVENT_ID