CML_DATA_UPDATES_GT

This is a transaction temporary table that stores additional information related to charge lines, trade operations, charge po schedules which are to be processed in a new transaction.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRADE_OPERATION_CHARGE_ID	NUMBER		18	Yes	Surrogate key that identifies a trade operation charge.
TROP_CHARGE_PO_SCHEDULE_ID	NUMBER		18		Surrogate key that identifies a record that associates a landed cost charge line with a specific Purchase Order (PO) schedule line.
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Yes	The purchase order line location identifier.
PURCHASE_BASIS_CODE	VARCHAR2	30		Yes	It specifies how a landed cost charge should be allocated or applied in relation to the underlying purchase.
CHARGE_BASIS_CODE	VARCHAR2	30			It determines how a specific landed cost charge (like freight, duty, or insurance) is distributed across purchase order lines, receipts, or inventory.
TENTATIVE_FLAG	VARCHAR2	1			Indicates whether a charge line is in tentative status i.e not eligible for feeding into receipt and inventory value.
NEW_EVENT_DATE	TIMESTAMP				It typically stores the date on which a landed cost event occurs or is recorded.
NEW_AMOUNT	NUMBER				It typically refers to the updated estimated or actual cost of a landed cost charge, potentially after adjustments or corrections.
NEW_PRICE	NUMBER				It is the estimated or actual landed cost of an item after incorporating additional charges like shipping, insurance, duties, and other associated expenses.
NEW_CURRENCY_CODE	VARCHAR2	15			It identifies the currency in which a transaction or cost is recorded.
NEW_ORDERED_QTY	NUMBER				The system will track the original ordered quantity and the updated quantity, and potentially re-allocate landed costs based on the new quantity.
NEW_UOM_CODE	VARCHAR2	3			Unit of measure for the quantity.
NEW_PO_QTY_IN_SECONDARY_UOM	NUMBER				It refers to the quantity of an item received in a purchase order, expressed in the item's secondary unit of measure.
NEW_PO_SECONDARY_UOM_CODE	VARCHAR2	3			It refers to the secondary unit of measure code used for landed cost charges on purchase orders.
NEW_PO_PRICE_IN_FUNC_CURR	NUMBER				It refers to the purchase order price in the functional currency, after any currency conversions or adjustments related to landed cost calculations.
CHARGE_LINE_OVN	NUMBER		9		Object version number of the Charge Line when the record was picked up for processing. This is used to ensure at update the row is only touched if no other process(eg. ADFUI) has updated this record.
TROP_POSCHED_OVN	NUMBER		9		Object version number of the TradeOperation Purchase Order Schedules when the record was picked up for processing. This is used to ensure at update the row is only touched if no other process(eg. ADFUI) has updated this record.
CHARGE_ESTIMATE_OVN	NUMBER		9		Object version number of the Charge Estimate when the record was picked up for processing. This is used to ensure at update the row is only touched if no other process(eg. ADFUI) has updated this record.