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 - indicates the 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. | ||
| SOURCE_DOC_LINE_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order line. | ||
| SOURCE_DOC_SHIPMENT_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order shipment. | ||
| SOURCE_DOC_DISTRIB_NUMBER | VARCHAR2 | 40 | User specified number for the purchase order distribution. | ||
| VENDOR_ID | NUMBER | 18 | Identifies the Supplier and references to {POZ_SUPPLIERS.vendor_id}. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Identifies the Supplier Site and references to {POZ_SUPPLIER_SITES_ALL_M.vendor_site_id}. | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | The identifier of the specific location that the goods are being shipped. | ||
| PO_ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description specified in purchase order line. Especially needed for purchase orders involving non inventory items. | ||
| FISCAL_DOC_NUMBER | VARCHAR2 | 30 | Number for the Fiscal Document given on the Fiscal Document sent by the supplier. | ||
| FISCAL_DOC_LINE_NUMBER | NUMBER | Indicates the line number of the Fiscal Document item line. | |||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. |