1. Tables and Views for SCM
  2. CMR_RCV_TXNS_GT

CMR_RCV_TXNS_GT

This table stores unprocessed receiving transactions.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Comments Status
CMR_RCV_TRANSACTION_ID NUMBER 18 Single column FK: Identifies the receiving transaction.
PRIM_UOM_CONV_FROM_TE_TO_RCPT NUMBER Conversion factor from trade event primary unit of measure to receipt transaction primary unit of measure.
SECONDARY_UOM_CODE VARCHAR2 3 Secondary unit of measure code of item.
SECONDARY_TRANSACTION_QTY NUMBER Transaction quantity in secondary unit of measure code.
TRADE_EVENT_ID NUMBER 18 Trade event identifier for complex flows and maps to {CST_TRADE_EVENTS.TRADE_EVENT_ID}.
PO_LINE_LOCATION_ID NUMBER 18 Purchase order shipment schedule identifier. Active
CMR_PO_LINE_LOCATION_ID NUMBER 18 Receipt accounting purchase order line location identifier.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Single column FK: Identifies entity in receipt accounting purchase order distributions. This value will exist for match to PO as well as match to receipt cases.
PARENT_TRANSACTION_ID NUMBER 18 Parent receiving transaction identifier. Active
CMR_ROOT_RECEIVE_TXN_ID NUMBER 18 Internal identifier that links the transaction with its first receiving transaction identifier.
ROOT_RECEIVE_TXN_ID NUMBER 18 Root receiving transaction identifier.
SHIP_TO_ORGANIZATION_ID NUMBER 18 Ship to inventory organization identifier. Active
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Business unit identifier where invoice is created.
DELIVER_TO_BUSINESS_UNIT_ID NUMBER 18 In case of global intercompany procurement flows, it's the business unit where the item is received and for normal purchase orders it is the same as sold to business unit.
PROFIT_CENTER_BUSINESS_UNIT_ID NUMBER 18 Profit center business where accounting entries gets created.
INV_TRANSACTION_ID NUMBER 18 Inter-organization shipment inventory transaction identifier.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 External system reference of transaction. FUSION for fusion based transactions.
INVENTORY_ITEM_ID NUMBER 18 Inventory item identifier and references {EGP_SYSTEM_ITEMS_B.inventory_item_id}. Active
TRANSACTION_TYPE VARCHAR2 40 Identifies the receiving event types associated with the transaction. Active
SOURCE_DOCUMENT_CODE VARCHAR2 25 Transaction source document type. Purchase Order or Transfer Order.
TRANSACTION_AMT NUMBER Received transaction amount for service line items. Active
TRANSACTION_DATE TIMESTAMP The date when this transaction happened. Active
SOURCE_DOC_QTY NUMBER Receiving quantity in source document unit of measure. Active
TRANSACTION_QTY NUMBER Receiving transaction quantity in transaction unit of measure. Active
SOURCE_DOC_UOM_CODE VARCHAR2 3 Source document unit of measure of PO document.
TRANSACTION_UOM_CODE VARCHAR2 3 Receiving transaction unit of measure for goods received.
MATCH_OPTION VARCHAR2 25 Indicates if the invoice is matched to the purchase order or to the receipt. Valid values are P for PO, and R for receipt. Active
PURCHASE_BASIS VARCHAR2 30 Identifies whether the PO line is for goods or services. Valid values are 'GOODS' and 'SERVICES'.
DESTINATION_TYPE_CODE VARCHAR2 25 Purchase order distribution destination. It can be Inventory, Expense, Manufacturing or Drop-ship.
PRIMARY_QTY NUMBER Transaction quantity in item's primary unit of measure.
PRIMARY_UOM_CODE VARCHAR2 3 Primary unit of measure of the item.
CURRENCY_CODE VARCHAR2 15 Indicates purchase order currency. Active
FD_CURRENCY_CODE VARCHAR2 15 Fiscal Document currency code and this can be different from Purchase Order currency code.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion type that should be used for currency conversion. Active
CURRENCY_CONVERSION_RATE NUMBER Optional user specified currency conversion rate. Active
CURRENCY_CONVERSION_DATE TIMESTAMP The date to be used to determine the exchange rates for currency conversion. Active
NONRECOVERABLE_TAX NUMBER Non-recoverable tax on purchase order document. Active
PO_UNIT_PRICE NUMBER Unit price defined on purchase order line in purchase order unit of measure. Active
TXN_FLOW_HEADER_ID NUMBER 18 OBSOLETE: It stores transaction flow header ID for global procurement PO transactions. The value comes from receiving. Receipt accounting uses this column to find all the business units involved in the PO flow.
TRANSACTION_ID NUMBER 18 Transaction identifier - FK to CMR_TRANSACTIONS.
DEL_TRANSACTION_ID NUMBER 18 Put away transaction's transaction identifier.
EVENT_DATE TIMESTAMP Purchase Order event date and maps to PO event change.
EFFECTIVE_DATE TIMESTAMP Creation date of the tax row for receipt transaction processed by receipt accounting.
TAX_PRICE NUMBER Total inclusive tax amount for the receipt transaction in entered currency.
NONREC_TAX_PRICE NUMBER Total non-recoverable exclusive tax amount for the receipt transaction in entered currency.
NONREC_INCLUSIVE_TAX NUMBER Total non-recoverable inclusive tax amount for the receipt transaction in entered currency.
SOURCE_DOC_NUMBER VARCHAR2 50 Source document number - PO flows PO number, TO flows to number.
REFERENCE_DOC_NUMBER VARCHAR2 50 Transactions source documents reference document number.
RECEIPT_NUMBER VARCHAR2 50 Receipt number of receipt transactions.
OWNERSHIP_CHANGE_EVENT_NUMBER VARCHAR2 30 Ownership change event number for trade events.
SHIP_FROM_INV_ORG_ID NUMBER 18 Shipping inventory organization identifier.
CONSIGNED_FLAG VARCHAR2 1 Consigned flag indicator - Y means consigned material.
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.
TRANSFER_ORDER_LINE_ID NUMBER 18 Transfer order line identifier and maps to CST_TRANSFER_ORDER_LINES.
TRANSFER_ORDER_DIST_ID NUMBER 18 Transfer order distribution identifier.
LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier from inventory organization where goods or services are received.
LEDGER_ID NUMBER 18 Primary Ledger identifier from legal entity where goods or services are received.
RECEIPT_CREATION_DATE DATE Stores actual receipt creation date to calculate if a transaction is back dated or not.
PO_EVENT_DATE TIMESTAMP Purchase order event date to pick the price and tax.
MANUAL_RECEIPT_REQD_FLAG VARCHAR2 1 Flag to denote Manual receipt is created or not for transfer order expense destination flow.
BUDGETARY_CONTROL_FLAG VARCHAR2 1 Indicates transaction enabled for budgetary control.
ENCUMBRANCE_ACCOUNTING_FLAG VARCHAR2 1 Encumbrance accounting flag - encumbrance reversal amount for purchase order and used for encumbrance accounting only.
CST_INV_TRANSACTION_ID NUMBER 18 Transaction identifier for issue transaction for inter-organization transfer flows.
SHIPMENT_NUMBER VARCHAR2 30 Shipment number entered while transferring the goods.
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.
FISCAL_DOCUMENT_SCHEDULE_ID NUMBER 18 Fiscal document schedules identifier.
TAX_PROCESSED_FLAG VARCHAR2 1 Indicates tax processed for this transaction or not eligible for tax calculation.
SOURCE_ACCOUNT_ID NUMBER 18 Source account identifier defined on transaction source document.
CONSUMPTION_UNIT_PRICE NUMBER Consigned purchase order transfer to owned unit price in source document unit of measure in entered currency.
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier.
INCLUSIVE_TAX NUMBER Total inclusive tax amount for the receipt transaction in entered currency.
TRANSACTION_AMT_ROUNDED NUMBER Receiving transaction amount in primary ledger currency rounded to functional currency precision.
NONREC_TAX_PRICE_ROUNDED NUMBER Total non-recoverable tax amount for the receipt transaction in primary ledger currency rounded to the functional currency precision.
NONREC_INCLUSIVE_TAX_ROUNDED NUMBER Total non-recoverable inclusive tax amount for the receipt transaction in primary ledger currency rounded to the functional currency precision.
PO_AMOUNT_ROUNDED NUMBER Net transaction amount in primary ledger currency for service purchase orders rounded to functional currency precision.
TRANSACTION_AMT_ROUNDED_EC NUMBER Receiving transaction amount in entered currency rounded to entered currency precision.
NONREC_TAX_PRICE_ROUNDED_EC NUMBER Non-recoverable tax in entered currency rounded to entered currency precision.
NONREC_INCLUSIVE_TAX_ROUND_EC NUMBER Total non-recoverable inclusive tax amount for the receipt transaction in entered currency rounded to the entered currency precision.
PO_AMOUNT_ROUNDED_EC NUMBER Net transaction amount in entered currency for service purchase orders rounded to entered currency precision.
PRIOR_INVENTORY_ORG_ID NUMBER 18 Prior inventory organization identifier.
ROOT_DELIVER_TXN_DATE DATE Indicates the transaction date on the associated root/first delivery transaction.
LEDGER_CURRENCY_CODE VARCHAR2 15 Indicates the purchase order ledger currency.
ENTERED_CURRENCY_PRECISION NUMBER 18 Stores the currency precision from fnd_currencies for the entered currency code.
PROJECT_FLAG VARCHAR2 1 Project enabled identifier flag. Y means project enabled transaction.
NR_SELFASSESSED_TAX NUMBER Total non-recoverable self-assessed tax for the receipt transaction in entered currency.
NR_SELFASSESSED_TAX_ROUNDED NUMBER Total non-recoverable self-assessed tax amount for the receipt transaction in primary ledger currency rounded to the functional currency precision.
NR_SELFASSESSED_TAX_ROUNDED_EC NUMBER Total non-recoverable self-assessed tax for the receipt transaction amount in entered currency rounded to the entered currency precision.
DS_RECEIPT_SOURCE_LINE_ID NUMBER 18 Indicates the source document line identifier that created drop-ship receipt.
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.