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. For purchase order: PO, transfer order: TO, inter-organization transfer :IOT. | ||
EVENT_SOURCE_ID | NUMBER | 18 | Receiving accounting event source identifier. | ||
LEDGER_ID | NUMBER | 18 | Primary 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 accounting event is created. It can be invoicing or delivering business unit. | ||
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 PO flow. | ||
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 | OBSOLETE - transfer price for logical events and if transfer price is existing. | |||
PO_UNIT_PRICE | NUMBER | OBSOLETE - purchase order unit price. | |||
TRANSACTION_AMT | NUMBER | OBSOLETE - transaction amount | |||
NONRECOVERABLE_TAX | NUMBER | 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 a display-only column. | |||
PRIMARY_QTY | NUMBER | Receiving transaction quantity 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 | Receiving transaction quantity in item primary UOM. | ||
EVENT_ID | NUMBER | 18 | Reference to the accounting event created in SLA. | ||
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 | 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 to 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. Possible errors could be due to ledger period status or event creation errors in SLA. | ||
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 | Transaction source document number. | ||
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 whether purchase order status synchronization was completed. | ||
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 identifier. | ||
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. N/NULL = Not Interfaced, A = Interfaced. | ||
EVENT_DATE | TIMESTAMP | Event date of the accounting event. | |||
PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which project expenditure transaction occurred. | |||
LOT_NUMBER | VARCHAR2 | 80 | This stores the lot number for the inventory item. | ||
SERIAL_NUMBER | VARCHAR2 | 80 | This stores the serial number for the inventory item. | ||
TRADE_EVENT_COST_ID | NUMBER | 18 | Trade event cost identifier used as foreign key to CST_TRADE_EVENTS. |