1. Tables and Views for SCM
  2. CMR_RCV_EVENTS_GT

CMR_RCV_EVENTS_GT

Stores receipt transaction accounting details temporarily, later moved to persistent table

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
ACCOUNTING_EVENT_ID NUMBER 18 Yes Receiving accounting event identifier and Surrogate Key.
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 Purchase order Distribution Identifier.
EVENT_TYPE_CODE VARCHAR2 40 Yes Single column FK: Identifies the SLA event type as defined in CMR_RCV_EVENT_TYPES.
EVENT_CLASS_CODE VARCHAR2 30 SLA event class code - maps to column EVENT_CLASS_CODE in CMR_RCV_EVENT_TYPES
ENTITY_CODE VARCHAR2 30 SLA entity code - maps to column ENTITY_CODE in CMR_RCV_EVENT_TYPES
CMR_RCV_TRANSACTION_ID NUMBER 18 Identifier for receiving transaction.
EVENT_SOURCE VARCHAR2 25 Receiving accounting event source.
EVENT_SOURCE_ID NUMBER 18 Receiving accounting event source identifier.
LEDGER_ID NUMBER 18 Ledger identifier of the profit center business unit
LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier of the Profit center business unit.
BUSINESS_UNIT_ID NUMBER 18 Business unit where the account event is created. It can be Invoicing Business or Delivering business unit
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
INVENTORY_ORG_ID NUMBER 18 Inventory organization identifier where the item is stored.
DELIVER_TO_INVENTORY_ORG_ID NUMBER 18 Deliver to inventory organization identifier.
INVENTORY_ITEM_ID NUMBER 18 Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}.
TRANSACTION_DATE DATE Yes Transaction date of the accounting event.
GL_DATE DATE Accounted date - this can be same as transaction date, or any GL open / future period start date
TRANSFER_PRICE NUMBER Transfer price for logical events.
PO_UNIT_PRICE NUMBER Functional - OBSOLETE - po unit price
TRANSACTION_AMT NUMBER Functional - OBSOLETE - transaction amount
NONRECOVERABLE_TAX NUMBER Functional - OBSOLETE - non recoverable tax on Purchase Order Document
ENTERED_CURRENCY_CODE VARCHAR2 15 Entered currency code of the event.
EXCHANGE_RATE_TYPE VARCHAR2 30 Exchange rate type for currency conversion.
EXCHANGE_RATE NUMBER Currency conversion exchange rate.
EXCHANGE_DATE DATE Currency conversion exchange date.
SOURCE_DOC_QTY NUMBER Transaction quantity in source document Unit of Measure.
TRANSACTION_QTY NUMBER Transaction quantity of receipt transactions. This is display column only.
PRIMARY_QTY NUMBER Receiving transaction qty in item primary Unit of Measure
SOURCE_DOC_UOM_CODE VARCHAR2 25 Source document unit of measure.
TRANSACTION_UOM_CODE VARCHAR2 25 Transaction unit of measure of receipt transactions.
PRIMARY_UOM_CODE VARCHAR2 25 This is Item unit of measure in which transaction quantity is converted to Item unit measure
EVENT_ID NUMBER 18 SLA event id - identifier field SLA Event
PROCUREMENT_ORG_FLAG VARCHAR2 1 Procurement organization indicator.
MULTI_BU_FLAG VARCHAR2 1 Indicator flag for this transaction belongs to multiple business unit or not.
DESTINATION_TYPE_CODE VARCHAR2 25 Functional - OBSOLETE - identifies the destination type for material - INVENTORY or EXPENSE
ACCOUNTED_FLAG VARCHAR2 1 Accounted flag which indicates if the transaction is accounted or not.
INVOICED_FLAG VARCHAR2 1 Invoiced indicator of the accounting event.
POSTED_FLAG VARCHAR2 1 Posted flag of the accounting event.
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
TXN_FLOW_HEADER_ID NUMBER 18 Transaction flow header identifier.
ROOT_RECEIPT_EVENT_DATE TIMESTAMP Root receipt event date of the accounting event.
CMR_PO_LINE_LOCATION_ID NUMBER 18 Purchase order line location identifier.
SHIP_FROM_INV_ORG_ID NUMBER 18 Ship from inventory organization identifier.
INV_SHIPPING_TRANSACTION_ID NUMBER 18 Inventory shipping 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.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to Business unit identifier.
ERROR_CODE VARCHAR2 30 Identifies error code during the processing of the accounting event.
CONSIGNED_ACCT_DIST_BASIS VARCHAR2 30 Indicates the Consigned accounting distribution basis for the cost profile.
CREATE_ACCT_DIST_BASIS VARCHAR2 1 Create accounting for consigned transactions flag.
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.
CONSIGNED_FLAG VARCHAR2 1 Indicates if it is a consigned transaction or not.
ENCUMBRANCE_REVERSAL_ENTR_AMT NUMBER Encumbrance Reversal Amount in transaction currency.
ENCUMBRANCE_REVERSAL_ACCT_AMT NUMBER Encumbrance Reversal Amount in functional currency.
TRANSFER_ORDER_HEADER_ID NUMBER 18 Transfer order header identifier.
TRANSFER_ORDER_LINE_ID NUMBER 18 Transfer order line identifier.
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 purchase order status sync called or not.
RECEIPT_CREATION_DATE DATE Receipt creation date to determine back dated transaction or not.
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.
CST_INV_TRANSACTION_ID NUMBER 18 Costing Inventory transaction identifier.
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 detail 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.
PJC_TXN_STATUS_CODE VARCHAR2 1 Indicates whether the distribution record has been interfaced to projects or not.
EVENT_DATE TIMESTAMP Event date of the accounting event.
PJC_EXPENDITURE_ITEM_DATE DATE Date on which project expenditure transaction occurred