1. Tables and Views for SCM
  2. CML_POSCHED_ESTIMATE_AMTS_GT

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 or a charge line transfer order shipment line association.
TRADE_OPERATION_ID NUMBER 18 Yes Surrogate ID identifying the Trade Operation owning this charge schedule or charge transfer order shipment line association.
TRADE_OPERATION_CHARGE_ID NUMBER 18 Yes Surrogate ID identifying Trade Operation Charge Line to which this PO schedule or transfer order shipment line is associated.
TROP_POSCHED_OVN NUMBER 9 Yes Object version number of the charge line schedule or a charge line transfer order shipment line association. 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 or transfer order shipment line.
UNIT_TAX NUMBER Per unit calculated tax amount for the schedule or transfer order shipment line.
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 or functional currency code of the business unit of receiving organization in the transfer order.
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 or transfer order shipment line. Only applicable for PERCENTAGE and PERCENTAGE_VARIABLE.
INVENTORY_ITEM_ID NUMBER 18 Inventory item for the PO schedule or transfer order shipment line. This is needed for UOM conversions.
PO_UNIT_PRICE NUMBER Purchase Order unit price specified on the PO schedule or estimated unit transfer price for the transfer order shipment.
PO_CURRENCY_CODE VARCHAR2 15 Currency Code on the Purchase Order or the functional currency of destination organization in the transfer order.
PO_UOM_CODE VARCHAR2 3 Unit of measure code on the purchase order or item's primary unit of measure in the receiving organization of the transfer order shipment.
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 or the transfer order shipment line associated to the charge line.
TRACKED_UOM_CODE VARCHAR2 3 Yes Tracked UOM Code specified on the PO Schedule line associated to the charge or on the transfer order shipment line associated to the charge line.
UOM_CONVERSION_FACTOR NUMBER UOM conversion factor needed for allocation.
ALLOCATION_FACTOR NUMBER Manual Allocation Factor specified on PO schedule or transfer order shipment line. 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.
TROP_TRANSACTION_TYPE VARCHAR2 30 Yes Indicates the type of the trade operation - PO_RECEIPT, TO_INTRANSIT_RECEIPT.