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 po line location identifier.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Single column FK: Identifies entity in Receipt accounting PO 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 root/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 global procurement, where the item belonging business unit and normal POs it is 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-org shipment inv transaction Identifier.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 External system reference - This column is used in global PO/interorg physical receipts to get the avg cost from TRA.
INVENTORY_ITEM_ID NUMBER 18 Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}. Active
TRANSACTION_TYPE VARCHAR2 40 Single column FK: 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 Transaction qty in source document uom. Active
TRANSACTION_QTY NUMBER Receiving transaction quantity in transaction UOM. 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 whether the invoice match should happen at the purchase order or 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 PO distribution destination - inventory or expense.
PRIMARY_QTY NUMBER Transaction quantity in item UOM.
PRIMARY_UOM_CODE VARCHAR2 3 The unit of measure code in which primary transaction quantity is specified.
CURRENCY_CODE VARCHAR2 15 Identifies currency of the price of purchase order. 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 Purchase order unit price defined on purchase order line. 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 Putaway transactions transaction identifier.
EVENT_DATE TIMESTAMP Purchase Order event date and maps to PO event change.
EFFECTIVE_DATE TIMESTAMP Effective date of TAXes on physical receipts transaction. Populated with system date.
TAX_PRICE NUMBER Tax price - total tax price returned by tax api call for this receipt transaction.
NONREC_TAX_PRICE NUMBER Non recoverable tax price defined on purchase order or tax api returned value.
NONREC_INCLUSIVE_TAX NUMBER Non Recoverable Inclusive Tax Price defined on Purchase Order or TAX API returned value.
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 of goods received.
LEDGER_ID NUMBER 18 Ledger of the business unit of goods receiving inventory organization.
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 Costing Inventory transaction identifier.
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.
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier.
INCLUSIVE_TAX NUMBER Transaction Inclusive tax amount.
TRANSACTION_AMT_ROUNDED NUMBER Receiving transaction amount in ledger currency rounded to functional currency precision.
NONREC_TAX_PRICE_ROUNDED NUMBER Non recoverable tax in ledger currency rounded to functional currency precision.
NONREC_INCLUSIVE_TAX_ROUNDED NUMBER Non recoverable inclusive tax in ledger currency rounded to functional currency precision.
PO_AMOUNT_ROUNDED NUMBER Net transaction amount in 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 Non recoverable inclusive tax in entered currency rounded to 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 Non Recoverable self-assessed tax Price defined on purchase order or tax api returned value.
NR_SELFASSESSED_TAX_ROUNDED NUMBER Non recoverable self-assessed tax in ledger currency rounded to functional currency precision.
NR_SELFASSESSED_TAX_ROUNDED_EC NUMBER Non recoverable self-assessed tax in entered currency rounded to entered currency precision.
DS_RECEIPT_SOURCE_LINE_ID NUMBER 18 Indicates the source document line identifier that created Drop Ship Receipt.