CMR_LCM_CHRG_PREPROC_GT
This transaction GT table will be used to calculate the UOM conversion factor and currency conversion rates for LCM charges applied to receipts.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHARGE_REF_ID | NUMBER | 18 | Surrogate ID of the table which is being processed e.g. RCV_CHARGE_ESTIMATE_ID for estimates and RCV_CHARGE_ACTUAL_ID for actual. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code in which the charge amounts have been calculated. Always the charge BU functional currency code. | |
| MAT_REQ_BU_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency of the receive transaction. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency conversion type. Rate type will be fetched from Account Payables module Bill to BU of the Material Requisition BU. This is defined as DEFAULT_EXCHANGE_RATE_TYPE in financial_system_params_all. | ||
| 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 as returned by the GL conversion API. | |||
| UOM_CONVERSION_FACTOR | NUMBER | Conversion factor from source document UOM to primary UOM of the receipt transaction. This is computed using the quantities present on the receive transaction. | |||
| 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. |