CML_TROP_CHARGES_TO_PROCESS_GT
This transaction temporary table stores the trade operation charges to be processed withing an allocation run.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_TROP_CHARGES_TO_PROCESS_PK |
TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the trade operation which holds the charge lines that is submitted for processing. | |
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the trade operation charge line that is to be processed. | |
| CHARGE_LINE_OVN | NUMBER | 9 | Yes | Object version number of the charge line schedule. Helps to avoid data corruption | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency conversion type specified on the trade operation charge line. | ||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date specified on the charge line. | |||
| ESTIMATE_AMOUNT | NUMBER | Total estimate amount excluding tax in charge BU functional currency. | |||
| NR_TAX | NUMBER | Calculated non-recoverable tax amount or user entered tax amount in user entered currency. | |||
| INVOICE_FUNC_AMOUNT | NUMBER | Total invoice amount in invoices functional currency. | |||
| INVOICE_FUNC_TAX | NUMBER | Total invoice tax in invoices functional currency. | |||
| TROP_CURRENCY_CODE | VARCHAR2 | 15 | Trade operation document currency code. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Charge currency code specified on the charge line. | ||
| REQ_BU_CURRENCY_CODE | VARCHAR2 | 15 | Requsitioning BU currency code specified on the charge line. | ||
| CHARGE_REQ_BU_CURR_CONV_RATE | NUMBER | Conversion rate from charge currency to requisitioning BU currency. | |||
| TROP_DOC_CURRENCY_CONV_RATE | NUMBER | Conversion rate from charge currency to trade operation document currency. | |||
| TENTATIVE_FLAG | VARCHAR2 | 1 | Yes | Tentative flag on the charge line. Valid values are N and Y. | |
| STATUS | VARCHAR2 | 30 | Allocation status for this charge line. | ||
| TAX_STATUS | VARCHAR2 | 30 | Tax calculation status for this charge line. | ||
| ERROR_MESSAGE | VARCHAR2 | 30 | Identifies the event that occurred. This value maps to the MESSAGE_NAME column of the FND_MESSAGES table. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Token value as required by error code message. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CML_TROP_CHRGS_TO_PROCES_U1 | Unique | TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID |