1. Tables and Views for SCM
  2. CMR_RCV_EVENTS_COSTS_GT

CMR_RCV_EVENTS_COSTS_GT

This table is used during the processing of Receiving adjustment entries. It will holds both enent and event cost details

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
ACCOUNTING_EVENT_ID NUMBER 18 Accounting event identifier and maps to CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID
EVENT_COST_ID NUMBER 18 Event Cost Identifier and maps to CMR_RCV_EVENT_COSTS.EVENT_COST_ID
EVENT_COST_SOURCE VARCHAR2 30 Accounted Event Cost Source identifier based on source document transactions.
TRADE_EVENT_AVG_COST_ID NUMBER 18 Trade Event Average cost identifier for trade and physical transactions in complex flows.
EVENT_UNIT_COST NUMBER Event Unit Cost of accounted transaction in transaction currency.
EVENT_PRIOR_UNIT_COST NUMBER Event prior unit cost of accounted transaction in transaction currency.
CMR_RCV_TRANSACTION_ID NUMBER 18 Receipt accounting transaction identifier for physical receipt transactions.
TRANSACTION_ID NUMBER 18 Transaction identifier
CMR_PO_DISTRIBUTION_ID NUMBER 18 Receipt Accounting purchase order distribution identifier.
CMR_PO_LINE_LOCATION_ID NUMBER 18 cmr po line location identifier for PO flow trade events
PO_LINE_LOCATION_ID NUMBER 18 Purchase order line location identifier
SOURCE_DOC_NUMBER VARCHAR2 50 source document number as PO number or shipment number based on flows type
INV_SHIPPING_TRANSACTION_ID NUMBER 18 Inter organization Inventory shipment transaction identifier
SLA_TRANSACTION_NUMBER VARCHAR2 50 Transaction number pass to SLA during event creation
CONSIGNED_FLAG VARCHAR2 1 Indicates event is a consigned flow or not.
TRADE_EVENT_ID NUMBER 18 Trade Event identifier and it maps to {CST_TRADE_EVENTS.TRADE_EVENT_ID}
LEDGER_ID NUMBER 18 Ledger identifier of Profit center business unit.
LEGAL_ENTITY_ID NUMBER 18 Legal Entity identifier of transaction associated to profit center business unit.
BUSINESS_UNIT_ID NUMBER 18 Profit Center Business Unit Identifier defined on accounted transactions.
INVENTORY_ORG_ID NUMBER 18 Inventory Organization identifier where financial obligation defined to book the accounting event.
INVENTORY_ITEM_ID NUMBER 18 Inventory Item identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to business unit identifier of accounted transactions.
DELIVER_TO_BUSINESS_UNIT_ID NUMBER 18 Deliver to Business Unit identifier defined on Purchase order document.
DELIVER_TO_INVENTORY_ORG_ID NUMBER 18 Deliver to Inventory Org identifier where goods are delivered.
EVENT_TYPE_CODE VARCHAR2 30 event type code - This is SLA event type code mapping column and has a limit to 30.
EVENT_CLASS_CODE VARCHAR2 30 event class code of a event in receipt accounting
ENTITY_CODE VARCHAR2 30 entity code to store receipt accounting event entity code
TRANSACTION_DATE DATE Transaction Date of accounted transaction and used to derive the ledger accounting date.
SOURCE_DOC_QTY NUMBER source doc quantity - it is accounted qty
SOURCE_DOC_UOM_CODE VARCHAR2 25 source document unit of measure code of a transaction.
TRANSACTION_QTY NUMBER transaction quantity in transaction unit of measure code.
TRANSACTION_UOM_CODE VARCHAR2 25 transaction uom code to represent the transaction quantity.
PRIMARY_QTY NUMBER primary quantity in Item's primary unit of measure code.
PRIMARY_UOM_CODE VARCHAR2 25 Item unit of measure code to represent the primary quantity.
EVENT_SOURCE VARCHAR2 25 Event source like IOT - inter org flows, PO - PO flows
ACCOUNTED_FLAG VARCHAR2 1 Accounted flag status of the transaction. P - pending status.
CROSS_BU_FLAG VARCHAR2 1 Multi Business unit indicator flag of transaction.
PROCUREMENT_BU_FLAG VARCHAR2 1 Supplier facing node indicator flag for complex flows.
DESTINATION_TYPE_CODE VARCHAR2 25 Destination Type Code -'INVENTORY' and 'EXPENSE'
SERVICE_LINE_TYPE_FLAG VARCHAR2 1 Indicates the if PO service based PO or not
CURRENCY_CODE VARCHAR2 15 Currency Code of accounted transaction in source document currency.
CURRENCY_CONVERSION_TYPE VARCHAR2 40 Currency Conversion Type - defined on source document and used to for conversions.
CURRENCY_CONVERSION_DATE DATE Currency Conversion Date - used to convert the source document currency transaction to ledger currency.
CURRENCY_CONVERSION_RATE NUMBER Currency Conversion Rate - used to convert the source document currency transaction to ledger currency.
TRANSFER_ORDER_HEADER_ID NUMBER 18 Transfer Order header identifier for Transfer order flows.
TRANSFER_ORDER_LINE_ID NUMBER 18 Transfer Order Line identifier or Transfer order flows.
TRANSFER_ORDER_DIST_ID NUMBER 18 Transfer order distribution identifier or Transfer order flows.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.