1. Tables and Views for SCM
  2. CML_TORECEIPT_CHARGE_ESTIMATES

CML_TORECEIPT_CHARGE_ESTIMATES

This table stores the allocated per unit charge and tax estimates for each transfer order shipment receipt. It will also act as interface table for downstream products like Cost Accounting and Receipt Accounting.

Details

  • Schema: FUSION

  • Object owner: CML

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CML_TORECEIPT_CHRG_ESTIMATE_PK

TORECEIPT_CHARGE_ESTIMATE_ID

Columns

Name Datatype Length Precision Not-null Comments
TORECEIPT_CHARGE_ESTIMATE_ID NUMBER 18 Yes Surrogate ID that uniquely identifies a row in this table.
CMR_RCV_TRANSACTION_ID NUMBER 18 Yes Surrogate ID that identifies a transfer order receipt in receipt accounting.
TRADE_OPERATION_ID NUMBER 18 Yes Surrogate ID that identifies the trade operation.
TROP_CHARGE_LINE_ID NUMBER 18 Yes Surrogate ID that identifies the trade operation charge line.
CHARGE_LINE_NUMBER NUMBER 9 Yes Trade Operation Charge line number this estimate was defined on.
REQ_BU_ID NUMBER 18 Yes Surrogate ID that identifies the Charge Requisitioning Business Unit for this charge.
SHIPMENT_LINE_ID NUMBER 18 Yes Shipment line identifier in RCV_SHIPMENT_LINES table.
CHARGE_ID NUMBER 18 Yes Surrogate ID that identifies the charge name associated to the charge line.
UNIT_AMOUNT NUMBER Yes Per unit allocated estimate amount.
UNIT_TAX NUMBER Yes Per unit allocated estimate tax.
SOURCE_DOC_UOM_CODE VARCHAR2 3 Yes Source Document UOM Code on the transfer order receipt transaction. Amounts present in this table are in this UOM.
CURRENCY_CODE VARCHAR2 15 Yes Charge Requisitioning Business Unit currency. Unit amount and tax amount are stored in this currency.
EFFECTIVE_DATE TIMESTAMP Yes Effective date of the estimate. Holds the date and time at which the estimate was created.
SHIP_TO_ORGANIZATION_ID NUMBER 18 This column stores receiving organization unique identifier where the receiving transaction is created.
ACCRUAL_OPTION VARCHAR2 30 Yes Accrual option for the charge line. For charge lines associated to service purchase orders this will be set to NO_ACCRUAL. For other cases it is set to MATERIAL_RECEIPT
CMR_SRV_PO_LINE_LOCATION_ID NUMBER 18 Surrogate ID that identifies the service PO schedule associated to this charge line.
ACTIVE_FLAG VARCHAR2 1 Yes Flag to identify if this charge line is storing the latest estimate and is to be used for downstream processing. Valid values are N and Y.
PROCESSED_BY_CA_FLAG VARCHAR2 5 Flag to identify if this row has been processed by Cost Accounting.
PROCESSED_BY_RA_FLAG VARCHAR2 5 Flag to identify if this row has been processed by Receipt Accounting.
PRIMARY_UOM_CONV_FACTOR NUMBER Conversion factor from source document UOM code to primary UOM code for the transfer order receive transaction. This is derived using the quantities specified on the receipt.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Currency conversion type fetched from Account Payables module using Bill to BU of the Material Requisition BU. This is defined as DEFAULT_EXCHANGE_RATE_TYPE in financial_system_params_all table.
CURRENCY_CONVERSION_DATE DATE Date used to derive the currency conversion rate. This value is equal to the transaction date of receive transaction when receive is not yet posted in CMR otherwise it is equal to the charge effective date in this table.
CURRENCY_CONVERSION_RATE NUMBER Currency conversion rate from the charge BU currency to the material requisitioning BU functional currency.
PREPROCESS_STATUS VARCHAR2 30 Status of currency and UOM conversion. Possible values: ERROR - failure in currency conversion SUCCESS - all conversions are updated and the line is ready for further processing.
MAT_REQ_BU_FUNC_CURRENCY_CODE VARCHAR2 15 Functional currency code of the business unit of receiving organization in the transfer order.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to Business Unit identifier for processing the landed cost charges. When user runs the process for this business unit charges are accounted in profit centre business unit of landed cost charges.
INTERCOMPANY_BILL_TO_BU_ID NUMBER 18 Used in cross BU case. For Non cross BU case it will be NULL. Whenever user runs the process for this Inter-company bill to business unit then landed cost charges are accounted in physical receipt's profit centre business unit.
INTERCOMPANY_PROCESSED_FLAG VARCHAR2 1 Flag to identify the cross BU case - Y/N. Y - means landed cost charges are accounted in physical receipt's profit centre business unit. For Non cross bu case it will be NULL.
RO_POSTED_FLAG VARCHAR2 1 Indicates if this charge is posted to landed cost reporting object.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
CML_TORECEIPT_CHRG_EST_U1 Unique Default TORECEIPT_CHARGE_ESTIMATE_ID
CML_TORECEIPT_CHRG_EST_U2 Unique Default CMR_RCV_TRANSACTION_ID, TROP_CHARGE_LINE_ID, CHARGE_ID, EFFECTIVE_DATE
CML_TORECEIPT_CHRG_EST_U3 Unique Default CMR_RCV_TRANSACTION_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, CHARGE_ID, EFFECTIVE_DATE