CST_ITEM_UOM_CONVERSIONS_GT

This table is populated with the distinct Inventory Item - From UOM codes which is then used to find the conversion rate. The conversion rate is then updated in the table and used in later processing.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier, and it references {EGP_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID}.
FROM_UOM_CODE	VARCHAR2	3		Find conversion rate from this unit of measure code
TO_UOM_CODE	VARCHAR2	3		Find conversion rate to this unit of measure code
FROM_UOM	VARCHAR2	25		Find conversion rate from this unit of measure
TO_UOM	VARCHAR2	25		Find conversion rate to this unit of measure
UOM_CONVERSION_FACTOR	NUMBER			Conversion rate to convert quantity between from_uom (from_uom_code) and to_uom (to_uom_code)
STATUS	VARCHAR2	30		Indicates the status of UOM conversion
INVENTORY_ORG_ID	NUMBER		18	Indicates the inventory organization to which the item belongs.
LOT_NUMBER	VARCHAR2	80		This stores the lot number for the inventory item.
TRANSACTION_DATE	TIMESTAMP			The date when this transaction happened.
LOT_CONVERSION_ENABLED_FLAG	VARCHAR2	1		Contains one of the following values: 'Y' or 'N'. 'Y' indicates that the transaction is deemed eligible for lot specific conversion, 'N' means UOM conversion will use the item conversions. The default value is 'N'.