CML_POSCHED_ESTIMATE_AMTS_GT
This is a transaction temporary table that stores trade operation charge line schedule which are to be processed by a run of allocation.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TROP_CHARGE_PO_SCHEDULE_ID | NUMBER | 18 | Yes | Surrogate ID that identifies a charge line PO schedule association. | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the Trade Operation owning this charge schedule. | |
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID identifying Trade Operation Charge Line to which this PO schedule is associated. | |
| TROP_POSCHED_OVN | NUMBER | 9 | Yes | Object version number of the charge line schedule. Helps to avoid data corruption. | |
| ESTIMATE_ENTERED_DATE | TIMESTAMP | Yes | Date and time at which estimate is entered. For system generated estimates, date time at which the allocation process is run. | ||
| UNIT_AMOUNT | NUMBER | Per unit calculated estimate amount for the schedule. | |||
| UNIT_TAX | NUMBER | Per unit calculated tax amount for the schedule. | |||
| CHARGE_BASIS_CODE | VARCHAR2 | 30 | Yes | Charge basis from the trade operation charge line. | |
| ALLOCATION_BASIS_CODE | VARCHAR2 | 30 | Allocation Basis from the charge line. | ||
| REQ_BU_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Functional currency of the requisitioning BU associated to the charge line. | |
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency Code stamped on the charge line. | |
| TROP_CURRENCY_CODE | VARCHAR2 | 15 | Trade operation document currency code. | ||
| MAT_REQ_BU_CURRENCY_CODE | VARCHAR2 | 15 | Material requisitioning BU functional currency for the material PO schedule. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency conversion type specified on the charge line. | ||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date specified on the charge line. | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate needed for allocation. | |||
| CHARGE_PER_UNIT | NUMBER | Per Unit Charge specified on the Charge Line. Only applicable for PER_UNIT charges. | |||
| CHARGE_PERCENT | NUMBER | Percent Charge for the charge line schedule. Only applicable for PERCENTAGE and PERCENTAGE_VARIABLE. | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item for the PO schedule. This is needed for UOM conversions. | ||
| PO_UNIT_PRICE | NUMBER | Purchase Order Unit price specified on the PO Schedule. | |||
| PO_CURRENCY_CODE | VARCHAR2 | 15 | Currency Code on the Purchase Order. | ||
| PO_UOM_CODE | VARCHAR2 | 3 | Unit of measure code on the purchase order. | ||
| CHARGE_BASIS_UOM_CODE | VARCHAR2 | 3 | Charge basis UOM code specified in case of per unit charges. | ||
| ALLOCATION_BASIS_UOM_CODE | VARCHAR2 | 3 | Allocation basis UOM code specified in case of aggregate charges of type Quantity/Weight/Volume. | ||
| AGGREGATE_AMOUNT | NUMBER | Aggregate Charge amount for the charge line. | |||
| AGGREGATE_TAX | NUMBER | Aggregate tax amount for the charge line. | |||
| TRACKED_QUANTITY | NUMBER | Yes | Tracked quantity on the charge line schedule. | ||
| TRACKED_UOM_CODE | VARCHAR2 | 3 | Yes | Tracked UOM Code specified on the PO Schedule line associated to the charge. | |
| UOM_CONVERSION_FACTOR | NUMBER | UOM conversion factor needed for allocation. | |||
| ALLOCATION_FACTOR | NUMBER | Manual Allocation Factor specified on PO schedule. For EQUALLY allocation, this will be populated as 1. | |||
| ALLOCATION_PERCENTAGE | NUMBER | Allocation percentage as calculated by the allocation program. | |||
| TROP_DOC_CURRENCY_CONV_RATE | NUMBER | Conversion rate from charge currency to trade operation document currency. | |||
| MAT_REQ_BU_CURR_CONV_RATE | NUMBER | Conversion rate from charge currency to material requisitioning BU functional currency. | |||
| STATUS_CODE | VARCHAR2 | 30 | Allocation Status of the trade Operation Charge. | ||
| ERROR_MESSAGE | VARCHAR2 | 30 | Error message name. This value maps to the MESSAGE_NAME field in 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. | ||
| PO_UOM_CONV_FACTOR | NUMBER | Conversion factor from ASN UOM to PO UOM. | |||
| PO_SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure code of item. |