CML_RCV_CHARGE_ESTIMATES
This table stores the allocated per unit charge and tax estimates for each material 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_RCV_CHARGE_ESTIMATES_PK |
RCV_CHARGE_ESTIMATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RCV_CHARGE_ESTIMATE_ID | NUMBER | 18 | Yes | Surrogate ID that uniquely identifies a row in this table. | |
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the material PO receipt in Receipt Accounting | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the trade operation for this charge. In case of direct charge estimates this will be ZERO. | |
| TROP_CHARGE_LINE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the trade operation charge line. For direct charge estimates this will be ZERO. | |
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Trade Operation Charge Line Number this estimate was defined on. | |
| REQ_BU_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Charge Requisitioning Business Unit for this charge. | |
| CHARGE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the to Charge Name associated to the charge line. | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the material PO schedule to which this charge is associated. | |
| 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 Receipt Transaction. This is same as UOM_CODE on the purchase order distribution line for this receipt. Amounts present int 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 | Single column FK: 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 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 | Material Requisitioning BU functional currency code. This is derived from CPOD using the po line location id present in this table. | ||
| 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 center 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. When ever user runs the process for this Inter-company bill to business unit then landed cost charges are accounted in physical receipt's profit center 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 center business unit. For Non cross bu case it will be NULL. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_RCV_CHARGE_ESTIMATES_N1 | Non Unique | Default | CMR_RCV_TRANSACTION_ID, ACTIVE_FLAG |
| CML_RCV_CHARGE_ESTIMATES_N2 | Non Unique | Default | REQ_BU_ID, PROCESSED_BY_CA_FLAG |
| CML_RCV_CHARGE_ESTIMATES_N3 | Non Unique | Default | REQ_BU_ID, PROCESSED_BY_RA_FLAG |
| CML_RCV_CHARGE_ESTIMATES_N4 | Non Unique | Default | ACTIVE_FLAG, PREPROCESS_STATUS, PROCESSED_BY_CA_FLAG |
| CML_RCV_CHARGE_ESTIMATES_N5 | Non Unique | Default | PREPROCESS_STATUS, ACTIVE_FLAG, INTERCOMPANY_PROCESSED_FLAG |
| CML_RCV_CHARGE_ESTIMATES_N6 | Non Unique | Default | ACTIVE_FLAG, PREPROCESS_STATUS, NVL("PROCESSED_BY_RA_FLAG",'N') |
| CML_RCV_CHARGE_ESTIMATES_N7 | Non Unique | Default | CMR_PO_LINE_LOCATION_ID |
| CML_RCV_CHARGE_ESTIMATES_N8 | Non Unique | Default | TROP_CHARGE_LINE_ID |
| CML_RCV_CHARGE_ESTIMATES_PK | Unique | Default | RCV_CHARGE_ESTIMATE_ID |
| CML_RCV_CHARGE_ESTIMATES_U1 | Unique | Default | CMR_RCV_TRANSACTION_ID, TROP_CHARGE_LINE_ID, CHARGE_ID, EFFECTIVE_DATE |
| CML_RCV_CHARGE_ESTIMATES_U2 | Unique | Default | CMR_RCV_TRANSACTION_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, CHARGE_ID, EFFECTIVE_DATE |