CML_EST_TRANSFER_PRICE_GT

This is a temporary table that stores the estimated transfer price and currency code returned by the FOS API for a transfer order. The data is used while processing the allocations.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
FROM_INVENTORY_ORG_CODE	VARCHAR2	18		This column stores the source inventory organization code for transfer order shipment lines.
TO_INVENTORY_ORG_CODE	VARCHAR2	18		This column stores the receiving inventory organization code where the transfer order receipt is created.
DESTINATION_LOCATION_ID	NUMBER		18	This column stores the deliver to location unique identifier.
ITEM_ID	NUMBER		18	Identifies the item on the transfer order line.
UOM_CODE	VARCHAR2	3		This column stores the item quantity's unit of measure code for the transfer order shipment line.
UNIT_PRICE	NUMBER			This column stores the estimated transfer price returned by the FOS API.
TRANSACTION_CURRENCY_CODE	VARCHAR2	15		This column stores the currency code of the estimated transfer price returned by the FOS API.
ERROR_CODE	VARCHAR2	240		This column stores the error code returned by the FOS API.

Indexes

Index	Uniqueness	Columns
CML_EST_TRANSFER_PRICE_GT_U1	Unique	FROM_INVENTORY_ORG_CODE, TO_INVENTORY_ORG_CODE, DESTINATION_LOCATION_ID, ITEM_ID, UOM_CODE