CST_LCM_CHARGE_AMTS_S_GT
This table is used to temporarily store a subset of data from CST_LCM_CHARGE_AMTS_GT table to support internal processing within the Cost Processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Yes | Identifies the root receiving transaction in CMR. | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Identifies the trade operation that contributes this charge. | |
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Yes | Single Column FK: Identifies the fiscal document header. | |
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Identifies the trade operation charge line that contributes this charge. | |
| CHARGE_ID | NUMBER | 18 | Yes | Identifies the landed cost charge against which the amount is captured. | |
| UNIT_AMOUNT | NUMBER | Per unit amount associated to this receipt transaction. | |||
| UNIT_TAX | NUMBER | Per unit tax associated to this receipt transaction. | |||
| UOM_UNIT_FACTOR | NUMBER | Primary unit of measure unit factor to Purchase Order unit of measure. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency code in which the amounts are captured. Typically, the functional currency of the material receipt. | ||
| UOM_CODE | VARCHAR2 | 3 | Primary UOM of the receipt transaction. | ||
| RCV_CHARGE_ESTIMATE_ID | NUMBER | 18 | Identifies the estimate association in Landed Costs. | ||
| RCV_CHARGE_ACTUAL_ID | NUMBER | 18 | Identifies the actual association in Landed Costs. | ||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 25 | Source document unit of measure. For PO receipts: represents purchase Order Unit of measure. Transfer Order receipts - Transfer Order document unit of measure. | ||
| ROW_UPDATED_FLAG | VARCHAR2 | 1 | Indicates if this row has been updated during the process. | ||
| PROCESSED_BY_CA_FLAG | VARCHAR2 | 5 | Indicates whether the row is processed by cost accounting. | ||
| CURRENCY_CONVERSION_DATE | DATE | The date to be used to determine the exchange rates for currency conversion. | |||
| CHARGE_CURRENCY_UNIT_AMOUNT | NUMBER | Unit cost in charge requisition BU currency. | |||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Charge requisition BU currency code. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_LCM_CHARGE_AMTS_S_GT_U1 | Unique | CMR_RCV_TRANSACTION_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, CHARGE_ID, FISCAL_DOC_HEADER_ID |