1. Tables and Views for SCM
  2. CMR_RCV_CHARGES_GT

CMR_RCV_CHARGES_GT

This table stores unprocessed actual/estimate charges for the processed Receipt transacations.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Comments
CMR_RCV_TRANSACTION_ID NUMBER 18 Single Column FK: Identifies the receiving transaction.
TRANSACTION_ID NUMBER 18 Transaction Identifier of eligible landed cost charges transactions
CMR_PO_LINE_LOCATION_ID NUMBER 18 Purchase Order shipment schedule identifier.
TROP_CHARGE_LINE_ID NUMBER 18 Identifies the trade operation charge line which has this actual/estimate defined.
CHARGE_ID NUMBER 18 Identifies the Charge Name associated to the charge line.
FISCAL_DOC_LINE_ID NUMBER 18 Fiscal Document Line Identifier and maps to {CMF_FISCAL_DOC_LINES_B.DOCUMENT_LINE_ID}
RCV_CHARGE_ALLOC_ID NUMBER 18 Reference column to charges allocated fiscal document receipts
RCV_CHARGE_ACTUAL_ID NUMBER 18 Identifies the landed cost actual charge.
RCV_CHARGE_ESTIMATE_ID NUMBER 18 Identifies the landed cost estimate charge.
EFFECTIVE_DATE TIMESTAMP Date and time on which actual/estimate was entered by the user/ Allocation was run. Effective date of the landed cost actual/estimate charge.
UNIT_AMOUNT NUMBER Per Unit Allocated charge actual/estimate Amount.
UNIT_TAX NUMBER Per Unit Allocated charge actual/estimate Tax.
TOTAL_UNIT_AMOUNT NUMBER Sum of Allocated charge actual/estimate UNIT_ AMOUNT and UNIT_TAX.
PRIOR_TOTAL_UNIT_AMOUNT NUMBER Unit amount of charge line. Accounted prior total unit amount
CHARGE_BU_ID NUMBER 18 Charge Requisitioning Business Unit for this landed cost charge.
REQ_BU_ID NUMBER 18 Requisition Business Unit on Material Purchase Order.
CMR_SRV_PO_LINE_LOCATION_ID NUMBER 18 Indicates if it is a service line type Purchase Order or not. Y - Service line PO, N - Not a Service line PO
SERVICE_PO_FLAG VARCHAR2 1 Flag to indicate service PO flag
CONSIGNED_FLAG VARCHAR2 1 Consigned purchase Order indicator
DESTINATION_TYPE_CODE VARCHAR2 25 Identifies type of destination for the material: Inventory, Expense.
TRANSACTION_TYPE VARCHAR2 40 Identifies the transaction type.
CURRENCY_CODE VARCHAR2 15 Identifies currency of the price.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion type that should be used for currency conversion.
CURRENCY_CONVERSION_RATE NUMBER Currency conversion rate from the charge BU currency to the material requisitioning BU functional currency.
CURRENCY_CONVERSION_DATE TIMESTAMP Identifies the currency conversion date.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to Business Unit identifier for this landed cost charge.
INTERCOMPANY_BILL_TO_BU_ID NUMBER 18 Used in cross bu case. For Non cross bu case it will be NULL.
SOURCE_DOC_NUMBER VARCHAR2 50 Source document number - Purchase order number.
CMR_ROOT_RCPT_TXN_ID NUMBER 18 Root Receipt txn id for child txns and receipt txn id for receipts

Indexes

Index Uniqueness Columns
CMR_RCV_CHARGES_GT_N1 Non Unique RCV_CHARGE_ACTUAL_ID
CMR_RCV_CHARGES_GT_N2 Non Unique RCV_CHARGE_ESTIMATE_ID