CML_RCV_CHARGE_ACTUALS
This table will be used to store the allocated per unit actual charge amounts 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_ACTUALS_PK |
RCV_CHARGE_ACTUAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RCV_CHARGE_ACTUAL_ID | NUMBER | 18 | Yes | Surrogate ID that identifies a row in this table. | |
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID that identifies a PO receipt in receipt accounting. | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID FK to trade operation where the user defined the charges associated to this receipt. Will be Zero in case of direct charge estimates. | |
| TROP_CHARGE_LINE_ID | NUMBER | 18 | Yes | Surrogate ID FK to trade operation charge line which has this estimate defined. Will be Zero in case of direct charge estimates. | |
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Trade Operation Charge Line Number this estimate belongs to. Will be Zero in case of direct charge estimates. | |
| REQ_BU_ID | NUMBER | 18 | Yes | Charge Requisitioning Business Unit for this charge. | |
| CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID FK to Charge Name associated to the charge line. | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Yes | Material PO Schedule associated with Trade Operation Charge to which this material PO receipt 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 Doc UOM Code on the Receipt Transaction. This is same as UOM_CODE on the purchase order distribution line for this receipt. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Charge Requisitioning Business Unit currency. Unit Amount and Tax Amount are stored in this currency. | |
| EFFECTIVE_DATE | TIMESTAMP | Yes | Date and time on which estimate was entered by the user/ Allocation was run. Effective date of the estimate. | ||
| 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 | PO Schedule ID of the Service PO which is associated to this charge. This value is only applicable for charge lines that are associated to a service PO. | ||
| 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. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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_ACTUALS_N1 | Non Unique | Default | CMR_RCV_TRANSACTION_ID, ACTIVE_FLAG |
| CML_RCV_CHARGE_ACTUALS_N10 | Non Unique | DEFAULT | NVL("PROCESSED_BY_RA_FLAG",'N') |
| CML_RCV_CHARGE_ACTUALS_N2 | Non Unique | Default | CMR_RCV_TRANSACTION_ID, PROCESSED_BY_CA_FLAG |
| CML_RCV_CHARGE_ACTUALS_N3 | Non Unique | Default | CMR_RCV_TRANSACTION_ID, PROCESSED_BY_RA_FLAG |
| CML_RCV_CHARGE_ACTUALS_N4 | Non Unique | Default | ACTIVE_FLAG, PREPROCESS_STATUS, PROCESSED_BY_CA_FLAG |
| CML_RCV_CHARGE_ACTUALS_N5 | Non Unique | Default | PREPROCESS_STATUS, ACTIVE_FLAG, INTERCOMPANY_PROCESSED_FLAG |
| CML_RCV_CHARGE_ACTUALS_N6 | Non Unique | Default | ACTIVE_FLAG, PREPROCESS_STATUS, NVL("PROCESSED_BY_RA_FLAG",'N') |
| CML_RCV_CHARGE_ACTUALS_N7 | Non Unique | Default | CMR_PO_LINE_LOCATION_ID |
| CML_RCV_CHARGE_ACTUALS_N8 | Non Unique | Default | TROP_CHARGE_LINE_ID |
| CML_RCV_CHARGE_ACTUALS_N9 | Non Unique | DEFAULT | NVL("PROCESSED_BY_CA_FLAG",'N') |
| CML_RCV_CHARGE_ACTUALS_PK | Unique | Default | RCV_CHARGE_ACTUAL_ID |
| CML_RCV_CHARGE_ACTUALS_U1 | Unique | Default | CMR_RCV_TRANSACTION_ID, TROP_CHARGE_LINE_ID, CHARGE_ID, EFFECTIVE_DATE |
| CML_RCV_CHARGE_ACTUALS_U2 | Unique | Default | CMR_RCV_TRANSACTION_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, CHARGE_ID, EFFECTIVE_DATE |