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 CMR Po 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 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 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 account event is created. It can be Invoicing Business or Delivering business unit Active
INVENTORY_ORG_ID NUMBER 18 inventory organization id 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 same as transaction date, or any GL open / future period start date Active
ACCOUNTED_FLAG VARCHAR2 1 indicator flag if event is accounted or not Active
ERROR_CODE VARCHAR2 30 identifies error code during the processing of accounting event. Possible errors are ledger period and event id creation in SLA
EVENT_ID NUMBER 18 SLA event id - identifier field SLA Event Active
CONSIGNED_ACCT_DIST_BASIS VARCHAR2 30 Indicate the Consigned accounting distribution basis for the cost profile.
CREATE_ACCT_DIST_BASIS VARCHAR2 1 Create accounting for consigned transactions flag - Y or N
SOURCE_DOC_QTY NUMBER Transaction qty in source document Unit of Measure Active
SOURCE_DOC_UOM_CODE VARCHAR2 25 Source document number of accounted transactions. For PO receipts - PO and Transfer Orders - TO. Active
PRIOR_BUSINESS_UNIT_ID NUMBER 18 It tells the prior business unit id in Global procurement intercompany flow
PRIOR_INVENTORY_ORG_ID NUMBER 18 It tells the prior inventory organization id in Global procurement intercompany flow
DELIVER_TO_BUSINESS_UNIT_ID NUMBER 18 In Global procurement, where the item belonging business unit and normal POs it is same as Sold to Business Unit 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 display column only. Active
TRANSACTION_UOM_CODE VARCHAR2 25 transaction unit of measure of receipt transactions. Active
PRIMARY_QTY NUMBER Receiving transaction qty in item primary UOM Active
PRIMARY_UOM_CODE VARCHAR2 25 This is Item unit of measure in which transaction quantity is converted to Item unit measure Active
PROCESSING_GROUP_ID NUMBER 18 Processing group id used in processing Active
EVENT_SOURCE VARCHAR2 25 receiving accounting event source - PO, TO, IOT Active
SOURCE_DOC_NUMBER VARCHAR2 50 Source document number of accounted transactions. For PO receipts - PO and Transfer Orders - TO. Look up code maps to lookup type - ORA_CMR_DOC_FLOW_TYPES.
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 Functional - OBSOLETE - transfer price for logical events and if transfer price is existing. Active
PO_UNIT_PRICE NUMBER Functional - OBSOLETE - po unit price Active
TRANSACTION_AMT NUMBER Functional - OBSOLETE - transaction amount Active
NONRECOVERABLE_TAX NUMBER Functional - OBSOLETE - non recoverable tax on Purchase Order Document Active
ENTERED_CURRENCY_CODE VARCHAR2 15 Functional - OBSOLETE - identifies currency of the price Active
EXCHANGE_RATE_TYPE VARCHAR2 30 Functional - OBSOLETE - currency conversion type - Conversion type which should be used for currency conversions Active
EXCHANGE_RATE NUMBER User specified currency conversion rate and populated for Project Purchase order deliver transactions. Active
EXCHANGE_DATE DATE Functional - 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 id - For Event Accrual Clearing it is Accrual Clearing id, for Invoice distribution Id, other events it is CMR Po distribution id. Active
PROCUREMENT_ORG_FLAG VARCHAR2 1 Functional - OBSOLETE - indicator flag for this transaction belongs to procurement org or not Active
MULTI_BU_FLAG VARCHAR2 1 Functional - OBSOLETE - indicator flag for this transaction belongs to multi business unit or not Active
TXN_FLOW_HEADER_ID NUMBER 18 Functional - OBSOLETE - transaction flow header id if transaction belongs to cross business unit Active
DESTINATION_TYPE_CODE VARCHAR2 25 Functional - OBSOLETE - identifies the destination type for material - INVENTORY or EXPENSE Active
INVOICED_FLAG VARCHAR2 1 Functional - OBSOLETE - indicator flag for if event is pushed to inventory for one time item Active
POSTED_FLAG VARCHAR2 1 Functional - OBSOLETE - This is 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 Y/N flag to indicate if transaction is budgetary control enabled or not
ENCUMBRANCE_ACCOUNTING_FLAG VARCHAR2 1 Y/N 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 Y/N flag to indicate po status sync called or not
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 means due to price change X accrual clearing Z 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 propagations 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 ID.
TRANSACTION_REVERSAL_FLAG VARCHAR2 1 Transaction reversal flag for period end accrual transactions for cases where po 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.
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

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