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. |